Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2011-08-16
2011-08-16
Ly, Cheyne D (Department: 2168)
Data processing: database and file management or data structures
Database and file access
Query optimization
Reexamination Certificate
active
08001109
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.
REFERENCES:
patent: 5301317 (1994-04-01), Lohman et al.
patent: 5551027 (1996-08-01), Choy et al.
patent: 6092062 (2000-07-01), Lohman et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6223182 (2001-04-01), Agarwal et al.
patent: 6282570 (2001-08-01), Leung et al.
patent: 6311265 (2001-10-01), Beckerle et al.
Zilio et al., Physical Database Design Decision Algorithms and Concurrent Reorganization for Parallel Database Systems, University of Toronto (Canada), pp. 1-277, Jul. 1999.
Agrawal et al., Proceedings of the 26thInternational Conference on Very Large Databases, Cairo, Egypt, pp. 496-505, 2000.
Baru et al., IBM Systems Journal, vol. 34, No. 2, pp. 292-322, 1995.
Valentin et al., IEEE, pp. 101-110, 2000.
Kossman et al., ACM Transactions on Database Systems, vol. 25, No. 4, Dec. 2000, pp. 517-558.
Lohman Guy Maring
Megiddo Nimrod
Rao Jun
Zhang Chun
International Business Machines - Corporation
Ly Cheyne D
Rogitz John L.
LandOfFree
System and method for automating data partitioning in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for automating data partitioning in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for automating data partitioning in a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2715261