Microsoft Technology Licensing, LLC

Anthony R Trappen

Steven P Anonsen

Raymond Holzhey

Matthew Aaron Thalman

Dempsey R Swan

Chen-mi Lin

Wade Daniel Lee Baird

Dempsey R Swam

Join expressions, expressed in terms of objects, are translated into a relational database join statement by generating a parse tree based on the join expression. The parse tree is traversed to build the relational database join statement.

Translation of object queries involving inheritence

An interface exposes methods for use in manipulating a database. The interface receives requests in terms of entities (or objects).

System and interface for manipulating a database

The select list for the query is thus constructed such that it produces a result set having a predefined structure. Columns representing identifier properties of an entity are added to the select list. If the entity is an inheritance entity or a collection, then entities from a least derived entity to all descendants are identified and columns representing their identifiers are added to the select list and columns representing non-inherited properties for those entities are added. If the entity is not an inheritance entity or a collection, then columns representing properties of the entity are added to the select list.

Result set formatting and processing

A method of processing an expression includes encoding an expression in source code of an object-relational application, the expression having at least one property of a class. The source code is then compiled to provide run time code, wherein compiling of the expression produces a form of the expression having the intent of the expression by maintaining all operators and operands of the expression.

Method for specifying and parsing expressions

The present invention is a method and system for querying a database system. An object query identifies a partial set of properties of an object to be returned. A portion of the relational database containing those properties is identified and only those properties are returned.

Growing community of inventors

Fargo, ND, United States of America

Anthony R Trappen