Polymorphic result sets

• US 20070136262A1
• Filed: 12/08/2005
• Published: 06/14/2007
• Est. Priority Date: 12/08/2005
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard, Kolz, Daniel
• Granted Patent: US 8,370,375 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models

Abstract

A method, apparatus, and article of manufacture for processing a database query. Database queries are submitted with an indication of a selected output format, To process the query, data records are retrieved and formatted according to the selected output format, as well as formatted for additional output formats supported by a given a query application. Once returned, query results may be presented in the selected format. A user may switch the presentation of the query result from the selected format to others, without having to re-execute the database query.

Claims

1. A computer-implemented method of processing a database query, comprising:

executing the database query to retrieve a set of data records consistent with conditions specified by the database query;

generating a first query result from the set of data records, organized according to a first output format mode;

generating at least a second query result from the set of data records, organized according to at least a second format mode;

combining the first and second query results to form a polymorphic query result set; and

presenting the polymorphic query result set to a requesting entity, according to one of the first and second output format modes.

2. The method of claim 1, further comprising:

receiving a request to view the polymorphic query result set according to another one of the first and second output format modes; and

switching the presentation of the polymorphic query result to the requested output format mode.

3. The method of claim 1, wherein the first and second output format modes each specify a different presentation style, arrangement or format for the retrieved set of data records.

4. The method of claim 1, wherein at least one of the first and second output format modes is used to format the set of data records according to the requirements of a data processing application.

5. The method of claim 1, wherein the database query includes a selection of one of the first or second format modes that should be used to present the polymorphic query result set to the requesting entity.

6. The method of claim 1, wherein the database query comprises an abstract query composed according to a database abstraction model, wherein the database abstraction model defines a plurality of logical fields, and wherein each logical field specifies an access method for accessing data in the database corresponding to the logical field;

wherein processing the database query to retrieve a set of data records comprises;

transforming the abstract query into a query consistent with a particular physical data representation used by an underlying physical database; and

issuing the transformed queries to the underlying physical database.

7. The method of claim 1, wherein the polymorphic query result set includes an indication of a given data record in the first query result that corresponds to the given data record in the second query result.

8. A computer-readable medium containing a program which when executed by a processor, performs operations for processing a database query, including the steps of:

executing the database query to retrieve a set of data records consistent with conditions specified by the database query;

generating a first query result from the set of data records, organized according to a first output format mode;

generating at least a second query result from the set of data records, organized according to at least a second format mode;

combining the first and second query results to form a polymorphic query result set; and

presenting the polymorphic query result set to a requesting entity, according to one of the first and second output format modes.

9. The computer-readable medium of claim 8, further comprising:

receiving a request to view the polymorphic query result set according to another one of the first and second output format modes; and

switching the presentation of the polymorphic query result to the requested output format mode.

10. The computer-readable medium of claim 8, wherein the first and second output format modes each specify a different presentation style, arrangement or format for the retrieved set of data records.

11. The computer-readable medium of claim 8, wherein at least one of the first and second output format modes is used to format the set of data records according to the requirements of a data processing application.

12. The computer-readable medium of claim 8, wherein the database query includes a selection of one of the first or second format modes that should be used to present the polymorphic query result set to the requesting entity.

13. The computer-readable medium of claim 8, wherein the database query comprises an abstract query composed according to a database abstraction model, wherein the database abstraction model defines a plurality of logical fields, and wherein each logical field specifies an access method for accessing data in the database corresponding to the logical field;

wherein processing the database query to retrieve a set of data records comprises;

transforming the abstract query into a query consistent with a particular physical data representation used by an underlying physical database; and

issuing the transformed queries to the underlying physical database.

14. The computer-readable medium of claim 8, wherein the polymorphic query result set includes an indication of a given data record in the first query result that corresponds to the given data record in the second query result.

15. A computing device, comprising:

a processor; and

a memory configured to store an application that includes instructions which, when executed by the processor, cause the processor to perform operations for processing a database query, comprising;

executing the database query to retrieve a set of data records consistent with conditions specified by the database query;

generating a first query result from the set of data records, organized according to a first output format mode;

generating at least a second query result from the set of data records, organized according to at least a second format mode;

combining the first and second query results to form a polymorphic query result set; and

presenting the polymorphic query result set to a requesting entity, according to one of the first and second output format modes.

16. The computing device of claim 15, further comprising:

receiving a request to view the polymorphic query result set according to another one of the first and second output format modes; and

switching the presentation of the polymorphic query result to the requested output format mode.

17. The computing device of claim 15, wherein the first and second output format modes each specify a different presentation style, arrangement or format for the retrieved set of data records.

18. The computing device of claim 15, wherein at least one of the first and second output format modes is used to format the set of data records according to the requirements of a data processing application.

19. The computing device of claim 15, wherein the database query includes a selection of one of the first or second format modes that should be used to present the polymorphic query result set to the requesting entity.

20. The computing device of claim 15, wherein the database query comprises an abstract query composed according to a database abstraction model, wherein the database abstraction model defines a plurality of logical fields, and wherein each logical field specifies an access method for accessing data in the database corresponding to the logical field;

wherein processing the database query to retrieve a set of data records comprises;

transforming the abstract query into a query consistent with a particular physical data representation used by an underlying physical database; and

issuing the transformed queries to the underlying physical database.

21. The computing device of claim 15, wherein the polymorphic query result set includes an indication of a given data record in the first query result that corresponds to the given data record in the second query result.