Building the data warehouse model. Assess the known and predicted data elements. Most of these steps are fairly straightforward modeling exercises. Table entities and de-normalization are activities that may have other names. Table entities can serve as metadata or as unifying information about the data.
Normalization eliminates duplication in the data.
However, there is a conflict between de-normalization and normalization of the data. Columns and data relate to the primary key and not to any other columns in the table. This method provides the best relational organization of the data, so that users can ask any question about all the data in the data warehouse. This unbounded flexibility is a prime requirement of knowledge discovery in biotechnology because the field is still not sufficiently mature enough to know what questions to ask. Generate general representations and tables of metadata.