BMGT 326 Exam 2

BMGT 326 Exam 2 - BMGT 326 EXAM 2 Chapter 5 Database...

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

View Full Document Right Arrow Icon
BMGT 326 – EXAM 2 Chapter 5 – Database management systems Introduction to Databases The enterprise database is at the heart of Accounting Information Systems (AIS). The chapter discusses the major types of databases available and how organizations undertake database design for AIS. Larger organizations store information in data warehouses in ways that let managers analyze it to gain important insights. Many companies combine their data resources with decision support systems, executive information systems, group decision systems, and other advanced technology-based systems to improve decision making and operations. Two Approaches to business event processing 1.Applications Approach Concentrates on the process being performed. Data support the role of the programs that run in each application system. Each application collects and manages its own data in separate, distinguishable files. Data redundancy can cause inconsistencies among the same data in different files when information is updated in one file but not the others. Storage costs are increased because the system must store and maintain multiple versions of the same data in different files. Data residing in separate files are not shareable among applications. 2. Database Approach Facts about events are stored in relational database tables instead of separate files. Solves many of the problems caused by data redundancy. Improves the efficiency of processing data by eliminating data redundancies and improving data integrity. Enables the creation of integrated business information systems that include data about all of a company’s operations in one massive collection of relational tables. Multiple users from throughout the organization can view and aggregate event data in a manner most conducive to their needs.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Record layouts under the applications approach to business event processing Problems with applications approach Data redundancy - files stored may include redundant information increasing storage requirements and the risk of inconsistency. Data in files is not shareable across applications because applications depend on a fixed record layout in data files. Record layout – applications approach Each application stores all the data required for analysis. Shows many redundancies across applications/files. Data lacks integrity when the data stored by one application is inconsistent with data stored by another application. Database management systems A set of integrated programs designed to simplify the tasks of creating, accessing, and managing data. Integrates a collection of files that are independent of application programs and are available to satisfy a number of different processing needs. Database contains data related to all the organization’s applications in one place.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/19/2010 for the course BMGT 326 taught by Professor Staff during the Spring '08 term at Maryland.

Page1 / 23

BMGT 326 Exam 2 - BMGT 326 EXAM 2 Chapter 5 Database...

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

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