Database, Data Warehouse, Data Mart, Data Lake, Data Lakehouse, Data Fabric, Data Mesh
"Data is just collection of facts"
"Data is just collection of facts"
Database.
Data Warehouse.
Data Mart.
Data Lake.
Data Lakehouse.
Data Fabric.
Data Mesh.
Structured Data.
Unstructured Data: Email, Documents, Video, Images.
Semi-structured Data: CSV, Json documents.
Quantitative Data (định lượng).
Countable.
Structured.
Qualitative Data (định tính).
Attribute.
Unstructured.
A database is used to store, search and report on structured data from a single source. They are the simplest to create and SQL can be used to query and report on the data. There are both open source and proprietary databases, making it widely accessible to install and start using on-premise or on the cloud.
A data warehouse is used to store large amounts of structured data from multiple sources in a centralized place. Organizations invest in building data warehouses because of its ability to deliver business insights from across the company, and quickly.
Properties:
Subject-oriented.
Integrated.
Time variant.
Non-volatile.
A data lake stores structured, semi-structured and unstructured data, supporting the ability to store raw data from all sources without the need to process or transform it at that time.