We already learned how to create a Data Foundation resource in Chapter 4, Creating the Data Foundation Layer, and we already discussed the following topics in detail:
How to insert database objects (database tables and views)
Creating alias and derived tables
Creating joins between Data Foundation objects
Learning Data Foundation toolbars, menus, and features
In this chapter, we will talk about the advanced topics of Data Foundation that are related to the design. The Data Foundation design is a critical part of the success of our Universe, so we need to understand some important design concepts first before starting the design process. This will help us create a proper design for our Data Foundation, based on the collected business requirements.
After that, we will discuss some advanced techniques that can be used to solve some design issues (known as SQL design traps). We will also get to know how to configure and use Data Foundation parameters...