CIS 1200 Lecture Notes - Lecture 11: Online Analytical Processing, Query Language, Data Cube

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

Document Summary

A collection of information that is organized so that it can easily be accessed, managed and updated. Can be classified according to types of content: bibliographic, full-text, numeric and images. The structure is achieved by organizing the data according to a database model. Large databases can still provide the information you request in seconds. Without them you could not store and retrieve large quantities of information easily. They allow the flexible use of data. Databases are more complex to construct and administer than tables (such as an excel spreadsheet table) They also can be time-consuming and expensive to set up. It is helpful to have an experienced database administrator assist with the construction of large databases. Data privacy concerns also arise when using databases. Despite the increased complexity of databases and the issues surrounding privacy, however, the advantages of databases far outweigh the administrative disadvantages. A category of information in a database is stored in a field.