Home » BI » A COMMON DATABASE APPROACH FOR OLTP AND OLAP USING AN IN-MEMORY COLUMN DATABASE

0
Print Friendly, PDF & Email

OVERVIEW

Relational database systems have been the backbone of business applications for more than 20 years. We promised to provide companies with a management information system that covers the core applications, including financials, sales, order fulfillment, manufacturing, as well as human resources, which run from planning through business processes to individually de ned analytics. However, we fell short of achieving this goal. The more complex business requirements became, the more we focused on the so-called transactional processing part and designed the database structures accordingly. These systems are called OLTP (Online Transactional Processing) systems. Analytical and nancial planning applications were increasingly moved out to separate systems for more exibility and better performance. These systems are called OLAP (Online Analytical Processing) systems. In reality, parts of the planning process were even moved off to specialized applications mainly around spreadsheets.

View this Article
« « Introduction to SAP System Administration (Basis)| Match Blueprints User’s Guide – SAP BusinessObjects Data Services 4.1 » »

Leave a Reply