COMP 300: Data Warehousing and Data Mining
Data warehousing and Data mining are two major areas of exploration for knowledge discovery in databases. These topics have gained great relevance especially in the 1990’s and early 2000’s with web data growing at an exponential rate. As more data is collected by businesses and scientific institutions alike,knowledge exploration techniques are needed to gain useful business intelligence. This course will cover a wide spectrum of industry standard techniques using widely available database and tools packages for knowledge discovery.
Data mining is for relatively unstructured data for which more sophisticated techniques are needed. The course aims to cover powerful data mining techniques including clustering, association rules, and classification. It then teaches high volume data processing mechanisms by building warehouse schemas such as snowflake, and star. OLAP query retrieval techniques are also introduced.