CS 107

Fall Semester 2004

Section 51

Lecture Week 8

Database, Data Warehousing, and Data Mining

UNH Home Page Computer Science Department Home Page Contact Instructor

Course Home Page

Syllabus

Assignments

Lectures
  • What is a database
  • Advantages of a database
    • Store large amounts of information
    • Retrieve information quickly and flexibly
    • Organize and re-organize informaiton
    • Print and distribute information in a variety of ways
  • Structure of a database
    • Field
    • Record
    • Table
  • What information can be gotten from a database
    • Browse data
      • Table/List view
      • Form view
    • Query - Structured Query Language - SQL - http://www.sqlcourse.com/
    • Sort
    • Print Reports
  • Data Base Management Systems - DBMS
  • Database Trends
    • Realtime Procssing
    • Distributed datebases - A database that consists of two or more data files located at different sites on a computer network.
    • Databases on the Web / Customer Relationship Management - CRM
    • Object Oriented Databases
    • Multimedia Databases
    • Natural Language Database
    • Data Warehousing - "a copy of transaction data specifically structured for querying and reporting"
    • Data Mining - "the automated extraction of hidden predictive information from databases"
  • Computerized Databases and Privacy
    • Data Warehousing / Data Mining and Personal Information
    • Identity Theft
    • Worker Monitoring / Surveilance cameras

Covers: Computer Confluence - Chapter 7

Links for Further Study

Easy to Understand Database Tutorials - http://www.geekgirls.com/menu_databases.htm

SQL Tutorial - http://www.w3schools.com/sql/default.asp

Data mining offshore raises privacy fears - http://www.startribune.com/stories/484/5047675.html

Data Mining, Knowledge Discovery, Genomic Mining, Web Mining - http://www.kdnuggets.com/

Information about data mining and analytic technologies - http://www.thearling.com/

Welcome to TheDataMine - http://www.the-data-mine.com/

Data Mining Technologies - http://www.data-mine.com

Data Mining Glossary - http://www.twocrows.com/glossary.htm

The Data Warehousing Information Center - http://www.dwinfocenter.org/

Data Warehousing.com - http://www.datawarehousing.com/

Data Warehousing and Business Intelligence - http://www.1keydata.com/datawarehousing/datawarehouse.html

Data Warehousing at Stanford - http://www-db.stanford.edu/warehousing/warehouse.html

Online Databases

The Internet Movie Database (IMDb) - http://www.imdb.com/

The GDB Human Genome Database - http://gdbwww.gdb.org/

International Data Base (IDB) - http://www.census.gov/ipc/www/idbnew.html

The Interent Hockey Database - http://www.hockeydb.com/

World Flag Database - http://www.flags.net/index.php

United States Patent and Trademark Office - http://www.uspto.gov/patft/

Languages of the World - http://www.ethnologue.com/

Last Updated: 10/25/04