Downloaded 16 times
Uploaded byDinesh Kumar
Database system utilities by dinesh
Database system utilities provide tools to load, backup, and reorganize database files. Loading utilities import data from external files into the database, specifying the source and target formats. Backup utilities create copies of the entire database, usually onto tape, which can restore the database in case of failure. Incremental backups record only changes since the previous backup. Performance monitoring utilities provide statistics to help the DBA optimize file organization and performance.
Database system utilities by dinesh
- 1.
- 2. Loading : - Aloading 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.
- 3. Backup:- A backup utilitycreates 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.
- 4. File Reorganization: This utilitycan 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.
- 5. TOOLS, APPLICATION ENVIRONMENTS, AND COMMUNICATIONSFACILITIES CASE tools Used in the design phase Expanded Data Dictionary(information repository) Stores catalog information about schemas and constraints Stores other information such as design decisions, usage standards, application program descriptions, and user information Application Development Environments Provide an environment for developing database applications Include facilities for database design, GUI development, querying and updating, and application program development Communications software Allow users to access database from remote location 5