EXTENSIBLE COMMAND TREES FOR ENTITY DATA MODEL PLATFORM
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.
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.