SSB4143 – DSS Lab assignment 2

Note: As I have lost my thumbdrive recently, the following questions may not be exacly the same as you had on class. Here they are:

Do some small reseach to answer the following questions

1. Explain ETL phase in data mining?
2. What is XML? And what does XML serves in the ETL process?
3. Explain briefly what ODBC is?
4. Explain briefly what JDBC is? Stress on the difference and similarity between ODBC and JDBC!
5. You are required to write a small java application to perform ETL on the northwind database, to a MySQL database. To create the impression of the data coming from disparate sources, the data is stored in plaintext, MS-Excel Spreadsheet, and XML files.

Make sure you bring your java application and the data definition language (DDL) for your database for next session (March 20) when we’ll perform a few DSS tricks on the data.
As usual, questions goes to barkah[DOT]yusuf[AT]gmail[DOT]com.

ADDED: Apparently, This site forbids zip files to be uploaded. So I cannot upload the northwind data. However you can pick it up at Application Lab, it’s on the desktop of PC “10AppTeach07″ (the one just infront of teacher’s PC).