O'Reilly logo

Greenplum - Architecture and SQL by Leona Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5 – Physical Database Design

"If the facts don’t fit the theory, change the facts”

- Albert Einstein

The Four Stages of Modeling for Greenplum

1.Requirement Analysis involves figuring out what information the users need and their processing requirements. The output of this is the Business Information Model (BIM) which shows major entities and their relationships. This is sometimes referred to as the Business Model or the Business Impact Model.

2.Logical Modeling determines defining the tables and their relationships, and this should be independent of a particular database or indexing strategy. Greenplum works well with a Third Normal Form (3NF) model, and the output defines all tables and their columns and the Primary Key Foreign Key ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required