Object-relational query builder which determines existence of structures from information loaded from the server and cached locally on the client computing system
First Claim
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 Assignments
0 Petitions
Accused Products
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.
-
Citations
32 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
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. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31)
-
-
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.
-
Specification