Describe Codd’s rules for OLAP tools.
What will be an ideal response?
In 1993, E.F. Codd formulated twelve rules as the basis for selecting OLAP tools. The publication of these rules was the outcome of research carried out on behalf of Arbor Software (the creators of Essbase) and has resulted in a formalized redefinition of the requirements for OLAP tools. Codd’s rules for OLAP are listed in Table 33.2 (Codd et al., 1993).
Table 33.2 Codd’s rules for OLAP tools.
1. Multi-dimensional conceptual view
2. Transparency
3. Accessibility
4. Consistent reporting performance
5. Client–server architecture
6. Generic dimensionality
7. Dynamic sparse matrix handling
8. Multi-user support
9. Unrestricted cross-dimensional operations
10. Intuitive data manipulation
11. Flexible reporting
12. Unlimited dimensions and aggregation levels
You might also like to view...
The ____________________ of a form is the underlying object that provides the fields and data in the form.
Fill in the blank(s) with the appropriate word(s).
A slide master is part of the template that stores information about the formatting and text that displays on EVERY slide in a presentation
Indicate whether the statement is true or false
Why is preproduction so important?
A. Because it's nice to have a lot of material and sketches to show when making videos. B. Because it helps you define the project much better and will help a lot during production. C. To make it more professional, but it's not really that important. D. While it's very important, most people succeed with their projects without preproduction.
The category of operating system used for handheld devices.
A. open source B. embedded C. network D. stand-alone