Class Notes (1,100,000)
CA (620,000)
Ryerson (30,000)
ITM (1,000)
ITM 100 (300)
Lecture 7

ITM 100 Lecture Notes - Lecture 7: Data Warehouse, Scalability, Call Centre


Department
Information Technology Management
Course Code
ITM 100
Professor
Raymond Moss
Lecture
7

This preview shows half of the first page. to view the full 2 pages of the document.
ITM100 Chapter 7 Notes
Data are raw facts that describe the characteristics of an event.
Information is data converted into a meaningful and useful context.
Information granularity – refers to the fine/coarse detail within the information
Real-time information – Immediate, up-to-date information
Real-time system – Provides real-time information in response to requests
The four primary sources of low-quality information include:
1. Customers intentionally enter inaccurate information
2. Data from different systems have different entry standards and formats
3. Call centre operators enter abbreviated/wrong info by accident or to save time
4. Third party and external information contains inconsistencies, inaccuracies, and errors
Database – collection of records about various business categories such as resources, events, people, and places
Database models include:
Hierarchical database model – info organized into a tree structure (parent/child relationships)
Network database model – a flexible way of representing objects and their relationships.
Relational database model – stores info into logically related two-dimensional tables.
Primary keyA field (or group of fields) contain values that uniquely identify a given record in a table.
Foreign key A primary key of one table that appears in another table.
A well-designed database should:
Handle changes quickly and easily
Physical view – deals with the physical storage of information
Logical view – focuses on how users logically access information
Scalability – refers to how well a system can adapt its capacity to changing demands.
Performance – measures how quickly a system performs a certain process or transaction.
Information integrity – measures the quality of information.
Integrity constraint – rules that help ensure the quality of information:
Relational integrity constraint – rule that enforces fundamental information-based constraints
You're Reading a Preview

Unlock to view full version