Shared scans utilizing query monitor during query execution...

Details Shared scans utilizing query monitor during query execution... Shared scans utilizing query monitor during query execution...

2004-01-22

2008-03-25

Lewis, Cheryl (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07349925

ABSTRACT:
A system for data base management using memory devices holding a database containing tables of data occupying extents. A database engine reviews each query to determine an extents list of extents containing the data needed by that said query. A query monitor then re-orders the extents lists so that extents are retreived and stored in a buffer cache for more efficient use when executing the queries. The database engine retreives needed extents from the memory devices, as ordered in the extents lists, and stores those extents in the buffer cache. The database engine then executes one or more queries on the data in the extents in the buffer cache to determine respective results.

REFERENCES:
patent: 5758146 (1998-05-01), Schiefer et al.
patent: 5761696 (1998-06-01), Giordano et al.
patent: 5794229 (1998-08-01), French et al.
patent: 5813005 (1998-09-01), Tsuchida et al.
patent: 5884299 (1999-03-01), Ramesh et al.
patent: 6470330 (2002-10-01), Das et al.
patent: 2001/0011268 (2001-08-01), Tsuchida et al.
patent: 2002/0169658 (2002-11-01), Adler
patent: 2002/0198872 (2002-12-01), McNicol et al.
patent: 2205970 (1990-08-01), None
Parle '93, Parallel Architectures and Languages Europe, 5thInternational Parle Conference, Munich, Germany, Jun. 14-17, 1993 Proceedings.
13thInternational Conference on Data Engineering, Apr. 7-11, 1997, University of Bermingham, Sponsored by IEEE Computer Society, entitled: Teaching an OLTP Database Kernel Advanced Datawarehousing Techniques by Clark D. French.
Euro-Par '95, Parallel Processing, Aug. 29-31, 1995, entitled: Analysis of Parallel Scan Processing in shared Disk Database Systems by Erhard Rahm and Thomas Stohr.
Inspec: Sarker, S. et al., French, CD., Sundaresan, P.; Xuemin, L. et al, 1997.
Experiences Building the Open OODB Query Optimizer by Blakeley et al., 1993.
Architectural Support for Scalable Speculative Parellelization in Shared-Memory Multiprocessors by M. Cintra et al.; 2000.
Barkovski et al., “Data Storage and Retrieval Method and Scanner,” Bibliographic information and Abstract translation of JP 2205970 A2, Sep. 24, 2003, Thompson Delphion.

Affiliated with

Also associated with

Rating

Shared scans utilizing query monitor during query execution... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Shared scans utilizing query monitor during query execution..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Shared scans utilizing query monitor during query execution... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3973780