DATABASE SYSTEM¶

COURSES¶

CMU 15-445: Database Systems¶

UCB CS186: Introduction to Database System¶

BASICS¶

WHAT IS A DATABASE?¶

A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques.

HOW MANY TYPES OF DATABASES ARE THERE?¶

There are several types of databases, but the most common are relational databases, NoSQL databases, graph databases, time-series databases, etc.

TYPICAL DATABASE SYSTEMS¶

RELATIONAL DATABASE MANAGEMENT SYSTEMS (RDBMS)¶

• MySQL
• PostgreSQL
• SQLite
• Oracle
• Microsoft SQL Server
• IBM DB2

NOSQL DATABASES¶

• MongoDB
• CouchDB
• Cassandra
• Redis
• HBase

GRAPH DATABASES¶

• Neo4j
• Amazon Neptune
• ArangoDB
• OrientDB

TIME-SERIES DATABASES¶

• InfluxDB
• TimescaleDB
• Kdb+
• OpenTSDB
• Prometheus
• Graphite