Method and system for federated querying of data sources
AssigneeInternational Business Machines Corporation
InventorsJoshua Fox, Rannen Meir, Zvi Schreiber
Life of this patent
Estimating the term…
Abstract
A system for managing and querying a plurality of data sources, including an interface to a plurality of inter-related data sources of diverse types, each of the plurality of data sources having a schema that describes its data structure, a schema generator communicating with the interface, for generating a federated schema that describes the structures of the plurality of data sources and their inter-relationships, and for modifying the federated schema over time as the plurality of data sources undergo changes, and a query generator communicating with the schema generator, for generating a query for the federated schema. A method and a computer-readable storage medium are also described.
Claims53
A system, implemented in a data processing system, for managing and querying a plurality of inter-related data sources, the system comprising:
- an interface to the plurality of inter-related data sources of diverse types, wherein each of the plurality of inter-related data sources has a corresponding schema that describes a corresponding data structure of a corresponding data source;
- a schema generator communicating with said interface, wherein the schema generator generates a federated schema that describes structures of the plurality of inter-related data sources and inter-relationships of the plurality of inter-related data sources, and wherein the schema generator further modifies the federated schema over time as the plurality of inter-related data sources undergo changes;
- a query generator communicating with said schema generator, wherein the query generator generates a query for the federated schema;
- and
- a storage device in communication with the data processing system, the storage device operable to store the query.
A method, implemented in a data processing system, for managing and querying a plurality of inter-related data sources, the method comprising:
- generating a federated schema that describes structures of the plurality of inter-related data sources and inter-relationships of the plurality of inter-related data sources;
- modifying the federated schema over time as the plurality of inter-related data sources undergo changes, wherein each of the plurality of inter-related data sources has a corresponding schema that describes a corresponding data structure of a corresponding data source;
- generating a query for the federated schema;
- and
- storing the federated schema.
A computer-readable storage medium storing program code for causing a computer to perform the steps of:
- generating a federated schema that describes structures of the plurality of inter-related data sources and inter-relationships of the plurality of inter-related data sources;
- modifying the federated schema over time as the plurality of inter-related data sources undergo changes, wherein each of the plurality of inter-related data sources has a corresponding schema that describes a corresponding data structure of a corresponding data source;
- and
- generating a query for the federated schema.
Dependencies are inferred from the claim text.