Nothing Special   »   [go: up one dir, main page]

skip to main content
article
Free access

Retrieval performance versus disc space utilization on WORM optical discs

Published: 01 June 1989 Publication History

Abstract

Steady progress in the development of optical disc technology over the past decade has brought it to the point where it is beginning to compete directly with magnetic disc technology. WORM optical discs in particular, which permanently register information on the disc surface, have significant advantages over magnetic technology for applications that are mainly archival in nature but require the ability to do frequent on-line insertions.
In this paper, we propose a class of access methods that use rewritable storage for the temporary buffering of insertions to data sets stored on WORM optical discs and we examine the relationship between the retrieval performance from WORM optical discs and the utilization of disc storage space when one of these organizations is employed. We describe the performance trade off as one of fast sequential retrieval of the contents of a block versus wasted space owing to data replication. A model of a specific instance of such an organization (a buffered hash file scheme) is described that allows for the specification of retrieval performance objectives. Alternative strategies for managing data replication that allow trade offs between higher consumption rates and better average retrieval performance are also described. We then provide an expected value analysis of the amount of disc space that must be consumed on a WORM disc to meet specified performance limits. The analysis is general enough to allow easy extension to other types of buffered files systems for WORM optical discs.

References

[1]
Batory, D.S., "Optimal File Designs and Reorganization Points", ACM Transactions on Database Systems, Vol. 7, No. 1, pp. 60-81.
[2]
Batory, D.S., Gotlieb, C.C., "A Unifying Model of Physical Databases", ACM Transaction8 on Database Systems, Vol. 7, No. 4, pp. 509-539.
[3]
Bell, A., Marrello, V., "Magnetic and Optical Data Storage: A comparison of the Technological Limits", Proceeding8 IEEE Compcon, Spring 1984, 512-517.
[4]
BYTE86, Collection of Articles, Byte, May 86.
[5]
Christodoulakis, S., Vanderbroek, J., Li, J., Li, T., Wan, S., Wang, Y., Papa, M., Bertino, E., "Development of a Multimedia information system for an office environment", Proc. of VLDB '84, Aug 1984, pp. 261-270.
[6]
Christodoulakis, S., "Analysis of Retrieval Performance for Records and Objects Using Optical Disk Technology", ACM Transaction on Database Systems, Vol. 12, No. 2, June 1987, pp. 137-169.
[7]
Christodoulakis, S., Elliott, K., Ford, D.A., Hatzilemonias, K., Ledoux, E., Leitch, M., Ng, R., "Optical Mass Storage Systems and their Performance", IEEE Database Engineering, March 1988
[8]
Christodoulakis, S., Ford, D.A., "File organizations and Access Methods for CLV Optical Disks", Technical Report CS-88-21, Department of Computer Science, University of Waterloo, March 1988. (Also to appear in Proceedings of SIGIR, Cambridge, Mass. June 1989).
[9]
Christodoulakis, S., Ford, D.A., "Sequentiality of and Disc Space Consumption on WORM optical Discs", Technical Report CS-88-$7, Department of Computer Science, University of Waterloo, December 1988.
[10]
Comer, D., "The Ubiquitous B-tree", Computing Surveys, Vol. 11, No. 2, pp. June 1979.
[11]
Easton, M.C., "Key-sequence data sets on indelible storage", IBM J. Res. Develop, Vol. 30, No. 3, (May 1986).
[12]
Fujitani. L., "Laser Optical Disks: The coming Revolution in On-Line Storage", CACM ~7, 6 (June '84), 546-554.
[13]
"HITFILE 650 Optical Disk Filing System", Hitachi Review, Vo{. 36 (1987), No. 4, pp. 213-220.
[14]
Hsiao, D., Harary, F., "A formal system for infortion retrieval from files", Communications of the ACM, Vol. 13, No. 2, pp. 67-73; Corrigendum, Communications of the ACM, Vol. 13, No. 4, pp. 266.
[15]
Katz, R.H., Wong, E., "Resolving Conflicts in Global Storage Design through Replication", ACM Transactions on Database Systems, Vol. 8, No. 1, pp. 110-135.
[16]
Lomet, D., Salzberg, B., "Access Methods for Multiversion Data", Technical Report NU-CCS-88-7, Northeastern University, December 16, 1988.
[17]
Larson, P.-A., "Analysis of index-sequential files with overflow chaining", ACM Transactions on Database Systems, Vol. 6, No. 4, pp. 671-680, 1981.
[18]
Litwin, W., "Linear Hashing: A New Tool for File and Table Addressing", In Proc. 6th Conf. on Very Large Databases, ACM, New York, pp. 212-223, 1980.
[19]
Lomet, D., "Partial Expansions for File Organizations with an Index", ACM Transactions on Database Systems, Vol 12, No. 1, pp. 65-84.
[20]
Maier, D., "Using Write-Once Memory for Database storage", Proceeding8 ACM PODS 8P, 1982.
[21]
"Optifile: Technical Reference Manual", KOM Inc. Ottawa, Version 1.0, (February 1986).
[22]
OPTIMEM1000, "Optical Disk Drive (OEM MANUAL)", Optimem, 435 Oakmead Parkway, Sunnyvale CA 94086.
[23]
Reed, I.S., Solomon, O. "Polynomial Codes over Certain Finite Fields", J. Soc. Indus. Appl. Math., 8.'8000-80,~, 1960.
[24]
Salzberg, B.J., File Structures, Prentice Hall, Englewood Cliffs, N.J., 1988
[25]
Severance, D.G., "A Parametric Model of Alternative File Structures", Information Systems, Vol. 1, No. 2, pp. 51-55.
[26]
Stonebraker, M., "The Design of the POSTCRES Stora~e System", Proc. 18th VLDB Conference, Brighton, 1987, pp. 289-300.
[27]
Teorey, Fry, Design of Database Structures, Prentice Hall, 1982.
[28]
Thomas, D., "A High-Speed Data Management System with On-Line Optical Disk Storage", IEEE 1985 Symposium On Mass Storage Systems, pp. 38-42.
[29]
de Vos, 3., "Megadoc, a modular system for electronic document handling", Philips Technical Review, 39 329.
[30]
ederhold, G., File Organization for Database Design, McGraw-Hill, 1987.
[31]
Yao, S.B., "An Attribute Based Model for Database Access Cost Analysis", ACM Transaction8 on Database Systems, Vol. 2, No. 1, March 1977, pp. 45-67.

Recommendations

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM SIGMOD Record
ACM SIGMOD Record  Volume 18, Issue 2
June 1989
442 pages
  • cover image ACM Conferences
    SIGMOD '89: Proceedings of the 1989 ACM SIGMOD international conference on Management of data
    June 1989
    451 pages
    ISBN:0897913175
    DOI:10.1145/67544
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1989
Published in SIGMOD Volume 18, Issue 2

Check for updates

Qualifiers

  • Article

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)52
  • Downloads (Last 6 weeks)12
Reflects downloads up to 24 Sep 2024

Other Metrics

Citations

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media