Ir al contenido principal

Components of a Database environment

  1. Users. Obviously, why would we want a DB if we don't have users?
  2. DBMS (Database Management System, such Microsoft Access). That includes
    • DDL (Data Definition Language). Which creates and modifies the logical structure of the DB (objects).
    • DML (Data Manipulation Language). It's used to manipulate and process data (retrieve, update, add) of the DB. I.e.: SQL.
  3. DBA (Database Administrator). It has two main functions:
    • Plans, designs, implements and do maintenance and protection functions for the DB
    • Defines data dictionary, which means that defines the meaning of data and describes interrelations between data items.
  4. DB itself. Finally we have the Database, which has its physical format and it's a collection of data.

Comentarios