Database Management System

Types of DBMS

• Object-oriented
  • comparison
• Relational
  • list
  • comparison
• Key--value
• Column-oriented
  • list
• Document-oriented
• Wide-column store
• Graph
• NoSQL
• NewSQL
• In-memory
  • list
• Multi-model
  • comparison
• Cloud
• Blockchain-based database

Concepts

• Database
• ACID
• Armstrong's axioms
• Codd's 12 rules
• CAP theorem
• CRUD
• Null
• Candidate key
• Foreign key
• Superkey
• Surrogate key
• Unique key

Objects

• Relation
  • table
  • column
  • row
• View
• Transaction
• Transaction log
• Trigger
• Index
• Stored procedure
• Cursor
• Partition

Components

• Concurrency control
• Data dictionary
• JDBC
• XQJ
• ODBC
• Query language
• Query optimizer
• Query rewriting system
• Query plan

Functions

• Administration
• Query optimization
• Replication
• Sharding

Related topics

• Database models
• Database normalization
• Database storage
• Distributed database
• Federated database system
• Referential integrity
• Relational algebra
• Relational calculus
• Relational model
• Object--relational database
• Transaction processing

Resources

• https://en.wikipedia.org/wiki/Armstrong%27s_axioms
• https://en.wikipedia.org/wiki/Functional_dependency