Send email to me: sschung.cis@gmail.com
Professor: Dr. Sunnie S. Chung
Class: Mon 6:00 PM - 9:50 PM
Class Room: BU 306
Office Hours: Mon 2:45 pm - 5:45 pm
IST 734 Announcement:
16. Dec 6, 2014
If you are strugging with creating and writing DMX in SQl Server for your second part of the project (data mining part),
then use Analysis Service interface to do the data mining part of the project. It is the same process as what you did in Lab4_2.
Refer to SQL Server 2012 Tutorials Analysis Services for Data mining that was given in your Lab4_2.
15. Dec 4, 2014:
For those who have the empty MDX result problem, see the guide to see to fix the problem.
Project Trouble Shooting Guide
14. Dec 4, 2014:
The Final will be on Wed Dec 10 6:00 - 8:00 pm. One Note Sheet will be allowed for the Final.
Topic to focus on:
SQL Query Processing
View, ACID with Transaction
Normalization
File Structure
Index
Query Processing Cost for Selection, Projection, Nested Loop Join, Join using Index
Data Warehouse with OLAP operators: Cube, Roll Up, Drill Down
Data mining techniques: Association Rule Mining, Decision Tree
Semi Structure and XML General Concept
Big data Processing with Map Reduce on Hadoop (No programming questions)
Big Data Processing Systems: Hive, Hbase (google's Big table)
One General Question in Presenation
23. Dec 1, 2014:
Presenatation Today:
1.Alexis Sa : Big Data Processing System with MapReduce and GFS in Google
2.Dora Tang: Cloud Computing with Microsoft Azure, Google, and Amazon
3.Wesam Helou : Big Data Processing System with PDW or DW with MapResduce Hadoop on Cloud Computing
4.J.R. Dipko : Big Data Processing System with Social Network Data on MapReduce Hadoop
5.Michel Heath : Big Data Processing System with Twitter Message Data on MapReduce Hadoop
Shared by Michel:Video Site on Real Time Big Data Processing System of Twitter by Raffi Krikorian
Shared by Michel:Real Time Big Data Processing System of Twitter by Raffi Krikorian
22. Nov 28, 2014:
Presentation Schedule on Dec 1 !
Note that 30 mins for Presentation and 10 mins for Discussion.
Send me your slides BEFORE the class to be posted for your presentation !
Presentation Schedue on Dec 1
21. The Project Due date is extended to Dec 8 !
20. Nov 17, 2014:
Lab 4: Part 2 Due by Nov 24
Lab4_2 Due by Nov 24
19. Nov 14, 2014:
More papers to choose in the presentation list below. Choose any two related papers in the list on your choice of the topic for the presentation on Dec 1 !
18. Nov 2, 2014:
Presentation on the Significant Database Industry Reseach Topics on Dec 1
Research Topics and Paper List Last Updated at 7:14 pm on 11/14
17. Nov 2, 2014:
Project (Due by the end of the class)
Here is a Tutorial for the Project !
Project Tutorial on Building Business Analytic Model
16. Oct 31, 2014:
Lab5 is Posted below. Due by Nov 10 !
Lab5 on Desining Data Warehouse and Using OLAP Cube Due by Nov 10
15. Oct 22, 2014:
Lab4 is Posted below. Due by Nov 3 !
Lab4 for Installing MS BI Tool and Setting up Data Warehouse Due by Nov 3
14. Oct 22, 2014:
Midterm will be on Oct 27 6:00 - 7:50 pm. There will be a class after the exam from 8:30pm -9:50pm.
Topic to focus on:
SQL Query Processing
View, Transaction
RA Steps
Database Programming constructs -- Assertion, Trigger, SP, TB
Embedded SQL/Dynamic SQL, JDBC, ODBC with PHP
Normalization
File Structure
13. Oct 6, 2014:
Lab3 is Posted below. Due by Oct 20 !
Lab3 Due by Oct 20
12. Oct 6, 2014
You can pick up a copy of Solution for Lab2 in my office.
11. Sept 26, 2014
We will have a class today in the CIS dept Conference room instead of BU306 at 5:15 pm.
10. Sept 17, 2014
Lab2 with the Typos corrected below at 3:35pm 09/18.
10. Sept 17, 2014
You can pick up a copy of a solution of Review Lab01 on Thursday Sept 18 3:00 - 4:30 PM 0r 5:50 - 7:50 PM in my office BU346.
9. Sept 17, 2014:
READING ASSIGNMENT on Big Data processing system for a class Sept 22 : The papers are Posted below.
Big Data System in Facebook published in SIGMOD 2010
Azure Cloud System by Micrsoft published in IEEE 2011
8. Sept 17, 2014
We will have a class on Friday Sept 26 5:15 PM - 7:15 PM in BU306.
7. Sept 15, 2014:
Lab2 is Posted below. Due by Sept 29 !
Lab2 Due by Sept 29
6. Sept 10, 2014:
Review Lab01 is Posted below. Due by Sept 15 !
Check out the general info for a database server in the Lab section below if you are confused by Lab0.
Review Lab01
5. Sept 8, 2014:
New Classroom is BU 306. Email me if you need the access code.
4. Aug 27, 2014:
Review Lab0 is Posted in the Lab section below. Due by Sept 8 !
Review Lab0
3. Aug 25, 2014:
Your Linux Account for Grail has been created !
Format for User Account:
User Id: first two letters of first name followed by up to 6 characters of last name, all lower case.
Default Password: CSU student ID number plus capitalized first letter of last name.
For example, Susan Johnson with CSU ID# 2345678 would have login name sujohnso and passwd 2345678J.
If you need directions for sign onto grail (grail.cba.csuohio.edu also known as cis.csuohio.edu with IP4 address 137.148.216.15).
See directions on the webpage cis.csuohio.edu/~jackie where you can download Secure Shell.
2. Aug 25, 2014:
For the coming lab assignments, Download and install your own RDBMS, any database server is fine.
Oracle 11g XE DBMS is available from www.oracle.com
http://www.oracle.com/us/downloads/index.html
MS SQL Server is available at the site of Microsoft Academic Alliance program: DreamSpark
http://e5.onthehub.com/WebStore/ProductsByMajorVersionList.aspx?ws=31b9929b-c09b-e011-969d-0030487d8897
1. Aug 25, 2014:
Registration Instructions - Microsoft Academic Alliance Program :
1) => Go to the DreamSpark page: Updated at 9:40pm Jan 14
http://e5.onthehub.com/WebStore/ProductsByMajorVersionList.aspx?ws=31b9929b-c09b-e011-969d-0030487d8897
and hit the "Signin" button at the top right.
2) => On the "SIGN IN" page and hit the "REGISTER"button.
3) => In the box labeled "USERNAME " input your CSU ID number.
4) => The next page is self explanatory.
NOTE- Your CSU ID ( or your email that you enter on this page ) becomes your Username after registration.
For more detailed infomation if you have difficulties, contact Dr. Jackie Woldering at jackie@grail.cba.csuohio.edu.
Review Lab0 (Due by Sept 8)
Example Output of Lab0
General Info about a database system (Guildelines for Lab0)
Review Lab01 (Due by Sept 15)
Lab2 Due by Sept 29 Typos corrected at 3:35pm 09/18
Lab3 Due by Oct 20
Lab4 for Installing MS BI Tool and Setting up Data Warehouse Due by Nov 3
Lab5 on Designing Data Warehouse and Using OLAP Operators Due by Nov 10
Lab4_2 Due by Nov 24
Project on Building Business Analytics Project using Microsoft BI Data Mining Tool and Building Data Warehouse with OLAP Cube
Project
Project Tutorial on Building Business Analytics Project and Data Warehouse and OLAP Cube
Project Reference 1: MDXQueryTutorial for Multi-Dimensional OLAP Query
Project Reference 2: Data Mining Extensions - DMX - Reference
Project Reference 3: SQL Server 2012 Tutorials - Analysis Services Data Mining (will be given in class)
Research Paper Presentation List
Relational Database Review:
Class Note_0: Relational Database Review: Chapter 3
Class Note_0: Lecture Note on Database Design and ER Model
Class Note_0: Relational Database Review: Chapter 7
Class Note_0: SQL Review: Chapter 4
Class Note_0: SQL Review: Chapter 5
Class Note_0: SQL Review: Example Queries
Mordern Relational Database System:
Class Note_1: Overview of RDBMS with Query Processing, Transaction, View
Class Note_2: Lecture Notes on Relational Algebra
Class Note_3: Chapter 6 Relational Algebra and Relational Calculus
Class Note_4: Database Extensions -- Trigger, Embedded SQL, Stored Procedure, Table Functions
Class Note_4_1: More Advanced Topics On Trigger (Last updated on 09/23/2014)
Class Note_5: MySQL Applications Using Java & JDBC
Class Note_6: Lecture Notes On Embedded SQL Using Java & JDBC
Class Note_7_1: Chapter 15:Database Programming Using PHP
Class Note_7_2: Web Programming Examples Using PHP
Class Note_7_3: More with Example Codes on Database Programming: PHP
Class Note_8: Chapter 15 Normalization
Class Note_8: Lecture Notes on Functional Dependencies
Class Note_8_1: Chapter 16 Further Functional Dependencies
Class Note_7: Chapter 17 Disk Storage System, File Structure, Hash
Class Note_8: Chapter 18 Index Structure for File
Class Note_9: Index Structure for File: B+ Tree
Class Note_10: Lecture Notes on Query Processing
Semi- Structured Database
Class Note_11: Lecture Notes on Introduction of Semi-Structured Database and XML
Class Note_12: Lecture Notes on Semi-Structured Database and XML
Data Warehouse and OLAP
Class Note_13: Lecture Notes on Data Warehouse (Last Updated at 5:00pm on 4/5)
Class Note_13_2: Data_Cube: A Relational Aggregate Operator by Jim Gray et al
Data Mining Techniques
Class Note_14: Lecture Notes On Data Mining -- Apriori Algorithm and Association Rule Mining
Class Note_14_1: Paper on Association Rule Mining by IBM in Sigmod 98
Class Note_15: Lecture Notes On Data Mining: Frequent Pattern Tree and Association Rule Mining
Correction On FP Slides
Class Note_16: Lecture Notes On Data Mining: Decision Tree
Information Retrieval System
Class Note_18: Lecture Notes On Information Retrieval System (By Google)
Big Data Processing System and Cloud
Class Note_17: Lecture Notes On Introduction of Big Data
Class Note_17: Lecture Notes On Map Reduce -- Introduction of Concept and Techniques
Class Note_18: Lecture Notes On Hadoop -- Introduction of ConceptUpdated on 11/24/2014
Class Note_19: Lecture Notes On Big Data Processing Systems with NO SQL
Class Note_19: Lecture Notes On Hive, PigLatin, HBase, and Zoo Keeper
Big Data Processing System at FaceBook (From SIGMOD 2013)
Class Note_20: Lecture Notes On Big Data Processing Systems with NEW SQL