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:
Apr. 16, 2002
Filed:
Jun. 16, 1999
Todd Guay, Nashua, NH (US);
Vipul Shah, Mountain View, CA (US);
Jonathan Soule, Belmont, CA (US);
Yao Feng, Belmont, CA (US);
Oracle Corporation, Redwood Shores, CA (US);
Abstract
A method and apparatus for identifying one or more schemas from which a Structured Query Language (SQL) statement may have been executed is provided. According to the method, to identify schemas from which a database command may have been executed a set of object references that are included in the database command is determined. From the set of object references, one or more ambiguous object references that are contained in the set of object references are identified. A set of one or more schemas that contain objects that correspond to each of the one or more ambiguous object references is then identified. In one aspect, the step of identifying the one or more ambiguous object references includes the steps of identifying any qualified object references from the set of object references that is associated with a schema identifier that identifies a particular schema for which the qualified object reference is to execute; identifying any public synonyms from the set of object references that represents an alias that may be used in multiple schemas to identified a single object; and determining the one or more ambiguous object references by selecting from the set of object references only those object references that have not been identified as either qualified object references or public synonyms.