Skip to main content
SpringerLink
Log in

A Technique for Upgrading Database Machines Online

  • Conference paper
  • First Online:
Advances in Information Systems (ADVIS 2000)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1909))

Included in the following conference series:

  • 319 Accesses

Abstract1

In order to improve performance of database systems, we may have to replace an existing database machine with more powerful one. Thus database migration between two machines becomes necessary. Database migration, however, generally requires taking a database off line for a long time, which is unacceptable for numerous applications. This paper addresses a very practical and important subject: how to replace a database machine on line, i.e., how to move a database from an existing machine to a new one concurrently with users’ reading and writing of the database. A technique for this purpose is proposed.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. P.M. Aoki, Recycling Secondary Index Structures, Sequoia 2000 Tech. Rep. 95/66, Univ. of California, Berkeley, CA, July 1995.

    Google Scholar 

  2. J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques, Morgan Kaufmann Publishers, Palo Alto, CA, 1993.

    MATH  Google Scholar 

  3. J. Gray, ed., The Benchmark Handbook for Database and Transaction Processing Systems, Morgan Kaufmann Publishers, Palo Alto, CA, 1993.

    MATH  Google Scholar 

  4. C. Mohan and I. Narang, Algorithms for creating indexes for very large tables without quiescing updates, Proc. 1992 ACM SIGMOD Conf., San Diego, California, pp. 361–370, 1992.

    Google Scholar 

  5. G.H. Sockut, T.A. Beavin, and C.C. Chang, A method for on-line reorganization of a database, IBM Systems Journal, vol. 36, no. 3, pp. 411–436, 1997.

    Article  Google Scholar 

  6. M. Stonebraker and G. Kemnitz, The POSTGRES next-generation database management system, Comm. of the ACM, vol. 34, no. 10, pp. 78–92, 1991.

    Article  Google Scholar 

  7. M. Stonebraker, P.M. Aoki, R. Devine, W. Litwin, and M. Olson, Mariposa: a new architecture for distributed data, Proc. 10th IEEE Int. Conf. on Data Eng., Houston, TX, pp. 54–65, 1994.

    Google Scholar 

  8. J. Troisi, NonStop availability and database configuration operations, Tandem Systems Review, vol. 10, no. 3, pp. 18–23, July 1994.

    Google Scholar 

  9. DB2 Parallel Edition V1.2 Parallel Technology, IBM Corp., Apr. 1997.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Software and Information Science, Iwate Prefectural University, 152-52 Sugo, Takizawa, Iwate, 020-0193, Japan

    Jiahong Wang & Masatoshi Miyazaki

  2. Institute of Information Sciences and Electronics, University of Tsukuba, Tsukuba Science City, Ibaraki, 305-8573, Japan

    Jie Li

Authors
  1. Jiahong Wang
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Masatoshi Miyazaki
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Jie Li
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Computer Engineering Department, Dokuz Eylul University, Bornova, 35100, Izmir, Turkey

    Tatyana Yakhno

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Wang, J., Miyazaki, M., Li, J. (2000). A Technique for Upgrading Database Machines Online. In: Yakhno, T. (eds) Advances in Information Systems. ADVIS 2000. Lecture Notes in Computer Science, vol 1909. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-40888-6_8

Download citation

  • DOI: https://doi.org/10.1007/3-540-40888-6_8

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-41184-0

  • Online ISBN: 978-3-540-40888-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation