Introduction of DBMS
Sunny Bhaskar
10/31/20241 min read
A database is an organized collection of structured information or data, stored electronically, usually in a computer system. Databases allow for efficient storage, retrieval, modification, and management of data.
Key Points about Databases
Organized: Data is arranged in a structured format, often in tables (like rows and columns in a spreadsheet).
Persistent: Data is saved and remains available until deleted or modified.
Efficient Management: Databases provide tools to efficiently add, update, delete, and search data.
Controlled Access: They ensure data security, allowing access only to authorized users.
Types of Databases
1.Relational Databases (e.g., MySQL, PostgreSQL) — Use tables and relationships between tables.
2.NoSQL Databases (e.g., MongoDB, Cassandra) — Use non-tabular structures, like documents or key-value pairs.
3.In-Memory Databases (e.g., Redis) — Store data in memory for fast access.
4. Distributed Databases — Data is spread across multiple locations or servers for scalability.
Example
A library database might store data about books, authors, and borrowers, allowing library staff to manage book checkouts, returns, and borrower information efficiently.