Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-06-30
1999-08-24
Amsbury, Wayne
Data processing: database and file management or data structures
Database design
Data structure types
707 5, 707100, 707102, G06F 1730
Patent
active
059436689
ABSTRACT:
A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A multi-dimensional database is defined having a set of multi-dimensional data blocks and a set of identifiers comprising selected dimensions of multi-dimensional data for identifying particular ones of the multi-dimensional data blocks. The set of identifiers provides an ordering of the multi-dimensional data blocks using multi-dimensional member identifiers and holds usage information and age information about the multi-dimensional data blocks. The data in the set of multi-dimensional data blocks is stored in a relational database that represents the multi-dimensional database. Then, a set of rows representing a multi-dimensional data block is accessed from the relational database.
REFERENCES:
patent: 5359724 (1994-10-01), Earle
patent: 5442784 (1995-08-01), Powers et al.
patent: 5706495 (1998-01-01), Chadha et al.
patent: 5721910 (1998-02-01), Unger et al.
patent: 5767854 (1998-06-01), Anwar
patent: 5799300 (1998-08-01), Agrawal et al.
Metaphor Business Series, "Examining Corporate and Syndicated Data", Chapter 3: "Reporter Workshop", 1990, pp. 3-1 through 3-66.
Archer Decision Sciences, Inc., Internet article, http://www.strategy.com/dwf/raden/str101.htm, 1995-1996 (entire document).
Kimball, Ralph, "The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses", Appendix D: "User's Guide for Star Tracker.TM.", published by John Wiley & Sons, Inc., 1996, pp. 321-366.
Malloy William Earl
Moore Simon Edward
Robinson Gary
Tomlyn Craig Reginald
Amsbury Wayne
Channavajjala Srirama
International Business Machines - Corporation
LandOfFree
Relational emulation of a multi-dimensional database does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Relational emulation of a multi-dimensional database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Relational emulation of a multi-dimensional database will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-476921