OLTP and OLAP

OLTP – Online transaction processing system.

SAP, ORACLE, JD Edwards – vendors which provides predefined applications for automating a business.
SAP R/3 – OLTP. Day-to-day, month-to-month transactions were carried out using OLTP systems.
It supported very low database. Millions of transactions, the database gets full.

OLAP systems were introduced. Online analysis and processing systems.
Support very database. BIW systems

R/3- table format
OLAP – Cubic format – 3d format… analysis and processing was very much accurate than OLTP systems.

• Maintenance problem
• Support
• Support with other vendors.

SAP Netweaver. – integrating all your heterogenous systems. Integration technology which can recognized both your SAP and Non-SAP Systems.