EXPANDABLE METHOD AND SYSTEM FOR STORING AND USING FACT DATA STRUCTURE FOR USE WITH DIMENSIONAL DATA STRUCTURE

• US 20150112953A1
• Filed: 09/24/2014
• Published: 04/23/2015
• Est. Priority Date: 10/22/2013
• Status: Abandoned Application

• Current Assignee: Omnition Analytics LLC
• Original Assignee: Omnition Analytics LLC
• Inventors: Nair, Kishore, Shannon, Eric T
• Application Number:
  US14/495,184
• Publication Number:
  US 20150112953A1
• Time in Patent Office: Days
• US Class Current: 707/694
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

The ability to store fact data and related dimensions is improved by having a single fact data structure connected to a plurality of dimensional structures via a bridge structure, which take the position of the data structure.

Claims

1. A data system comprising a single fact data structure having a plurality of fact and a plurality of dimensional data structures capable of adding additional dimensional data structures without having to add additional fact data structures comprising associating the fact data and dimensional data structures together by coupling them each directly to a bridge data structure wherein each dimensional structure is added to the bridge data structure utilizing a dimension key entry in the bridge data structure to associate at least one of the fact data with the dimensional structure.

2. The data system according to claim 1 wherein the data system is at least one of a database data structure and object data structure.

3. A data system according to claim 2 wherein the data system is an open database connectivity database.

4. A data system according to claim 1 which further comprises a rules data store and a software that facilitates the operation and maintenance of the data system.

5. A bridge data structure for use in a data storage system having a single fact data structure and a plurality of dimensional data structures wherein the bridge data structure links the fact data structure and the plurality of dimensional data structures by coupling them each directly to a bridge data structure wherein each dimensional structure is added to the bridge data structure utilizing a dimension key entry in the bridge data structure to associate at least one of the facts with the dimensional structure.