Query generation assist method and query generation assist apparatus
To derive a query which can be joined and which gives non-zero pieces of data even if joined. A query generation assist method to assist generation of a query to extract data from a database includes: a first step of accepting, at the computer, a condition of extracting data to be acquired from the database as a data extraction condition; a second step of extracting, as graph data and at the computer, data which can be joined in data of the database; a third step of extracting subgraphs at the computer based on the data extraction condition from the graph data, and acquiring the subgraphs as query candidates; and a fourth step of calculating, at the computer, rank values of the query candidates and outputting the query candidates ranked according to the rank values.
1. A query generation assist apparatus for assisting generation of a query to extract data from a database, the apparatus comprising:
a memory;
an input/output device; and
a processor communicatively coupled to the memory and the input/output device, wherein the processor is configured to
accept a condition of extracting data to be acquired from the database as a data extraction condition,
extract, as graph data, data which can be joined in data of the database,
extract subgraphs based on the data extraction condition from the graph data,
set a value to a predetermined number, the value corresponding to an upper limit of a number of combinations of the subgraphs included in matching entries in the data extraction condition,
determine if the value is equal to the upper limit,
when the value is equal to the upper limit, combine a plurality of subgraphs,
generate query candidates based on data extraction conditions,
integrate the query candidates into a group of candidates,
determine if the group of candidates should be executed at the database,
when the groups of candidates are executed at the database, the acquired data is saved in the database and the processor receives a competition message, and
calculate rank values of the query candidates and output the query candidates ranked according to the rank values.
2. The query generation assist apparatus according to claim 1 , wherein the processor accepts an other query candidate which is a conversion target and not in the query candidates generated, and generates a query based on a correspondence between the other query candidate and the subgraphs.
3. The query generation assist apparatus according to claim 1 , wherein the processor
accepts a candidate derivation condition including at least one of a table count, a data join count and a count of table-joining routes, in addition to the data extraction condition,
extracts subgraphs satisfying the candidate derivation condition, and
outputs as a narrow-down result the subgraphs satisfying the candidate derivation condition.
4. The query generation assist apparatus according to claim 1 ,
wherein the processor accepts a candidate derivation condition including at least one of a table count, a data join count and a count of table-joining routes, in addition to the data extraction condition, and
the processor calculates the rank values from at least one of the table count, the data join count and the count of table-joining routes.