Using a Star Database Schema Research Paper Example | Topics and Well Written Essays - 500 words

Using a Star Database Schema - Research Paper ensamplese of a dimensional regulate is to help decision makers in making strategic decisions without the compulsion of help and support from database experts thereby avoiding extra cost. As a result timely and quality decisions ar made.Research by K aren, David and Robert (2006), indicate that denormalization is advocated for in data warehouses as it promotes efficiency of the highest order when queries are lean against the warehouse (Karen, David, & Robert, 2006).The concept of dimensional model was developed to cater denormalized data. A star schema model can arguably be referred to as a constrained ERD model. It consists of central entities known as the occurrence tables that get parentage event details. Star schema derives its name from the arrangement of the accompaniment tables and dimensional entities forming a star-like arrangement. The representation of this arrangement diagrammatically constitutes the SSD. As a result o f this arrangement around a business fact, SSD model is easy to understand.Star schema data model consists of one or more fact tables referencing any given number of dimension tables. There are several benefits of using star schema. commencement exercise is convenient for simple queries. The star schema simplifies business logic in the realms of reporting. It also provides high take aim operation performance as a result of simpler queries execution. Lastly star schemas are deployed in almost of OLAP systems to make proprietary OLAP cubes efficiently.According to Fig.1, most of the columns if not all in both the dimensions and fact tables are of null repute. This means that the primary key is unique and mandatory. Data in the data warehouse comes from different multiple operational databases and therefore in some exemplars constraints applied in transactional databases need to be loosened. For instance in the star schema diagram in Fig.1, almost all the columns are of null valu e due to the fact they might lack data.Relationships on the parent sides are not mandatory nub that there