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

Using a Star Database Schema - Research Paper Example se of a dimensional model is to help decision makers in making strategic decisions without the need of help and support from database experts thereby avoiding extra cost. As a result timely and quality decisions are made. Research by Karen, David and Robert (2006), indicate that denormalization is advocated for in data warehouses as it promotes efficiency of the highest order when queries are run 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 fact tables that get business event details. Star schema derives its name from the arrangement of the fact tables and dimensional entities forming a star-like arrangement. The representation of this arrangement diagrammatically constitutes the SSD. As a result of 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. First is convenient for simple queries. The star schema simplifies business logic in the realms of reporting. It also provides high level operation performance as a result of simpler queries execution. Lastly star schemas are deployed in most 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 value. This means that the primary key is unique and mandatory. Data in the data warehouse comes from various multiple operational databases and therefore in some instances 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 value due to the fact they might lack data. Relationships on the parent sides are not mandatory meaning that there