07 September 2009

Database System Utilities

  • Loading : A loading utility is used to load existing data files-such as text files or sequential files-into the database. Usually, the current (source) format of the data file and the desired (target) database file structure are specified to the utility, which then automatically reformats the data and stores it in the database. With the proliferation of DBMSs, transferring data from one DBMS to another is becoming common in many organizations. Some vendors are offering products that generate the appropriate loading programs, given the existing source and target database storage descriptions (internal schemas). Such tools are also called conversion tools.
  • Backup: A backup utility creates a backup copy of the database, usually by dumping the entire database onto tape. The backup copy can be used to restore the database in case of catastrophic failure. Incremental backups are also often used, where only changes since the previous backup are recorded. Incremental backup is more complex but saves space.
  • File Reorganization: This utility can be used to reorganize a database file into a different file organization to improve performance.
  • Performance Monitoring: Such a utility monitors database usage and provides statistics to the DBA. The DBA uses the statistics in making decisions such as whether or not to reorganize files to improve performance.

2 comments:

  1. site does not dispay propery on desktop.does not make use of complete screen

    ReplyDelete
  2. Anonymous19 May, 2018

    Latest Technology Information The website Provide Database Management System includes, Besides Theoretical Portion, Complete Articles on SQL and MS Access so that the readers may get a practical knowledge of databases.


    https://itused.net/

    ReplyDelete