Skip to main content
SpringerLink
Log in
Book cover

Encyclopedia of Database Systems pp 1–2Cite as

Administration Wizards

  • Living reference work entry
  • First Online:

  • 143 Accesses

Definition

Modern database systems provide a collection of utilities and programs to assist a database administrator with tasks such as database installation and configuration, import/export, indexing (index wizards are covered in the self-management entry), and backup/restore.

Historical Background

Database Administrators have been skeptical of any form of automation as long as they could control the performance and security of a relatively straightforward installation. The advent of enterprise data management towards the end of the 1990s, where few administrators became responsible for many, possibly diverse database servers, has led to the use of graphical automation tools. In the mid-1990s, third party vendors introduced such tools. With SQL Server 6.5, Microsoft was the first constructor to provide an administration wizard.

Foundations

Installation and Configuration

Database servers are configured using hundreds of parameters that control everything buffer size, file layout,...

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

Recommended Reading

  1. Bersinic D, Gile S. Portable DBA: SQL Server. New York: McGraw Hill; 2004.

    Google Scholar 

  2. Schumacher R. DBA tools today. DBMS Magazine, January 1997.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Copenhagen, Universitetsparken 1, 2100, Copenhagen, Denmark

    Philippe Bonnet

  2. Department of Computer Science, New York University, 251 Mercer Street, New York, NY, 10012, USA

    Dennis Shasha

Authors
  1. Philippe Bonnet
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Dennis Shasha
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding authors

Correspondence to Philippe Bonnet or Dennis Shasha .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, Georgia, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, Ontario, Canada

    M. Tamer Özsu

Section Editor information

  1. Dept. of Computer Science, Univ. of Copenhagen, Universitetsparken 1, 2100, Copenhagen, Denmark

    Philippe Bonnet

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media New York

About this entry

Cite this entry

Bonnet, P., Shasha, D. (2016). Administration Wizards. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_12-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_12-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics

Search

Navigation