ADM2372.Chap07 - ADM2372 Management Information Systems...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
1 ADM2372 Management Information Systems (MIS) Book: Business Driven Information Systems Book: Business Driven Information Systems Chapter 7 Chapter 7
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Agenda Databases and Data Warehouses
Background image of page 2
3 Databases and data warehouses are at the centre of all information systems discussed in this course Databases store the information necessary for day to day transactions (operational level) Data Warehouses store information for analysis and decision making (management and strategic levels) Bit : Smallest unit of data; binary digit (0,1) Byte : Group of bits representing a single character Field or column: group of characters, representing an attribute or characteristic or property Record or row: group of related fields, describes an entity (e.g., person, event, place) about which information is stored File or table or entity class: group of related records of the same type Database : group of related files Introduction
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 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 extent of detail within the information (fine and detailed or coarse and abstract): Levels, Formats, Granularities Record Fields / Attributes Key field A Bookstore database with a single file called “Books”
Background image of page 4
5 Before databases we had flat files with the following problems Data redundancy: same data stored in more than one location Program-Data Dependence: changes in programs required changes to the data Lack of Flexibility: only routine reports , hard to obtain ad-hoc reports Poor security: little knowledge of who is accessing or making changes to the data Lack of data sharing: no sharing of data between different applications or parts of the organization Transactional data encompasses all of the data contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks. Analytical information encompasses all organizational information, and its primary purpose is to support the performing of higher-level analysis tasks.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 Low-quality information example High Quality Information must be : Accurate: is the name spelled correctly? Complete: is the address complete (street, city, province, postal code)? Consistent: does the total field equal the total of the individual fields? Unique: are there any duplicate customers? Timely: is information updated weekly, daily, or hourly?
Background image of page 6
7 A database maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) A database is a collection of data organized to serve several applications efficiently Database models include: Hierarchical database model information is organized into a tree-like structure (using parent/child
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/12/2012 for the course TELFER ADM2372 taught by Professor El-kadri during the Fall '11 term at University of Ottawa.

Page1 / 23

ADM2372.Chap07 - ADM2372 Management Information Systems...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online