-
Physical data model The physical data model, also known as the logical database design, is a diagram of the physical database structures that will contain the BI data. Depending on the selected database design schema, this diagram can be an entity-relationship diagram, a star schema diagram, or a snowflake diagram. It shows tables, columns , primary keys, foreign keys, cardinality, referential integrity rules, and indices. -
Physical design of the BI target databases The physical database design components include dataset placement, index placement, partitioning, clustering, and indexing. These physical database components must be defined to the DBMS when the BI target databases are created. -
Data definition language The DDL is a set of SQL instructions that tells the DBMS what types of physical database structures to create, such as databases, tablespaces, tables, columns, and indices. -
Data control language The DCL is a set of SQL instructions that tells the DBMS what types of CRUD access to grant to people, groups, programs, and tools. -
Physical BI target databases Running (executing) the DDL and DCL statements builds the actual BI target databases. -
Database maintenance procedures These procedures describe the time and frequency allocated for performing ongoing database maintenance activities, such as database backups , recovery (including disaster recovery), and database reorganizations. The procedures should also specify the process for and the frequency of performance-monitoring activities. |