Data Architecture Tradeoffs.

Overview

Teaching: 90 min

Questions

• Why 80% of classical Data Warehouse projects fails?

• Why RDBMS is less trendy these days?

• What are the expected characteristics of a data store these days?

• What are the limitation of a classical RDBMS and how the “New tools” are solving these limitations?

Objectives

• Understand the issues around the classical Data Warehouse architecture

• Understand the limitation of RDBMDs

• Understand the social, economical and technological changes after 2010 and the radical changes induced in the data world

• Understand the role of opens source in data world

• Understand distributed systems

• Understand cloud-based systems

• Practice creation of a RDBMS in AWS

Keywords

#SERVER ARCHITECTURES

#CLOUD

#SQL SWISSKNIFE

#NOSQL

#SCHEMALESS

#BEYOND TABULAR

Table of Content

Lecture PPTX

Installing MySQL in AWS Cloud

Homework

Installing MySQL in AWS Cloud

Getting insights in AWS cloud, has to major goals:

• A data system in cloud enables collaboration during the execution of your term project
• Introducing cloud in practice, helps students to understand the next lecture

Homework (Optional, no need to submit)

• Replicate the “classicmodels” schema into your cloud instance using MySQL Workbench’s migration wizard.