A window-based approach to retrieving memory-resident data for query execution

Proceedings of the International Database Engineering and Applications Symposium, IDEAS

Volumn , Issue , 2004, Pages 283-288

  Pisharath, Jayaprakash ^a   Choudhary, Alok ^a   Kandemir, Mahmut ^b  

^a Northwestern University   (United States)

^b The Pennsylvania State University   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATA BLOCKING; DATA WINDOWING; MEMORY-RESIDENT DATA; QUERY EXECUTION;

BENCHMARKING; BUFFER STORAGE; COMPUTER SCIENCE; DATA ACQUISITION; DATA STORAGE EQUIPMENT; DISTRIBUTED DATABASE SYSTEMS; INFORMATION MANAGEMENT; OPTIMIZATION;

QUERY LANGUAGES;

EID: 5444254677     PISSN: 10988068     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/IDEAS.2004.1319802     Document Type: Conference Paper

References (17)

1. A. Ailamaki, D.J. DeWitt, M.D. Hill, and D.A. Wood DBMSs on a Modem Processor: Where Does Time Go?. The VLDB Journal, 1999.
2. A. Ailamaki, D. J. DeWitt, and M.D. Hill. Data Page Layouts for Relational Databases on Deep Memory Hierarchies. The VLDB Journal, 11(2), 2002.
3. Berkeley DB V4.1.25, Sleepycat Software, 2003. Available HTTP: http://www.sleepycat.com/docs/index.html
4. P. A. Boncz. Monet: A Next-Generation DBMS Kernel For Query-Intensive Applications. Ph.D. Thesis, Univeràteit van Amsterdam, The Netherlands, May 2002.
5. R. Choenni, M.L. Kersten, J.F.P. Van den Akker, and A. Saad. On multi-query optimization. Technical Report CS-R9638, Centrum voor Wiskunde en Informatica, 1996.
6. International Technology Raadmap for Semiconductors - 2002 Update, ITRS, 2003. Available HTTP: http://public.itrs.net/
7. T. J. Lehman and M. J. Carey. A study of index structures for main memory database management systems. In Proceedings of the 12th International Conference on. Very Large Data Bases, 1986.
8. Main Memory Databases, white paper, Bloor Research Ltd., November 1999.
9. Main Memory vs. RAM-Disk Databases, McObject LLC, 2003. Available HTTP: http://www.mcobject.com/whitepapers.htm
10. C. Nyberg, T. Barclay, Z. Cvetanovic, J. Gray, and D. B. Lomnet. AlphaSort A RISC Machine Sort. In Proceedings of the ACM SIGMOD International Conference on Management of Data, 1994.
11. W. Pugh and D. Won. Constraint-based array dependence analysis. ACM Transactions on Programming Languages and Systems, 20(3):635-678, May 1998.
12. R. Ramakrishnan and J. Gehrke. Database Management Systems, third edition, McGraw-Hill publishers, 2002.
13. K. A. Ross. Conjunctive selection conditions in main memory. In Proceedings of the 21st ACM Symposium on Principles of Database Systems, 2002.
14. Shade V6, Sun Microsystems, 2003. Available HTTP: http://www.sun.com/ microelectronics/shade/
15. A. Shatdal, C. Kant, and J.F. Naughton. Cache Conscious Algorithms for Relational Query Processing. In Proceedings of the 20th International Conference on Very Large Data Bases, 1994.
16. TPC-H Benchmark Revision 2.0.0, Transaction Processing Performance Council, 2003.
17. P. Trancoso and J. Torrellas. Cache Optimization for Memory-Resident Decision Support Commercial Workloads, In Proceedings of the International Conference on Computer Design, 1999.