” Īlthough Teradata is geared towards OLAP and Oracle for OLTP, Oracle can run both OLTP and OLAP databases on the same platform, which Teradata does not support. OLAP technology enables data warehouses to be used effectively for online analysis, providing rapid responses to iterative complex analytical queries. Data in a data warehouse is organized to support analysis rather than to process real-time transactions as in online transaction processing systems (OLTP). “A data warehouse is a database containing data that usually represents the business history of an organization. OLTP is transactional and provides data to data warehouses and OLAP is designed to analyze the data. Relational Database Management Systems (RDBMS) can be categorized as Online Transaction Processing – OLTP and Online Analytical Processing – OLAP. Its’ capabilities made it perfect for big data (a term coined by Teradata), Business Intelligence (BI) tools, and the Internet of Things (IoT).
In the late seventies, while Oracle became the first commercially available RDBMS, Teradata was laying the foundation for the first data warehouse. It is a quicker to fetch and store data compared to the old Database Management System (DBMS).Īlthough similar to a relational database, Oracle’s object-oriented database model uses objects, and classes supported in the database schema and query language.
The RDBMS was introduced using the Relational Model that maintains relationships between tables using indexes, primary and foreign keys. Oracle and Teradata are both Relational Database Management Systems (RDBMS), however Oracle implements an Object-Relational Database Management System (ORDBMS).
0 kommentar(er)
