Explain the utilities which help the dba to manage database, Database Management System

Assignment Help:

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


Related Discussions:- Explain the utilities which help the dba to manage database

Define the third normal form, Define the Third Normal Form: The third ...

Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

Software engineering, Critically evaluate the bulleted list of information-...

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

What was the method in which records are physically stored, What was the me...

What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within

Online Bakery Data Base Project, How much would you charge to create a data...

How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should

Explain the dynamic hashing techniques, Explain the Dynamic Hashing Techniq...

Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica

Copy data from one database to another database, Copy Data from One Databas...

Copy Data from One Database to another Database Project Description: I am having two MySQL databases with same tables. I just need to copy one Data from one to another dat

Describe the benefits of OOD techniques, Describe the benefits of OOD techn...

Describe the benefits of OOD techniques OOD techniques are very useful for development of large and complex systems. It has been noted that large projects that are developed u

Stock market, need requirement analysis for database management of stock ma...

need requirement analysis for database management of stock market

Give an example of object representation, Give an example of Object Represe...

Give an example of Object Representation  For illustration, consider the implementation of a social security number within an employee object that is shown in Figure. The soci

Explain the reason for keeping legacy system, In order to keep pace with co...

In order to keep pace with competitors, Space Ltd has decided to implement an ERP system in order to replace its old legacy and manual systems. Management does not have much knowle

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd