Method of managing database, management computer and storage medium
AssigneeHitachi, Ltd.
InventorKazutomo USHIJIMA
Life of this patent
Estimating the term…
Abstract
The present invention is a method of managing a database, which manages a graph database and a relational database on a computer provided with a processor and memory, wherein the computer acquires frequency of reference for each type of node of a graph database, extracts types of nodes for which the reference frequency is greater than or equal to a threshold, converts the extracted nodes to a table structure, and then retains the same as an intermediate table, and upon receiving an inquiry by the relational database, references the intermediate table.
Claims15
A database management method for managing a graph database and a relational database in a computer comprising a processor and a memory, the database management method comprising:
- a first step of acquiring, by the computer, a reference frequency for each type of node in the graph database;
- a second step of extracting, by the computer, the types of nodes having a reference frequency equal to or more than a threshold;
- a third step of converting, by the computer, the extracted nodes into a table structure and storing the table structure as an intermediate table;
- and
- a fourth step of referencing, by the computer, the intermediate table based on a received query to the relational database.
A management computer configured to reference a graph database and a relational database, comprising:
- a processor and a memory;
- a statistical information management module configured to acquire a reference frequency for each type of node in the graph database;
- a high-frequency reference range determination module configured to extract the types of nodes having a reference frequency equal to or more than a threshold, convert the extracted nodes into a table structure, and store the table structure as an intermediate table;
- and
- a query execution module configured to reference the intermediate table based on a received query to the relational database.
A non-transitory computer-readable storage medium having stored thereon a program for controlling a computer comprising a processor and a memory to execute:
- a first procedure of acquiring a reference frequency for each type of node in a graph database;
- a second procedure of extracting, by the computer, the types of nodes having a reference frequency equal to or more than a threshold;
- a third procedure of converting, by the computer, the extracted nodes into a table structure and storing the table structure as an intermediate table;
- and
- a fourth procedure of referencing, by the computer, the intermediate table based on a received query to a relational database.
Dependencies are inferred from the claim text.