Model Design Accelerator is an extension of Framework Manager which has been designed to simplify the design and creation of a single fact relational star schema model. Model Design Accelerator can be used to create a relational star schema model that adheres to proven modeling practice. By using Model Design Accelerator, a novice modeler can build a Framework Manager model without extensive training, and a more experienced modeler can quickly build a new model, thereby reducing the time taken to design and build a Framework Manager model.
This chapter covers the following topics:
The Model Design Accelerator user interface
Starting Model Design Accelerator
Adding tables
Adding joins
Generating Framework Manager models
By the end of this chapter you will be able to use Model Design Accelerator to design a new Framework model.
To introduce Model Design Accelerator, we will use a fairly simple schema based on a rental star schema, derived from the MySQL Sakila
sample...