Object-relational query builder which determines existence of structures from information loaded from the server and cached locally on the client computing system

• US 6,119,126 A
• Filed: 05/29/1998
• Issued: 09/12/2000
• Est. Priority Date: 05/29/1998
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Gaunce, David Brennan, Yee, David R.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): JUNG, DAVID YIUK
• Application Number:
  US09/087,122
• Time in Patent Office: 837 Days
• Field of Search: 707/3, 707/4, 707/5, 707/6, 707/7, 707/10, 707/101, 707/102, 707/103, 707/200, 707/201, 707/202, 709/216, 709/213, 345/302
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

One embodiment of the present invention provides a method for constructing a query for an object-relational database. This method displays at least part of a schema for the object-relational database to a user in a graphical representation. Next, the method allows the user to perform graphical manipulations on the schema. The method then generates a query based upon the schema and the graphical manipulations, and this query is sent to the object-relational database. Another embodiment of the present invention provides a method for processing an object-relational query for transmission from a client to an object-relational database server. This method receives the query at the client, and parses the query to determine which object-relational structures the query is attempting to access. The method then determines from data dictionary information, loaded from the object-relational database server and cached locally on the client, if the object-relational structures the query is attempting to access exist in the object-relational database server. If they do not exist, the method indicates an error condition. Yet another embodiment of the present invention provides a method for displaying objects defined within an object-oriented programming system that are stored in a relational table structure. This method displays a table of objects, so that a first object in the table is represented by an identifier. The method next receives a command from a user to provide a more-detailed display of the first object. In response to this command, the method retrieves attributes of the first object from a data store, and displays an expanded representation of the first object by displaying the attributes.

Claims

1. A method for processing a query for transmission from a client computing system to an object-relational database server, comprising:

receiving the query at the client computing system;

parsing the query to determine which object-relational structures the query is attempting to access;

determining, from data dictionary information loaded from the object-relational database server and cached locally on the client computing system, if the object-relational structures the query is attempting to access exist in the object-relational database server;

if the object-relational structures do not exist on the object-relational database server, indicating an error condition; and

if the object-relational structures exist on the object-relational database server, sending the query to the object-relational database server.

2. The method of claim 1, further comprising, if the object-relational structures exist on the object-relational database server:

displaying the query to a user; and

if a command is received from the user to send the query, sending the query to the object-relational database server.

3. The method of claim 1, further comprising:

displaying the query to a user at the client computing system; and

allowing the user to modify the query through manipulations of graphical objects representing the query.

4. The method of claim 3, wherein allowing the user to modify the query includes allowing the user to add new tables to the query.

5. The method of claim 3, wherein allowing the user to modify the query includes allowing the user to remove tables from the query.

6. The method of claim 3, wherein allowing the user to modify the query includes allowing the user to type the query in manually.

7. The method of claim 3, wherein allowing the user to modify the query includes allowing the user to paste in the query from a clipboard.

8. The method of claim 3, wherein allowing the user to modify the query includes allowing the user to select different columns for the query.

9. The method of claim 3, wherein allowing the user to modify the query includes allowing the user to modify conditions of the query.

10. The method of claim 1, wherein receiving the query includes importing the query from a file containing the query.

11. The method of claim 1, wherein receiving the query comprises:

receiving, at the client computing system, a command in the form of a manipulation of a graphical object in a graphical user interface from a user of the client computing system; and

converting the command into a corresponding object-relational database query.

12. The method of claim 11, wherein the graphical object includes a visual presentation of data dictionary elements.

13. The method of claim 1, wherein receiving the query includes receiving manually typed input from a user.

14. The method of claim 1, wherein indicating the error condition includes informing a user that the query is not valid.

15. The method of claim 1, wherein determining if the object-relational structures the query is attempting to access exist in the object-relational database server further comprises:

determining that the query includes a reference to an attribute of an object from a table; and

using the data dictionary information to expand a type for the object to verify that the attribute exists in the object.

16. A method for processing a query for transmission from a client computing system to an object-relational database server, comprising:

receiving the query from a user of the client computing system;

displaying the query to the user of the client computing system through a graphical user interface;

allowing the user to modify the query through manipulations of graphical objects representing the query;

parsing the query to determine which object-relational structures the query is attempting to access;

determining, from data dictionary information loaded from the object-relational database server and cached locally on the client computing system, if the object-relational structures the query is attempting to access exist in the object-relational database server;

if the object-relational structures do not exist on the object-relational database server, indicating an error condition; and

if the object-relational structures exist on the object-relational database server, sending the query to the object-relational database server.

17. An apparatus for processing a query for transmission to an object-relational database server, comprising:

a client computing system;

a parser, within the client computing system, that parses the query to determine which object-relational structures the query is attempting to access;

a query checking mechanism, within the client computing system, that determines, from data dictionary information loaded from the object-relational database server and cached locally on the client computing system, if the object-relational structures the query is attempting to access exist in the object-relational database server;

an error handler, within the client computing system, that indicates an error if the object-relational structures do not exist on the object-relational database server; and

a communication mechanism, within the client computing system, that is configured to,

send the query to the object-relational database server if the object-relational structures exist on the object-relational database server, and to

indicate an error condition if the object-relational structures do not exist on the object-relational database server.

18. The apparatus of claim 17, further comprising a display mechanism, within the client computing system, that displays the query to a user.

19. The apparatus of claim 17, further comprising a query editing mechanism, within the client computing system, that allows a user to edit the query through manipulations of graphical objects representing the query.

20. The apparatus of claim 19, wherein the query editing mechanism is configured to allow the user to add new tables to the query.

21. The apparatus of claim 19, wherein the query editing mechanism is configured to allow the user to remove tables from the query.

22. The apparatus of claim 19, wherein the query editing mechanism is configured to allow the user to remove tables from the query.

23. The apparatus of claim 19, wherein the query editing mechanism is configured to allow the user to type the query in manually.

24. The apparatus of claim 19, wherein the query editing mechanism is configured to allow the user to paste in the query from a clipboard.

25. The apparatus of claim 19, wherein the query editing mechanism is configured to allow the user to select different columns for the query.

26. The apparatus of claim 19, wherein the query editing mechanism is configured to allow the user to modify conditions of the query.

27. The apparatus of claim 17, further comprising a query receiving mechanism that receives the query from a file containing the query.

28. The apparatus of claim 17, further comprising a query receiving mechanism that receives a command in the form of a manipulation of a graphical object in a graphical user interface from a user of the client computing system, and converts the command into a corresponding object-relational database query.

29. The apparatus of claim 28, wherein the graphical object includes a visual presentation of data dictionary elements.

30. The apparatus of claim 17, further comprising a query receiving mechanism that receives a manually typed query.

31. The apparatus of claim 17, wherein the query checking mechanism is configured to determine that the query includes a reference to an attribute of an object from a table, and to use the data dictionary information to expand a type for the object to verify that the attribute exists in the object.

32. A program storage device storing instructions that when executed by a computer perform a method for processing a query for transmission from a client computing system to an object-relational database server, comprising:

receiving the query at the client computing system;

parsing the query to determine which object-relational structures the query is attempting to access;

determining, from data dictionary information loaded from the object-relational database server and cached locally on the client computing system, if the object-relational structures the query is attempting to access exist in the object-relational database server;

if the object-relational structures do not exist on the object-relational database server, indicating an error condition; and

if the object-relational structures exist on the object-relational database server, sending the query to the object-relational database server.