Please download the dossier by clicking on the dossier button x
×

Method and system for query transformation for managing information from multiple datasets

  • US 9,881,103 B2
  • Filed: 02/03/2014
  • Issued: 01/30/2018
  • Est. Priority Date: 09/17/2004
  • Status: Active Grant
First Claim
Patent Images

1. A method for managing data, comprising:

  • creating a metadata dataset comprising metadata of a plurality of disparate data sources, wherein the metadata of each of the plurality of disparate data sources describes data source information contained in the disparate data source, and wherein the metadata dataset comprises fields for each type of information to be queried;

    receiving a user request for information from the plurality of disparate data sources;

    in response to receiving the user request, for each of the plurality of disparate data sources, generating (i) a query based on a query language of the disparate data source and (ii) an API request to convey the query to the disparate data source, wherein generating the query is based on the user request, wherein the operation of generating the query and the API request for each of the plurality of disparate data sources comprises using the metadata dataset to correlate information requested in the user request with the disparate data source'"'"'s information;

    submitting each of the generated queries to its corresponding disparate data source using the corresponding API request;

    receiving, in response to the generated queries, a raw data source response from each of the plurality of disparate data sources;

    mapping, using the metadata dataset, a data source information field in each raw data source response to a formatted information field to transform each of the raw data source responses into a formatted data source response; and

    combining the formatted responses into a response to the user request.

View all claims
  • 5 Assignments
Timeline View
Assignment View
    ×
    ×