Optimized database appliance

Details Optimized database appliance Optimized database appliance

2006-03-07

2006-03-07

Rimell, Sam (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07010521

ABSTRACT:
A system from processing database queries allows for cost and locale based distribution for execution of database queries. The database queries are executed on execution engines that provide flexible configuration and overlapping functionality. The system reduces various costs, including elapsed time, required to perform database queries. The system provides processing of a database query using a database catalog comprising database table locality information, record locality information and execution engine information. A query optimizer receives the query and accesses the database catalog to create a query execution plan comprising locality-based database operations. A central database operation processor providing a first execution engine executes the query execution plan by performing at least a portion of the locality-based database operations and distributing at least a portion of the locality-based database operations as a subplan. A second database operation processor providing a second execution engine executes the subplan received from the central database operation processor. At least one of the database operations can be executed on either the first execution engine or the second execution engine. A storage unit stores at least a portion of database tables and records. A data communications network connects the central database processor to the second database processor.

REFERENCES:
patent: 4817035 (1989-03-01), Timsit
patent: 5442791 (1995-08-01), Wrabetz et al.
patent: 5457797 (1995-10-01), Butterworth et al.
patent: 5495601 (1996-02-01), Narang et al.
patent: 5537533 (1996-07-01), Staheli et al.
patent: 5544347 (1996-08-01), Yanai et al.
patent: 5586315 (1996-12-01), Narang et al.
patent: 5832486 (1998-11-01), Itoh et al.
patent: 5884299 (1999-03-01), Ramesh et al.
patent: 6026379 (2000-02-01), Haller et al.
patent: 6112281 (2000-08-01), Bamford et al.
patent: 6272662 (2001-08-01), Jadav et al.
patent: 6282610 (2001-08-01), Bergsten
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6304874 (2001-10-01), Corley et al.
patent: 6308169 (2001-10-01), Ronström et al.
patent: 6311187 (2001-10-01), Jeyaraman
patent: 6321235 (2001-10-01), Bird
patent: 6314417 (2001-11-01), Bennett et al.
patent: 6351749 (2002-02-01), Brown et al.
patent: 6505285 (2003-01-01), Rabinovici et al.
patent: 6507834 (2003-01-01), Kabra et al.
“The Berkeley ISTORE Project,” http://istore/cs.berkeley.edu/, downloaded Dec. 10, 2001 (2 pp.).
Brown, A. et al., “ISTORE: An Introspective Storage Architecture for Network Service Applications,” http://istore.cs.berkeley.edu/talks/iram-jan99-retreat-istore-intro/sld001-015.htm, (downloaded Dec. 10, 2001) 15 pp.
Acharya, A. et al., “Active Disks: Programming Model, Algorithms and Evaluation,”Proceedings of the Eighth International Conference on Architectural Support for Programming Languages and Operating Systems(Association for Computing Machinery), San Jose, CA Oct. 1998 (11 pp.).
“Active Disks: Remote Execution for Network-Attached Storage,” http://www.pdl.cmu.edu/Active/, downloaded Dec. 10, 2001 (9 pp.).
Keeton, K. K., “Computer Architecture Support for Database Applications,” Doctoral dissertation, University of California at Berkeley, 1999 (217 pp.).
“WX/DES—Technical Information,”WhiteCross White Paper: R&D 99Q3-01, May 25, 2000 (36 pp.).

Affiliated with

Also associated with

Rating

Optimized database appliance does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimized database appliance, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimized database appliance will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3552738