On-line Analytical Processing Systems for Business

Features

• Cover Type: Hard Cover with 352 pages
• Published by: Quorum Books September 30, 1997
• Written in: English
• ISBN 10 Number: 1567200990
• ISBN 13 Number: 978-1567200997
• Book Dimensions: 9.2 x 6.1 x 1.2 inches
• Weighs: 1.1 pounds

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

Product Description
On-line analytical processing (OLAP) is clearly a new approach to information system technology--offering a much-needed way to make informed decisions better and faster. One of its most important characteristics is multidimensional analysis--analysis 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.