System and method for managing presentation of query results

• US 20070143245A1
• Filed: 12/16/2005
• Published: 06/21/2007
• Est. Priority Date: 12/16/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard, Glowacki, Janice, Rao, Padma, Wenzel, Shannon, Sperber, Marci, Kolz, Daniel
• Application Number:
  US11/303,524
• Publication Number:
  US 20070143245A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

A method, system and article of manufacture for managing presentation of query results. One embodiment comprises receiving, from a requesting entity, a query having at least (i) one result field for which data from one or more databases is to be returned, (ii) one or more conditions for filtering which of the data contained in the one or more databases is returned for each result field, and (iii) a conditions object defining at least one expression for at least one of the conditions. The query is executed against the one or more databases to obtain a query result having one or more data records. The query result is returned in a format relating the data records to respective expressions on the basis of which conditions the data records satisfy. Thereby, it is exposed which of the data records satisfy respective conditions having defined expressions in the conditions object.

Claims

1. A method for managing presentation of a query result, comprising:

receiving, from a requesting entity, a query having at least;

(i) one result field for which data from one or more databases is to be returned;

(ii) one or more conditions for filtering which of the data contained in the one or more databases is returned for each result field; and

(iii) a conditions object defining at least one expression for at least one of the conditions;

executing the query against the one or more databases to obtain a query result having one or more data records; and

returning the query result in a format relating the data records to respective expressions on the basis of which conditions the data records satisfy, thereby exposing which of the data records satisfy respective conditions having defined expressions in the conditions object.

2. The method of claim 1, wherein executing the query comprises generating metadata identifying each data record that satisfies conditions for which an expression is defined in the condition object.

3. The method of claim 2, further comprising:

persistently storing the query result and the generated metadata to allow subsequent retrieval thereof.

4. The method of claim 2, wherein returning the query result in a format relating the data records to respective expressions comprises returning the obtained query result and the generated metadata.

5. The method of claim 2, further comprising:

formatting the query result to render the format relating the data records to respective expressions on the basis of which conditions the data records satisfy;

wherein formatting comprises highlighting each data record related to each of the expressions in a manner that distinguishes the expressions from one another in the query result.

6. The method of claim 5, wherein the formatting further comprises determining each data record related to one of the expressions using the metadata.

7. The method of claim 5, wherein highlighting each data record related to each of the expressions comprises at least one of:

(i) associating each data record related to a particular expression with an indication of the expression;

(ii) displaying each data record related to a particular expression in a specific color associated with the expression; and

(iii) displaying all data records related to a particular expression separate from data records that are related to a different expression.

8. The method of claim 1, further comprising:

formatting the query result to render the format relating the data records to respective expressions on the basis of which conditions the data records satisfy;

wherein formatting comprises for each data record that satisfies at least one group of conditions having at least one defined expression in the conditions object at least one of;

(i) associating the data record with an indication of the at least one defined expression;

(ii) displaying the data record in a specific color associated with the at least one defined expression; and

(iii) displaying the data record together with all other data records that satisfy the at least one group of conditions separate from other data records that are not satisfying the at least one group of conditions.

9. The method of claim 1, further comprising:

after executing the query to obtain the query result, identifying each data record in the query result that satisfies conditions for which an expression is defined in the condition object.

10. The method of claim 9, further comprising:

generating metadata indicating each identified data record;

wherein returning the query result in a format relating the data records to respective expressions comprises returning the obtained query result and the generated metadata.

11. The method of claim 1, wherein each condition is defined using one or more logical fields of a data abstraction model abstractly describing the data in the database;

whereby the query defines an abstract query, and wherein the data abstraction model is adapted for transforming the one or more logical fields of the abstract query into a form consistent with a physical representation of the data in the database.

12. A computer-readable medium containing a program which, when executed by a processor, performs a process for managing presentation of a query result, the process comprising:

receiving, from a requesting entity, a query having at least;

(i) one result field for which data from one or more databases is to be returned;

(ii) one or more conditions for filtering which of the data contained in the one or more databases is returned for each result field; and

(iii) a conditions object defining at least one expression for at least one of the conditions;

executing the query against the one or more databases to obtain a query result having one or more data records; and

returning the query result in a format relating the data records to respective expressions on the basis of which conditions the data records satisfy, thereby exposing which of the data records satisfy respective conditions having defined expressions in the conditions object.

13. The computer-readable medium of claim 12, wherein executing the query comprises generating metadata identifying each data record that satisfies conditions for which an expression is defined in the condition object.

14. The computer-readable medium of claim 13, wherein the process further comprises:

persistently storing the query result and the generated metadata to allow subsequent retrieval thereof.

15. The computer-readable medium of claim 13, wherein returning the query result in a format relating the data records to respective expressions comprises returning the obtained query result and the generated metadata.

16. The computer-readable medium of claim 13, wherein the process further comprises:

formatting the query result to render the format relating the data records to respective expressions on the basis of which conditions the data records satisfy;

wherein formatting comprises highlighting each data record related to each of the expressions in a manner that distinguishes the expressions from one another in the query result.

17. The computer-readable medium of claim 16, wherein the formatting further comprises determining each data record related to one of the expressions using the metadata.

18. The computer-readable medium of claim 16, wherein highlighting each data record related to each of the expressions comprises at least one of:

(i) associating each data record related to a particular expression with an indication of the expression;

(ii) displaying each data record related to a particular expression in a specific color associated with the expression; and

(iii) displaying all data records related to a particular expression separate from data records that are related to a different expression.

19. The computer-readable medium of claim 12, wherein the process further comprises:

formatting the query result to render the format relating the data records to respective expressions on the basis of which conditions the data records satisfy;

wherein formatting comprises for each data record that satisfies at least one group of conditions having at least one defined expression in the conditions object at least one of;

(i) associating the data record with an indication of the at least one defined expression;

(ii) displaying the data record in a specific color associated with the at least one defined expression; and

(iii) displaying the data record together with all other data records that satisfy the at least one group of conditions separate from other data records that are not satisfying the at least one group of conditions.

20. The computer-readable medium of claim 12, wherein the process further comprises:

after executing the query to obtain the query result, identifying each data record in the query result that satisfies conditions for which an expression is defined in the condition object.

21. The computer-readable medium of claim 20, wherein the process further comprises:

generating metadata indicating each identified data record;

wherein returning the query result in a format relating the data records to respective expressions comprises returning the obtained query result and the generated metadata.

22. The computer-readable medium of claim 12, wherein each condition is defined using one or more logical fields of a data abstraction model abstractly describing the data in the database;

whereby the query defines an abstract query, and wherein the data abstraction model is adapted for transforming the one or more logical fields of the abstract query into a form consistent with a physical representation of the data in the database.