Data analysis method, data analysis device, and storage medium storing processing program for same

• US 9,892,187 B2
• Filed: 09/14/2012
• Issued: 02/13/2018
• Est. Priority Date: 09/14/2012
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Tsuchida, Masashi, Kotera, Takashi, Matsuura, Shohei, Nakano, Yukio
• Primary Examiner(s): NGUYEN, KIM T
• Application Number:
  US14/402,838
• Publication Number:
  US 20150100543A1
• Time in Patent Office: 1,978 Days
• Field of Search: 707603, 707798
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A data analysis method for analyzing data on a data analysis apparatus having: setting, a plurality of dimension tables each having a first identifier for identifying data to be analyzed and attributes corresponding to the first identifier; setting, a history table having a second identifier associated with each of the first identifiers of the dimension tables, and having attributes corresponding to the second identifier; setting, a relation table for storing attributes relating to the first identifier, the dimension tables having a first dimension table associated with the relation table through the attribute relating to the first identifier; associating, the first identifiers that refers to the first identifier of a first dimension table with the attributes; and processing, a query for the relation table and the first dimension table, and generating a second dimension table.

Claims

1. A data analysis method for analyzing data on a data analysis apparatus comprising a storage, comprising:

a first step of setting, by the data analysis apparatus, a plurality of dimension tables each comprising a plurality of first identifier entries for identifying data to be analyzed and attributes corresponding to each first identifier;

a second step of setting, by the data analysis apparatus, a history table comprising a plurality of second identifier entries respectively associated with each of the first identifiers of the plurality of dimension tables, and comprising attributes corresponding to each of the second identifiers, wherein the attributes and corresponding second identifiers are stored in a time series;

a third step of setting, by the data analysis apparatus, a relation table comprising a first column and a second column, each of the first column and the second column having entries associated with an entry of the first identifiers of the dimension tables and comprising attributes corresponding to the entries of both the first column and the second column, the plurality of dimension tables comprising a first dimension table associated with first column and the second column of the relation table;

a fourth step of associating, by the data analysis apparatus, each entry of the first column with each entry of the second column that refers to the first identifier of the first dimension table and combining the first dimension table and the relation table to be a graph structure by setting the first identifier of the first dimension table as a node and using the first column and the second column of the relation table indicating the correlation between the first column and the second column as an edge; and

a fifth step of processing, by the data analysis apparatus, a query for the relation table and the first dimension table, and generating a second dimension table as a result of the processing of the query.

2. The data analysis method according to claim 1, further comprising a sixth step of executing, by the data analysis apparatus, a query in which the generated second dimension table, the plurality of dimension tables, and the history table relating thereto are associated with one another.

3. The data analysis method according to claim 1, wherein the fifth step comprises a seventh step of executing, by the data analysis apparatus, a query in which the plurality of dimension tables and the history table relating thereto are associated with each other, generating the second dimension table as a result of executing the query, and further comprising a seventh step of executing a query in which the generated second dimension table and the relation table are associated with each other.

4. The data analysis method according to claim 1, wherein the fifth step further comprises designating, by a query in which the relation table and the first dimension table are associated with each other, the attribute identified from the graph structure formed of the relation table and the first dimension table.

5. The data analysis method according to claim 2, wherein the sixth step comprises designating, by a query in which the second dimension table and the relation table are associated with each other, the attribute of the second dimension table.

6. The data analysis method according to claim 2, wherein the sixth step comprises designating, by a query in which the second dimension table, the plurality of dimension tables, and the history table relating thereto are associated with one another, the attribute and a range of a plurality of attribute values.

7. The data analysis method according to claim 3, wherein the seventh step comprises designating, by a query in which the second dimension table and the relation table are associated with each other, the attribute of the second dimension table.

8. The data analysis method according to claim 3, wherein the seventh step comprises designating, by a query in which the second dimension table, the plurality of dimension tables, and the history table relating thereto are associated with one another, the attribute and a range of a plurality of attribute values.

9. A data analysis apparatus for analyzing data, comprising:

a processor;

a storage;

a table definition processing part configured to;

set a plurality of dimension tables each comprising a plurality of first identifier entries for identifying data to be analyzed and attributes corresponding to each first identifier;

set a history table comprising a plurality of second identifier entries respectively associated with each of the first identifier entries of the plurality of dimension tables, and comprising attributes corresponding to each of the second identifiers, wherein the attributes and corresponding second identifiers are stored in a time series;

set a relation table including a first column and a second column, each of the first column and the second column having entries associated with an entry of the first identifiers of the dimension tables and comprising attributes corresponding to the entries of both the first column and the second column, the plurality of dimension tables comprising a first dimension table associated with the first column and the second column of the relation table; and

associate each entry of the first column with each entry of the second column that refers to the first identifier of the first dimension table with the attributes and combining the first dimension table and the relation table to be a graph structure by setting the first identifier of the first dimension table as a node and using the first column and the second column of the relation table indicating the correlation between the first column and the second column as an edge;

a data load part for capturing data into each of the plurality of dimension tables, the history table, and the relation table; and

a query processing part for receiving a query, executing a query for the plurality of dimension tables, the history table, and the relation table, and generating a second dimension table as a result of executing the query.

10. The data analysis apparatus according to claim 9, wherein the query processing part executes a query in which the generated second dimension table, the plurality of dimension tables, and the history table relating thereto are associated with one another.

11. The data analysis apparatus according to claim 9, wherein the query processing part is configured to:

execute a query in which the plurality of dimension tables and the history table relating thereto are associated with each other;

generate the second dimension table as a result of executing the query; and

execute a query in which the generated second dimension table and the relation table are associated with each other.

12. The data analysis apparatus according to claim 9, wherein the query processing part designates, by a query in which the relation table and the first dimension table are associated with each other, the attribute identified from the graph structure formed of the relation table and the first dimension table.

13. The data analysis apparatus according to claim 10, wherein the query processing part designates, by a query in which the second dimension table and the relation table are associated with each other, the attribute of the second dimension table.

14. The data analysis apparatus according to claim 10, wherein the query processing part designates, by a query in which the second dimension table, the plurality of dimension tables, and the history table relating thereto are associated with one another, the attribute and a range of a plurality of attribute values.

15. A non-transitory storage medium having stored thereon a processing program for controlling a computer comprising a processor and a storage to analyze data, the processing program controlling the computer to execute:

setting a plurality of dimension tables each comprising a plurality of first identifier entries for identifying data to be analyzed and attributes corresponding to each first identifier;

setting a history table comprising a plurality of second identifier entries respectively associated with each of the first identifiers of the plurality of dimension tables, and comprising attributes corresponding to each of the second identifiers, wherein the attributes and corresponding second identifiers are stored in a time series;

setting a relation table comprising a first column and a second column, each of the first column and the second column having entries associated with an entry of the first identifiers of the dimension tables and comprising attributes corresponding to the entries of both the first column and the second column, the plurality of dimension tables comprising a first dimension table associated with first column and the second column of the relation table;

associating each entry of the first column with each entry of the second column that refers to the first identifier of the first dimension table with the attributes and combining the first dimension table and the relation table to be a graph structure by setting the first identifier of the first dimension table as a node and using the first column and the second column of the relation table indicating the correlation between the first column and the second column as an edge; and

performing processing based on a query for the relation table and the first dimension table, and generating a second dimension table as a result of the processing of the query.

16. The non-transitory storage medium having stored thereon a processing program according to claim 15, wherein the processing program further controls the computer to execute:

executing a query in which the generated second dimension table, the plurality of dimension tables, and the history table relating thereto are associated with one another.

17. The non-transitory storage medium having stored thereon a processing program according to claim 15, wherein the processing program further controls the computer to execute:

executing a query in which the plurality of dimension tables and the history table relating thereto are associated with each other, generating the second dimension table as a result of executing the query, and executing a query in which the generated second dimension table and the relation table are associated with each other.

18. The non-transitory storage medium having stored thereon a processing program according to claim 15, wherein the processing program further controls the computer to execute:

designating, by a query in which the relation table and the first dimension table are associated with each other, the attribute identified from the graph structure formed of the relation table and the first dimension table.

19. The non-transitory storage medium having stored thereon a processing program according to claim 16, wherein the processing program further controls the computer to execute:

designating, by a query in which the second dimension table and the relation table are associated with each other, the attribute of the second dimension table.

20. The non-transitory storage medium having stored thereon a processing program according to claim 16, wherein the processing program further controls the computer to execute:

designating, by a query in which the second dimension table, the plurality of dimension tables, and the history table relating thereto are associated with one another, the attribute and a range of a plurality of attribute values.