ISOM Lecture 6

ISOM Lecture 6 - Database management systems(DBMS software...

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

View Full Document Right Arrow Icon
Database management systems (DBMS) – software through which users and application programs interact with a database •The components of the DBMS are discussed in detail on the following slides •A DBMS contains: Data definition component – allows user to create tables and relationships Data manipulation component – allows users to create, read, update, and delete information in a database Application generation component - allows users to create various interfaces to databases Example : Report and form generators – users can define report and form formats Data administration component – allows DBA (Data Base Administrator) to maintain technical aspects of database systems (such as performance, security, etc.) •MS Access Overview – Covers IMPLEMENTATION and phases Data warehouse – a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks •The primary purpose of a data warehouse is to aggregate (gather) information throughout an organization into a single repository for decision-making purposes Transactional information – encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks –examples include withdrawing cash from an ATM, making an airline reservation, purchasing
Background image of page 1

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

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

This note was uploaded on 02/16/2011 for the course ISOM 247 taught by Professor Jukic during the Spring '08 term at Loyola Chicago.

Page1 / 3

ISOM Lecture 6 - Database management systems(DBMS software...

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

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