🗄️Database

NEW

Also known as: DB

An organized collection of data stored electronically to enable efficient storage, retrieval, and management.

DESCRIPTION

A database is a structured repository that supports reliable data storage, retrieval, and update operations. Relational databases use tables, schemas, and SQL, typically enforcing ACID transactions. NoSQL databases optimize for scale, flexibility, or specific access patterns like key-value, document, graph, or columnar stores. Core functions include indexing, concurrency control, backup/recovery, and security. Databases underpin OLTP workloads and serve as sources for analytics. Design considerations include normalization, denormalization, partitioning, and replication. Deployment spans on-premises, cloud-managed services, and embedded environments. Performance depends on schema design, query optimization, and hardware. Governance ensures data integrity, access control, and compliance. Databases remain foundational to applications and data platforms.

ALTERNATIVE DEFINITIONS

Wikipedia

A database is an organized collection of data, generally stored and accessed electronically from a computer system.

Highlights organization and electronic storage/access, broadly applicable across types.

Source

Oracle

A database is an organized collection of structured information, or data, typically stored electronically in a computer system.

Emphasizes structured information and electronic storage, from a vendor perspective.

Source

IBM

A database is an organized collection of data that can be easily accessed, managed and updated.

Focuses on manageability and updatability in operational use.

Source

RELATED TERMS

Relational Database NoSQL SQL ACID Online Transaction Processing Index Data Schema Transaction Query Optimizer

COMPETING TERMS

Data Lake Data Warehouse

RELATIONS

• Narrower: American Medical Association’s Prescriber Database Columnar Database Distributed Database Document Database Graph Database NewSQL Database NoSQL Database Normalization (Database) Oracle Database Relational Database Time Series Database Vector Database

KNOWLEDGE AREAS

Data Storage & Operations Data Architecture Data Management Software Engineering Data Warehousing & BI

TARGET AUDIENCE

Data Engineer Data Architect Cloud Architect Software Developer BI Specialist Data Modeler

EXTERNAL SOURCES

• Wikipedia - Database
• PostgreSQL - Open-source RDBMS documentation
• Microsoft - Relational database architecture overview
• AWS - Managed relational database service

TOP QUESTIONS

What distinguishes a relational Database from NoSQL?

Relational databases use fixed schemas and SQL with ACID guarantees. NoSQL prioritizes flexibility or scale with models like key-value, document, graph, or column families.

Category: Misunderstanding

Why are indexes important in a Database?

Indexes accelerate queries by avoiding full scans, at the cost of extra storage and write overhead. Properly designed indexes can dramatically reduce response times.

Category: Example

How do transactions work in a Database?

Transactions group operations into atomic units with ACID properties, ensuring consistency and durability even amid failures or concurrent access.

Category: Requirements

What are common Database performance pitfalls?

Unindexed predicates, N+1 queries, poorly designed schemas, and missing statistics are frequent issues. Monitoring and query plans reveal bottlenecks.

Category: Mistakes

Should I choose a Database or a Data Lake?

Choose a database for transactional workloads or consistent schemas; pick a data lake for raw, diverse data and advanced analytics. Lakehouses blend both.

Category: Opinion

How is a Database secured?

Use strong authentication, least-privilege authorization, encryption at rest/in transit, auditing, and patching. Network segmentation and secrets management help minimize risk.

Category: Risk

What is sharding in Databases?

Sharding partitions data across nodes to scale throughput and storage. It improves performance but adds complexity in consistency and query routing.

Category: Example

When should denormalization be used in a Database?

Denormalization can improve read performance and simplify queries in analytics or read-heavy apps, at the expense of redundancy and complex writes.

Category: Opinion

How do backups and recovery work for Databases?

Backups capture data and sometimes logs for point-in-time recovery. Regular testing of restores is essential to meet RPO/RTO objectives.

Category: Management