Explain the utilities which help the DBA to manage the database?

Every DBA uses database utilities to maintain and control their databases. But there is a lot of confusion within the field as to what, exactly, is a database utility. There are a many of definitions floating around out there. DBAs constantly refer to utilities, tools, solutions, and suites.

So, first of all, let's be clear on what a utility is and what is a "tool" or "solution." A utility is generally a single reason program for moving and/or verifying database pages; examples involves LOAD, CHECK, REORG, UNLOAD, COPY, and RECOVER. A database tool is a multi-functioned program designed to simplify database monitoring, management, and/or administrative tasks. A solution is a synergistic group of tools and utilities designed to work together to address a customer's business issue. A suite is a group of tools which are sold together, but are not necessarily integrated to work along with each other in any way. Of course, these are only my definitions. But there are meaningful definitions which creates it easier to discuss DBA products and programs

Posted Date: 5/10/2013 6:27:03 AM | Location : United States

Ask an Expert

Related Discussions:- Explain the utilities which help the dba to manage database, Assignment Help, Ask Question on Explain the utilities which help the dba to manage database, Get Answer, Expert's Help, Explain the utilities which help the dba to manage database Discussions

Write discussion on Explain the utilities which help the dba to manage database
Your posts are moderated

Write your message here..

Related Questions

Distributed and client server databases, Distributed And Client Server Data... Distributed And Client Server Databases Introduction This unit tells the distributed database systems which are primarily relational and one important execution model: the

What you understand by client-server environment, Problem: a) Briefly d... Problem: a) Briefly describe what you understand by Client-Server environment b) The File Server is a simple form of Client-Server. Describe the principles of the File Serve

Explain in details about the functions of dba, Explain in details about the... Explain in details about the f unctions of DBA ?

State about the tables- DBMS, State about the Tables- DBMS Data is sto... State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

Define the term database, QUESTION (a)(i) Define the term database. ... QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

Identification of concurrency, Identification of concurrency Identifica... Identification of concurrency Identification of concurrency: Dynamic model identifies concurrency. Two objects are said to be parallel (concurrent) if they can receive events a

The concurrent transactions, The Concurrent Transactions  Almost every ... The Concurrent Transactions  Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make

What is a block and a block number, What is a block and a block number? ... What is a block and a block number? A block is a contiguous sequence of sectors from a single track of one platter. Every request specifies the address on the disk to be refere

Durability-transaction , Durability : This property necessitates that once ... Durability : This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a bas

Computer, 1. Will you advise that your organization uses open source softwa... 1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development