A DBMS defines what’s called thedata schema,or the structure in which the data is stored.

Relational database management systems(RDBMS) implement the relational model of tables and relationships.

Examples of DBMSs

Choosing which database you need is a complex task.

Database development

Stefan Matei Lungu / Getty Images

For small organizations or home use, popular DBMSs are Microsoft Access and FileMaker Pro.

More recently, other non-relational DBMSs have grown in popularity.

These options are useful for storing and working with very large datasets comprising a wide range of data types.

Major players in this space include MongoDB, Cassandra, HBase, Redis, and CouchDB.

Individual pieces of data were connected only between parent and child records.

DBMSs also control access to the database through authorization, implemented at various levels.

Most DBMSs use the Structured Query Language, which provides a scripted method to interact with the database.