A database is a technology by which we keep and access data in an organized way. There are many database models used by the modern architect. Based on the needs and usage we choose the database model in the system. Mainly we work with the following DB models-

  • Relational Model
  • Flat file Model
  • Big Data
  • In-memory Model
  • Graph DB

Relational Database

This is most popular and is robustly used in the industry. The relational model works very well when data volume is not very big. We have vast experience in RDBMS and we have used the following DB in various application-

  • PostgreSQL:
  • MySQL:
  • MS SQL:
  • Aurora DB:
  • Oracle DB:

Flat file Database/ NoSQL Database

A flat file database stores data in the form of a flat file, which can either be a plain text file or a binary file. Unlike relational databases, a flat file database doesn’t support data storage on multiple tables. Flatfile/NoSQL becomes efficient when the data volume is huge. Normally we use the following NoSQL DB

  • MongoDB.
  • Cassandra
  • Couchbase

Big Data

Relational database engines can only accept data to a limit. There are some unstructured, often time-sensitive data which could not be processed by using the relational databases. Organizations which generate and process a large volume of data needs Big data for reliable and fast data processing. Bigdata is a great opportunity for those organizations who are using Mainframe infrastructure to maintain their large volume of data. Bigdata implementation and data migration can cut their technology cost drastically. Normally we use the following Bigdata technology-

  • Hadoop
  • Hive
  • MapReduce
  • ElasticSearch / Solr
  • Spark
  • Data Lakes

In-Memory Database

In-memory database technology(IMDB) database technology stores data in RAM, the main memory of the computer. It negates the dependency on an external hard disk for the accessing data. Thus, an in-memory database is characterized by simplicity and swift performance. Many databases support the in-memory concept. Some renowned in-memory databases are as follows:

  • Redis
  • Apache Geode
  • Apache Ignite
  • SQLite

Get a Quotation