Accessing multi-dimensional data by mapping dense data blocks to rows in a relational database
US5978796A · kind A · utility
169Cited by
8References
30Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 30, 1997 |
| Grant date | Nov 2, 1999 |
| Priority date | — |
| Expiry date | Jun 30, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99933
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.