MULTI-DIMENSIONAL DATA ANALYSIS

• US 20070162472A1
• Filed: 12/26/2006
• Published: 07/12/2007
• Est. Priority Date: 12/23/2005
• Status: Abandoned Application

• Current Assignee: PivotLink Corporation (Citobi SA)
• Original Assignee: Seatab Software Inc. (Citobi SA)
• Inventors: Wan, Qiang, Luo, Ping
• Application Number:
  US11/616,240
• Publication Number:
  US 20070162472A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A system and method for generating a multi-dimensional data structures are provided. One or more data sources including data formats are obtained. Based on data processing requirements, a multi-dimensional data structured is developed and processing definitions for the source data is developed including the alignment of data attributes and the definition of metric calculations. Thereafter, the source data may be queried using the definitions. Additionally, the data definitions may be dynamically modified without requiring the modification of the source data.

Claims

1. A method for managing data comprising:

obtaining a set of source data, wherein the source data corresponds to a native format;

identifying a set of data requirements;

defining a set of data definitions corresponding to the processing of the source data to obtain the set of data requirements; and

storing the set of data definitions.

2. The method as recited in claim 1, wherein the set of data requirements corresponds to a multi-dimensional data structure.

3. The method as recited in claim 1, wherein defining the set of data requirements corresponds to defining a set of data definitions for each data source in the set of source data.

4. The method as recited in claim 1, wherein defining the set of data definitions includes aligning data attributes.

5. The method as recited in claim 4, wherein aligning data attributes includes aligning similar data attributes.

6. The method as recited in claim 4, wherein aligning data attributes includes grouping unsimilar data attributes.

7. The method as recited in claim 1, wherein defining the set of data definitions includes deriving one or more data attributes.

8. The method as recited in claim 1, wherein defining the set of data definitions includes merging metrics.

9. The method as recited in claim 8, wherein defining the set of data definitions includes deriving metrics from a set of merged metrics.

10. A computer-readable medium having computer-executable components for data management comprising:

an interface for obtaining a set of data sources, wherein the set of data sources, wherein the source data corresponds to a native format;

a data processing component for identifying a set of data requirements and processing of the source data to obtain the set of data requirements; and

a second interface for obtaining data queries for the processed source data.

11. A method for managing data comprising:

obtaining a set of source data, wherein the source data corresponds to a native format;

identifying a set of data requirements;

defining a set of data definitions corresponding to the processing of the source data to obtain the set of data requirements;

obtaining a data query;

providing a set of data corresponding to the data query;

obtaining a revised data query based on drill paths.

12. The method as recited in claim 11 further comprising identifying a modified set of data definitions based on the revised data query.