Importance

Loading Importance Indicators...

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.

Loading the Abstract Image...

First Claim