EXTENSIBLE COMMAND TREES FOR ENTITY DATA MODEL PLATFORM

• US 20080319957A1
• Filed: 06/19/2007
• Published: 12/25/2008
• Est. Priority Date: 06/19/2007
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Nagarajan, Ramesh, Cavanagh, Simon, Valbuena, Fabio Meireles Fernandez, House, Sean B., Muralidhar, Subramanian, Iceva, Katica, Starck, Steve
• Application Number:
  US11/764,851
• Publication Number:
  US 20080319957A1
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06F 16/24526 Internal representations for queries

Abstract

Systems and methods that provide for a canonical representation in a structured form of a query, against a data model platform. A parser component can parse the SQL query to generate the abstract class that represent the query (command tree). Moreover, a view generation component can supply a mapping between a rich structure (e.g., on the client side) and the relational side. Accordingly, a query can be represented by an abstract class in form of a tree structure with nodes, which has metadata tied therewith.

Claims

1. A computer implemented system comprising the following computer executable components:

a query; and

a canonical representation of the query against a data model platform.

2. The computer implemented system of claim 1, the canonical representation in form of a tree structure with nodes.

3. The computer implemented system of claim 1, the canonical representation translatable into a structured query language.

4. The computer implemented system of claim 1 further comprising a parser component that parses the query to generate an abstract class that forms the canonical representation.

5. The computer implemented system of claim 4 further comprising a tracking component that tracks changes to the canonical representation.

6. The computer implemented system of claim 2 further comprising a metadata space that presents an object model of the query.

7. The computer implemented system of claim 6, a Query, Update, Insert and Delete command presentable by the metadata space.

8. The computer implemented system of claim 6 further comprising a Data Manipulation Language that employs a non-textual form for query representation.

9. The computer implemented system of claim 2 further comprising relational and Entity constructs represented by the nodes.

10. The computer implemented system of claim 4 further comprising a view generation component that performs query translations on the canonical representation.

11. A computer implemented method comprising the following computer executable acts:

forming a query as entity constructs; and

representing the query in canonical form against a data model platform.

12. The computer implemented method of claim 11 further comprising parsing the query to obtain a plurality of nodes.

13. The computer implemented method of claim 11 further comprising accessing metadata to validate the canonical form.

14. The computer implemented method of claim 11 further comprising translating the canonical form into SQL language.

15. The computer implemented method of claim 11 further comprising tracking changes to the canonical form.

16. The computer implemented method of claim 11 further comprising supporting a rich data model for application frameworks that issue the query.

17. The computer implemented method of claim 11 further comprising updating the canonical form with metadata associated with the query.

18. The computer implemented method of claim 11 further comprising representing the query as an object model.

19. The computer implemented method of claim 12 further comprising traversing the plurality of nodes for an optional replacement of a node with another node.

20. A computer implemented system comprising the following computer executable components:

means for representing a query as an object model; and

means for tracking the query in the object model.