Prefetching in realtime database applications

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

Prefetching in realtime database applications

Full text

Pdf (1.01 MB)

Source

International Conference on Management of Data archive
Proceedings of the 1986 ACM SIGMOD international conference on Management of data table of contents

Washington, D.C., United States

Pages: 215 - 226

Year of Publication: 1986

ISBN:0-89791-191-1

Also published in ...

Authors

H. Wedekind	Universitaet Frlangen-Nuernberg, Informatik VI, Martensstrasse 3, 8520 Prlangen, W-Germany
George Zoerntlein	Universitaet Frlangen-Nuernberg, Informatik VI, Martensstrasse 3, 8520 Prlangen, W-Germany

Sponsor

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 5, Downloads (12 Months): 19, Citation Count: 7

Additional Information:

abstract references cited by index terms collaborative colleagues peer to peer

Tools and Actions:	Review this Article Save this Article to a Binder Display Formats: BibTex EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/16894.16876 What is a DOI?

ABSTRACT

In this paper a method is proposed how to achieve response times of main memory database systems without keeping the whole database in main memory. The method was originally developed for real-time systems in manufacturing automation, but it is applicable in environments where canned transactions interact with databases rather than people performing free transactions. The main idea is to preanalyse canned transactions in order to extract knowledge about their local access behaviour. This knowledge is used by the runtime system of the database when the transaction is started. Concepts for modules doing the preanalysis and the runtime tasks are described in detail. Furthermore a database architecture is developed incorporating these new components.

REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	BA 84	Baumann, R. Datenverarbeltung unter Zeltbedlngungen. in Informatlk Spektrum, Band 7, Heft 2, Aprll 1984
	BE 66	Belady,L A A study of replacement algorlthms for vlrtual storage computers IBM Syst. J 5,2 (1966), 78 - IZl
	DB 82	Umeshwar Dayal , Philip A. Bernstein, On the correct translation of update operations on relational views, ACM Transactions on Database Systems (TODS), v.7 n.3, p.381-416, Sept. 1982 [doi>10.1145/319732.319740]
	EH 84	Wolfgang Effelsberg , Theo Haerder, Principles of database buffer management, ACM Transactions on Database Systems (TODS), v.9 n.4, p.560-595, Dec. 1984 [doi>10.1145/1994.2022]
	GA 83	Hector Garcia-Molina, Using semantic knowledge for transaction processing in a distributed database, ACM Transactions on Database Systems (TODS), v.8 n.2, p.186-213, June 1983 [doi>10.1145/319983.319985]
	HA 78	Haerder,T Impl#mentlerung yon Datenbanksystemen Hanser-Verlag, #uenchen 1978
	RO 76	Rodrlguez-Rosell, J FmFlrlcal #ata reference behavlour In database systems in Computer, Vol 9, No ii, (1976), pp 9-13
	SM 78	Alan Jay Smith, Sequentiality and prefetching in database systems, ACM Transactions on Database Systems (TODS), v.3 n.3, p.223-247, Sept. 1978 [doi>10.1145/320263.320276]
	ST 84	Stelnbauer,P Trensaktlonen als Crundlage zur StrukturJerung und Integrltaetsslcherung in Da%enbank-Anwendungssystemen Arbeltsberlchte des IM#'P d Unl Erlangen, 16 (1984)
	WH 76	Wedeklnd,H , Haerder,T Datenbanksysteme II B I , Relhe Informatlk, Band 18, Mannhelm 1976

CITED BY 7

	H. Wedekind, Ubiquity and need-to-know: two principles of data distribution, ACM SIGOPS Operating Systems Review, v.22 n.4, p.39-45, Oct. 1988
	M. J. Carey , R. Jauhari , M. Livny, Priority in DBMS resource scheduling, Proceedings of the 15th international conference on Very large data bases, p.397-410, July 1989, Amsterdam, The Netherlands
	Binto George , Jayant R. Haritsa, Secure buffering in firm real-time database systems, The VLDB Journal — The International Journal on Very Large Data Bases, v.8 n.3-4, p.178-198, February 2000
	Achim Kraiss , Gerhard Weikum, Vertical Data Migration in Large Near-Line Document Archives Based on Markov-Chain Predictions, Proceedings of the 23rd International Conference on Very Large Data Bases, p.246-255, August 25-29, 1997
	Achim Kraiss , Gerhard Weikum, Integrated document caching and prefetching in storage hierarchies based on Markov-chain predictions, The VLDB Journal — The International Journal on Very Large Data Bases, v.7 n.3, p.141-162, August 1998
	Zhenmin Li , Zhifeng Chen , Sudarshan M. Srinivasan , Yuanyuan Zhou, C-Miner: Mining Block Correlations in Storage Systems, Proceedings of the 3rd USENIX Conference on File and Storage Technologies, March 31-31, 2004, San Francisco, CA
	Zhenmin Li , Zhifeng Chen , Yuanyuan Zhou, Mining block correlations to improve storage performance, ACM Transactions on Storage (TOS), v.1 n.2, p.213-245, May 2005