Extensible data query scenario definition and consumption

Patent metadata

Field	Value
Publication number	US-9372884-B2
Application number	US-201213517611-A
Country	US
Kind code	B2
Filing date	Jun 14, 2012
Priority date	Jun 14, 2012
Publication date	Jun 21, 2016
Grant date	Jun 21, 2016

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 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 and a use scenario for querying the corresponding dataset, the one or more sample queries being in a first format provided by the corresponding dataset publisher;
generating a dataset listing 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 dataset listing user interface, generating a dataset subscription user interface, the dataset subscription user interface presenting the one or more sample queries from a particular dataset description that corresponds to the particular listed dataset, the dataset subscription 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 format corresponding to the query translation user interface element;
based on selection of one of the query translation user interface elements at the dataset subscription user interface, translating the at least one of the one or more sample queries into the specified format, wherein the translated format has a different syntax than the first format and is understandable by the subscriber computer system; and
providing the translated at least one of the one or more sample queries to the subscriber computer system.

2. The method of claim 1 , wherein the at least one sample query is provided to a translation engine for translation to the translated format selected by the user.

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

4. The method 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.

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

6. The method of claim 5 , further comprising receiving a modified sample query comprising at least one of the one or more modifiable query parameters having been modified.

7. The method of claim 1 , wherein the dataset subscription user interface also comprises at least one of (i) an option for the user to subscribe/purchase access to the particular listed dataset; (ii) metadata, including a dataset name of the particular listed dataset, a billing structure of the particular listed dataset, a maintenance/update schedule of the particular listed dataset, and a database type of the particular listed dataset; (iii) an identifier of a location of the particular listed dataset; (iv) a description of the particular listed dataset comprising an explanation of the type of data that can be accessed in the particular listed dataset; and (v) an image comprising a visualization of the type of results that can be provided by the particular listed dataset.

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

9. 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 and a use scenario for querying the corresponding dataset, the one or more sample queries being in a first format provided by the corresponding dataset publisher;
generate a dataset listing 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 dataset listing user interface, generate a dataset subscription user interface, the dataset subscription user interface presenting the one or more sample queries from a particular dataset description that corresponds to the particular listed dataset, the dataset subscription 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 format corresponding to the query translation user interface element;
based on selection of one of the query translation user interface elements at the dataset subscription user interface, translate the at least one of the one or more sample queries into the specified format, wherein the translated format has a different syntax than the first format and is understandable by subscriber computer system; and
provide the translated at least one of the one or more sample queries to the subscriber computer system.

10. The computer system of claim 9 , wherein at least one sample query is provided to a translation engine for translation to the translated format selected by the user.

11. The computer system 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 computer system of claim 9 , wherein each sample query also identifies one or more user-modifiable query parameters.

13. The computer system of claim 12 , wherein a modified sample query is received that comprises at least one of the one or more modifiable query parameters having been modified.

14. The computer system of claim 9 , wherein the dataset subscription user interface also comprises at least one of (i) an option for the user to subscribe/purchase access to the particular listed dataset; (ii) metadata, including a dataset name of the particular listed dataset, a billing structure of the particular listed dataset, a maintenance/update schedule of the particular listed dataset, and a database type of the particular listed dataset; (iii) an identifier of a location of the particular listed dataset; (iv) a description of the particular listed dataset comprising an explanation of the type of data that can be accessed in the particular listed dataset;
and (v) an image comprising a visualization of the type of results that can be provided by the particular listed dataset.

15. 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 computing system to cause the computing system to provid

Assignees

• Puszkiewicz Piotr Milosz
• Mall Roger
• Kasperski Ziv
• Schellhardt Zachary
• Microsoft Technology Licensing Llc

Inventors

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

Classifications

• G06F16/2428 Primary

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

• G06Q30/02 Primary

  Marketing; Price estimation or determination; Fundraising · CPC title

• G06F16/24526

  Internal representations for queries · CPC title

• G06F16/2423

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

• G06F16/2425

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