DATA QUERY TRANSLATING INTO MIXED LANGUAGE DATA QUERIES

• US 20090319496A1
• Filed: 06/24/2008
• Published: 12/24/2009
• Est. Priority Date: 06/24/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Kulkarni, Dinesh C., Hejlsberg, Anders, Warren, Matthew J., Vasilian, Ion, Meijer, Erik
• Granted Patent: US 8,819,046 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/24535 of sub-queries or views

Abstract

Data source queries may be specified in various languages, such as SQL, XQuery, and object-oriented languages, and each language may have various linguistic features that enable different types of queries. It may be advantageous to formulate mixed language queries having portions specified in a first language and portions specified in a second language, and to provide mixed language query evaluation components that can parse portions of queries of different languages. It may also be advantageous to permit the translation of single language queries into multiple languages to be parsed by such mixed language query evaluation components. Such techniques may permit queries to utilize linguistic features and processing techniques of one language that are less efficient, less direct, or simply unavailable in another language.

Claims

1. A method of issuing a language integrated query embedded in a first language to a query processor configured to parse mixed language queries having components of a query language and components of a second language, the method comprising:

translating a first portion of the language integrated query into a query language portion;

translating a second portion of the language integrated query into the second language portion;

combining the query language portion and the second language portion to generate a mixed language query; and

sending the mixed language query to the query processor.

2. The method of claim 1, the second language comprising the first language in which the language integrated query is integrated.

3. The method of claim 1, at least one of the second language portion and the query language portion configured to generate a processed query portion that is compatible with the other of the second language portion and the query language portion.

4. The method of claim 1, comprising:

translating a third portion of the language integrated query into a third language portion, and

the combining comprising;

combining the query language portion, the second language portion, and the third language portion to generate a mixed language query.

5. The method of claim 1:

the method comprising;

translating the language integrated query into an expression tree;

the combining comprising;

generating a mixed language expression tree comprising the query language portion and the second language portion; and

the sending comprising;

sending the mixed language expression tree to the query processor.

6. The method of claim 1:

the query processor comprising a second language runtime configured to process at least partially compiled components of the second language, and

the method comprising;

at least partially compiling the second language portion into an at least partially compiled second language component.

7. The method of claim 1:

the language integrated query specifying at least one object in the first language, and

the method comprising;

translating the at least one object into at least one of the query language and the second language.

8. The method of claim 1, comprising:

upon receiving a query result from the query processor for the mixed language query, translating the query result into the first language.

9. The method of claim 8, translating to the first language comprising:

generating at least one local object of the first language comprising at least one element of the query result.

10. The method of claim 9, respective local objects corresponding to a record in the query result.

11. The method of claim 8, translating to the first language comprising:

storing at least one element of the query result in at least one local object of the first language.

12. The method of claim 1:

the query processor comprising a first query processor and a second query processor;

the first portion of the mixed language query targeted to a first query processor and the second portion of the mixed language query targeted to a second query processor; and

the sending comprising;

sending the query language portion of the mixed language query to the first query processor, and

sending the second language portion of the mixed language query to the second query processor.

13. A system for issuing a language integrated query embedded in a first language to a query processor configured to parse mixed language queries having components of a query language and components of a second language, the system comprising:

a query language translating component configured to translate a first portion of the query into a query language portion;

a second language translating component configured to translate a second portion of the query into a second language portion;

a mixed language query generating component configured to combine the query language portion and the second language portion to generate a mixed language query; and

a query sending component configured to send the mixed language query to the query processor.

14. The system of claim 13:

the system comprising;

an expression tree generating component configured to translate the language integrated query into an expression tree;

the mixed language query generating component configured to generate a mixed language expression tree comprising the query language portion and the second language portion; and

the query sending component configured to send the mixed language expression tree to the query processor.

15. The system of claim 13:

the query processor comprising a second language runtime configured to process at least partially compiled components of the second language, and

the system comprising;

a second language compiling component configured to at least partially compile the second language portion into an at least partially compiled second language component.

16. The system of claim 13:

the language integrated query specifying at least one object in the first language, and

the system comprising;

an object translating component configured to translate the at least one object into at least one of the query language and the second language.

17. The system of claim 13, comprising:

a query result receiving component configured to translate into the first language a query result received from the query processor for the mixed language query.

18. The system of claim 17, comprising:

a local object generating component configured to generate at least one local object comprising at least one element of the query result.

19. The system of claim 17, the query result receiving component configured to store at least one element of the query result in at least one local object of the first language.

20. A system for issuing a language integrated query embedded in a first language and specifying at least one object in the first language to a query processor configured to parse mixed language queries having components of a query language and components of a second language using a second language runtime configured to process at least partially compiled components of the second language, the system comprising:

an expression tree generating component configured to translate the language integrated query into an expression tree;

a query language translation component configured to translate a first portion of the expression tree into a query language portion;

a second language translation component configured to translate a second portion of the expression tree into a second language portion;

a second language compiling component configured to at least partially compile the second language portion into an at least partially compiled second language component;

a mixed language query generation component configured to combine the query language portion and the at least partially compiled second language component to generate a mixed language expression tree;

an object translating component configured to translate the at least one object into at least one of the query language and the second language;

a query sending component configured to send the mixed language expression tree to the query processor;

a query result receiving component configured to translate into the first language a query result received from the query processor for the mixed language query; and

a local object generating component configured to generate at least one local object comprising at least one element of the query result.