QUERY MODEL OVER INFORMATION AS A NETWORKED SERVICE

• US 20160267191A1
• Filed: 05/19/2016
• Published: 09/15/2016
• Est. Priority Date: 03/12/2010
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Khosravy, Moe, Gwozdz, Lukasz, Liensberger, Christian, Swedberg, Gregory David, Bouw, Ren Jacco, Mall, Roger Soulen
• Granted Patent: US 10,019,524 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/24547 Optimisations to support specific applications; Extensibility of optimisers
• CPC Class Codes: G06F 16/24565 Triggers; Constraints
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/285 Clustering or classification
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 16/9538 Presentation of query results
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46

Abstract

Techniques for hosting data or connecting to hosted data are disclosed herein. In one embodiment, a first computing device in a first region of control can receive a data set from a second computing device in a second region of control via a communication network. The first computing device can then analyze the received data set to determine structural information, such as one or more structural features associated with the received data set. The determined structural information can then be transmitted to the second computing device. In response to the transmission, the first computing device can receive input from the second computing device regarding a query capability to enforce over the received data set.

Claims

1. A computing device, comprising:

a computing processor; and

a memory containing instructions executable by the computing processor to cause the computing processor to perform a process comprising;

accessing a data set;

rendering, to another data processing device via a communications network, structural information associated with the accessed dataset, the structural information including data representing one or more data categories of the data set; and

subsequent to rendering the structural information including data representing the one or more data categories, receiving, via the communications network, data representing a query restriction enforceable over the data set by the computing device, wherein the query restriction is enforceable over the at least one data category of the data set.

2. The computing device according to claim 1 wherein the query restriction identifies one of the one or more data categories over which a search of the received data set is authorized.

3. The computing device according to claim 1 wherein the query restriction identifies one of the one or more data categories over which a search of the received data set is prohibited.

4. The computing device according to claim 1 wherein the query restriction identifies one of the one or more data categories for which a consuming device is authorized to receive search results from the received data set.

5. The computing device according to claim 1 wherein the query restriction identifies one of the one or more data categories for which a consuming device is prohibited to receive search results from the received data set.

6. The computing device according to claim 1 wherein the query restriction identifies one data category over which a consuming device is authorized to search the received data set and authorized to receive search results from the received data set.

7. The computing device according to claim 1 wherein the process further includes in response to receiving the data representing the query restriction, analyzing the received data set to determine the structural information of the data set prior to rendering the structural information to the another data processing device via the communications network.

8. The computing device according to claim 1 wherein rendering the structural information includes rendering a user interface containing the structural information to the another data processing device via the communications network.

9. The computing device according to claim 1 wherein:

receiving the data representing the query restriction includes;

receiving a search parameter input defining a first one of the data categories over which a consuming device is authorized to search the received data set;

receiving a search result input defining a second one of the data categories for which the consuming device is authorized to receive search results from the received data set; and

the process performed by the computing processor further includes automatically generating a query interface based on the search parameter input and the search result input for the consuming device to search the data set according to the search parameter input and the search result input.

10. The computing device according to claim 1 wherein the one or more data categories of the received data set includes column information associated with the received data set.

11. A computing device, comprising:

a computing processor; and

a memory containing instructions executable by the computing processor to cause the computing processor to perform a process comprising;

transmitting a searchable data set to a network server via a communications network;

receiving structural information associated with the transmitted data set from the network server via the communications network, the received structural information including data representing one or more data categories of the data set; and

subsequent to receiving the structural information, transmitting, via the communications network, data representing a search restriction associated with the searchable data set to the network server, the search restriction being enforceable over at least one data category at the network server for processing search requests by one or more consuming devices.

12. The computing device according to claim 11 wherein the data representing the search restriction includes a search predicate and a limitation on search results, and wherein transmitting the data representing the search restriction includes transmitting, via the communications network, data representing the search predicate or the limitation on search results to the network server.

13. The computing device according to claim 11 wherein:

receiving the structural information includes receiving, via a user interface, identification of one or more columns of the searchable data set based on the analysis of the searchable the data set; and

transmitting the data representing the search restriction includes providing, via the user interface, a limitation on search results based on the identified one or more columns of the searchable data set, the limitation on search results prohibiting data from at least one column of the searchable data set from being returned as search results.

14. The computing device according to claim 11 wherein:

receiving the structural information includes receiving, via a user interface, presentation of one or more columns of the searchable data set based on the analysis of the searchable the data set; and

transmitting the data representing the search restriction includes providing, via the user interface, a limitation on search results based on the presented one or more columns of the searchable data set, the limitation on search results prohibiting data from one of the columns of the searchable data set from being returned as search results while allowing data from another one of the columns of the searchable data set to be returned as search results.

15. The computing device according to claim 11 wherein:

receiving the structural information includes receiving, via a user interface, identification of one or more columns of the searchable data set based on the analysis of the searchable the data set; and

transmitting the data representing the search restriction includes providing, via the user interface, a search parameter prohibiting searching of the data set based on data from one of the identified columns of the searchable data set.

16. The computing device according to claim 11 wherein:

receiving the structural information includes receiving, via a user interface, identification of first and second columns of the searchable data set based on the analysis of the searchable the data set; and

transmitting the data representing the search restriction includes providing, via the user interface, a first search parameter prohibiting searching of the data set based on data from the first column of the searchable data set; and

providing, via the user interface, a second search parameter allowing searching of the data set based on data from the second column of the searchable data set.

17. A computing device, comprising:

a computing processor; and

a memory containing instructions executable by the computing processor to cause the computing processor to perform a process comprising;

accessing a data set;

rendering, to another data processing device via a communications network, structural information associated with the accessed dataset, the structural information including data representing one or more data categories of the data set;

receiving from the another computing device, via the communications network, data representing a query restriction enforceable over the data set by the computing device, wherein the query restriction is enforceable over the at least one data category of the received data set; and

enforcing the query restriction over the received data set in response to a search requests from a consuming device, wherein enforcing the query restriction includes;

receiving the search query from the consuming device;

in response to receiving the search query from the consuming device, searching the data set to generate search results based on the received search query in accordance with the received query restriction over at least one data category of the received data set; and

providing the generated search results to the consuming device.

18. The computing device according to claim 17 wherein receiving the data representing the query restriction includes receiving a limitation on search results that prohibits data from one of the data category of the data set from being returned as search results in response to the search requests from the consuming devices while allowing data from another one of the data categories of the data set to be returned as search results.

19. The computing device according to claim 17 wherein receiving the data representing the query restriction includes receiving a search parameter prohibiting searching of the data set based on data from one of the data categories of the searchable data set.

20. The computing device according to claim 17 wherein receiving the data representing the query restriction includes:

receiving a first search parameter prohibiting searching of the data set based on data from one of the data categories of the searchable data set; and

receiving a second search parameter allowing searching of the data set based on data from another one of the data categories of the searchable data set.