Background Info
Database Implementation: is the process of installing a Database Management System (DBMS) on a required hardware, creating the database, importing the data, setting administrative privileges, and establishing a backup plan.
Database Management (or Database Administration): are the activities that ensure continued availability of a database for other users, throughout the life cycle of data, and includes:
- Optimizing query performance
- Testing and debugging
- Updating database
- Integrating database with applications
- Training users
Why is this important?
Proper implementation and management of databases:
- Protects the integrity of the database
- Makes database continuously available to key stakeholders, and end users
- Prevents disrupts of work that is dependent on database
Resources
Database Implementation
Database Implementation: is the step that occurs after the logical database design process. The aim of database implementation is to create the database, and tables outlined in the design step, and to:
- Decide on the relational database management system
- Organize database project
- Identify the data source
- Establish the data migration strategy