Method and system for query transformation for managing information from multiple datasets
First Claim
Patent Images
1. A method for managing data comprising:
- identifying a plurality of disparate data sources, each of the disparate data sources comprising data source information and metadata that describes the data source information;
accessing the metadata from the disparate data sources;
generating a listing of fields from the metadata, wherein the fields correspond to data source information fields in one or more of the disparate data sources;
receiving a selection of a field from the listing of fields, thereby resulting in a selected field;
creating a metadata dataset comprising one or more selected fields, and identifying one or more data sources from the disparate data sources based on the metadata dataset;
for each of the one or more identified disparate data sources, generating (i) a query based on a query language of the identified disparate data source and (ii) an API request that conveys the query to the identified disparate data source, wherein generating the query is based on a user request or the metadata dataset, wherein generating the API request is based on the user request or the metadata dataset, and generating the query request and the API request comprises using the metadata dataset to correlate information requested in the user request with the data source information;
submitting each of the one or more generated queries to the one or more identified disparate data sources through the API request;
receiving, in response to the one or more generated queries, a data source response from the one or more identified disparate data sources; and
preparing a data source response to the user request for information.
5 Assignments
0 Petitions
Accused Products
Abstract
A method and system for users to connect, extract, query and transform data from multiple databases, independent of their format, type, and location. The system comprises a setup portion, a meta database, and a user portion. The setup portion establishes datasets for use by the system with the user portion. The meta database stores the datasets. The user portion allows a user to input a query and processes the query to gather information from at least one data source and generate a response.
-
Citations
19 Claims
-
1. A method for managing data comprising:
-
identifying a plurality of disparate data sources, each of the disparate data sources comprising data source information and metadata that describes the data source information; accessing the metadata from the disparate data sources; generating a listing of fields from the metadata, wherein the fields correspond to data source information fields in one or more of the disparate data sources; receiving a selection of a field from the listing of fields, thereby resulting in a selected field; creating a metadata dataset comprising one or more selected fields, and identifying one or more data sources from the disparate data sources based on the metadata dataset; for each of the one or more identified disparate data sources, generating (i) a query based on a query language of the identified disparate data source and (ii) an API request that conveys the query to the identified disparate data source, wherein generating the query is based on a user request or the metadata dataset, wherein generating the API request is based on the user request or the metadata dataset, and generating the query request and the API request comprises using the metadata dataset to correlate information requested in the user request with the data source information; submitting each of the one or more generated queries to the one or more identified disparate data sources through the API request; receiving, in response to the one or more generated queries, a data source response from the one or more identified disparate data sources; and preparing a data source response to the user request for information. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer system comprising:
-
a processor; and a memory coupled to the processor; a computer readable medium having instructions embedded therein, the instructions configured to cause the processor to perform the operations of; identifying a plurality of disparate data sources, each of the disparate data sources comprising data source information and metadata that describes the data source information; accessing the metadata from the disparate data sources; generating a listing of fields from the metadata, wherein the fields correspond to data source information fields in one or more of the disparate data sources; receiving a selection of a field from the listing of fields, thereby resulting in a selected field; and creating a metadata dataset comprising one or more selected fields, and identifying one or more data sources from the disparate data sources based on the metadata dataset; for each of the one or more identified disparate data sources, generating (i) a query based on a query language of the identified disparate data source and (ii) an API request that conveys the query to the identified disparate data source, wherein generating the query is based on a user request or the metadata dataset, wherein generating the API request is based on the user request or the metadata dataset, and generating the query request and the API request comprises using the metadata dataset to correlate information requested in the user request with the data source information; submitting each of the one or more generated queries to the one or more identified disparate data sources through the API request; receiving, in response to the one or more generated queries, a data source response from the one or more identified disparate data sources; and preparing a data source response to the user request for information. - View Dependent Claims (11, 12, 13, 14)
-
-
15. A computer program product, the computer product comprising a non-transitory computer readable medium in which program instructions are stored, the program instructions configured to cause a computer system to:
-
identify a plurality of disparate data sources, each of the disparate data sources comprising data source information and metadata that describes the data source information; access the metadata from the disparate data sources; generate a listing of fields from the metadata, wherein the fields correspond to data source information fields in one or more of the disparate data sources; receive a selection of a field from the listing of fields, thereby resulting in a selected field; create a metadata dataset comprising one or more selected fields, and identifying one or more data sources from the disparate data sources based on the metadata dataset; for each of the one or more identified disparate data sources, generate (i) a query based on a query language of the identified disparate data source and (ii) an API request that conveys the query to the identified disparate data source, wherein generating the query is based on a user request or the metadata dataset, wherein generating the API request is based on the user request or the metadata dataset, and generating the query request and the API request comprises using the metadata dataset to correlate information requested in the user request with the data source information; submit each of the one or more generated queries to the one or more identified disparate data sources through the API request; receive, in response to the one or more generated queries, a data source response from the one or more identified disparate data sources; and prepare a data source response to the user request for information. - View Dependent Claims (16, 17, 18, 19)
-
Specification