Database query processing with dynamically activated buffers

Details Database query processing with dynamically activated buffers Database query processing with dynamically activated buffers

2008-03-27

2011-12-20

Mofiz, Apu (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

Reexamination Certificate

active

08082265

ABSTRACT:
A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an access plan for the database query. By doing so, the selection of a less optimal buffer position during optimization may be replaced with a more optimal buffer position during runtime, often resulting in improved query performance and parallelism.

REFERENCES:
patent: 5355029 (1994-10-01), Houghton et al.
patent: 6910032 (2005-06-01), Carlson et al.
patent: 6999958 (2006-02-01), Carlson et al.
patent: 2006/0080285 (2006-04-01), Chowdhuri
patent: 2006/0218123 (2006-09-01), Chowdhuri et al.
Acker, Ralph et al, “Parallel Query Processing in Databases on Multicore Architectures”, Algorithms and Architectures for Parallel Processing (lecture notes in computer science), Springer Berlin Heidelberg, Berlin, Heidelberg, vol. 5022,Jun. 11, 2007, pp. 2-13.
Babu, Shivnath et al, “Proactive Re-optimization with Rio”, Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data, Jun. 14, 2005, pp. 936-938 http://portal.acm.org/citation.cfmid=1066294>.
Ng, Kenneth W. et al, “Dynamic Query Re-Optimization”, Scientific and Statistical Database Management, 1999, Eleventh International Conference on Cleveland, OH, USA, Jul. 23-30, 1999, Los Alamitos, CA, USA, IEEE Computer Society, US, Jul. 28, 1999, pp. 264-273.
Bouganim, Luc et al, “Dynamic Query Scheduling in Data Integration Systems”, Data Engineering, 2000 Proceedings, 16th International Conference on San Diego, CA, USA, Feb. 29 to Mar. 3, 2000, Los Alamitos, CA, USA, IEEE Computer Society, US, Feb. 29, 2000, pp. 425-434.
Babu, Shivnath et al, “Adaptive Caching for Continuous Queries”, Proceedings of the 21st International Conference on Data Engineering (ICDE 2005), pp. 118-129 http://ieeexplore.ieee.org/stamp/stamp.jsp?arnumber=01410111>.
Markl, Volker et al, “Robust Query Processing through Progressive Optimization”, Proceedings of the 2004 ACM SIGMOD International Conference on Management of Data Table of Contents, 2004, pp. 659-670 http://portal.acm.org/citation.cfm?id=1007642>.

Affiliated with

Also associated with

Rating

Database query processing with dynamically activated buffers does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database query processing with dynamically activated buffers, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database query processing with dynamically activated buffers will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4315609