Accessing multi-dimensional data by mapping dense data blocks to

Details Accessing multi-dimensional data by mapping dense data blocks to Accessing multi-dimensional data by mapping dense data blocks to

1997-06-30

1999-11-02

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707100, G06F 1730

Patent

active

059787961

ABSTRACT:
A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A relational database has a fact table and at least one related dimension table. A dimension identifier is received that identifies a data block in a multi-dimensional database. The dimension identifier comprises one or more multi-dimensional member identifiers. Rows are accessed from the fact table through the related dimension tables using the received dimension identifier. Then, the accessed rows are formatted as a data block for the multi-dimensional database.

REFERENCES:
patent: 5257365 (1993-10-01), Powers et al.
patent: 5359724 (1994-10-01), Earle
patent: 5572644 (1996-11-01), Loaw et al.
patent: 5604854 (1997-02-01), Glassey
patent: 5761652 (1998-06-01), Wu et al.
patent: 5799300 (1998-08-01), Agrawal et al.
patent: 5822751 (1998-10-01), Gray et al.
patent: 5848408 (1998-12-01), Jakobsson et al.
Agrawal, R, et al., Modeling multidimensional databases, data engineering, 1997, proceedings, 13th international conference, and 232-243, Apr. 1997.
Maurice Frank, The truth about OLAP, DBMS, vol. 8, No. 9, Aug. 1995, and 40-48.
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). total 16 pages only.
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.

Affiliated with

Also associated with

Rating

Accessing multi-dimensional data by mapping dense data blocks to does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Accessing multi-dimensional data by mapping dense data blocks to, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Accessing multi-dimensional data by mapping dense data blocks to will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2149771