Difference between Database Administrator and Database Architect
Database administrator is responsible for ensuring that the logical data model is transformed into an efficient physical database design. According to Mullins (2002), the database administrator incorporates knowledge of database management systems in the design. Additionally, the database administrator acts as a link of communication between the data administrator and technicians and application programming staff (Mullins, 2002). A database architect is involved in the new design of databases and development of existing applications only. This implies that a database architect does not do any administrative work (Mullins, 2002).
The database administrator performs a role of an overseer in ensuring existing applications are running properly, whereas the database architect designs new applications.
Advantages and Disadvantages of DBMS
Storage of related data together enables the enforcement of data integration with minimal programming in the application programs. Data sharing is easily enabled due to storage of related data in one location. DBMS involves a structured and organized manner of storing data hence facilitating the enforcement of standards as concerns efficient database management. This also means it is easier to implement better controls.
Database Recovery Process
The database process will involve determination of the type and extent of the recovery required. This will imply that if the entire database is to be recovered, the most recent backup copy of the database will be used. The backup copy will be used to restore all transactions by utilizing the transaction log information.
Features of Distributed DBMS
Distributed DBMS utilizes several databases with each database running separately. This means relating data over interconnected computer systems. This promotes processor independence while enabling faster data access and processing. The risk of single point failure is also largely reduced. The main features of this DBMS are I/O interface, query optimization, concurrency control, and security of data.
Coronel, C., Morris, S. and Rob, P. (2012). Database Systems: Design, Implementation and
Management. Boston: Cengage Learning.
Mullins, C. (2002). Database administration: the complete guide to practices and procedures.