Differences between OLTP and OLAP
Online transaction processing system: ******************************* In OLTP system, the tables are in normalized structure As the OLTP is in normalized structure, DML operations like Updates and deletes will be faster Simple queries are run against the OLTP system OLTP system contains only current data. As the OLTP system does not contain history data, it cannot be used in reporting Online analytic processing system: **************************** In OLAP system, the tables are in de normalized structure As the OLAP is in de normalized structure, the numbers of joins between tables are less and hence select statements will be faster Complex queries are run against the OLAP system OLTP system contains only history data and can be used for reporting purpose