Core Functions
Data Storage and Retrieval
Efficiently storing data and providing fast access through queries.
Data Security
Protecting data against unauthorized access, breaches, or corruption using encryption, user roles, and access controls.
Data Integrity
Ensuring accuracy and consistency using constraints like primary keys, foreign keys, and validation rules.
Backup and Recovery
Protecting data by creating backups and enabling recovery in case of system failures or data loss.
Performance Optimization
Managing indexes, queries, and database configurations to improve performance.
Key Database Management Systems (DBMS)
Relational Databases (RDBMS)
Use structured query language (SQL) for data management. Examples:
Oracle
Microsoft SQL Server
MySQL
PostgreSQL
NoSQL Databases
Designed for unstructured or semi-structured data. Examples:
MongoDB
Cassandra
Redis
DynamoDB
Cloud Databases
Hosted on cloud platforms for scalability and availability. Examples:
AWS RDS
Google Cloud SQL
Azure SQL Database
