GENERATING SUMMARIES FOR QUERY RESULTS BASED ON FIELD DEFINITIONS

• US 20080168042A1
• Filed: 01/09/2007
• Published: 07/10/2008
• Est. Priority Date: 01/09/2007
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Kulack, Frederick A.
• Application Number:
  US11/621,301
• Publication Number:
  US 20080168042A1
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Embodiments of the invention provide techniques for generating summaries for query results based on field definitions. The summaries are generated automatically according to specifications in the field definitions of the fields included in the query results. Each result field may include one or more summaries that are designed to summarize the type of data of the particular field.

Claims

1. A method of generating summaries for query search results, comprising:

receiving the query search results for a query executed against a database, wherein the search results include result fields and corresponding values for the result fields and wherein the result fields have respective field definitions that define attributes of the respective result fields and wherein at least one of the field definitions includes a data summary specification;

identifying one or more data summary specifications defined in the respective field definitions of the result fields of the query search results; and

generating a summary for each of the identified one or more data summary specifications.

2. The method of claim 1, wherein the field definitions are included in a database abstraction model, and wherein each field definition specifies an access method for accessing data in the database corresponding to the field definition, and wherein the executed query is a transformed instance of an abstract query composed on the basis of the database abstraction model and wherein the abstract query includes the result fields.

3. The method of claim 2, wherein the data abstraction model further defines a plurality of focus entities, wherein a user specifies a focus for the abstract query by selecting a focus entity from the plurality of focus entities.

4. The method of claim 1, further comprising presenting the generated summaries in a graphical user interface with the search results.

5. The method of claim 4, wherein the presentation of the search results is performed in one or more tabbed screens of the graphical user interface, wherein each tabbed screen presents one or more of the generated summaries for a given result field.

6. The method of claim 1, wherein at least one of the field definitions includes at least two data summary specifications, wherein each data summary specification causes the data to be summarized differently.

7. The method of claim 1, wherein generating the summary for a given data summary specification comprises invoking an executable plug-in configured to generate the respective summary, wherein the plug-in is invoked using a reference to the plug-in in the given data summary specification.

8. The method of claim 1, wherein generating the summary for each of the identified one or more data summary specifications is performed only upon determining that conditions specified by the identified one or more data summary specifications are satisfied.

9. A computer readable medium containing a program which, when executed, performs an operation of generating summaries for query search results, the operation comprising:

receiving search results for a query executed against a database, wherein the search results include result fields and corresponding values for the result fields and wherein the result fields have respective field definitions that define attributes of the respective result fields and wherein at least one of the field definitions includes a data summary specification;

identifying one or more data summary specifications defined in the respective field definitions of the result fields of the query results; and

generating a summary for each of the identified one or more data summary specifications.

10. The computer readable medium of claim 9, wherein the field definitions are included in a database abstraction model, and wherein each field definition specifies an access method for accessing data in the database corresponding to the field definition, and wherein the executed query is a transformed instance of an abstract query composed on the basis of the database abstraction model and wherein the abstract query includes the result fields.

11. The computer readable medium of claim 10, wherein the data abstraction model further defines a plurality of focus entities, wherein a user specifies a focus for the abstract query by selecting a focus entity from the plurality of focus entities.

12. The computer readable medium of claim 9, further comprising presenting the generated summaries in a graphical user interface with the search results.

13. The computer readable medium of claim 12, wherein the presentation of the search results is performed in one or more tabbed screens of the graphical user interface, wherein each tabbed screen presents one or more of the generated summaries for a given result field.

14. The computer readable medium of claim 9, wherein at least one of the field definitions includes at least two data summary specifications, wherein each data summary specification causes the data to be summarized differently.

15. The computer readable medium of claim 9, wherein generating the summary for a given data summary specification comprises invoking an executable plug-in configured to generate the respective summary, wherein the plug-in is invoked using a reference to the plug-in in the given data summary specification.

16. A system, comprising:

a database abstraction model of data stored in a physical database that defines a plurality of logical fields that each specify an access method for accessing data in the physical database, wherein one or more of the logical fields include data summary specifications applied to generate summaries for query results that include the respective logical field; and

a runtime component configured to receive an abstract query composed from the plurality of logical fields, and further configured to generate a resolved query corresponding to a schema of the underlying physical database, and further configured, upon receiving any query results, to generate a summary for one or more result fields of the abstract query according to the respective data summary specifications of the result fields.

17. The system of claim 16, further comprising a query building interface for composing the abstract query from the plurality of logical fields, wherein the interface is configured to display an initial query result to a user, and further configured to display the generated summaries.

18. The system of claim 17, wherein the query building interface includes one or more tabbed screens, wherein each tabbed screen presents one or more of the generated summaries for a given result field.

19. The system of claim 16, wherein the runtime component causes a given data summary specification to be generated by invoking an executable plug-in configured to generate the respective summary, wherein the plug-in is invoked using a reference to the plug-in in the given data summary specification.

20. The system of claim 16, wherein at least one of the logical fields includes at least two data summary specifications, wherein each data summary specification causes the data to be summarized differently.

21. A system, comprising:

a database abstraction model of data stored in a physical database that defines a plurality of logical fields that each specify an access method for accessing data in the physical database, wherein one or more of the logical fields include data summary specifications applied to generate summaries for query results that include the respective logical field.

22. The system of claim 21, wherein generating the summary for a given data summary specification comprises invoking an executable plug-in configured to generate the respective summary, wherein the plug-in is invoked using a reference to the plug-in in the given data summary specification.

23. The system of claim 21, wherein at least one of the logical fields includes at least two data summary specifications, wherein each data summary specification causes the data to be summarized differently.