Database
Database
A database is an organized collection of data stored and accessed electronically. Database management systems (DBMS) are software systems that interact with end users, applications, and the database itself to capture, store, and analyze data. Modern databases are often designed to support query languages such as SQL, which enable efficient retrieval and manipulation.
Databases range from small, single-file systems to large clusters distributed across multiple servers. They are fundamental to many computing applications, including web applications, enterprise software, and scientific computing.
History
The concept of organized data storage predates computers, with early examples such as library card catalogs. The first computerized databases emerged in the 1960s, using navigational models like the hierarchical database model (e.g., IBM's IMS) and the network model (e.g., CODASYL). The relational model, proposed by Edgar F. Codd in 1970, became the dominant paradigm, exemplified by systems such as Oracle Database, MySQL, and PostgreSQL.
In the 2000s, the rise of big data and web-scale applications led to the development of NoSQL databases, which offer flexible schemas and horizontal scalability (e.g., MongoDB, Cassandra, Redis). The 2010s saw further diversification with NewSQL databases aiming to combine relational integrity with NoSQL scalability, and cloud database services like Amazon Aurora and Google Cloud Spanner.
Features
Databases provide several key features:
- Data independence: Separation of logical and physical data organization.
- ACID properties (Atomicity, Consistency, Isolation, Durability) for transaction reliability, especially in relational databases.
- Concurrency control: Mechanisms such as locking or multiversion concurrency control (MVCC) to allow multiple users to access data simultaneously without corruption.
- Security: User authentication, authorization, encryption, and auditing.
- Query optimization: The DBMS chooses efficient execution plans for queries.
- Backup and recovery: Ensuring data durability after failures.
Database models vary: relational databases use tables with strict schemas, while NoSQL databases may use document, key-value, graph, or column-family structures.
Types of databases
- Relational databases (RDBMS): e.g., MySQL, PostgreSQL, SQL Server.
- NoSQL databases: e.g., MongoDB (document), Redis (key-value), Neo4j (graph), Cassandra (wide-column).
- In-memory databases: e.g., Redis, SAP HANA.
- Time-series databases: e.g., InfluxDB, TimescaleDB.
- Graph databases: e.g., Neo4j, Amazon Neptune.
Applications
Databases are used in virtually every sector: banking (transaction processing), healthcare (patient records), e-commerce (product catalogs), social media (user profiles and feeds), and scientific research (genomics, climate data). Distributed databases power global services like Google Search and Facebook.