COMP 8390 (60-539-01 ) WINTER 2024
Announcements.
PLEASE, CHECK THIS PAGE FOR
COURSE INFORMATION AND EVENTS. Just scroll down to read from recent to old
announcements.
Course Web Page can be accessed through: https://brightspace.uwindsor.ca/d2l/login
Or https://cezeife.myweb.cs.uwindsor.ca/courses/60-539/539index.htm
Classes: Mon : 2:30 – 5:20pm in Room : ER Room
To attend class, Log on to Brightspace https://brightspace.uwindsor.ca/d2l/login. Then, click on Virtual classroom, and
join Comp 8390 Class session for the day.
Office hours: Tues. 3:00pm – 4:00pm, will be held in my CS
office.
|
Note: Office hours will be held in-person in my office at LT 5103. The following link is for joining any MSTeams group for class or during my office hours if it becomes necessary to move meeting online to MSTeams: |
Get the
course information through the link Course information Volume 1.
Get more
course information through the link More
course information Volume 2
Posted Tuesday,
April 16, 2024.
Dear Comp 8390 Students,
I have
just posted the updated unofficial final marks which includes the all marks through the marks link below. Refresh your
browser to always get the updated post:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-539/marks/index.htm
Send an email to me soon if there are any discrepancies or adjustments to address before I would submit these grades to the registrar’s office in about a day.
As announced in my course outline, if you completed
all course work and need less than 1% to get to the next grade level, I will
round you up using the unrounded total.
Good Luck with completing the rest of your program.
Dr. Ezeife, C.
Posted Wednesday, March 27, 2024
Note the remaining scheduled class
events below. Marks for Assignment 3 will be updated on the Marks web site once
marking is completed. Check that all your updated marks are correct on
this marks spreadsheet or send a mail to me asap.
Steps for completing online SPTs
(student perception of teaching (formerly called SET)) in the next few days and
class are shown below.
SPTs provide
students with an opportunity for feedback regarding their course and instructor
in order to enhance the teaching/learning culture on campus.
To
access and complete an online SPT:
1.
In your web browser, preferably Google
Chrome, go to www.uwindsor.ca/uwinsitestudent.
2.
Click the blue SIGN IN TO UWINSITE STUDENT button.
3.
On the Sign
in screen, enter (or select) your UWinID@uwindsor.ca.
Click the Next button.
4.
On the Enter
password screen, enter your UWin
Account password. Click the Sign
in button.
5.
On your Student
Homepage in UWinsite Student, click the My Academics tile.
6.
Click Student
Perception of Teaching in the left navigation menu.
7.
Select the appropriate term and click the Continue button.
8.
In the STUDENT
PERCEPTION OF TEACHING box, click the Start button. Please note
that the Start button is active during the last 2 weeks of classes only. You
will not be able to complete your course SPT prior to this time or once your
term has completed. SPTs will show UNAVAILABLE if they are not active.
o For
courses that have both an instructor and an academic coordinator, PLEASE
SELECT YOUR INSTRUCTOR'S NAME WHEN COMPLETING THE SPT.
Follow
the instructions within the SPT in order to complete and submit.
If you
encounter a technical issue completing a SPT through UWinsite Student, please submit a ticket here.
Note the remaining scheduled class events can be found below. Two classes
left on Mondays Apr. 1 (SPT and Week 4 Seminar presentations), and Apr. 8 (All
Project presentations). Then, all
group/individual concluding project presentation in my office at your scheduled
time on Monday, Apr 15.
UPCOMING CLASS EVENTS
|
COURSE EVALUATION
|
Dr. Ezeife, C.
Posted Saturday, March 9, 2024
Comp 8390 Midterm Test results have been posted through the web marks
link:
https://cezeife.myweb.cs.uwindsor.ca/courses/60-539/marks/index.htm.
Great performance in Comp 8390 midterm
test by half of the the class (Well done to these students!!). However, the
lower 50% of the class who got less than 70% but more than 50% may need to review what they
need to do in the rest of the class to ensure they do not get a total course mark
of less than 70% or they may consider dropping the course. If you receive less than
50% in the course, I encourage you to drop in during my office hour to discuss.
Some of the major problems I
found while marking is lack of understanding of the data warehouse design that
I had stressed a lot in class and given several examples of. Many students were integrating two different
source databases that are computing different things into a data warehouse. For example, they have one source database
about Project and the second source database is about Inventory. It is like integrating apples and oranges,
where a simple data warehouse query to give the total number of apples in the
two source databases will be wrong because there are no apples in the second source
database. Why then do you have a data warehouse?
The other problem is many students did
not understand the main aim of the the data warehouse that must include
integration, historical and in particular aggregate attribute and all their
data warehouse queries are really not queries on the aggregate attribute but
queries like ‘give me the total number of customers in the database’. This is not really a data warehouse query as the
total number of customers in the data warehouse will be the same as the total
number of customers in the two source databases or in the case of apples and
oranges kind of source databases, the total of the one source database containing
customers. There are a lot of issues also with even Apriori and Fp-tree mining.
It is disappointing to find some
students not attempting a lot questions.
The marks are now posted on the
web through my web page marks link, below, which you can also access through
your brightspace marks link. I will bring the test papers to class for you to review,
but you need to hand them back to me after reviewing the same day in class.
https://cezeife.myweb.cs.uwindsor.ca/courses/60-539/marks/index.htm
Note that the voluntary
withdrawal date is Sunday, March 17, 2024 in case you think you cannot do well
in this class.
Summary of class performance is given below.
|
Section Comp-8390 Midter
Test Result Summary: |
|
Average Mark:
70.4% Highest
Mark: 97% (obtained by 1 student) Lowest Mark: 23% Number of
students who wrote the test: 30 Number
who got
100%:
0 ( Excellent !!!!!) Number with 90 <= mark < 100: 6
(Excellent !!!!!) Number with
50 <= mark < 80: 15 Number
with mark < 50%: 4 (talk
to me in my office hour)
|
Regarding Comp 8390 Research
Seminar Presentations
To ensure we are not wasting
time looking for how to connect your power point presentation starting this
coming Monday, March 11, 2024 in our classroom of ER 2125 at 2:30pm, I have
created an assignment link for you to go and upload your power point
presentation so you can present it from brightspace. Please, ensure you have uploaded your power
point presentation on that appropriate brightspace link before your
presentation as we will not go through switching computers, etc. We do not have any time as the sessions are
full booked with 7 or 8 presentations each day.
UPCOMING CLASS EVENTS
|
COURSE EVALUATION
|
Posted Saturday, March 2, 2024
Comp 8390 Students,
As previously announced even in
the last announcement below, our class test is to be written this coming
Monday, March 4, 2024 at 2:30pm in our regular class in ER during class time.
The test duration as in the sample midterm practice test handed out to you is 2
hours 30 minutes. I wanted a bigger room for this big class but the registrar’s
office could not find a room big enough for the two class periods. We shall try to space out as much as we can
on Monday in the class room for the test.
Below are the comments about
test I kept for you in the more course information volume 2 since the beginning
of course. We have also reviewed the
practice test I gave you in the last class and you are ready to go.
More on Test
****
Test covers materials taught in
the lecture part of course and distributed into 3 sections for i) database
foundation, ii) data warehouse, XML and NOSQL databases and iii) data mining
techniques. The sample test handed out in class is a good model with a fairly
good coverage of test materials (note that XML and NOSQL Databases are new
addition and not included in the sample test).
For section A of test, Know how
to design source data bases that are normalized, querying through Sql,
relational algebra and calculus; disk anatomy (e.g., what is a sector,
cylinder,
platter, track and give the size of a sector, what is the size of
a track, disk etc.). File organizations and Indexes etc.
For section B, know how to design data warehouses from source databases and
multi-dimensional modelling aspects of the data warehouse, data warehouse
querying. Also know the differences between components of other non-traditional
databases discussed in class (XML and NOSQL databases) and the traditional
databases.
For section C, know how to mine
association rules using the basic Apriori and FP-growth
techniques, olap querying and operations such as drill-down and
roll-up etc.
On seminars, please, find below the announcement I posted
on Feb. 18 to you that is as well in the more course information volume 2 about
seminars.
Update on seminar is that I
have created assignment links on brigtspace for you to:
1.
Upload the conference or
journal paper that you are going to present for your seminar asap and
definitely before March 7, 2024 or your grade for seminar may be affected.
2.
Download from brightspace both
seminar grading sheet and project grading sheet so that you can upload those
sheets in the appropriate links after grading is completed for both seminar
presentations and project presentations.
3.
Upload your seminar paper
summary report when done and before deadline.
4.
Upload your completed project
report that accompanies your project demo before the project demo on April 15
during your alloted time in my office.
Good Luck in your test, seminar
and project.
Dr. Ezeife, C.
Posted Sunday, February 18,
2024
Hello Comp 8390 Students,
Check the updated seminar presentation and project topic schedules through the
course web page also accessible through brightspace at: https://cezeife.myweb.cs.uwindsor.ca/courses/60-539/539index.htm.
Also, check other course upcoming events below at the end of this
announcement.
Comp-8390 class test is to be written on Monday, March 4, 2024 in our class
room in ER. Student seminar presentations begin immediately the following
Monday, March 11, 2024. Each seminar presentation takes about 20 mins, and 5
mins for questions. Seminar grading is scheduled as posted in the seminar
schedule on the course web site also accessible through your brightspace.
Students in seminar grading group A will grade seminars for students in seminar
grading group B and vice versa. Ensure that you have given every student
grading your seminar a copy of your seminar paper by Feb. 4, 2024. I will try
to create a link where you can post the link to your paper with your name, your
day of presentation and that seminar paper #.
Seminar reports are due on the day of presentation of the paper or
latest the last day of seminar presentations.
Note: seminars are graded based on clarity(2), organization(2),
quality (3), technical content(3). Ensure that your paper is not less than 9 pages
or you may need to present two such short papers.
For seminar presentation, the
goal is to focus on making clear the following:
Students are expected to grade seminar based on clarity,
organization, quality of talk and technical content. Clarity judges
how you understand what the presenter is giving from the way they present
it(not based on your lack of concentration on what they are talking about).
Organization judges how cohesive (the flow or togetherness) of the material
taught (e.g., do they clearly tell you the topic, explain the purpose before
discussing the solutions and results or do they jump in and talk of results
when you do not even know what the topic is about. Efforts put into slide
presentations also come in here). Quality of talk judges the
correctness of the presentation from the paper presented (that is, how well
does the presenter understand materials in this paper or are they providing
wrong information?). Technical content judges level of difficulty of
the paper presented and efforts put in by the student. Some students
avoid actually trying to understand and explain thetechnical solution
(algorithms) presented in the paper, but rather spend too much time discussing
purpose and performance analysis.
UPCOMING
CLASS EVENTS
|
COURSE EVALUATION
|
Posted Friday, January 5, 2024.
Hello Winter 2024 Comp 8390 Students,
Welcome and see you in class
coming Monday, Jan. 8, 2024 at 2:30pm in the ER classroom specified in
Brightspace.
Classes: Mon : 2:30 – 5:20pm in ER classroom.
Office hours: Tues. 3:00pm – 4:00pm,
If it becomes necessary to move
any class online, to attend any possible online class, Log on to Brightspace
LMS (learning management system). https://brightspace.uwindsor.ca/d2l/login.
Then, click on Virtual
classroom, and join Comp 8390 Class session for the day.
Note: Office hours will be held
in-person in my office at CS office. The following link is for joining any
MSTeams group for class or during my office hours if it becomes necessary to
move meeting online to MSTeams:
Course Web Page can be accessed through: https://brightspace.uwindsor.ca/d2l/login
Or https://cezeife.myweb.cs.uwindsor.ca/courses/60-539/539index.htm
Get the course information
through the link Course information Volume 1.
Get more course information
through the link More course information Volume 2
RECOMMENDED Materials:
C.I Ezeife, Course
Notes for Comp 8390, Non-Traditional Database Systems: Data Warehousing and
Mining, University of Windsor, Winter 2024.
Course
notes can be downloaded from the notes page of this site.
Reference Materials:
1. Jiawei Han, Jian Pei, and Hanghang Tong. Data
Mining - Concepts and Techniques, published by Morgan Kaufmann/Elsevier,
2022, Fourth Edition, isbn: ISBN 9780128117606). **** Most comprehensive and
useful to read for warehousing and mining.
2. Wilfried Lemahieu, Seppe Vanden Broucke, Bart
Baesens. Principles of Database Management: The Practical Guide to Storing,
Managing and Analyzing Big and Small Data, Cambridge University Press, 2018.
isbn: 978-1-107-18612-5. *** New book in the bookstore and useful for
the traditional database reviews and NOSQL databases.
3. Raghu Ramakrishnan/ Johannes Gehrke, Database
Management Systems, third edition, WCB/McGraw-Hill, 2003, isbn:
0-07-246563-8. ** Any other undergrad
DB book ok too, for Database overview.
4. Margaret H. Dunham, Data Mining - Introductory
and Advanced Topics, published by Pearson Education, 2003. isbn 1-13-088892-3.
(available in the library)
Research papers in Data Warehousing and Mining
from a variety of journals and conference proceedings including:
C.I. Ezeife and Yi Lu, “Mining Web Log sequential Patterns with Position Coded
Pre-Order Linked WAP-tree”, the
International Journal of Data Mining and Knowledge Discovery (DMKD),
Vol. 10, No. -, pp. 5-38, Kluwer Academic Publishers, June 2005.