O'Reilly logo

Aster Data Database Administration by Todd Wilson, 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 12 – Aster Modeling Rules

“I know that you believe that you understand what you think I said, but I am not sure you realize that what you heard is not what I meant.”

-Sign on Pentagon office wall

Modeling Rules for Aster Data

Below are some excellent modeling rules for Aster Data:

1. Dimensionalize your schema.

2. Use Columnar techniques when appropriate.

3. Distribute your data by hash or replication with joins in mind.

4. Replicate frequently joined rows on Dimension Tables.

5. Use Logical partitioning on Fact tables when appropriate.

6. Make your Fact tables skinny.

7. Index your tables.

8. Consider denormalizing based on your environment.

Above are the eight rules for modeling Aster Data. These are designed around three principles ...

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