Remove 2003 Remove Analytics Remove Cost-Benefit Remove OLAP
article thumbnail

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

erwin

In fact, many commonly accepted best practices for designing OLTP databases could well be considered worst practices for these purely analytical systems. Static over-provisioning or dynamic scaling will run up monthly cloud costs very quickly on a bad design. Analytical. Look at Figure 1 below. Business Focus. Operational.