Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-04-29
2009-10-06
Alam, Shahid A (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07599923
ABSTRACT:
A method and apparatus of analyzing a target system comprises receiving information relating to an environment of the target system and storing cost data based on the environment information. The plan and its estimated performance for a query may be determined based on the cost data. The environment information may pertain to the environment of a parallel system (e.g., a multi-node parallel system, a single-node parallel system having plural central processing units or a system running plural virtual processors) that is running a parallel database. The cost data may identify a number of nodes in the target system, a number of central processing units in each node of the target system, and other types of system information. The cost data may be stored in a relational table having a plurality of rows. Each row of the relational table may correspond to a different target system. The cost data is used to emulate the environment of the target system and is usable by an optimizer module to derive a query plan for an SQL (structured query language) query having the lowest (or lower) cost.
REFERENCES:
patent: 5303383 (1994-04-01), Neches et al.
patent: 5398199 (1995-03-01), Lefons
patent: 5495578 (1996-02-01), Rohrbaugh et al.
patent: 5606693 (1997-02-01), Nilsen et al.
patent: 5640584 (1997-06-01), Kandasamy et al.
patent: 5655080 (1997-08-01), Dias et al.
patent: 5819066 (1998-10-01), Bromberg et al.
patent: 5857192 (1999-01-01), Fitting
patent: 5864841 (1999-01-01), Agrawal et al.
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5872904 (1999-02-01), McMillen et al.
patent: 5884299 (1999-03-01), Ramesh et al.
patent: 5940819 (1999-08-01), Beavin et al.
patent: 5943545 (1999-08-01), Ise
patent: 5943666 (1999-08-01), Kleewein et al.
patent: 6067542 (2000-05-01), Carino, Jr.
patent: 6208955 (2001-03-01), Provan et al.
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6298349 (2001-10-01), Toyoshima et al.
patent: 6381604 (2002-04-01), Caughran et al.
patent: 6401083 (2002-06-01), Agarwal et al.
patent: 6414307 (2002-07-01), Gerlach et al.
patent: 6415307 (2002-07-01), Jones et al.
patent: 6418389 (2002-07-01), Peter et al.
patent: 6430556 (2002-08-01), Goldberg et al.
patent: 6487547 (2002-11-01), Ellison et al.
patent: 6507834 (2003-01-01), Kabra et al.
patent: 6507842 (2003-01-01), Grey et al.
patent: 6564209 (2003-05-01), Dempski et al.
patent: 6615120 (2003-09-01), Rother
patent: 6662312 (2003-12-01), Keller et al.
patent: 2003/0016237 (2003-01-01), Hickey
Brown Douglas P.
Sinclair Paul
Alam Shahid A
Cowart John D.
McDonald Steve
Teradata , US Inc.
Trop Pruner & Hu
LandOfFree
Analysis method and apparatus for a parallel system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Analysis method and apparatus for a parallel system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Analysis method and apparatus for a parallel system will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4071194