BUSI 3400 Lecture Notes - Lecture 1: Sql, Database, Query Language
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. Typically has two components (data warehouse and online analytical processing) 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.