Designing data marts
This chapter provides an overview of database designs for transactional and analytical database systems. It describes the techniques of dimensional modeling for data warehouses, including star and snowflake database schemas. Also covered are the specific design aspects for data marts in Informix Warehouse Accelerator and practical considerations.
2.1 Relational database design overview
The purpose of a database determines what the schema for the database looks like. When you design the schema for a relational database, consider ...