# US 2023/0053866 A1 · Computer system, and data retrieval support method

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2023/0053866 A1
- Document ID: US20230053866A1
- Status: Published application
- Kind: A1
- Application number: 17/690,247
- Filed: 2022-03-09
- Published: 2023-02-23
- Earliest claimed: 2021-08-23
- Assignees: Hitachi, Ltd.
- Applicants: Hitachi, Ltd.
- Inventors: Katsuaki NAKAMIZO; Yuji KOSEKI; Yasuhiro KAWABATA; Atsushi HIRATA
- Web page: https://patentgrep.com/patent/US20230053866A1

## CPC

- G06F 16/2423: {Interactive query statement specification based on a database schema}
- G06F 16/2445: {Data retrieval commands; View definitions}
- G06F 16/24578: {using ranking}
- G06F 16/25: Integrating or interfacing systems involving database management systems
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A computer system, which is coupled to a plurality of databases configured to store data having different data types, being configured to: manage a catalog database configured to store a catalog including information on an SQL which has been used; execute, in a case of receiving a retrieval request including a first SQL from a user terminal, the first SQL and output an execution result of the first SQL to the user terminal; refer to the catalog database, and select at least one recommended SQL in which a retrieval condition, which is a retrieval condition for retrieving data by joining the plurality of databases, and is similar to the retrieval condition of the first SQL, is defined; and present the at least one recommended SQL to the user terminal.

## Claims

### Claim 1

A computer system, which is coupled to a plurality of databases configured to store data having different data types,
the computer system comprising a computer including a processor, a storage device coupled to the processor, and a network interface coupled to the processor,
the computer system being configured to:
manage a catalog database configured to store a catalog including information on an SQL which has been used;
execute, in a case of receiving a retrieval request including a first SQL from a user terminal, the first SQL and output an execution result of the first SQL to the user terminal;
refer to the catalog database, and select at least one recommended SQL in which a retrieval condition, which is a retrieval condition for retrieving data by joining the plurality of databases, and is similar to the retrieval condition of the first SQL, is defined; and
present the at least one recommended SQL to the user terminal.

### Claim 2 (depends on 1)

The computer system according to claim 1, wherein the computer system is configured to select the at least one recommended SQL based on a similarity degree calculated from a degree of matching between a combination of data items obtained from the plurality of databases in the first SQL and a combination of data items obtained from the plurality of databases in the SQL included in each of a plurality of the catalogs, and a degree of matching between a join condition between the plurality of databases in the first SQL and a join condition between the plurality of databases in the SQL included in each of the plurality of the catalogs.

### Claim 3 (depends on 2)

The computer system according to claim 2, wherein the computer system is configured to:
determine, in a case where a plurality of the recommended SQLs have been selected, a ranking of each of the plurality of the recommended SQLs based on the similarity degree of each of the plurality of the recommended SQLs; and
present the ranked plurality of the recommended SQLs.

### Claim 4 (depends on 2)

The computer system according to claim 2, wherein the computer system is configured to:
manage a history database for managing a usage trend of the retrieval condition;
determine, in a case where a plurality of the recommended SQLs have been selected, a ranking of each of the plurality of the recommended SQLs based on the usage trend of the retrieval condition of each of the plurality of the recommended SQLs by referring to the history database; and
present the ranked plurality of the recommended SQLs.

### Claim 5 (depends on 2)

The computer system according to claim 2,
wherein the catalog includes information on a user who has executed the SQL, and
wherein the computer system is configured to:
manage a publicly available information database for managing information on documents relating to a user who uses the computer system;
determine, in a case where a plurality of the recommended SQLs have been selected, a ranking of each of the plurality of the recommended SQLs based on at least one of a number of documents relating to the user who has executed each of the plurality of the recommended SQLs or a number of citations of each of the documents by referring to the publicly available information database; and
present the ranked plurality of the recommended SQLs.

### Claim 6 (depends on 2)

The computer system according to claim 2, wherein the computer system is configured to:
refer to the catalog database and identify the retrieval condition having a high usage frequency;
generate an SQL in which a retrieval condition generated by using a plurality of the identified retrieval conditions is defined; and
generate the catalog including information on the generated SQL and register the generated catalog in the catalog database.

### Claim 7

A data retrieval support method to be executed by a computer system which is coupled to a plurality of databases configured to store data having different data types,
the computer system having a computer including a processor, a storage device coupled to the processor, and a network interface coupled to the processor,
the computer system being configured to manage a catalog database configured to store a catalog including information on an SQL which has been used,
the data retrieval support method including:
a first step of executing, by the computer, in a case of receiving a retrieval request including a first SQL from a user terminal, the first SQL and outputting an execution result of the first SQL to the user terminal;
a second step of referring, by the computer, to the catalog database, and selecting at least one recommended SQL in which a retrieval condition, which is a retrieval condition for retrieving data by joining the plurality of databases, and is similar to the retrieval condition of the first SQL, is defined; and
a third step of presenting, by the computer, the at least one recommended SQL to the user terminal.

### Claim 8 (depends on 7)

The data retrieval support method according to claim 7, wherein the second step includes selecting, by the computer, the at least one recommended SQL based on a similarity degree calculated from a degree of matching between a combination of data items obtained from the plurality of databases in the first SQL and a combination of data items obtained from the plurality of databases in the SQL included in each of a plurality of the catalogs, and a degree of matching between a join condition between the plurality of databases in the first SQL and a join condition between the plurality of databases in the SQL included in each of the plurality of the catalogs.

### Claim 9 (depends on 8)

The data retrieval support method according to claim 8,
wherein the second step includes determining, by the computer, in a case where a plurality of the recommended SQLs have been selected, a ranking of each of the plurality of the recommended SQLs based on the similarity degree of each of the plurality of the recommended SQLs, and
wherein the third step includes presenting, by the computer, the ranked plurality of the recommended SQLs.

### Claim 10 (depends on 8)

The data retrieval support method according to claim 8,
wherein the computer system is configured to manage a history database for managing a usage trend of the retrieval condition,
wherein the second step includes determining, by the computer, in a case where a plurality of the recommended SQLs have been selected, a ranking of each of the plurality of the recommended SQLs based on the usage trend of the retrieval condition of each of the plurality of the recommended SQLs by referring to the history database, and
wherein the third step includes presenting, by the computer, the ranked plurality of the recommended SQLs.

### Claim 11 (depends on 8)

The data retrieval support method according to claim 8,
wherein the catalog includes information on a user who has executed the SQL, and
wherein the computer system is configured to manage a publicly available information database for managing information on documents relating to a user who uses the computer system,
wherein the second step includes determining, by the computer, in a case where a plurality of the recommended SQLs have been selected, a ranking of each of the plurality of the recommended SQLs based on at least one of a number of documents relating to the user who has executed each of the plurality of the recommended SQLs or a number of citations of each of the documents by referring to the publicly available information database, and
wherein the third step includes presenting, by the computer, the ranked plurality of the recommended SQLs.

### Claim 12 (depends on 8)

The data retrieval support method according to claim 8, further including:
referring, by the computer, to the catalog database and identifying the retrieval condition having a high usage frequency;
generating, by the computer, an SQL in which a retrieval condition generated by using a plurality of the identified retrieval conditions is defined; and
generating, by the computer, the catalog including information on the generated SQL and registering the generated catalog in the catalog database.
