ITM 100 Lecture Notes - Lecture 7: Data Warehouse, Scalability, Call Centre
DepartmentInformation Technology Management
Course CodeITM 100
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 key – A 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