Method of selecting and presenting data from a database using a query language to a user of a computer system

• US 5,715,450 A
• Filed: 09/27/1995
• Issued: 02/03/1998
• Est. Priority Date: 09/27/1995
• Status: Expired due to Term

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Rothwein, Thomas Michael, Ambrose, Jesse Lee
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Mizrahi, Diane D.
• Application Number:
  US08/535,553
• Time in Patent Office: 860 Days
• Field of Search: 395/614, 395/201, 395/762
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A thread management system for implementation within a computer system having a database disposed to be accessed through queries provided by a system user is disclosed herein. In this environment the thread management system provides a mechanism for subsequent replication of a sequence of one or more of such queries made by the system user. In a preferred implementation, a first thread step object is generated upon a first of the queries being provided to the database. The thread step object is formed so as to include information relating to a first state of the database. A representation of the first thread step object is then presented to the system user via a display of the computer system. Upon the system user selecting the representation of the first thread step object, the first of the queries to the database is replicated. A second thread step object may be generated upon provision of a second of the queries to the database. The second thread step object is created so as to include information relating to a second state of the database. In an exemplary implementation a thread object is then formed from the first and second thread step objects, and a representation of the thread object is displayed to the system user. Upon the system user selecting the representation of the thread object, the first and second queries to the database are replicated.

Claims

1. A method of selecting and presenting data from a database using a database query language to a user of a computer system, said method comprising the steps of:

a) providing at least one frame bookmark object that specifies a format for the display of data;

b) for each of said at least one frame bookmark objects, providing a component bookmark object that specifies a criterion for data to be displayed according to the format specified by said frame bookmark object;

c) retrieving data from a database according to the a criterion specified by said component object; and

d) displaying said data according to the format specified in said at least one frame bookmark object.

2. The method of claim 1, said method further comprising the steps of:

a) dividing a screen image into a plurality of screen sectors;

b) mapping each of said frame objects to at least one of said screen sectors.

3. The method of claim 1, said method further comprising the steps of providing at least one thread object that comprises said at least one frame bookmark object.

4. The method of claim 3, said method further comprising the steps of

a) providing a thread array object that comprises said at least one thread object, and

b) presenting said user with a display of said at least one thread object, and

c) selecting said thread object in response to indicia specified by the user.

5. In a computer system having a database disposed to be accessed through queries using a database query language made to said database, a method for replicating a sequence of one or more of said queries made by a system user, said method comprising the steps of:

generating a first thread step object upon providing a first of said queries to said database, said thread step object including information relating to a first state of said database;

displaying a representation of said first thread step object upon a display of said computer system; and

replicating said first of said queries to said database upon selection by said user of said representation of said first thread step object.

6. The method of claim 5 further including the steps of:

generating a second thread step object upon providing a second of said queries to said database, said second thread step object including information relating to a second state of said database, and

forming a thread object from said first and second thread step objects.

7. The method of claim 6 further including the steps of:

displaying a representation of said thread object, and

replicating said first and said second of said queries to said database upon selection by said user of said representation of said thread object.

8. In a computer system having a database disposed to be accessed through queries using a database query language made to said database, a system for replicating a sequence of one or more of said queries made by a system user, said system comprising:

means for generating a first thread step object upon providing a first of said queries to said database, said thread step object including information relating to a first state of said database;

means for displaying a representation of said first thread step object upon a display of said computer system; and

means for replicating said first of said queries to said database upon selection by said user of said representation of said first thread step object.

9. The system of claim 8 further including:

means for generating a second thread step object upon providing a second of said queries to said database, said second thread step object including information relating to a second state of said database, and

means for forming a thread object from said first and second thread step objects.

10. The system of claim 9 further including:

means for displaying a representation of said thread object, and

means for replicating said first and said second of said queries to said database upon selection by said user of said representation of said thread object.