Database vs Data Warehouse vs Data Lake..!

So all of us have heard about databases and data warehouses but I never actually used a data lake. So in this article I will try and describe all 3 of these and how they connect with one another. I will also try to walk you through the differences between them.

What is a Database

This is the smaller unit for storing data.

Types and examples of databases

• Relational databases: Oracle, MySQL, Microsoft SQL Server, and PostgreSQL
• Document databases: MongoDB and CouchDB
• Key-value databases: Redis and DynamoDB
• Wide-column stores: Cassandra and HBase
• Graph databases: Neo4j and Amazon Neptune

Most common databases are relational databases like SQL etc designed to store transactional data or OLTP data. This data is usually transactional involving insert, update and delete operations.

Since most of use know about databases, i will not go into detail about a database.

What is a Data Warehouse

Its a process of collecting data from a myriad of sources and then providing business insights on this data.The data warehouse is the core of the Business Intelligence system which is…