Microsoft Technology Licensing, LLC

Ziv Kasperski

Christian Liensberger

Stéphane Nyombayire

Shankar Lakshmi Regunathan

Kunal Mukerjee

Venkatesh Krishnan

Santosh Balasubramanian

Matthew Roche

Clemens Alden Szyperski

Olivier Nano

Roger Soulen Mall

Ivo Jose Garcia Dos Santos

Laurent Bussard

Piotr Milosz Puszkiewicz

Dirk Siemer

Zachary Schellhardt

The present invention extends to methods, systems, and computer program products for forming data responsive to a query. Responding to a query can include selecting data views on top of data sources. A data catalog stores data elements from different data sources and stores links between data elements from the different data sources. A view can be selected for a query based on one or more of: classification of data included in the data catalog or prior usage of data included in the data catalog. A selected data view is populated with data elements from the data catalog using the links to determine that data elements spanning multiple data sources satisfy the query. The data catalog can be used to identify relationships between data elements from different data sources that would not otherwise be identified.

Forming data responsive to a query

Embodiments described herein are directed to methods, and systems for generating event processing language code in a development environment using an event processing compiler. A query in event processing language is received in a development environment. The query can be associated with sample data from input files or an input data source. An event processing compiler compiles the query, where the compiler transforms the query from event processing language code to a development environment script language code. In particular, the event processing language code transforms the code based on event processing attributes that are intricately aligned in syntax and semantic between the event processing language and the development environment script language. The query as a development environment script is executed using sample data. Executing the query generates output comprising final results data, intermediate results data, and provides for display warnings when mismatches exist between the results data and output specifications.

Event processing development environment

The present invention extends to methods, systems, and computer program products for creating data views. Embodiments of the invention allow automatic creation of data views/projections on top of data sources. A view can be created on one data source (by looking at one or multiple data elements within the data source) or by looking at multiple data sources (of the same or different data types) and combining elements into a view. Data sources can be any kind of data source, including but not limited to: databases, files, and Web services. Views can be picked from a set of predefined views, picked from views of another tenant (either statically or using fuzzy logic), selected based on data element classifications and/or data element relationship classifications, selected based on data usage (e.g., by looking at logs), etc.

Creating data views

Embodiments are directed to providing access to supplemental query data that is relevant to a data query. In one scenario, a computer system receives an input indicating that a data query is to be processed, where the input provides various search criteria. The computer system then generates the data query according to the search criteria in the received input. The computer system further sends the data query to a second computer system which is configured to process the data query and receives the results of the data query. The results indicate that additional data elements relevant to the search criteria have been identified. The computer system then displays an indication of various steps that are to be taken in order to access the identified additional data elements.

Interfaces for accessing and managing enhanced connection data for shared resources

Embodiments are directed to establishing a metadata repository that aggregates metadata for a plurality of data sources, inferring data source metadata at a metadata repository and to providing recommendations to data managers based on aggregated inputs. In one scenario, a computer system establishes a reference to one or more data sources, where each data source includes data elements. The computer system receives a data request for specified data elements stored on the data sources and accesses the established references to determine which data source the specified data elements are stored on. The computer system then retrieves at least one of the specified data elements from its determined data source and sends the retrieved data elements to a specified computer system, along with an indication of additional data elements that are relevant to the received data request, and a further indication of how those additional data elements are to be accessed.

Providing enhanced connection data for shared resources

Content providers define a set of scenarios that are addressed by their datasets. The scenarios include user-friendly, human-readable attributes such as a title, description, and visualization. The scenarios may also include a technical description that can be used to generate sample queries that can then be executed against the dataset. The technical description may be machine translated to arbitrary data querying protocols while maintaining the semantic meaning of the query. A user interface may be provided to allow users to intuitively generate the scenarios. In one embodiment, an extensible framework provides for the creation of protocol-specific translation plug-ins that are used to generate implementations of the scenario suitable for selected protocols. Known market-relevant translator plug-ins may also be implemented.

Growing community of inventors

Redmond, WA, United States of America

Ziv Kasperski