Transactional vs Analytical Database
Transactional Database Analytical Database OLTP OLAP Operational Systems Data Warehousing Original source of data Data comes from varies sources Large number of transactions. Low number of transaction. Very fast query processing Queries are often very complex and involve aggregations Detailed and current data, and schema is the entity model (usually 3NF) Aggregated, historical data, stored... » read more