What Is OLAP?
The term OLAP stands for Online Analytical Processing. As its name implies, it is a technology centered around the analysis of data. OLAP applications allow users to select, view, and analyze transactional data from a variety of sources, which allows corporations to extract additional value from their traditional Online Transaction Processing (OLTP) systems and data warehouses. OLAP is really an extension, or further refinement, of previous genres of applications such as Decision Support Systems (DSSs) and Executive Information Systems (EISs). Those types of applications are intended to provide high-level, summarized information about which decisions can be made so management can stay informed. OLAP takes that notion and expands ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
