Arpan A Desai, 464413 Mentone Ave, Culver City, CA 90232

7409636, Aug 5, 2008

Jul 29, 2005

11/193567

Henricus Johannes Maria Meijer - Mercer Island WA, US
Anders Hejlsberg - Seattle WA, US
David L. Remy - Mercer Island WA, US
Arpan A. Desai - Bothell WA, US
Asad Jawahar - Woodinville WA, US
Andrew E. Kimball - Sammamish WA, US
Donald F. Box - Yarrowpoint WA, US

Microsoft Corporation - Redmond WA

G06F 17/00

715255

An architecture that leverages support for markup language operations, e. g. , extensible markup language (XML) queries, via a lightweight application program interface (API). The API defines an object model that can simplify construction of XML values in languages that do not natively support XML. The novel aspects of the described innovation can enable query languages to be factored into general operations (e. g. , mapping, filtering, sorting, and/or projection of functions) on collections on one hand, and a set of domain specific operations (e. g. , navigation, construction and modification) on the elements of these collections on another hand. The subject API can support creation of XML data that is node centric (e. g. , context-free). Accordingly, nodes do not have to be constructed within the context of a document.

7454436, Nov 18, 2008

Aug 30, 2005

11/215134

Henricus Johannes Maria Meijer - Mercer Island WA, US
Anders Hejlsberg - Seattle WA, US
David L. Remy - Mercer Island WA, US
Arpan A. Desai - Bothell WA, US
Asad Jawahar - Woodinville WA, US
Andrew E. Kimball - Sammamish WA, US

Microsoft Corporation - Redmond WA

G06F 17/30

707102, 707103 R, 707203, 715234

A system for managing data element names, comprises a parent table for listing names of data elements that is constrained such that the parent table cannot grow beyond a first predetermined size. The system also includes a child table for listing names of data elements that is derived from the parent table and that is constrained such that the child table cannot grow beyond a second predetermined size. Methods for using the system are also provided.

7472112, Dec 30, 2008

Jun 23, 2003

10/601730

Todd F. Pfleiger - Redmond WA, US
Andrew E. Kimball - Sammamish WA, US
Arpan A. Desai - Kirkland WA, US

Microsoft Corporation - Redmond WA

G06F 7/00
G06F 17/30
G06F 17/00

707 3, 7071041

A distributed query engine pipeline architecture comprises cascaded analysis engines that accept an input query and each identifies a portion of the input query that it can pass on to an execution engine. Each stage rewrites the input query to remove the portion identified and replaces it with a placeholder. The rewritten query is forwarded to the next analysis engine in the cascade. Each engine compiles the portion it identified so that an execution engine may process that portion. Execution preferably proceeds from the portion of the query compiled by the last analysis engine. The execution engine corresponding to the last analysis engine executes the query and makes a call to the next higher execution engine in the cascade for data from the preceding portion. The process continues until the results from the input query are fully assembled.

7567968, Jul 28, 2009

Jan 31, 2005

11/046693

Arpan A Desai - Bothell WA, US
Daniel Dedu-Constantin - Redmond WA, US
Ion Vasilian - Seattle WA, US
Todd F Pfleiger - Seattle WA, US

Microsoft Corporation - Redmond WA

G06F 17/30

707 10, 7071041, 709203

A system and/or methodology that employs a non-relational (e. g. , XML (extensible markup language)) query language to access stored procedures employed in connection with relational (e. g. , SQL (structured query language)) database management systems is provided. Stored procedures in SQL enable the predetermination of queries that can be executed against the relational database. The invention bridges the gap between non-relational query languages and relational data stores. In other words, the invention enables the integration of non-relational query languages with relational data stores. The invention can define a view of the relational data in the current data model, convert data from relational to non-relational format and provide a mechanism in which a stored procedure can be referenced from the non-relational query language, using, for example, a function.

7676476, Mar 9, 2010

Aug 25, 2004

10/925509

Henricus Johannes Maria Meijer - Mercer Island WA, US
Yan V. Leshinsky - Bellevue WA, US
Arpan A. Desai - Bothell WA, US
Andrew E. Kimball - Sammamish WA, US

Microsoft Corporation - Redmond WA

G06F 17/00

707100, 707 7, 707 3

The subject invention pertains to a system and method of incorporating collation information into data types. In particular, the subject invention provides for parameterizing data types with collation information such that a comparison between two different collations generates a static-type error rather than a run-time error. Additionally, the invention affords for conveniently working with localized data types to allow generic parameterization over collations as well as ordinary types. In the context of strings, the present invention enables concurrent use of strings in multiple languages and facilitates the correct handling thereof.

2004011, Jun 10, 2004

Dec 6, 2002

10/313907

Eldar Musayev - Sammamish WA, US
Haiyang Hao - Redmond WA, US
Arpan Desai - Kirkland WA, US
Chia-Hsun Chen - Redmond WA, US

G06F017/30

707/003000

A method is disclosed for querying a hierarchically structured document embodied in a data stream. A query specifies desired data to be obtained from the document and reference data from which the desired data may be determined by way of reference thereto. The reference data specified in the query is verified to occur in the passing data stream prior to the desired data, and the passing data stream is examined. The reference data in the passing data stream is located and thereafter, and with reference to the located reference data, the desired data in the passing data stream is located and outputted.

2004026, Dec 23, 2004

Jun 23, 2003

10/601445

Arpan Desai - Kirkland WA, US
Mark Fussell - Sammarnish WA, US
Andrew Kimball - Sammamish WA, US
Michael Brundage - Kirkland WA, US
Sergey Dubinets - Bellevue WA, US
Todd Pfleiger - Redmond WA, US

G06F017/30

707/004000

A query runtime architecture and an exemplary application programming interface suitable for the architecture are presented. The architecture inputs one or more XML queries and views and enables the queries to be translated wherein the queries and views may be run over multiple data sources of different data models. The architecture incorporates front-end compilers which convert input queries and views into an intermediate language representation which represents the meaning of the respective query or view. The architecture may then allow the back-end compiling of the intermediate language representation to target languages compatible with the data sources desired to be queried. The architecture also allows the execution of those target compilations to extract the data requested of the queries. The invention also discloses an example application programming interface for the query runtime system.