What Is The Difference Between Oltp And A Data Warehouse?

1.	What Is The Difference Between Oltp And A Data Warehouse?
Answer» Indexes: OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization. Joins: In an OLTP system, LARGE NUMBER of joins and data is normalized however in an OLAP system there are less joins and de-normalized. AGGREGATION: In an OLTP system data is not AGGREGATED while in an OLAP database more aggregations are used. Indexes: OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization. Joins: In an OLTP system, large number of joins and data is normalized however in an OLAP system there are less joins and de-normalized. Aggregation: In an OLTP system data is not aggregated while in an OLAP database more aggregations are used.

Answer»

Indexes: OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization.

Joins: In an OLTP system, LARGE NUMBER of joins and data is normalized however in an OLAP system there are less joins and de-normalized.

AGGREGATION: In an OLTP system data is not AGGREGATED while in an OLAP database more aggregations are used.

Indexes: OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization.

Joins: In an OLTP system, large number of joins and data is normalized however in an OLAP system there are less joins and de-normalized.

Aggregation: In an OLTP system data is not aggregated while in an OLAP database more aggregations are used.

Discussion