AUTOMATED ABSTRACT DATABASE GENERATION THROUGH EXISTING APPLICATION STATEMENT ANALYSIS

• US 20060265404A1
• Filed: 08/03/2006
• Published: 11/23/2006
• Est. Priority Date: 02/12/2003
• Status: Active Grant

• Current Assignee: Eric W. Will, Frederick A. Kulack, Richard D. Dettinger, Richard J. Stevens
• Original Assignee: Eric W. Will, Frederick A. Kulack, Richard D. Dettinger, Richard J. Stevens
• Inventors: Dettinger, Richard D., Stevens, Richard J., Will, Eric W., Kulack, Frederick A.
• Granted Patent: US 8,615,527 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

The present invention generally is directed to methods, articles of manufacture and systems for automatically generating abstract representations of a limited subset of data repository fields accessed by a particular application. The limited subset of fields may be identified by monitoring queries issued against the data repository by the application. The abstract representations may be grouped in a data repository abstraction (DRA) component that serves as a data definition framework allowing data from the fields to be accessed independent of the particular in which the data is physically represented in the data repository. By limiting the fields exposed to the application to the limited subset of fields actually accessed by the application, the DRA component, in effect, provides the application with a custom database tailored to its particular needs.

Claims

1. A computer implemented method for automatically generating a data repository abstraction component describing, and used to access, data in a data repository, the method comprising:

monitoring queries issued against the data repository by an application;

collecting, from the monitored queries, information regarding usage of the fields of the data repository;

identifying, from the collected usage information, a limited subset of one or more fields of the data repository accessed by the application; and

generating, for use in the data repository abstraction component, abstract representations for the limited subset of fields;

wherein the abstract representations logically model the respective limited subset of fields;

whereby the data repository abstraction component is customized on the basis of usage of the fields of the data repository.

2. The method of claim 1, wherein identifying the limited subset of fields comprises extracting, from the monitored queries, a list of one or more referenced fields.

3. The method of claim 2, further comprising determining, based on the monitored queries, whether one or more of the referenced fields is a searchable field.

4. The method of claim 2, further comprising determining, based on the monitored queries, whether one or more of the referenced fields is returned as query results.

5. The method of claim 2, further comprising determining, from the monitored queries, a logical name for the at least one referenced field to be included in a corresponding abstract representation.

6. The method of claim 2, further extracting information regarding a relationship between at least two referenced fields.

7. The method of claim 1, wherein monitoring the queries comprises examining an output modifier used in a monitored query.

8. The method of claim 1, further comprising gathering metadata for results returned for the monitored queries.

9. The method of claim 8, further comprising obtaining, from the metadata, a list of fields returned as query results.

10. The method of claim 9, wherein generating the abstract representations comprises generating an abstract representation for at least one of the fields returned as query results.

11. A computer readable storage medium containing a program which when executed by a processor performs an operation for automatically generating a data repository abstraction component describing, and used to access, data in a data repository, the operation comprising:

monitoring queries issued against the data repository by an application;

collecting, from the monitored queries, information regarding usage of the fields of the data repository;

identifying, from the collected usage information, a limited subset of one or more fields of the data repository accessed by the application; and

generating, for use in the data repository abstraction component, abstract representations for the limited subset of fields;

wherein the abstract representations logically model the respective limited subset of fields;

whereby the data repository abstraction component is customized on the basis of usage of the fields of the data repository.

12. The computer readable storage medium of claim 11, wherein identifying the limited subset of fields comprises extracting, from the monitored queries, a list of one or more referenced fields.

13. The computer readable storage medium of claim 12, further comprising determining, based on the monitored queries, whether one or more of the referenced fields is a searchable field.

14. The computer readable storage medium of claim 12, further comprising determining, based on the monitored queries, whether one or more of the referenced fields is returned as query results.

15. The computer readable storage medium of claim 12, further comprising determining, from the monitored queries, a logical name for the at least one referenced field to be included in a corresponding abstract representation.

16. The computer readable storage medium of claim 12, further extracting information regarding a relationship between at least two referenced fields.

17. The computer readable storage medium of claim 11, wherein monitoring the queries comprises examining an output modifier used in a monitored query.

18. The computer readable storage medium of claim 11, further comprising gathering metadata for results returned for the monitored queries.

19. The computer readable storage medium of claim 18, further comprising obtaining, from the metadata, a list of fields returned as query results.

20. The computer readable storage medium of claim 19, wherein generating the abstract representations comprises generating an abstract representation for at least one of the fields returned as query results.

21. A data processing system, comprising:

a processor and memory;

a data repository;

an application suitable for querying the data repository; and

a data repository abstraction generator configured to generate a data repository abstraction component describing, and used to access, data in the data repository based on usage information collected by monitoring and parsing queries issued against the data repository by the application;

wherein the data repository abstraction generator is configured to generate a plurality of logical field specifications for a limited subset of fields of the data repository accessed by the application, as indicated by the monitored queries;

whereby the data repository abstraction is customized on the basis of how the application queries the data repository.

22. The data processing system of claim 21, wherein the data repository abstraction generator is configured to determine a logical name, to include in one or more of the generated logical field specifications, based on reference to one or more corresponding fields in the data repository in the monitored queries.

23. The data processing system of claim 21, wherein the data repository comprises a relational database and the data repository generator is configured to extract a list of referenced tables and associated columns from the monitored queries and generate logical field specifications for at least one of the columns.

24. The data processing system of claim 21, wherein the collected usage information comprises output modifiers within the modified queries.

25. The data processing system of claim 21, wherein the data repository abstraction generator is configured to gather metadata for results returned for the monitored queries.

26. The data processing system of claim 25, wherein the data repository abstraction generator is further configured to obtain, from the metadata, a list of fields and associated data types returned as results for the monitored queries.

27. The data processing system of claim 25, wherein the data repository abstraction generator is configured to generate a logical field specification including the associated data type for one or more of the fields returned as results for the monitored queries.