databases mgmt 661 - summer 2012 night #4, lecture part 1 based on textbook chapter 6
TRANSCRIPT
DatabasesDatabasesMGMT 661 - Summer 2012
Night #4, Lecture Part 1
Based on textbook Chapter 6
Why study databases?Why study databases?databases are the central
component of TPS, CRM, etc.
Data organization impacts information quality.
Old Style Data Old Style Data ManagementManagement
ApplicatioApplicationn
SoftwareSoftware
Data
File
Data
File
Data
File
ApplicatioApplicationn
SoftwareSoftware
DataFile
DataFile
Many "legacy systems"still work this way.
textbook Figure 6-1
Terms to Know:•Field / Attribute•Record•Field Type
Problems with File-based Problems with File-based SystemsSystems
Data RedundancyData Inconsistency
◦different values in different files◦different names for attributes◦different attributes types for the same
attributeProgram-data Dependence
◦zip codes◦Y2K
Lack of Data Sharing
textbook p 211-212
Database Management Database Management SystemSystem
DatabaseDatabase
ApplicationApplication
ApplicatioApplicationn
ApplicationApplication
ApplicatioApplicationn
The DBMS uncouples programs and data
Relational Database◦data organized as 2D "Tables", not text
Files
Example DBMS◦Big Systems
Oracle Database Microsoft SQL Server
◦Small Systems MySQL
◦Single Computer Microsoft Access
Database DesignDatabase DesignTerms to KnowTableRecord
◦ info about an entity (eg a supplier)
Primary Key◦ must be unique
Foreign Key◦ used to link to
another table
Data Dictionary◦ what is this field◦ read/write
permissionstextbook Figure 6-4
Database DesignDatabase Design
Database DesignDatabase Design
securitysystem
sensor
monitors
enables/disables
tests
programsis programmed by
securitysystem
sensor
monitors
enables/disables
tests
programsis programmed by
SQLSQL - - Structured Query Structured Query LanguageLanguageWhich suppliers are in Ohio?SELECT Supplier_Name from Supplier WHERE Supplier_State = "OH";
Web-Based DatabasesWeb-Based Databases
textbook Figure 6-16
Misc Database TermsMisc Database TermsDistributed DatabasesData WarehouseOnline Analytical Processing
(OLAP)Data Mining
◦web mining◦text mining
Data Scrubbing
HomeworkHomeworkDesign the tables for a small pizza delivery shop. Design?
number of tables? fields in each table? primary keys?
Uses for this information?