Remove cloud-data-warehouse-migration-101
article thumbnail

Cloud Data Warehouse Migration 101: Expert Tips

Alation

The cloud is no longer synonymous with risk. There was a time when most CIOs would never consider putting their crown jewels — AKA customer data and associated analytics — into the cloud. But today, there is a magic quadrant for cloud databases and warehouses comprising more than 20 vendors.

article thumbnail

Data Modeling 101: OLTP data modeling, design, and normalization for the cloud

erwin

How to create a solid foundation for data modeling of OLTP systems. As you undertake a cloud database migration , a best practice is to perform data modeling as the foundation for well-designed OLTP databases. This makes mastering basic data modeling techniques and avoiding common pitfalls imperative.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

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

erwin

This blog is based upon webcast which can be watched here. Designing databases for data warehouses or data marts is intrinsically much different than designing for traditional OLTP systems. Accordingly, data modelers must embrace some new tricks when designing data warehouses and data marts.

article thumbnail

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

erwin

This blog is based upon a recent webcast that can be viewed here. For NoSQL, data lakes, and data lake houses—data modeling of both structured and unstructured data is somewhat novel and thorny. Moreover, this blog will provide readers with a firm foundation for NoSQL and data lakes as they move to the cloud.

article thumbnail

Data Modeling 401 for the cloud: Database design for serverless data-bases in the cloud

erwin

This blog is based upon a recent webcast that can be watched here. As with part 1 , part 2 ,and part 3 of this data modeling blog series, this blog also stresses that the cloud is not nirvana. Cloud database design choices. Below is a diagram showing your choices under the Amazon AWS cloud.

article thumbnail

Modernize Your ETL Processes, Discover Better Insights

Sisense

We live in a world of data: there’s more of it than ever before, in a ceaselessly expanding array of forms and locations. Dealing with Data is your window into the ways Data Teams are tackling the challenges of this new world to help their companies and their customers thrive.