Data Warehousing ???? - PowerPoint PPT Presentation

Loading...

PPT – Data Warehousing ???? PowerPoint presentation | free to download - id: 56b147-NDA2N



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Data Warehousing ????

Description:

Data Warehousing Introduction to Data Warehousing 1001DW01 MI4 Tue. 6,7 (13:10-15:00) B427 Min-Yuh Day Assistant Professor – PowerPoint PPT presentation

Number of Views:62
Avg rating:3.0/5.0
Slides: 30
Provided by: myD3
Learn more at: http://mail.tku.edu.tw
Category:
Tags: data | warehousing

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Data Warehousing ????


1
Data Warehousing????
Introduction to Data Warehousing
1001DW01 MI4 Tue. 6,7 (1310-1500) B427
  • Min-Yuh Day
  • ???
  • Assistant Professor
  • ??????
  • Dept. of Information Management, Tamkang
    University
  • ???? ??????
  • http//mail.im.tku.edu.tw/myday/
  • 2011-09-06

2
http//mail.im.tku.edu.tw/myday/
3
http//mail.im.tku.edu.tw/myday/
4
????
  • ???????? (Data Warehousing)
  • ??????? (Min-Yuh Day)
  • ??????? (MI4)
  • ?????? ??? 2??
  • ?????? 6,7 (Tue 1310-1500)
  • ????B427

5
Knowledge Discovery (KDD) Process
Knowledge
  • Data Warehouse fundamental process for Data
    Mining and Business Intelligence
  • Data mining core of knowledge discovery process

Pattern Evaluation
Data Mining
Task-relevant Data
Data Warehouse
Selection
Data Cleaning
Data Integration
Databases
Source Han Kamber (2006)
6
Data WarehouseData Mining and Business
Intelligence
Increasing potential to support business decisions
End User
Decision Making
Business Analyst
Data Presentation
Visualization Techniques
Data Mining
Data Analyst
Information Discovery
Data Exploration
Statistical Summary, Querying, and Reporting
Data Preprocessing/Integration, Data Warehouses
DBA
Data Sources
Paper, Files, Web documents, Scientific
experiments, Database Systems
Source Han Kamber (2006)
7
????
  • ??????????????????
  • ???????????OLAP?????????????????,????,????????????
    ?????????????????

8
Syllabus
  • ?? ?? ??(Subject/Topics)
  • 1 100/09/06 Introduction to Data
    Warehousing
  • 2 100/09/13 Data Warehousing, Data Mining,
    and Business Intelligence
  • 3 100/09/20 Data Preprocessing Integration
    and the ETL process
  • 4 100/09/27 Data Warehouse and OLAP
    Technology
  • 5 100/10/04 Data Warehouse and OLAP
    Technology
  • 6 100/10/11 Data Cube Computation and Data
    Generation
  • 7 100/10/18 Data Cube Computation and Data
    Generation
  • 8 100/10/25 Project Proposal
  • 9 100/11/01 ?????

9
Syllabus
  • ?? ?? ??(Subject/Topics)
  • 10 100/11/08 Association Analysis
  • 11 100/11/15 Classification and Prediction
  • 12 100/11/22 Cluster Analysis
  • 13 100/11/29 Sequence Data Mining
  • 14 100/12/06 Social Network Analysis
  • 15 100/12/13 Link Mining
  • 16 100/12/20 Text Mining and Web Mining
  • 17 100/12/27 Project Presentation
  • 18 101/01/03 ?????

10
Course Introduction
  • This course introduces the fundamental concepts
    and technology of data warehousing.
  • Topics include data warehousing, data mining,
    business intelligence, OLAP, data cube,
    association analysis, classification, cluster
    analysis, social network analysis, text mining,
    and web mining.

11
Objective
  • Students will be able to understand and apply the
    fundamental concepts and technology of data
    warehousing.

12
??????????????
  • ????
  • ???????????????????????
  • ????
  • ?????????
  • ????
  • ?????????????????

13
????
  • Data Mining Concepts and Techniques, Second
    Edition, Jiawei Han and Micheline Kamber, 2006,
    Elsevier
  • ????
  • ?????????,??? ?,2008,??
  • SQL Server 2008 R2 ?????????,???????????,2011,??
  • ????????SQL Server 2008,??????,2010,??
  • Web ????????,???,2008,??

14
Data Mining Concepts and Techniques (Second
Edition)
http//www.amazon.com/Data-Mining-Concepts-Techniq
ues-Management/dp/1558609016
15
???????????
  • ??????
  • 1?(Team Term Project)
  • ????????
  • ??????30
  • ??????30
  • ????? 20 (Team Term Project)
  • ???(???????????) 20

16
Team Term Project
  • Term Project Topics
  • Data Warehousing
  • Business Intelligence
  • Data mining
  • Text mining
  • Web mining
  • Social Network Analysis
  • Link Mining
  • 3-5 ????
  • ????? 2011.09.20 (?) ???????
  • ?????????????

17
Typical framework of a data warehouse
Source Han Kamber (2006)
18
Multidimensional data cube for data warehousing
Drill-down
Roll-up
Source Han Kamber (2006)
19
Example of Star Schema

Sales Fact Table
time_key
item_key
branch_key
location_key
units_sold
dollars_sold
avg_sales
Measures
Source Han Kamber (2006)
20
Architecture of a typical data mining system
Graphical User Interface
Pattern Evaluation
Knowledge-Base
Data Mining Engine
Database or Data Warehouse Server
data cleaning, integration, and selection
Data Warehouse
World-Wide Web
Other Info Repositories
Database
Source Han Kamber (2006)
21
Social Network Analysis
Source http//www.fmsasg.com/SocialNetworkAnalysi
s/
22
Text Mining
Source http//www.amazon.com/Text-Mining-Applicat
ions-Michael-Berry/dp/0470749822/
23
Web Mining and Social Networking
Source http//www.amazon.com/Web-Mining-Social-Ne
tworking-Applications/dp/1441977341
24
Mining the Social Web Analyzing Data from
Facebook, Twitter, LinkedIn, and Other Social
Media Sites
Source http//www.amazon.com/Mining-Social-Web-An
alyzing-Facebook/dp/1449388345
25
Web Data Mining Exploring Hyperlinks, Contents,
and Usage Data
Source http//www.amazon.com/Web-Data-Mining-Data
-Centric-Applications/dp/3540378812
26
NTCIR Project (NII Test Collection for IR
Systems) 
Source http//research.nii.ac.jp/ntcir/ntcir-9/in
dex.html
27
NTCIR-9 RITERecognizing Inference in TExt _at_NTCIR9
Source http//artigas.lti.cs.cmu.edu/rite/Main_Pa
ge)
28
NTCIR-9 RITERecognizing Inference in TExt _at_NTCIR9
Source http//artigas.lti.cs.cmu.edu/rite/Main_Pa
ge_(TC)
29
Contact Information
  • ??? ?? (Min-Yuh Day, Ph.D.)
  • ??????
  • ???? ??????
  • ??02-26215656 2347
  • ??02-26209737
  • ???I716 (??????)
  • ?? 25137 ?????????151?
  • Email myday_at_mail.tku.edu.tw
  • ??http//mail.im.tku.edu.tw/myday/
About PowerShow.com