Load - unload utilities, Database Management System

These permit the user to unload a database or parts of a database and reload the data on the similar machine, or on another machine in a dissimilar location. This can be useful in many situations, such as for creating backup copies of a database at a definite point in time, or for loading data into a latest version of the database or into an entirely dissimilar database. These load/unload utilities may also be used for reorganizing the data in the database to improve performance, such as clustering data together in a exacting way or reclaiming space occupied by data that has become obsolete.

Reporting/Analysis Utilities:

These are used to report and analyse on the data contained in the database. This may have computing values from data, analysing trends in data or displaying data that meets some particular criteria, and then printing or displaying a report having this information.

Posted Date: 3/6/2013 5:06:55 AM | Location : United States







Related Discussions:- Load - unload utilities, Assignment Help, Ask Question on Load - unload utilities, Get Answer, Expert's Help, Load - unload utilities Discussions

Write discussion on Load - unload utilities
Your posts are moderated
Related Questions
MySQL Database Merge Project Description: I have two databases, I need merge the data of one database into another Work to be done online right now. Payment can be done

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key att

What are the several forms of identity? a) Value b) Name c) Built-in

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

Define Signal. It allows methods to respond to events triggered by themselves or by other processes. Each signal corresponds to an exacting event. A signal is represented in Sy

The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No o

What is Log Shipping? Log shipping is the method of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a stand

Describe Interfaces for the DBA? Interfaces for the DBA - Most database systems holds privileged commands which could be used only through the DBA's staff. These involves com