Chapter 5

Chapter 5 - Introduction to Databases The enterprise...

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

View Full Document Right Arrow Icon
1 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.
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 Two Approaches To Business Event Processing 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. 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 2
3 Record Layouts under the Applications Approach to Business Event Processing
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 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. Supports normal data processing needs and enhances the organization’s management activities by providing data useful to managers. Data is independent of the application that created the data (i.e., can be changed/used by other applications). The term enterprise database is synonymously with database management system or DBMS.
Background image of page 4
5 Relational Database Tables The next slide shows a database with data stored in a relational structure. This is most common type of database structure used in
Background image of page 5

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

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

Page1 / 37

Chapter 5 - Introduction to Databases The enterprise...

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

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