Business Administration 3300K Study Guide - Quiz Guide: Unstructured Data, Business Intelligence, Star System
Document Summary
Data access tools and applications for end users. Relational technology: stores data in tables with attributes & rows; norm for data storage. Multidimensional database technology: stores data organised around dimensionality of data (cube); eg: how many television sold stored based on product, retail outlet & tune: relational databases can provide dimensional view by using star schema data model. Star schema data model: resembles star & is made up of fact table in center of star and dimension tables as points of star; provides a non-normalised data model. Fact table: stores numerical data that were recorded for each transaction; eg: retail number units sold; banking average monthly balance etc. Dimension tables: provide dimensions through which data in fact table can be analysed (here: payer, patient, physician, service, time periods) Conformed dimensions: whenever a firm that has multiple star schemas uses many of same dimensions and measures across star schemas allows meaningful queries to be made across different subject areas.