Database Needs for an Enterprise
- Every application needs some kind of database to store the data and querying the data.
- Lets try to understand different kinds of database needs for an Enterprise
- Relational Databases:
- Store the data in tabular format (columns, rows/records)
- To query the data we would have SQL
- RDBMS:
- Oracle
- mySQL/Maria db
- Microsoft SQL Server
- PostgreSQL
- DB2
- Data Warehouses:
- This is type of data management system designed to enable & support BI and Analytics.
- Data Warehouses are intended to perform queries and analysis that often contain large amounts of data
- Examples:
- Teradata
- DB2 warehouse
- Exadata
- SAP HANA
- Cache Databases
- A database cache supplements your primary database by removing unnecessary pressure on it, typicall in the form of frequently accessed read data. The cached data itself can live in RAM
- Examples:
- Memcached
- Redis
- A database cache supplements your primary database by removing unnecessary pressure on it, typicall in the form of frequently accessed read data. The cached data itself can live in RAM
- Key-Value Stores:
- This is type of nonrelational database that uses simple key-value method to store data
- Examples:
- Couchbase
- Hbase
- Redis
- Cassandra
- Document Databases
- This is non relational db i.e desinged to store and query data as JSON-like documents
- Examples:
- Mongo DB
- Couchbase
- CouchDB
- Apache Drill
- MarkLogic
- Graph Databases:
- This is designed to treat relationships between data as equally important to data itself
- Examples
- neo4j
- Dgraph
- Apache Giraph
- Bitsy
- Time Series Database:
- This is a database optimized for time-stamped data.
- Time series data are measurements & event tracked or monitored
- Examples:
- Influx
- Graphite
- Druid
- Ledger (Block Chain)
- Examples:
- Ethereum
- Hyperledger
- Examples:
- Relational Databases:
Support on AWS
| Database Type | AWS Service |
|---|---|
| Relational | Amazon RDS, Amazon Aurora |
| Data warehouse | Amazon Redshift |
| key-value | Amazon Dynamo DB |
| In-memory | Amazon Elastic Cache, Amazon Memory Db for Redis |
| Document | Amazon Document DB |
| Graph | Amazon Neptune |
| Time Series | Amazon Timestream |
| Ledger | Amazon Ledger Database Service (QLDB) |
Approach in AWS
- In an enterprise as shown below all the activities have to done and managed by you
- In AWS, we get database as a service i.e.
- We dont need to install database on some server
- Backups can be schedule and aws will take backups for you
- There are some solutions where even automatic failover is done/managed by AWS
- Replicating/sync between two databases is managed by AWS
Exercise:
- AWS Free tier Account Creation Refer Here
- Necessary Software Installation Refer Here
- For Windows 10 and above configure Windows Terminal Refer Here
