NoSQL databases are non-relational databases that offer flexibility in data modeling, scalability, and high performance. They do not require a fixed schema, support various data models, and are designed for distributed environments. NoSQL databases are well-suited for applications with dynamic data structures and high data volumes.
Amazon RDS is a web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.
- Database Types Covered:
- Amazon RDS (Relational Database Service) - stores structured data
- DynamoDB (NoSQL Database) - stores semi-structured data
- Data Types:
- Structured data: Fits neatly in rows and columns (e.g., excel sheets)
- Unstructured data: Lacks a defined format (e.g., text, images)
- Semi-structured data: Has some organization but not as rigid as structured data (e.g., JSON)
- Database Management:
- On-premises databases: Complex and time-consuming to manage
- Cloud databases (like Amazon RDS): Easier to manage with features like automated backups and patching
- Benefits of Cloud Databases (Amazon RDS example):
- Reduced administrative burden
- Automatic tasks: provisioning, setup, patching, backups, etc.
- Benefits of DynamoDB (NoSQL Database):
- Efficient storage for semi-structured data
- Fully managed service: No need to worry about hardware, setup, configuration, scaling, etc.