Query data acquisition and analysis

摘要

Described in this disclosure are systems and techniques for acquiring query data which includes an execution plan descriptive of how queries used to access a database are processed. In one implementation, an inquiry analysis system uses a copy of a production system to generate execution plan information. The copy includes tables, relationships, metadata, and so forth, but may omit data in the tables, allowing for a compact installation. By analyzing the query data, usage trends, inefficient queries, unused fields, and so forth may be determined and used for maintenance or performance improvements.

主权项

1. A system comprising:
a communication interface; a memory storing computer-executable instructions; and a processor configured to couple to the communication interface, access the memory, and execute the computer-executable instructions to:
receive a first set of information about at least one data structure from a first database, wherein the at least one data structure is indicative of one or more tables in a relational database;receive metadata associated with the first database;based at least in part on the first set of information about the at least one data structure from a first database and the metadata, generate a second database comprising a shadow database having the at least one data structure of the first database and the metadata associated with the first database duplicated in the second database with data from the first database omitted;receive a query, wherein the query comprises expressions in a data manipulation language;generate an execution plan based on parsing the query to execute the query against the second database, wherein the execution plan comprises information indicative of execution of the query against the second database having the at least one data structure of the first database and the metadata associated with the first database duplicated in the second database with data from the first database omitted from the second database;store query data comprising the query and the execution plan;receive an information request;access the query data; andgenerate analysis output based on the information request and the query data.