Online Transactional Processing (OLTP) databases are optimized for transaction processing. The performance of the Insert
, update
, and delete
SQL statements are very important in the OLTP databases. They store the data in the two-dimensional structures called as tables. Enterprises need to retrieve valuable information from these databases to make strategic decisions. The databases that are optimized for queries are called as data warehouses. The need for the data warehouses is obvious for analytical reporting. They store the data in the tables like the OLTP databases. The major difference between the OLTP and data warehouse databases is the design of the tables. Normalization rules are applied in the OLTP to improve the performance of the transactions. On the other hand, data warehouses are mostly designed based on denormalization rules.
Online Analytical Processing (OLAP) databases store summary data and they are used to generate aggregated result sets. They store their data...