Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-02-17
2008-11-04
Wong, Don (Department: 2163)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07447681
ABSTRACT:
Disclosed is a method for directing a data processing system, the data processing system and an article of manufacture. The data processing system has memory for storing a database. The method directs the data processing system to configuring the database based on a database workload having a performance metric. The method includes selecting a plurality of database characteristics based upon the database workload, each of the database characteristics having an associated estimated performance metric for the database workload, selecting a set of database characteristics from the plurality of database characteristics for which the associated estimated performance metric is lower than the database workload performance metric, and configuring the database using the selected set of database characteristics.
REFERENCES:
patent: 5222235 (1993-06-01), Hintz et al.
patent: 5404510 (1995-04-01), Smith et al.
patent: 5442784 (1995-08-01), Powers et al.
patent: 5485610 (1996-01-01), Gioielli et al.
patent: 5668944 (1997-09-01), Berry
patent: 5701471 (1997-12-01), Subramanyam
patent: 5960423 (1999-09-01), Chaudhuri et al.
patent: 6029163 (2000-02-01), Ziauddin
patent: 6141655 (2000-10-01), Johnson et al.
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6341285 (2002-01-01), Blott et al.
patent: 6356889 (2002-03-01), Lohman et al.
patent: 6366903 (2002-04-01), Agrawal et al.
patent: 6535872 (2003-03-01), Castelli et al.
patent: 6629102 (2003-09-01), Malloy et al.
patent: 6957211 (2005-10-01), Tyulenev et al.
patent: 7007006 (2006-02-01), Zilio et al.
patent: 7127456 (2006-10-01), Brown et al.
patent: 7194452 (2007-03-01), Galindo-Legaria et al.
patent: 7233939 (2007-06-01), Ziauddin
patent: 7281004 (2007-10-01), Lightstone et al.
patent: 2002/0077997 (2002-06-01), Colby
patent: 2002/0091708 (2002-07-01), Vos et al.
patent: 2003/0088541 (2003-05-01), Zilio et al.
patent: 2004/0068424 (2004-04-01), Lee et al.
patent: 2004/0236757 (2004-11-01), Caccavale et al.
patent: 2005/0015641 (2005-01-01), Alur et al.
patent: 2005/0086242 (2005-04-01), Ngai et al.
patent: 2005/0086246 (2005-04-01), Wood et al.
patent: 2002163290 (2002-07-01), None
Rullo, P., et al.,An Automatic Physical Designer for Network Model Databases, IEEE Transactions on Software Engineering, vol. 14, No. 9, Sep. 1988.
Wu Wen-chuan, et al.,A Graphic Database Based Network Topology and Its Application, Power System Technology vol. 26, No. 2, Feb. 2002, Abstract in English.
DeKimpe, D., et al,Method, System, and Program for Improving Performance of Database Queries, U.S. Appl. No. 10/410,793, filed Apr. 9, 2003.
Malloy, W., et al,Method, System, and Program for Specifying Multidimensional Calculations for a Relational OLAP Engine, U.S. Appl. No. 10/341,763, filed Jan. 13, 2003.
Jeffrey O. Kephart, “The Vision of Autonomic Computing”, Computer, Jan. 2003, pp. 41-50, 0018-9162/03, Published by the IEEE Computer Society.
Lightstone et al., Automated Design of Multidimensional Clustering Tables for Relational Databases, 30th VLDB Conference, 2004, pp. 1170-1181, Toronto, Canada.
Rao et al., Automating Physical Database Design in a Parallel Database, AC SIGMOD, Jun. 4-6, 2002, pp. 558-569, ACM 1-58113-497-5/02/06, Madison, US.
Valentin et al., DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes, 10 pages.
Zilio et al., DB2 Design Advisor: Integrated Automatic Physical Database Design, 30th VLDB Conference, 2004, pp. 1087-1097, Toronto, Canada.
Zilio et al., Recommending Materialized Views and Indexes with the IBM DB2 Design Advisor, 8 pages.
Lightstone Sam Sampson
Lohman Guy Maring
O'Connell William T.
Rao Jun
Van Boeschoten Robin D.
Hwa Shyue Jiunn
International Business Machines - Corporation
Sawyer Law Group LLP
Wong Don
LandOfFree
Method, system and program for selection of database... 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, system and program for selection of database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system and program for selection of database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4045498