Databases

Database Management Systems

Gerald Senarclens de Grancy

Database

A database is an organized collection of data stored and accessed electronically.

Database Management System (DBMS)

Software that interacts with end users, applications, and the database itself to capture and analyze data.

Encompasses the core facilities provided to administer the database.

Provides a database engine to create, read, update and delete (CRUD) data from a database.

Classification

Relational DBMS (RDBMS)
Model data as rows and columns in a series of tables
Use the structured query language (SQL)
NoSQL
Key-value store, object database, document store, graph database, ...

Relational Database Management Systems (RDBMS)

The most prominent examples include

SQLite is a library that implements a SQL database engine. It is the most used database engine in the world.

Relation

SQL relations are represented by tables

column (attribute) column (attribute) column (attribute)
field field field row / record (tuple)
field field field row / record (tuple)
field field field row / record (tuple)

Questions
and feedback...