CS338 Lecture Notes - Lecture 1: Database, Data Definition Language, Online Analytical Processing

• School: University of Waterloo
• Department: Computer Science
• Course: CS338
• Professor: Angela Bonifati

Document Summary

Traditional databases: store numeric short text information, for managing enterprises. Text & multimedia databases: stores documents, digital images, audio and video streams. Geographic information systems: store maps, weather data, satellite images, for route finding, agriculture, natural resource management. Data warehouses and online analytical processing (olap) systems: store historical business information, for business analytics & decision support. Real time and active database technology: store process models, constraints, and key performance indicators, control industrial and manufacturing processes. Database: collection of related data, known facts that can be recorded and have implicit meaning, represents some aspects of the real world (miniworld, built for a specific purpose, eg. Amazon. com, canadian census, the bay"s product inventory, data collection underlying quest. Database management system (dbms: collection of programs, enables users to create and maintain a database, allows multiple users and programs to access and manipulate database simultaneously, ability to change the database and program as requirements change, eg. Ibm"s db2, access & sql server, oracle, mysql.