A method includes receiving, by a first computing entity of a database system, a query request that is formatted in accordance with a generic query format. The method further includes generating, by the first computing entity, an initial query plan based on the query request and a query instruction set. The method further includes determining, by the first computing entity, storage parameters. The method further includes determining, by the first computing entity, processing resources for processing the query request based on the storage parameters. The method further includes generating, by the first computing entity, an optimized query plan from the initial query plan based on the storage parameters, the processing resources, and optimization tools. The method further includes sending, by the first computing entity, the optimized query plan to a second computing entity for distribution and execution of the optimized query plan.
Legal claims defining the scope of protection, as filed with the USPTO.
10. The method of claim 1, wherein the plurality of processing resources are further determined based on determining processing resources that are available, and based on selecting processing resources that store a relevant portion of the database table, and wherein the plurality of processing resources execute the optimized query plan based on processing at least one operation of the optimized query plan on their respective portions of the database table.
22. The computer readable memory device of claim 13, wherein the plurality of processing resources are further determined based on determining processing resources that are available, and based on selecting processing resources that store a relevant portion of the database table, and wherein the plurality of processing resources execute the optimized query plan based on processing at least one operation of the optimized query plan on their respective portions of the database table.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
February 5, 2019
May 7, 2024
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.