BUSI 3400- Final Exam Guide - Comprehensive Notes for the exam ( 28 pages long!)
Document Summary
Shared, integrated computer structure that stores a collection of end-user data. Different versions of the same data appear in different places. Workgroup databases supports a small number of users or a specific department (~<50 users) Supports many users across many departments (~>=50 users) Centralized database data is located at a single site. Distributed database data is distributed across different sites. Contains a wide variety of data used in multiple disciplines. Operational database designed to support a company"s day-to-day operations. Transactional database (production/operational/oltp) supports company"s day to day operations. Stores historical data and business metrics used exclusively for tactical or strategic decision making. Stores data in a format optimized for decision support. Tools for retrieving, processing, and modeling data from the. Captures and processes business data to generate information that support. Importance of database design defines expected use of database, different approach needed for different types of databases, and poor design could be costly.