Abstract Query Processing Using Metadata on Multiple Complex Data Sources

Patent metadata

Field	Value
Publication number	US-2019034496-A1
Application number	US-201715661325-A
Country	US
Kind code	A1
Filing date	Jul 27, 2017
Priority date	Jul 27, 2017
Publication date	Jan 31, 2019
Grant date	—

Abstract

Systems and methods for performing a query using abstracted metadata are described. As described, a metadata object that requests data from a plurality of data sources can be received from, for example, a user device. One or more queries for the one or more of the plurality of data sources based upon the metadata object can be generated. The queries can then be transmitted to the one or more data sources. Results of the queries, according to the method, can be stored in a block memory. In various embodiments, the metadata object may be user-generated and define one or more of a data source, filter conditions, sorting conditions, aggregations criteria, and an operation. Additionally, various embodiments describe updating the queries at pre-determined intervals which can be defined by the metadata object.

First claim

What is claimed is:

1 . A method of performing a query, comprising:
receiving a metadata object requesting data from a plurality of data sources; generating one or more queries corresponding to one or more of the plurality of data sources from the metadata object; transmit the one or more queries to the one or more data sources; and storing one or more results from the one or more queries in a block memory.

2 . The method of claim 1 , further comprising:
determining that at least some of the requested data is present in the block memory; and declining to generate a query corresponding to the requested data that is present in the block memory.

3 . The method of claim 1 , wherein the metadata object is a user-generated object.

4 . The method of claim 1 , wherein the metadata object defines one or more of a data source, filter conditions, sorting conditions, aggregation criteria.

5 . The method of claim 1 , further comprising:
updating the one or more queries at a pre-determined interval.

6 . The method of claim 5 , wherein the pre-determined interval is defined by the received metadata object.

7 . The method of claim 1 , further comprising:
storing the metadata object for later execution.

8 . The method of claim 1 , further comprising:
performing one or more operations on the one or more results from the one or more queries based on an operation specified in the metadata object.

9 . The method of claim 8 , further comprising:
storing the result of the one or more operations in the block memory.

10 . The method of claim 8 , further comprising:
transmitting the result of the one or more operations to a remote user device.

11 . A system, comprising:
a block memory; and one or more processors configured to:
receive a metadata object requesting data from a plurality of data sources;
generate one or more queries corresponding to one or more of the plurality of data sources from the metadata object;
transmit the one or more queries on the one or more data sources;
receive the results of the one or more queries from the one or more data sources; and
store one or more results from the one or more queries in the block memory.

12 . The system of claim 11 , wherein the one or more processors are further configured to:
determine that at least some of the requested data is present in the block memory; and decline to generate a query corresponding to the requested data that is present in the block memory.

13 . The system of claim 11 , wherein the metadata object is configured to define one or more of a data source, filter conditions, sorting conditions, aggregation criteria.

14 . The system of claim 11 , wherein the one or more processors are further configured to update the one or more queries at a pre-determined interval.

15 . The system of claim 14 , wherein the pre-determined interval is defined by the received metadata object.

16 . The system of claim 11 , wherein the one or more processors are further configured to store the metadata object for later execution.

17 . The system of claim 11 , wherein the one or more processors are further configured to:
perform one or more operations on the one or more results from the one or more queries based on an operation specified in the metadata object.

18 . The system of claim 17 , wherein the one or more processors are further configured to:
store the result of the one or more operations in the block memory.

19 . The system of claim 17 , wherein the one or more processors are further configured to:
transmit the result of the one or more operations to a remote user device.

20 . A non-transitory computer-readable medium containing computer instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
receiving a metadata object requesting data from a plurality of data sources; generating one or more queries corresponding to one or more of the plurality of data sources from the metadata object; transmit the one or more queries to the one or more data sources; and storing one or more results from the one or more queries in a block memory.

Assignees

• Citrix Systems Inc

Inventors

• Acosta Rodney Gallart
• Rodriguez Katia Lopez
• Tyrewalla Nizar
• Garg Rohit

Classifications

• G06F17/30554

  Physics · mapped topic

• G06F17/30867

  Physics · mapped topic

• G06F17/30451

  Physics · mapped topic

• G06F17/30545 Primary

  Physics · mapped topic

• G06F16/2471 Primary

  Distributed queries · CPC title