On-line Analytical Processing Systems for Business

(Hardback)

Publishing Details

Classifications

Physical Properties

Description

On-line analytical processing (OLAP) is clearly a new approach to information system technologyoffering a much-needed way to make informed decisions better and faster. One of its most important characteristics is multidimensional analysisanalysis that goes beyond the conventional two-dimensional analysis and provides users with rapid retrieval of data from organizational databases, data warehouses, or both. Not only that, but most importantly, says Dr. Thierauf, it allows users to look at different dimensions of the same data, thus enabling them to do analyses across departmental and even corporate boundaries. How it works and OLAP's many benefits to aid users in the public and private sectors is spelled out here, comprehensively yet concisely, and with the author's customary well-developed examples and clear prose. His book will be important reading for people at all levels of management and in all types of organizations. Another way of viewing OLAP is getting a typical company out of the custom-report-writing business and into the data-cube-server building business. An OLAP data structure can be thought of as a Rubik's Cube of data that users can twist and twirl in different ways to work through what-if and what-happened scenerios to get at the whys of the situation. Within an OLAP environment, the focus is on performing dictionary definition and maintenance as well as mapping flat files or relational columns to dimensions and measures. Although this may sound like a lot of work, managing one data cube is more efficient than writing a number of custom reports. Currently, some vendors provide administrative tools to get the data into the cubes in the first place, in the proper form, and on a regular basis. Hence, the job of managing data has been simplified for users.

Reviews

A well-organized presentation of the concepts and applications of online analytical processing (OLAP) for those interested in decision support systems.-Computing Reviews
"A well-organized presentation of the concepts and applications of online analytical processing (OLAP) for those interested in decision support systems."-Computing Reviews

Author Bio

ROBERT J. THIERAUF is Professor of Information Systems at Xavier University, Cincinnati, Ohio. Formerly a staff accountant (CPA) and consultant at Coopers & Lybrand, Dr. Thierauf writes extensively on all facets of information systems, particularly decision support systems, executive information systems, expert systems, virtual reality systems, and information systems management. He is the author of 30 books, twelve published by Quorum.