Access-plan-based querying for federated database-management systems
AssigneeInternational Business Machines Corporation
InventorsChang Sheng Liu, Yan Li Xu, Hui Guo, Yao M. Wang, Hai Jun Shen, Ping Liu
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsChang Sheng Liu, Yan Li Xu, Hui Guo, Yao M. Wang, Hai Jun Shen, Ping Liu
Estimating the term…
A federated database-management system receives an SQL query or other type of data-access request. The federated system's host DBMS parses, rewrites, and optimizes the request into an optimal data-access plan, then determines which portions of the plan require access to data stored on the federated systems' remote databases. The federated host partitions the plan into subplans that each represent instructions of the original data-access request that were directed to a corresponding remote database of the federated DBMS. Each subplan is then transmitted to its corresponding remote database, which directly executes the subplan and returns results to the host. If necessary, a subplan is translated from an original generic access-plan format into a database-specific format required by its corresponding remote database.
A federated database-management system comprising a processor, a memory coupled to the processor, and a computer-readable hardware storage device coupled to the processor, the storage device containing program code configured to be run by the processor via the memory to implement a method for access-plan-based querying for federated database-management systems, the method comprising:
A method for access-plan-based querying for federated database-management systems, the method comprising:
A computer program product, comprising a computer-readable hardware storage device having a computer-readable program code stored therein, the program code configured to be executed by a federated database-management system comprising a processor, a memory coupled to the processor, and a computer-readable hardware storage device coupled to the processor, the storage device containing program code configured to be run by the processor via the memory to implement a method for access-plan-based querying for federated database-management systems, the method comprising:
Dependencies are inferred from the claim text.