Monday March 16, 2020
A data lake is a collection of raw data in the form of blobs or files. It acts as a single store for all the data in an enterprise that can include raw source data, pictorial representations, charts, processed data, and much more.
An advantage with the data lake is that it can contain different forms of data including structure data like a database including rows and columns, semi-structured data in the form of CSV, XML, JSON, etc.
It can also store unstructured data like PDF, emails, and word documents along with images, and videos.
It is a store of all the data and information in an enterprise. The concept of the data lake is catching up fast due to the growing needs of data storage and analysis in all the domains.
Let us learn more data lakes.
What is Data Lake?
We need to understand what a data mart First for the answer. Datamart can be considered as a repository of summarized data for easy understanding and analysis.
Pentaho CTO James Dixon was the person who first used the term As per him, a data mart is like packaged and cleaned drinking water that is ready for consumption.
The source of this drinking water is the lake. Hence the term data lake. A storehouse of information from where the data mart can interpret and filter out the data as needed.
What is the importance of the data lake?
it’s a huge storage of raw data. This data can be used in infinite ways to help people in varied positions and roles.
Data is information and power, that can be used to arrive at inferences and help in decision making too.
What is data ingestion?
Data Ingestion; what does it does? So well, it permits the connectors to source the data from various data sources and piles them up into the Lake.
What all does Data Ingestion supports?
It supports Structured, Semi-Structured, and Unstructured data. Batch, Real-Time, One-time load, and similar multiple ingestions. Databases, Webservers, Emails, IoT, FTP, and many such data sources.
What is Data Governance
Data governance is an important activity in a data lake that supports the management of availability, usability, integrity, and security of the organizational data.
Factors that are important in Data Lake
Security of data is a must, be it in any kind of data storage, so is true for the data lake. Every layer of the Data Lake should have proper security implemented. Though the main purpose of security is to bar unauthorized users, at the same time it should support various tools that permit you to access data with ease.
Some key features of data lake security are:
Data quality is another important activity that helps in ensuring that quality data is extracted for quality processes and insights.
Data Discovery is an activity of identifying connected data assets to make it easy and guide date consumers to discover it
Data Auditing includes two major tasks:
It helps in evaluating the risks and compliances.
Data linkage works on easing error corrections in data analytics
The beginning of data analysis is data exploration, where the main purpose is to recognize the correct dataset.
What are the maturity stages of a data lake?
Data Lake maturity Stages
There are different maturity stages of a data lake and their understanding might differ from person to person, but the basic essence remains the same.
Stage 1: in the very first stage the focus is on enhancing the capability of transforming and analyzing data based on business requirements. The businesses find appropriate tools based on their skill set to obtain more data and build analytical applications.
Stage 2: in stage two businesses combine the power of their enterprise data warehouse and the data lake. These both are used together.
Stage 3: in the third stage the motive is to extract as much data as they can. Both enterprise data warehouses and data lake work in unison and play their respective roles in business analytics.
Stage 4: Enterprise capability like Adoption of information lifecycle management capabilities, information governance, and Metadata management is added to the data lake. Only a few businesses reach this stage.
Here are some major areas where data lakes are most helpful:
Advantage of a data lake
In this section let us list out some of the obvious reasons and advantages of having a single repository of data that we call a data lake.
All data in a data lake is stored in its raw format and is never deleted. A data lake can typically scale several terabytes of data in the original form.
What’s the architecture of a Data lake?
The above image is a pictorial representation of the architecture of the data lake.
ingestion tier – Contains data source. Data is fed to the data lake in batches and that too in real-time
Insights tier – Located on the right side, is the insights of the system.
HDFS – Spcialy built a cost-effective system for structured and unstructured data.
Distillation – Data will be retrieved from storage and will be converted to structured data
Processing – User queries will be run through analytical algorithms to generate structured data
Unified operations – system management, data management, monitoring, workflow management, etc.
Differences between data lake, database, and data warehouse
In the simplest form data lake contains structured and unstructured data while both database and data warehouse except pre-processed data only. Here are some differences between all of them.
|Data Lake||Data Warehouse|
|Stores everything||Stores only business-related data|
|Lesser control||Better control|
|Can be structured, unstructured and semi-structured||In tabular form and structure|
|Can be a data source to EDW||Compliments EDW|
|Can be used in analytics for the betterment of business||Mainly used for data retrieval|
|Used by scientists||Used by business professionals|
Data Lake Implementation
Data Lake is a heterogeneous collection of data from various sources. There are two parts to any successful implementation of a data lake.
The first part is the source of data. Since the lakes take all forms of data, the source need not have any restriction. This can be the company’s production data to be monitored, emails, reports, and more.
Another zone that can be added to this implementation is the data warehouse or a curated data source. This will contain a set of structured data ready for analysis and derivations.
Best practices for Data Lake Implementation:
What are the Challenges of building a Data Lake:
Some of the common challenges of Data Lake are:
Risk of Using Data Lake:
Some of the risks of Data Lake are:
Example for Data Lake
Think about this scenario where unstructured data that you have can be used for endless purposes and insights. However, possession of data late doesn’t implicate that you can load all the unwanted data. You don’t need data swamp right? The collected data must have a log called a catalog. Having data catalogs makes the data lake much more effective.
Examples of Data Lake based system include,
and many more.
Also Read: Wish to know about data-driven testing?
What is Snowflake?
Snowflake is a combination of a data warehouse and a data lake, taking in the benefits of both.
It is a cloud-based data warehouse that can be used as a service. It can be used as a data lake to give your organization unlimited storage of multiple relational data types in a single system at very reasonable rates.
This is like a modern data lake with advanced features. Being a cloud-based service, the use of snowflakes is catching up fast.
Data Lake solution from AWS
Amazon is one of the leading cloud service providers globally. With the advent and extensive use of the data lakes, they have also come up with their own data lake solution that will automatically configure the core AWS services that will help to simplify tagging, searching and implementing algorithms.
This solution includes a simple user console from where one can easily pull the data and analysis that one needs with ease.
Below is a pictorial representation of the data lake solution from Amazon.
Some of the main components of this solution include the data lake console and CLI, AWS Lambda, Amazon S3, AWS Glue, Amazon DynamoDB, Amazon CloudWatch, Amazon Athena among others.
Amazon’s simple storage service or Amazon S3 is a web-based object storage service launched by Amazon in March 2006.
It enables organizations of all sizes to store and protect their data at a low cost. As shown in the diagram above, it is a part of the data lake solution provided.
It is designed to provide 99.999999999% durability and is being used by companies across the globe to store their data.
With the growing needs to data and the requirement to make it centrally available for storage and analysis, data lakes fit the bill for most companies.
Newer technologies like Hadoop and big data facilitate the storage and assimilation of huge amounts of data centrally.
There are still some challenges with respect to data lakes and they are likely to be overcome soon, making data lakes the one-stop solution for the data needs of every organization.