Loading patent…
AssigneeParAccel LLC
InventorsWilliam J. McKenna, Richard L. Cole, Yijou Chen, Sergei Perfilov, Aman Sinha, Eugene Szedenits, Jr.
Estimating the term…
A database system allows users to specify plan constraint specification that limit choices of execution plans considered by an optimizer of the database system for optimizing database queries. The plan constraint specification specifies attributes of execution plans. The plan constraint specification may identify tables/intermediate results that the plan constraint is applicable to using table names or aliases. The database system applies the plan constraint specification to database queries that match the tables/aliases specified in the plan constraint specification. The database system limits the choice of execution plans evaluated for a database query to execution plans satisfying the attributes specified in an applicable plan constraint specification. The plan constraint specification may specify distribution of a table, a join order for tables, the join mechanism, cardinality of a table or intermediate result, and so on.
A computer-implemented method for limiting the execution plans evaluated by database system for queries, the method comprising:
A computer readable non-transitory storage medium storing instructions thereon, the instructions for:
A computer-implemented system for limiting the execution plans evaluated by database system for queries, the system comprising:
Dependencies are inferred from the claim text.