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?.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Data Management & Data Warehouses
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
Data Mining: Example of pattern discovered via mining
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