Data processing: database and file management or data structures – Database and file access – Preparing data for information retrieval
Reexamination Certificate
2011-03-29
2011-03-29
Stace, Brent (Department: 2161)
Data processing: database and file management or data structures
Database and file access
Preparing data for information retrieval
C707S972000
Reexamination Certificate
active
07917512
ABSTRACT:
A workload specification, detailing specific queries and a frequency of execution of each of the queries, and a set of partitions, are obtained for the database, as inputs. A number of candidate tables are identified for the database, the tables having a plurality of attributes. A chosen attribute is allocated for each of the tables, to obtain a set of tables and a set of appropriate partitions for each of the tables.
REFERENCES:
patent: 6101495 (2000-08-01), Tsuchida et al.
patent: 7158996 (2007-01-01), Croisettier et al.
patent: 2002/0194157 (2002-12-01), Zait et al.
patent: 2004/0122845 (2004-06-01), Lohman et al.
patent: 2004/0260684 (2004-12-01), Agrawal et al.
patent: 2005/0038784 (2005-02-01), Zait et al.
patent: 2005/0160074 (2005-07-01), Vos et al.
patent: 2006/0085378 (2006-04-01), Raizman et al.
patent: 2006/0085484 (2006-04-01), Raizman et al.
Wikipedia, “Tirangular matrix” Oct. 26, 2007, Wikipedia.org, p. 1-5.
Rao, Jun et al., “Automating Physical Database Design in a Parallel Database” Jun. 6, 2002, ACM SIGMOD, p. 1-12.
Zhao, X et al. “PPS—A Parallel Partition Sort Algorithm for Multiprocessor Database Systems.” Proceedings of the 11th International Workshop on Database and Expert Systems Applications, 2000.
Table Partitioning and Multidimensional Clustering Tables. Downloaded at http://publib boulder ibm.com/infocenter/db2luw/v9/index jsp?topic=/com ibm db2 udb admin doc/doc/c0021605.htm.
“Catalog Statistics Tables” Downloaded at http://publib boulder ibm.com/infocenter/db2luw/v9/index jsp?topic=/com.ibm.db2 udb admin.doc/doc/c0005087.htm.
Feelifl, H. et al “RING: A Stategy for Minimizing the Cost of On-line Data Placement Reorganization for Btree Indexed Database Over Shared-nothing Parallel Machines” Proceedings of the Seventh International Conference on Database Systems for Advanced Applications 2001.
Barua, R et al. Communication-Minimal Partitioning of Parallel Loops and Data Arrays for Cache-Coherent Distributed-Memory Multiprocessors Languages and Compilers for Parallel Computing p. 350-368. 1997.
Bhide Manish A.
Lightstone Sam S.
Mignet Laurent S.
Negi Sumit
Zilio Daniele C.
International Business Machines - Corporation
Ryan & Mason & Lewis, LLP
Stace Brent
LandOfFree
Method for automated design of range partitioned tables for... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method for automated design of range partitioned tables for..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for automated design of range partitioned tables for... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2740279