OLAP Features
Databases normally hold large amounts of data that can be updated, deleted, queried, and inserted on a daily basis. Databases in which data is constantly updated, deleted, and inserted are known as online transaction processing (OLTP) systems.
Databases that hold large amounts of data and do not have a heavy transaction work load but do have a large number of concurrent queries executing all the time, are known as decision support systems (DSS). Certain decision support systems have fewer queries, but each query can be very complex. These allow users to examine the data from different perspectives by performing online analytical processing (OLAP).
The functionality of the database is required to provide multidimensional views of ...
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
