The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 05, 2002
Filed:
Feb. 16, 2000
David R. Yee, Pacifica, CA (US);
David Brennan Gaunce, Mountain View, CA (US);
Oracle Corporation, Redwood Shores, CA (US);
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.