Extensible data query scenario definition and consumption

Patent metadata

Field	Value
Publication number	US-2016292218-A1
Application number	US-201615182894-A
Country	US
Kind code	A1
Filing date	Jun 15, 2016
Priority date	Jun 14, 2012
Publication date	Oct 6, 2016
Grant date	—

Abstract

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.

First claim

What is claimed is:

1 . A computer system, comprising:
one or more processors; system memory; and one or more computer readable storage media having stored thereon computer-executable instructions that are executable by the one or more processors to cause the computer system to provide access to datasets, the computer-executable instructions including instructions that are executable to cause the computer system to perform at least the following:
identify a plurality of dataset descriptions that are provided by one or more dataset publishers, each dataset description describing a corresponding dataset provided by one of the one or more dataset publishers and including one or more sample queries that illustrate a syntax for querying the corresponding dataset, the one or more sample queries being in a first format;
generate a first user interface that includes a listing of a plurality of datasets that are available for subscription by dataset subscriber computer systems, each listed dataset corresponding to one of the plurality of dataset descriptions;
based at least on receiving a selection of a particular one of the plurality of listed datasets at the first user interface, generate a second user interface, the second user interface presenting the one or more sample queries from a particular dataset description that corresponds to the particular listed dataset, the second user interface also including a plurality of query translation user interface elements, each query translation user interface element being user-selectable to translate at least one of the one or more sample queries to a second format corresponding to the query translation user interface element;
based on selection of one of the query translation user interface elements at the second user interface, translate the at least one of the one or more sample queries into the second format, wherein the translated format has a different syntax than the first format; and
provide the translated at least one of the one or more sample queries to the subscriber computer system.

2 . The computer system of claim 1 , wherein the at least one sample query is provided to a translation engine for translation to the translated format.

3 . The computer system of claim 1 , wherein at least one corresponding dataset provided by one of the one or more dataset publishers is stored at a location of the one or more dataset publishers.

4 . The computer system of claim 1 , wherein the computer-executable instructions also include instructions that are executable to cause the computer system to store at least one corresponding dataset provided by one of the one or more dataset publishers.

5 . The computer system of claim 1 , wherein each sample query also identifies one or more user-modifiable query parameters.

6 . The computer system of claim 5 , wherein the computer-executable instructions also include instructions that are executable to cause the computer system to receive a modified sample query comprising at least one of the one or more modifiable query parameters that have been modified.

7 . The computer system of claim 1 , wherein the computer-executable instructions also include instructions that are executable to cause the computer system to receive at least one corresponding dataset provided by one of the one or more dataset publishers to be stored locally.

8 . The computer system of claim 1 , wherein the first user interface is a dataset listing user interface, and wherein the second user interface is a dataset subscription user interface.

9 . A method, implemented at a computer system that includes one or more processors, for providing access to datasets, the method comprising:
identifying a plurality of dataset descriptions that are provided by one or more dataset publishers, each dataset description describing a corresponding dataset provided by one of the one or more dataset publishers and including one or more sample queries that illustrate a syntax for querying the corresponding dataset, the one or more sample queries being in a first format; generating a first user interface that includes a listing of a plurality of datasets that are available for subscription by dataset subscriber computer systems, each listed dataset corresponding to one of the plurality of dataset descriptions; based at least on receiving a selection of a particular one of the plurality of listed datasets at the first user interface, generating a second user interface, the second user interface presenting the one or more sample queries from a particular dataset description that corresponds to the particular listed dataset, the second user interface also including a plurality of query translation user interface elements, each query translation user interface element being user-selectable to translate at least one of the one or more sample queries to a second format corresponding to the query translation user interface element; based on selection of one of the query translation user interface elements at the second user interface, translating the at least one of the one or more sample queries into the second format, wherein the translated format has a different syntax than the first format; and providing the translated at least one of the one or more sample queries to the subscriber computer system.

10 . The method of claim 9 , wherein the at least one sample query is provided to a translation engine for translation to the translated format.

11 . The method of claim 9 , wherein at least one corresponding dataset provided by one of the one or more dataset publishers is stored at a location of the one or more dataset publishers.

12 . The method of claim 9 , further comprising storing at least one corresponding dataset provided by one of the one or more dataset publishers.

13 . The method of claim 9 , wherein each sample query also identifies one or more user-modifiable query parameters.

14 . The method of claim 13 , further comprising receiving a modified sample query comprising at least one of the one or more modifiable query parameters that have been modified.

15 . The method of claim 9 , further comprising receiving at least one corresponding dataset provided by one of the one or more dataset publishers to be stored locally.

16 . The method of claim 9 , wherein the first user interface is a dataset listing user interface, and wherein the second user interface is a dataset subscription user interface.

17 . A computer program product comprising one or more hardware storage devices having stored thereon computer-executable instructions that are executable by one or more processors of a computer system to cause the computer system to provide access to datasets, the computer-executable instructions including instructions that are executable to cause the computer system to perform at least the following:
identify a plurality of dataset descriptions that are provided by one or more dataset publishers, each dataset description describing a corresponding dataset provided by one of the one or more dataset publishers and including one or more sample queries that illustrate a syntax for querying the corresponding dataset, the one or more sample queries being in a first format; generate a first user interface that includes a listing of a plurality of datasets that are available for subscription by dataset subscriber computer systems, each listed dataset corresponding to one of the plurality of dataset descriptions; based at least on receiving a selection of a particular one of the plurality of listed datasets at the first user int

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Puszkiewicz Piotr Milosz
• Mall Roger
• Kasperski Ziv
• Schellhardt Zachary

Classifications

• G06F16/2425

  Iterative querying; Query formulation based on the results of a preceding query · CPC title

• G06F16/2428 Primary

  Query predicate definition using graphical user interfaces, including menus and forms (G06F16/2423 takes precedence) · CPC title

• G06F16/951

  Indexing; Web crawling techniques · CPC title

• G06F16/242

  Query formulation · CPC title

• G06F16/2423

  Interactive query statement specification based on a database schema · CPC title