ABSTRACT
This chapter presents Dimensional Modeling after revisiting Relational Database Design Fundamentals. Dimensional Relational Databases in both Relational Database Management Systems and Online Analytical Processing (OLAP) Databases are primarily designed to hold summarized/aggregated data based on certain Facts or Measures. The chapter also presents installation of Oracle SQL Developer Data Modeling. Star Schemas can be found in both Data Warehouse Databases and OLAP Databases. Often Data Warehouses are simply a duplicate, nightly updated version of Production Online Transaction Processing Application (OLTP) Databases that are used for Reporting and Analytics. In Star Schemas, a duplicative information structure is introduced that holds Aggregated Facts or Measures in a Fact Table. Data Marts, like Warehouses, are often copies of Production OLTP Databases in Human Resources, Finance, Manufacturing, Sales, Research, Engineering, and other Organizational Divisions and Departments. Third Normal Form is the design approach of choice for all Online Transaction Processing Databases that support Business Applications including Human Capital Management Systems.
