Query generation method, query generation apparatus, and computer-readable recording medium

Patent metadata

Field	Value
Publication number	US-10831746-B2
Application number	US-201816204269-A
Country	US
Kind code	B2
Filing date	Nov 29, 2018
Priority date	Dec 19, 2017
Publication date	Nov 10, 2020
Grant date	Nov 10, 2020

Abstract

A non-transitory computer-readable recording medium stores therein a query generation program that causes a computer to execute a process including: determining, from a plurality of category schemas each being a set of attribute schemas, a main category schema to be associated with an output target table that defines acquisition target data, based on attribute names of a plurality of output items contained in the output target table; determining a subcategory schema to be associated with an un-associated item, which is an output item that is not associated with the main category schema among the plurality of output items, from category schemas that are associated with respective features of a plurality of attribute schemas contained in the main category schema; and generating queries with respect to the plurality of category schemas based on the main category schema and the subcategory schema.

First claim

What is claimed is:

1. A non-transitory computer-readable recording medium storing therein a query generation program that causes a computer to execute a process comprising:
determining, from a plurality of category schemas each being a set of attribute schemas, a main category schema to be associated with an output target table that defines acquisition target data, based on attribute names of a plurality of output items contained in the output target table;
determining a subcategory schema to be associated with an un-associated item, which is an output item that is not associated with the main category schema among the plurality of output items, from category schemas that are associated with respective features of a plurality of attribute schemas contained in the main category schema;
generating queries with respect to the plurality of category schemas based on the main category schema and the subcategory schema;
calculating, when a plurality of category schemas associated with a predetermined feature that is designated in advance among features of the plurality of attribute schemas contained in the main category schema are present, similarities between the attribute names of the attribute schemas contained in each of the category schemas and an attribute name of the un-associated item of the output target table; and
determining a category schema with a highest similarity as the subcategory schema.

2. The non-transitory computer-readable recording medium according to claim 1 , wherein the process further includes:
calculating similarities between attribute names of the attribute schemas contained in each of the category schemas and the attribute names of the output target table, for each of the category schemas; and
determining a category schema with a highest similarity as the main category schema.

3. The non-transitory computer-readable recording medium according to claim 1 , wherein the process further includes determining, when a category schema with a similarity equal to or higher than a threshold is not present, the subcategory schema from a category schema that has an inheritance relationship to inherit a feature of the main category schema.

4. The non-transitory computer-readable recording medium according to claim 1 , wherein the process further includes generating the query for reading data corresponding to each of the output items contained in the output target table from among a plurality of pieces of data stored in the main category schema and a plurality of pieces of data stored in the subcategory schema.

5. A query generation method comprising:
determining, from a plurality of category schemas each being a set of attribute schemas, a main category schema to be associated with an output target table that defines acquisition target data, based on attribute names of a plurality of output items contained in the output target table;
determining a subcategory schema to be associated with an un-associated item, which is an output item that is not associated with the main category schema among the plurality of output items, from category schemas that are associated with respective features of a plurality of attribute schemas contained in the main category schema, by a processor;
generating queries with respect to the plurality of category schemas based on the main category schema and the subcategory schema;
calculating, when a plurality of category schemas associated with a predetermined feature that is designated in advance among features of the plurality of attribute schemas contained in the main category schema are present, similarities between the attribute names of the attribute schemas contained in each of the category schemas and an attribute name of the un-associated item of the output target table; and
determining a category schema with a highest similarity as the subcategory schema.

6. A query generation apparatus comprising:
a processor configured to:
determine, from a plurality of category schemas each being a set of attribute schemas, a main category schema to be associated with an output target table that defines acquisition target data, based on attribute names of a plurality of output items contained in the output target table;
determine a subcategory schema to be associated with an un-associated item, which is an output item that is not associated with the main category schema among the plurality of output items, from category schemas that are associated with respective features of a plurality of attribute schemas contained in the main category schema;
generate queries with respect to the plurality of category schemas based on the main category schema and the subcategory schema;
calculating, when a plurality of category schemas associated with a predetermined feature that is designated in advance among features of the plurality of attribute schemas contained in the main category schema are present, similarities between the attribute names of the attribute schemas contained in each of the category schemas and an attribute name of the un-associated item of the output target table; and
determining a category schema with a highest similarity as the subcategory schema.

Assignees

• Fujitsu Ltd

Inventors

• Okajima Seiji
• Morikawa Hiroaki
• Nishino Fumihito

Classifications

• G06F16/211 Primary

  Schema design and management · CPC title

• G06F17/10

  Complex mathematical operations {(function generation by table look-up G06F1/03; evaluation of elementary functions by calculation G06F7/544)} · CPC title

• G06F16/2423 Primary

  Interactive query statement specification based on a database schema · CPC title

• G06F16/285

  Clustering or classification · CPC title