Path expression in structured query language
AssigneeMicrosoft Corporation
InventorsJose Blakeley, Evgueni Zabokritski, Conor Cunningham, Balaji Rathakrishnan
Life of this patent
Estimating the term…
Abstract
Systems and methods for extension of a query language for defining a simple formulation of joins by capturing the semantics of an existing linkage between a plurality of tables, via employing a reference join. Such reference join enables a compiler to exploit existing relationships in a data base, and employ existing knowledge about referential constraints for an unambiguous transformation of the reference join expression into the equivalent INNER JOIN on the columns involved. Accordingly, a simpler query syntax and semantics can be provided to express multi-table join navigation over primary key/foreign key relations, for example.
Claims20
A system that facilitates database querying, comprising:
- a compiler that receives a query for interaction with a database;
- and
- a relational join component that extends a corresponding query language via a reference join(s) to capture semantics of an existing linkage among plurality of tables associated with the database, to reduce syntax required to explore or navigate therethrough.
A method of simplifying database querying comprising:
- defining linkage according to item store implementations among tables associated with a database;
- extending a query language via a reference join to capture semantics of the linkage, and reduce syntax required to explore or navigate the database;
- and
- formulating the query language with syntactic simplicity of the reference join.
A system that facilitates database querying, comprising:
- means for compiling a query that interacts with a database;
- and
- means for extending a corresponding query language to capture semantics of existing linkage among plurality of tables associated with the database, to reduce syntax required to explore or navigate therethrough.
Dependencies are inferred from the claim text.