M cheung william tan and carson woo 19 busi 335

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ment: Database Data Management: Database BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 19 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 20 Multidimensionality Creating Data Warehouse Creating a Data Warehouse The common data table layout for a data warehouse is called a star schema. The dimension tables usually radiate out from the fact table. Please refer to the next slide for an example. example. BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 21 BUSI 335 An An Example: Multidimensional Database Multidimensional Database BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo • Organize data into different dimensions: dimensions: − dimensions: products, salespeople, market segments, business units, mar geographical locations, distribution channels, country, or industry − measures: money, sales volume, head count, inventory profit, actual vs forecasted vs. forecasted − time: daily, weekly, monthly, quarterly, or yearly Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 22 Data Warehouse Database Data Warehouse Database 23 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 24 Model Base Management Base Management Data Warehouse Issues Data Warehouse Issues • Data Warehouse Challenges (Hackney, 1997) • Provides the DSS analytical capabilities the DSS analytical capabilities − Expensive to build ($2 to $3 million) − 12 to 36 months before measurable impact on the business business • Contains elements: • To address the challenges: Data Mart − Small, single-subject data warehouse • may form part of organizational data warehouse • provides decision support to a small group of people • may serve as a test vehicle for companies exploring the potential costs and benefits of data warehouses • addresses local or departmental problems BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 25 − Model base − Model base management system − Model directory − Model execution, integration, and command BUSI 335 Model Base Management: Structure • Contains routine and special statistical, Model Directory financial, management, and other quantitative models • The models can be divided into four categories: Model Base Management - Modeling commands: creation Modeling commands: creation - Matainenance-update - Database interface - Modeling language Data Management 26 Model Base Management: Model Base Base Mode...
View Full Document

This document was uploaded on 03/04/2014 for the course COMM 335 at The University of British Columbia.

Ask a homework question - tutors are online