databasemanagement
Database management is the administration of database systems to store, organize, secure, retrieve, and maintain data. It encompasses the use of database management systems (DBMS) and related tools, processes, and policies to ensure data availability, integrity, and security.
A DBMS provides a structured interface for creating, querying, updating, and administering databases. Data is stored
Data models include relational (tables, rows, columns), document, key-value, columnar, and graph. Most traditional systems are
Core operations involve defining data structures, manipulating data (create, read, update, delete), and querying data using
Design and integrity focus on normalization to reduce redundancy, indexing to speed queries, constraints to enforce
Concurrency and performance cover concurrency control, locking, multi-version concurrency control (MVCC), query optimization, and caching.
Security and recovery address authentication, authorization, encryption, auditing, backups, and disaster recovery planning.
Deployment and scalability discuss on-premises and cloud-based DBaaS options, replication for availability, and techniques like sharding
Roles and governance describe the responsibilities of a database administrator (DBA) who manages systems, and broader
Examples of widely used DBMS include Oracle, MySQL, PostgreSQL, Microsoft SQL Server, MongoDB, Cassandra, and Redis.