Database Platform Flashcards
What are the featured to consider in Database Platform?
- Scalability
- Security
- Performance Optimization
- Backup and Recovery
Types of Database Platforms
Relational DBMS, NoSQL Database, Cloud Database, In Memory Database
Structured data in tables
Relational DBMS
Data stored in RAM for speed
In Memory database
What are the Core Components of Database Platform?
- Database engine
- Query processor
- Storage System
- Metadata catalog
A system/framework for creating, managing and interacting with databases.
Database Platform
For unstructured/ semi - structured data
No SQL Database
What are the popular platform of NoSQL Database?
MongoDB, Cassandra
What are the popular platform of Cloud Database?
Amazon Aurora, Firebase Realtime Database
What are the popular platform of Relational DBMS?
- MySQL, PostgreSQL
Managed in the cloud
Cloud Database
Types of NoSQL Database
- Document Stores (MongoDB)
- Key Value (Redis)
- Column Family (Cassandra)
- Graph Database (Neo4j)
What type of Database Platform that use SQL?
Relational DBMS
Use cases of Database Platform
- E commerce
- Healthcare
- Social Media
- Financial Services
- IoT
What are the key functions of database platform?
- store, retrieve, update data
- Maintain data integrity and security
- Enable multi-access user
