BUSI 3400 Chapter Notes - Chapter 1: Sql, Database, Query Language
Document Summary
Database: shared, integrated computer structure that stores a collection of end-user data. Data inconsistency: different versions of the same data appear in different places. Workgroup databases: supports a small number of users or a specific department (~<50 users) Enterprise database: 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. General-purpose databases: contains a wide variety of data used in multiple disciplines. Discipline-specific databases: contains data focused on specific subject areas. Operational database: designed to support a company"s day-to-day operations. Transactional database: (production/operational/oltp) supports company"s day to day operations. Analytical: stores historical data and business metrics used exclusively for tactical or strategic decision making. Typically has two components (data warehouse and online analytical processing) Data warehouse: stores data in a format optimized for decision support. Online analytical processing (olap): tools for retrieving, processing, and modeling data from the data warehouse.