Microsoft Technology Licensing, LLC

Jeffrey Wang

Xiaohong Mark Yang

Marius Dumitru

Peter Eberhardy

Zhenyu Tang

Rou-Peng Huang

Sridharan Ramanathan

Hai Huang

George Randall Dong

Randy Dong

Patricia O'Connor Sebelsky

A system and method for facilitating querying one or more data sources. A system provides mechanisms to enable flexible specification of user queries and generation of one or more SQL queries that correspond closely to corresponding user queries. An operator tree and a logical operator tree may be created as intermediate steps to generate the one or more SQL queries. Capabilities of data sources are determined and used to generate remotable SQL queries for composable queries, to reduce an amount of post-processing that is performed on result sets. The system enables user queries that extend beyond those defined by a data model.

Composable SQL query generation

Computer-implemented methods, computer-readable media, and an application system are disclosed for creating and deploying metadata-generated applications. Access is provided to one or more type libraries that each include one or more defined object types configurable for use in generating the application. The defined object types include data structure types, rule types, and data types. Input is elicited from a user regarding desired content and function of the application. Based on the user input, metadata is generated to adapt the defined object types to generate the application. Metadata is generated to adapt the defined data structure types to create one or more application databases, to adapt the defined rule types to create one or more application behaviors, and to adapt the defined data types to create one or more application data types.

Metadata-based application deployment

Sharable extended cell information is used by multidimensional data models to enable cell annotations and line item details. Annotations are notes stored with a cell in a multidimensional dataset. Line item details permit levels of numeric detail below the lowest dimensional granularity. When receiving a multidimensional dataset in response to a query, a client application receives indicator information at the cell level, indicating to the client application that extended cell information is retrievable.

Extended cell information in multidimensional data models

Growing community of inventors

Seattle, WA, United States of America

Jeffrey Wang