Resumeable batch query for processing time consuming queries in an object oriented database management system

• US 5,161,223 A
• Filed: 10/23/1989
• Issued: 11/03/1992
• Est. Priority Date: 10/23/1989
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Abraham, Robert L.
• Primary Examiner(s): Shaw, Gareth D.
• Assistant Examiner(s): BUTLER, DENNIS
• Application Number:
  US07/425,829
• Time in Patent Office: 1,107 Days
• Field of Search: 364/200 MS File, 364/900 MS File, 395/600, 395/650
• US Class Current: 707/718
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A resumeable batch query object class provides a link between a first dialog for obtaining information regarding a query to be performed by an object oriented database management system, a second dialog for manipulating the results of the query, and the stream which includes the query results. The resumeable batch query attributes include identifiers of the second dialog and the stream, and a method to run the query. The resumable batch query is used by the object oriented database management system to allow a second dialog to manipulate results of a batch or background query in the same manner as results of a foreground or interactive query. Time consuming queries may thereby be processed in background mode in a manner which is transparent to the second dialog.

Claims

1. An object oriented database management system for performing a query in background mode and for linking results of the background mode query for display, comprising:

a data storage device;

input means;

display means;

a database of data objects stored in said data storage device;

a data processor connected to said data storage device;

incoming message indicating means executing in said data processor for displaying an incoming message indicator on display means;

a first dialog executing in said data processor, for accepting information from said input means regarding a query to be performed on said database;

means executing in said data processor, and responsive to said first dialog, for determining that said query is to be performed in background mode;

means, executing in said data processor, and responsive to said determining means, for performing said query on said database in background mode to produce a stream, said stream comprising an object having a plurality of stream attributes including a list of data objects which result from said query performed in background mode;

a second dialog executing in said data processor, for displaying said stream on said display means;

a resumeable batch query object executing in said data processor for linking said second dialog and said stream, said resumeable batch query object including resumeable batch query attributes and at least one resumeable batch query method, said resumeable batch query attributes comprising an identifier of said second dialog and an identifier of said stream produced by said query performed in background mode; and

means, executing in said data processor, for providing said resumeable batch query object to said incoming message indicating means, to notify said incoming message indicating means that said query has been performed.

2. The object oriented database management system of claim 1 wherein said at least one resumeable batch query method comprises means for activating said performing means.

3. The object oriented database management system of claim 2 wherein said at least one resumeable batch query method further comprises means for providing said identifier of a stream to said second dialog.

4. The object oriented database management system of claim 1 wherein said determining means comprises means for accepting an indication that said query is to be performed in background mode.

5. The object oriented database management system of claim 1 wherein said determining means comprises means for accepting an indication from said first dialog that said query is to be performed in background mode.

6. The object oriented database management system of claim 1 wherein said determining means comprises means for estimating the time required for performing said query and means for determining that said query is to be performed in background mode if the estimated time exceeds a predetermined time.

7. A process for linking a first dialog for accepting information regarding a first query to be performed on a database, and a second dialog for displaying results of the first query, in an object oriented database management system comprising a data storage device having a database of data objects stored therein and a data processor connected to said data storage device and having an object oriented database manager operating therein for performing queries of said database, said linking process comprising the following steps performed on said data processor:

producing a first stream for said first query in background mode, said first stream comprising an object having a plurality of stream attributes including a list of data objects which result from the first query performed in background mode; and

linking said second dialog and said first stream produced in background mode with a resumeable batch query object which includes resumeable batch query attributes and at least one resumeable batch query method, the resumeable batch query attributes comprising an identifier of said second dialog and an identifier of said first stream produced in background mode.

8. The process of claim 7 wherein said linking step is followed by the step of indicating that said query has been performed.

9. The process of claim 8 wherein said indicating step comprises the step of:

placing the instance of the resumeable batch query in an incoming message indicating means.

10. The process of claim 7 wherein the at least one resumeable batch query method comprises a method for causing aid producing step to perform said first query.

11. A process for performing a query of a database of data objects in an object oriented database management system, comprising a data storage device having a database of data objects stored therein and a data processor connected to said data storage device and having an object oriented database manager operating therein for performing queries of said database, said query performing process comprising the following steps performed by said data processor:

obtaining search criteria for said query;

determining whether said query is to be performed in background mode; and

performing the following steps if said query is to be performed in background mode;

creating a stream comprising an object having a plurality of stream attributes including a list of data objects which result from said query;

creating a resumeable batch query object comprising resumeable batch query attributes, the resumeable batch query attributes comprising an identifier of said stream;

performing said query in background mode; and

placing said resumeable batch query object in an incoming message indicating means after said query has been performed.

12. The process of claim 11 wherein the following steps are performed if said query is not to be performed in background mode:

creating a stream comprising an object having a plurality of stream attributes including a list of data objects which result from said query; and

immediately performing said query.

13. The process of claim 11 wherein said obtaining step comprises the step of providing a first dialog for obtaining said search criteria for said query.

14. The process of claim 11 wherein said determining step comprises the step of accepting an indication that said query is to be performed in background mode.

15. The process of claim 11 wherein said determining step comprises the steps of:

estimating the time required for performing said query, and

determining that said query is to be performed in background mode if the estimated time exceeds a predetermined time.

16. The process of claim 11 wherein said incoming message indicating means comprises a mailbox.

17. The process of claim 11 wherein said resumeable batch query attributes further comprise an identifier of a second dialog for processing said list of data objects resulting from said query;

and wherein said placing step is followed by the step of invoking said second dialog for processing said list of data objects.