The application lead developer and the database administrator should review all lessons learned during the prototyping activities. The application lead developer should help the database administrator determine which queries and reports can be executed in parallel and what type of security is needed.
Data administrator
The data administrator should provide the logical data model and the meta data to the database administrator. The logical data model and the meta data will be helpful to the database administrator when he or she designs the BI target databases. This is true even if a multidimensional database design schema was chosen because the entities and relationships on the logical data model are the perfect starting point for designing conformed dimensions and normalized snowflake dimensions.
Database administrator
The database administrator has the primary responsibility for database design. He or she needs to know the access paths, weigh the projected data volumes and growth factors, and understand the platform limitations. He or she must create and run the DDL and DCL to build the physical databases. In addition, he or she is responsible for choosing the most appropriate implementation options.
Database administrators, not programmers, should design databases. Database design usually is ”and should be ”part of the job description for database administrators because it requires special product-specific training on the DBMS optimizer.
ETL lead developer
The ETL process is dependent on the database design. The ETL lead developer should be involved in the database design activities in order to stay informed about any database design changes that will affect the ETL process or the ETL programming specifications.
