BUS 171CP Lecture Notes - Lecture 1: Data Warehouse, Unstructured Data, Unique Key
Document Summary
Databases: collection of related data, easily stored, sorted, organized, and queried, turn data into information. Database management systems (dbms: application software designed to capture and analyze data, four main operations of dbms b. i. Advantaged of using databases: store and retrieve large quantities of information, enable information sharing, provide data centralization, promote data integrity (creating validation rules, allow for flexible use of database. Disadvantage of database: complex to construct, time consuming, expensive, privacy concern. Database types: relational database most popular a. i. Organize data in 2d tables (columns and rows) a. ii. Links tables to each other through their primary keys a. ii. 1. Common field(s) need to exist between tables a. iii. Collection of related data, create relationships between: object-oriented databases best handling unstructured data data b. i. Database terms: table: a group of related records, fields: a category of information, displayed in columns, records: a group of related fields, data type: type of data that can be stored in a field d. i.