Optimized database appliance

Details Optimized database appliance Optimized database appliance

2011-04-05

2011-04-05

Al-Hashemi, Sana (Department: 2156)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

C707S763000, C707S766000, C707S771000

Reexamination Certificate

active

07921130

ABSTRACT:
A system and method 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 method 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 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 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: 5857180 (1999-01-01), Hallmark 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: 6314417 (2001-11-01), Bennett et al.
patent: 6321235 (2001-11-01), Bird
patent: 6351749 (2002-02-01), Brown et al.
patent: 6505285 (2003-01-01), Rabinovici et al.
patent: 6507834 (2003-01-01), Kabra et al.
patent: 6507934 (2003-01-01), Smith
patent: 2002/0055937 (2002-05-01), Walther
“The Berkeley ISTORE Project,” http://istore/cs.berkeley.edu/, downloaded Dec. 10, 2001 (2 pages).
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 pages.
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 pages).
“Active Disks: Remote Execution for Network-Attached Storage,” http://www.pdl.cmu.edu/Active/dowloaded Dec. 10, 2001 (9 pages).
Keeton, K., “Computer Architecture Support for Database Applications,” Doctoral Dissertation, University of California at Berkeley, 1999 (217 pages).
“WX/DES—Technical Information,”WhiteCross White Paper: R&D 99Q3-01, May 25, 2000 (36 pages).
Kang, S., and Moon, S., “Global Query Management in Heterogeneous Distributed Database Systems,”Microprocessing and Microprogramming, 38(1): pp. 377-384 (1993).

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-2738953