Data Management & Data Warehouses. MIS 320 Kraig Pencil Summer 2014. Game Plan. Introduction Why use a relational database? Database management systems Data warehouses Data mining Data marts. A. Why use a relational database?.
1. A database sounds great, but why don’t we just store all our data in one big table in an Excel spreadsheet?
1. Why don’t we just store our data in one spreadsheet table? (cont.)
Break up the table into a set of linked tables in a data base (instead of having one spreadsheet)
Examples of redundancy
1. What is a “database management system” (DBMS)?
2. Key components
Lab Tutorials 1,2
Lab Tutorials 3,5
Lab Tutorials 4,6
3. Examples of DBMS components in Access
Data Definition subsystem
Data Manipulation subsystem: Move, change, and “ask questions”
Application Generation subsystem: the “front end”
Data Administration subsystem
4. What aspects of data need to be specified?
Data “type” (number, text, date, etc.)
Information about the “Gender” field is specified in “Field Properties” section
QBE or SQL may be used to prepare a query. Which approach would be easier for most people?
5. DBMS: Example products
From Haag, et al., MIS for the Information Age, 2004
3. Data warehouse features
4. Identify previously unknown patterns
*This is a common example, not an actual case.
5. Data marts
Some organizations create “data marts”
Haggen photo from: www.callhugh.com/ ferndale.php
MiniMart photo from: http://www.ae.gatech.edu/research/controls/pictures/f020801_gtar/Mini%20Mart.JPG