Database Design Phase 3: Implementation

The implementation phase is where you install the DBMS on the required hardware, optimize the database to run best on that hardware and software platform, and create the database and load the data. The initial data could be either new data captured directly or existing data imported from a MariaDB database or another DBMS. You also establish database security in this phase and give the various users that you've identified access applicable to their requirements. Finally, you also initiate backup plans in this phase.

The following are steps in the implementation phase:

  1. Install the DBMS.
  2. Tune the setup variables according to the hardware, software and usage conditions.
  3. Create the database and tables.
  4. Load the data.
  5. Set up the users and security.
  6. Implement the backup regime.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.