Data processing system

• US 8,359,299 B2
• Filed: 02/26/2010
• Issued: 01/22/2013
• Est. Priority Date: 09/04/1998
• Status: Expired due to Fees

• Current Assignee: Kalido Ltd. (Insightsoftware UK Trading Ltd.)
• Original Assignee: Kalido Ltd. (Insightsoftware UK Trading Ltd.)
• Inventors: Angus, Christopher, Ottmann, Douglas John Bruce
• Primary Examiner(s): Fleurantin, Jean B
• Application Number:
  US12/713,835
• Publication Number:
  US 20100223296A1
• Time in Patent Office: 1,061 Days
• Field of Search: 707600-831, 711/1, 711/100
• US Class Current: 707/705
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A data processing system is provided for storing and managing multiple data entries. The data processing system employs a data structure which allows the storage and management of a vast number of interrelated data entries the interrelations of which change over time. The data structure reflects such changing interrelations over time and allows the querying and extracting of data entries on the basis of their interrelations as they were or are defined at any desired point in time.

Claims

1. A data processing system, comprising:

a processor for generating a data model in accordance with a data structure, the data model being adaptable to represent a change in the data structure; and

computer memory for storing data in accordance with the generated data model, said stored data including information representative of the time of change in the data structure, said stored data also including validity data indicative of a period of time during which said stored data was valid data, said stored data including;

transaction data representative of one or more measures associated with one or more units, said measures being determined relative to one or more references;

reference data representative of said one or more references; and

metadata descriptive of the transaction data and the reference data, wherein the metadata defines hierarchical associations between classes of the reference data.

2. The data processing system of claim 1, wherein the stored data comprises a number of elements of reference data, each element of reference data comprising information which defines an association with one or more other elements of reference data.

3. The data processing system of claim 2, wherein each element of reference data further comprises information representative of a first period of validity of a defined association.

4. The data processing system of claim 1, wherein the associations between the one or more measures and the one or more units are associated with a second period of validity.

5. The data processing system of any of claim 1, wherein the stored data comprises a number of items of transaction data, each item of transaction data being associated with a date of transaction.

7. The data processing system of claim 1, further comprising:

first interface means for receiving data of any structure from a data source for storage in the data processing system.

8. The data processing system claim 7, further comprising:

second interface means for outputting data from the storage means in a required format.

6. A data processing system comprising:

a processor for generating a data model in accordance with a data structure, the data model being adaptable to represent a change in the data structure; and

computer memory for storing data in accordance with the generated data model, said stored data including information representative of the time of change in the data structure, said stored data also including validity data indicative of a period of time during which said stored data was valid data, said stored data including;

transaction data representative of one or more measures associated with one or more units, said measures being determined relative to one or more references;

reference data representative of said one or more references; and

metadata descriptive of the transaction data and the reference data, wherein the said metadata defines associations between classes of reference data and the one or more measures, the associations between the classes of reference data and the one or more measures being representative of classes of transaction data.