Remove 2021 Remove Data Lake Remove Machine Learning Remove OLAP
article thumbnail

Data Modeling 301 for the cloud: data lake and NoSQL data modeling and design

erwin

For NoSQL, data lakes, and data lake houses—data modeling of both structured and unstructured data is somewhat novel and thorny. This blog is an introduction to some advanced NoSQL and data lake database design techniques (while avoiding common pitfalls) is noteworthy. Machine Learning.

article thumbnail

Data Modeling 201 for the cloud: designing databases for data warehouses

erwin

The first and most important thing to recognize and understand is the new and radically different target environment that you are now designing a data model for. Machine Learning. Star schema: a data modeling and database design paradigm for data warehouses and data lakes. Business Focus. Operational.

article thumbnail

Build an Amazon Redshift data warehouse using an Amazon DynamoDB single-table design

AWS Big Data

A key pillar of AWS’s modern data strategy is the use of purpose-built data stores for specific use cases to achieve performance, cost, and scale. Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query. To house our data, we need to define a data model.