Database Reference
In-Depth Information
21.6 Database Removal
Sometimes, it becomes necessary to remove a database. Often, there is no specific
command for this, for obvious reasons: The database exists under the auspices of the host
operating system. Database removal is therefore an operating system command.
Depending on the DBMS being used, database removal may be a trivial matter, or
one requiring a few steps. For instance, removal of a Delphi or MySQL database involves
a single step. On the other hand, removing an Oracle database involves several steps
of deleting related folders/directories managed by the DBMS in collaboration with the
underlying operating system. These folders/directories were created when the database
was created (or altered).
Once a database has been deleted, it is completely gone, and can only be
reintroduced via a recovery operation.
21.7 Summary and Concluding Remarks
Here is a summary of what has been discussed in this chapter:
Depending on the DBMS being used, database creation may be
complex or simple. Delphi and Oracle are at the two extreme ends
of the spectrum — database creation is very simple in Delphi, and
very complex in Oracle.
Database security must ideally be multi-tiered. It must address
access to the system, access to the system resources, and access
to data.
Database management must continue after database creation. It
must address issues relating to the performance of the database
system in the face of growing data collection and changing user
needs. Database tuning is and integral part of this.
Backup must be carefully planned and methodically
implemented, in order to minimize or eliminate data loss due to
system failures. The recovery procedures must also be reviewed
as required.
Like database creation, depending on the DBMS used, database
removal may be trivial or complex.
21.8 Review Questions
1.
What are the main issues to be considered when creating a
database?
2.
What are the critical issues to be addressed when configuring
the security mechanism of a database?
 
Search WWH ::




Custom Search