DECLARATIVE VIEWS FOR MAPPING

• US 20090055364A1
• Filed: 08/21/2007
• Published: 02/26/2009
• Est. Priority Date: 08/21/2007
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Meek, Colin Joseph, Mallalieu, Timothy, Kuo, Ju-Yi, Dosen, Daniel Gerard, Adya, Atul, Pather, Shyamalan, Mandadi, Srikanth
• Application Number:
  US11/842,629
• Publication Number:
  US 20090055364A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24526 Internal representations for queries
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

The claimed subject matter provides systems and methods that effectuates and facilitates the generation of bidirectional views. The disclosed system can include components that transform queries and mappings into an internal representation that can be compiled into a bidirectional view. The bidirectional view can thereafter be employed to actuate query and update processing in a relational database management system.

Claims

1. A system that effectuates and facilitates generation of bidirectional views, comprising:

a component that receives from an interface a query view or a mapping, the component transforms the query view or the mapping into an internal representation, the internal representation compiled into a bidirectional view.

2. The system of claim 1, the bidirectional view employed to drive query or update processing in a runtime engine.

3. The system of claim 1, the query view composed in a data manipulation language based at least in part on SQL.

4. The system of claim 1, the mapping formulated in an Extensible Markup Language (XML) or as Comma Separated Values (CSV).

5. The system of claim 1, the component based at least in part on the query view reformulates the query view into a data manipulation language based at least in part on SQL.

6. The system of claim 5, the component reformulates the query view by utilizing a fragment composed in the data manipulation language.

7. The system of claim 5, the data manipulation language allows entity retrieval from an entity set.

8. The system of claim 1, the component converts the mapping automatically into a data manipulation language based at least in part on SQL.

9. The system of claim 1, the query received by the interface as a complete full formed query written in a data manipulation language requiring no conversion by the component.

10. The system of claim 9, the complete full formed query compiled directly into the bidirectional view.

11. The system of claim 1, the internal representation formulated in a data manipulation language based at least in part on SQL.

12. A method that generates bidirectional views, comprising:

retrieving a query view or a mapping;

converting the query view or the mapping into an internal representation;

compiling the internal representation into a bidirectional view; and

utilizing the bidirectional view to actuate query or update processing in a relational database system.

13. The method of claim 12, the converting further includes utilizing a data manipulation language to reformulate the query view.

14. The method of claim 13, reformulation of the query view includes manipulating data manipulation language fragments.

15. The method of claim 13, the reformulation of the query transforms the query into a standard form of the data manipulation language.

16. The method of claim 12, the data manipulation language permits navigation from an entity to a collection of entities reachable via an association.

17. The method of claim 12, the query specified in a data manipulated language based at least in part on SQL.

18. The method of claim 12, the mapping formulated at least in part in an extensible markup language or as comma separated values.

19. The method of claim 12, the internal representation formulated in a data manipulation language based at least in part on SQL.

20. A system that produces bidirectional views, comprising:

means for obtaining queries or mappings;

means for generating an internal representation of the queries or mappings, the internal representation formulated in a data manipulation language based at least in part on SQL;

means for compiling the internal representation into a bidirectional view employed to effectuate query or update processing in a means for persisting relational data.