Management-information acquiring program, management information acquiring method, and management information acquiring apparatus

Patent metadata

Field	Value
Publication number	US-2016253383-A1
Application number	US-201615049685-A
Country	US
Kind code	A1
Filing date	Feb 22, 2016
Priority date	Feb 27, 2015
Publication date	Sep 1, 2016
Grant date	—

Abstract

A non-transitory computer-readable storage medium storing therein a management-information acquiring program that causes a computer to execute a process includes acquiring queries to a target database for a management target service system, specifying a reference target table in the database based on names of target tables included in the queries and content of the queries, specifying a reporting target table on the basis of data of the reference target table, causing the database to execute an acquisition query to the reporting target table, and acquiring specific management information from the reporting target table.

First claim

1 . A non-transitory computer-readable storage medium storing therein a management-information acquiring program that causes a computer to execute a process comprising:
acquiring queries to a target database for a management target service system; specifying a reference target table in the database based on names of target tables included in the queries and content of the queries; specifying a reporting target table on the basis of data of the reference target table; causing the database to execute an acquisition query to the reporting target table; and acquiring specific management information from the reporting target table.

2 . The non-transitory computer-readable storage medium according to claim 1 , wherein
the specifying the reporting target table includes specifying a plurality of the reporting target tables, and the process further comprising: creating the acquisition query on the basis of joining information of the plurality of reporting target tables included in an acquired query.

3 . The non-transitory computer-readable storage medium according to claim 2 , wherein,
the creating the acquisition query includes;
executing a joining information search function that makes a determination on whether joining information of a first table and a second table is included in the query and specifies the included joining information by using the reporting target tables as a function input, and
recursively executing the joining information search function until the joining information of the plurality of reporting target tables is obtained.

4 . The non-transitory computer-readable storage medium according to claim 1 , wherein,
the specifying the reference target table includes;
obtaining, for each of the target tables, a number of times when content of the queries is reference, a number of times when the content is registration, and a number of times when the content is update, and
specifying the target table as the reference target table when one or both of a condition under which the number of times of reference is larger than the number of times of registration and a condition under which the number of times of reference is larger than the number of times of update are satisfied.

5 . The non-transitory computer-readable storage medium according to claim 1 , wherein,
the specifying the reporting target table includes specifying the reference target table as the reporting target table when data of the reference target table includes data of the reporting target table.

6 . A method of acquiring management-information, the method comprising:
acquiring queries to a target database for a management target service system; specifying a reference target table included in the database based on names of target tables included in the queries and content of the queries; specifying a reporting target table on the basis of data of the reference target table; causing the database to execute an acquisition query to the reporting target table; and acquiring specified management information from the reporting target table.

7 . The method according to claim 1 , wherein
the specifying the reporting target table includes specifying a plurality of the reporting target tables, and the process further comprising: creating the acquisition query on the basis of joining information of the plurality of reporting target tables included in an acquired query.

8 . An apparatus that acquires acquiring management information, the apparatus comprising:
an install unit configured to install, in a management target system, a management-information acquiring program for causing a computer to execute a process including:
acquiring queries to a target database for a management target system,
specifying a reference target table included in the database based on names of target tables included in the queries and content of the queries,
specifying a reporting target table on the basis of data of the reference target table,
causing the database to execute an acquisition query to the reporting target table, and
acquiring specific management information from the reporting target table; and
a receiver that receives the specific management information.

9 . The apparatus according to claim 8 , wherein
the specifying the reporting target table includes specifying a plurality of the reporting target tables, and the process further includes creating the acquisition query on the basis of joining information of the plurality of reporting target tables included in an acquired query.

10 . The apparatus according to claim 8 , wherein the management information is acquired by executing the management information acquiring program, without executing a query directly to the database.

Assignees

• Fujitsu Ltd

Inventors

• Tokoda Kensuke
• Kouge Kiyoshi
• Nakazawa Takaaki
• Ohta Satoshi
• Torii Yuki
• Miyagawa Yukihisa
• Matsuda Satoshi
• Mori Kenichi
• Yonemoto Yoko
• Nakamura Saeko
• Kawaguchi Takeshi
• Kotani Ichiro
• Nagakura Shinnosuke
• Li Hui
• Tateishi Naoki
• Kandani Kazunori

Classifications

• G06F16/24544 Primary

  Join order optimisation · CPC title

• G06F16/2455

  Query execution · CPC title

• G06F17/30477

  Physics · mapped topic

• G06F17/30466 Primary

  Physics · mapped topic