CIS 1200 Lecture Notes - Lecture 95: Online Analytical Processing, Query Language, Data Warehouse

• School: University of Guelph
• Department: Computing and Information Science
• Course: CIS 1200
• Professor: John Saville

Document Summary

A database is a collection of related data that can be stored, sorted, organized, and queried. Databases have tables and within those tables are records and within those records are fields. Most common type of database is relational, for example microsoft access. Relational databases operate by organizing data into various tables, based on logical groupings. In relational databases, a link between tables that defines how the data is related is referred to as relationship. A common field between the two tables is used to create a link. Data mining uses databases to search for information. Data mining uses databases to also collect huge amounts of information and then takes those tables to search for relative terms and patterns. Databases enable information sharing, provide data centralization, promote data integrity, and allow the flexible use of data. A category of information in a database is stored in a field.