System and method for automating data partitioning in a parallel database
First Claim
1. A computer program device for automatically determining the best data partitioning for a given workload in a parallel database, comprising:
- logic means for recommending at least one candidate partition for at least one data table.
2 Assignments
0 Petitions
Accused Products
Abstract
A system for automating data partitioning in a parallel database includes plural nodes connected in parallel. Each node includes a database server and two databases connected thereto. Each database server includes a query optimizer. Moreover, a partitioning advisor communicates with the database server and the query optimizer. The query optimizer and the partitioning advisor include a program for recommending and evaluating data table partitions that are useful for processing a workload of query statements. The data table partitions are recommended and evaluated without requiring the data tables to be physically repartitioned.
-
Citations
31 Claims
-
1. A computer program device for automatically determining the best data partitioning for a given workload in a parallel database, comprising:
logic means for recommending at least one candidate partition for at least one data table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
12. A method for automatically partitioning data in a parallel database, comprising:
-
recommending at least one candidate partition for at least one data table based in part on a workload of query statements referencing the data table; and
evaluating the candidate partition based in part on the workload of query statements to determine a cost of using the candidate partition. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19)
-
-
20. A system for automating data partitioning in a parallel database, comprising:
-
plural nodes connected in parallel, each node including;
at least one database server;
at least one database connected to the database server;
at least one query optimizer within the database server; and
at least one partitioning advisor in communication with the database server and the query optimizer, at least one of the query optimizer and the partitioning advisor including a program for recommending and evaluating data table partitions useful for processing a workload of query statements before a data repartition is implemented. - View Dependent Claims (21, 22, 23, 24, 25, 26, 27, 28, 29, 30)
-
-
31. A computer program device for automatically determining the best data partitioning for a given workload in a parallel database, comprising:
logic means for evaluating a candidate partition based in part on a workload of query statements to determine a cost of the workload of query statements using the candidate partition without first requiring the data table to be repartitioned.
Specification