Databases
- Database offers a structured approach for
- storing and retrieving data
- user management
- connection management
- Databases are of different types
- Relational Databases
- NOSQL Databases
- Key value stores
- Document Databases
- Column Databases
- Graph Databases
- Blockchain Ledger
- Cache Servers
- Data Warehouses
Relational databases
- data is organized in tables as rows and columns
- Each row represents a record
- Tables will have relations between them
- To interact with database there will be a formal language based on standard SQL
- Examples:
- SQL Server
- Oracle
- PostgreSQL
- mySQL
- DB2
- To bringup the database on the server,
- Install the Database engine (Server side of DBMS)
- configure the users
- any other additional configurations if required
- On the clients
- install database client software for users
- install database client libraries for applications
- Once the server is up, we will have administrative activities
- adding more users
- Backup the databases
- Configuring Replications (Readonly, Write supported)
- Performance Tuning
- Patching:
- IN the self hosted (on-premise) we have to perform all the activities mentioned above.
- Public Cloud platforms offer Database as a Service, i.e. i directly get the pre installed databse and
- Backup is a single click
- Replications is a single click
- Patching is automated, we need to give time frame
- Performance Tuning is partially automated.
- Offerings by AWS
- mysql (mariadb)
- postgres
- sql server
- oracle
- DB2
- Aurora (mysql and Postgres)
- Offering by Azure
- Microsoft SQL Server
- mysql (mariadb)
- postgres
Azure Database offerings
AWS Database Offerings
Practical Difference
- We have setup a mysql database on a linux machine
- we had to install database
- create users
- grant permissions
- Administrative activities are still our problem
- We have setup mysql db as service
- We had set paramters, database was up
- connected and started using
- Most of administrative activities are available at easy one click
