Databases in Applications

• Relational Databases:
  • Data is represent in the form of Tables (Rows & Columns)
  • There can be relations between tables
  • Most of the applications still use Relational Databases
  • To Create, Retrieve, Update and Delete (CRUD) we have a SQL (Structured Query Language)
  • Popular Relational Database Management Systems (RDMBS)
    • Oracle
    • Microsoft SQL Server
    • mySql
    • PostgreSQL
• No SQL Database:
  • This is type of Database which allows for storing wide variety of datasets
  • This came into existense when the demand for modern applications increased.
  • NoSQL Databases can further be divided into following categories
    • Key-Value Storage
    • Document Oriented Databases
    • Graph Databases
  • Examples:
    • Mongo DB
    • Cassandra
    • Gremlin
    • Couchbase
• Cache Databases: These are kind of databases which cache infrequently changed data into RAM for faster application Performances
  • Examples:
    • Redis
    • Memcached

Typical Process Involved for Working With Databases

• To configure the database, we need to choose the right server (Physical or VM)
• Install Operating System
• Install Database Management System
• Ensure Networking is correctly configured
• Then allow connectivity from which generates data
• Other Activities
  • Configure Database Backup and Recovery
  • OS updates (patches)
  • DBMS update (patches)
  • Replication Setups
  • Query performance Tuning activities

Teaser into Cloud Databases

• We need to answer/select the following
  • What is the Database Engine which you want?
  • What is size of the Databases in terms of Storage & CPU & Memory?
• Cloud Service Provider in the case of Cloud can do the following
  • Install & Patch Operating Systems
  • Install & Patch Datbase Management System
  • Execute Replications as configured by user
  • For Some Databases Query Tuning activities can also be done
  • Show all the detailed reports or monitor the databases
  • Give easier options for Backup & Recovery
• Cloud Service Consumer should
  • Select the Backup Plan
  • Select the Replication Options
  • For some database Tuning is still done by consumer