CP465 DATABASES II, WINTER 2007, WLU
- The first assignment has been handed out in class. Wed. Jan. 17, 2007
- OQL Term Project handed out in class. Mon. Jan. 22, 2007
- Data Mining Term Project handed out in class. Mon. Feb. 5, 2007
- Midterm Solutions Mon. Mar. 5, 2007
- The second assignment has been handed out in class. Mon. Mar. 12, 2007
- VLDB access: go to Trellis, search for "VLDB" journal title, click on the link "Click here for access"
- "IEEE/ACM Transactions on Networking" access: same process as for VLDB
Monday April 2, 2007:
Term project demonstrations:
Please arrange for your group to do a 45-min. term project demonstration,
this week or next week, at the latest. e-mail me the following
(1) date and time of your demonstration
(2) project title (i.e. OQL or DM)
The demonstrations will be in one of the Department labs.
All groups members must be present during the demo, to answer questions.
- Research Presentations Schedule
Monday March 26, 2007, Room BA113, 2:30-3:45 p.m.
- 2:30-2:45 Side by side comparison of current DBMS's
- 2:45-3:00 Mariposa: a wide-area distributed database system
- 3:00-3:15 The KDD Process For Extracting Useful Information From Volumes of Data
- 3:15-3:30 Exploring the tradeoff between performance and data freshness in database-driven Web servers
Wednesday March 28, 2007, Room BA113, 2:30-3:45 p.m.
- 2:30-2:45 Learning Through Data Mining
- 2:45-3:00 Indexing mobile objects using dual transformations
- 3:00-3:15 Knowledge management and data mining for marketing
- 3:15-3:30 Databases for GIS
- 3:30-3:45 Efficiently publishing relational data as XML documents
Monday April 2, 2007, Room BA113, 2:30-3:45 p.m.
- 2:30-2:45 Views as first-class citizens in object-oriented databases
- 2:45-3:00 EOS2: Unstoppable Stateful PHP
- 3:00-3:15 Data Mining Using Two-Dimensional Optimized Association Rules: Scheme,
Algorithms, and Visualization
- 3:15-3:30 An authorization system for digital libraries
- 3:30-3:45 A Database-Independent Approach of Mining Association Rules with Genetic Algorithm
- 3:45-4:00 Query optimization in XML structured-document databases
Wednesday April 4, 2007, Room BA113, 2:30-5:00 p.m.
- 2:30-2:45 Simulated Annealing for Materialized View Selection in Data Warehousing Environment
- 2:45-3:00 Efficient Hardware Data Mining with the Apriori Algorithm on FPGAs
- 3:00-3:15 Hierarchical Hippocratic databases with minimal disclosure for virtual organizations
- 3:15-3:30 On utilizing variables for specifying FDs in data-centric XML
- 3:30-3:45 Privacy leakage in multi-relational databases: a semi-supervised learning perspective
- 3:45-4:00 Outlier detection
- 4:00-4:15 Compression techniques for fast external sorting
- 4:15-4:30 Analysis of Tracking Moving Objects through Database Queries
- Instructor: Dr. Ilias S. Kotsireas,
Office: N2076A, Office Hours: 24/7 and by appointment, Phone: 884-0710 ext. 2218, E-Mail: ikotsireATwlu.ca
Ms. Wegdan Abdelsalam,
Office: N2091, Office Hours: by appointment, Phone: 519-884-1970 ext.3165, E-mail: wabdelsalamATwlu.ca
Notes & Overheads
Course Website A link to the course web page is available at:
Lecture Topics (corresponding to the 12 weeks schedule)
- Introduction, Relational Algebra, Query Processing, Query Optimization
- Lexical Analysis, Syntactic Analysis, BNF Grammars, LEX/YACC
- Object Databases, Object Database Management Systems, (ODBMSs), ODMG, Object Definition Language (ODL), Object Query Language (OQL)
- Data Mining I,
- Data Mining II,
- Data Mining III
- Web Databases, PHP, HITS/PageRank Algorithms
- XML, well-formed documents, Document Type Definitions (DTDs), XML Schemas, XML Documents, XML Databases, XML Query Languages (XPath,XQuery)
- Data Storage, Indexing Structures for Files
- Data Warehousing, OLAP, Distributed Databases
- Deductive Databases
- Research Projects Presentations
- Mon 2:30 - 3:50 Room BA113
- Wed 2:30 - 3:50 Room BA113
Winter Semester Timetable
| Mon | Wed |
| 2:30-3:50 | 2:30-3:50 |
| BA113 | BA113 |
| | |
Week 1: | --- | Jan 03 |
Week 2: | Jan 08 | Jan 10 |
Week 3: | Jan 15 | Jan 17 |
Week 4: | Jan 22 | Jan 24 |
Week 5: | Jan 29 | Jan 31 |
Week 6: | Feb 05 | Feb 07 |
Week 7: | Feb 12 | Feb 14 |
Reading Week Feb 19 - Feb 23 N o C o u r s e s
| | |
Week 8: | Feb 26 | Feb 28 |
Week 9: | Mar 05 | Mar 07 |
Week 10: | Mar 12 | Mar 14 |
Week 11: | Mar 19 | Mar 21 |
Week 12: | Mar 26 | Mar 28 |
| Apr 02 | --- |
| | |
Course Requirements/Student Evaluation
New Course Drop Dates 2006/2007:
- Assignment 1: 15% due date: Wednesday, January 31, in class or by e-mail.
- Assignment 2: 15% due date: Wednesday, March 14, in class or by e-mail.
- Midterm: 30%, Wednesday, February 28, in class.
- Term Project: 30% due date: Monday, April 2.
All students will be required to prepare a Term Project, details in class.
Students may form teams (of no more than 3 students each) to work on the Term Project collaboratively.
- Research Projects Presentations: 10%, Week 12 of courses.
All students will be required to study and understand
a research article relevant to databases research.
Half-hour presentations (20-min talk + questions/answers)
will be scheduled for the last week of courses.
Students will work on this project individually.
September 8: final day to cancel Fall term and Fall/Winter session registration with no tuition charge (cancellation fee applies)
September 22: final day to drop 12-week and fall/winter session course(s) or withdraw at 10% tuition charge
November 6: final day to drop course(s) or withdraw from 12-week course(s) without failure and for tuition adjustment
January 2: final day to cancel Winter term registration with no tuition charge (cancellation fee applies)
January 16: final day to drop 12-week winter term course(s) or withdraw at 10% tuition charge
March 6: final day to drop course(s) or withdraw from two-term or 12-week Winter term course(s) without failure and for tuition adjustment
The Academic Date section of the Calendar (Printed and Web Site Versions) clearly states the examination date period for each semester. Students must note that they are required to reserve this time in their personal calendars for the examinations. The examination period for this course is APRIL 9-27, 2007. Students who are considering registering to write MCAT, LSAT or GMAT or a similar examination, should select a time for those examinations that occurs outside the University examination period. For additional information that describes the special circumstances for examination deferment, consult the University calendar.
Student Awareness of the Accessible Learning Centre:
Students with disabilities or special needs, are advised to contact Laurier.s Accessible Learning Centre for information regarding its services and resources. Students are encouraged to review the Calendar for information regarding all services available on campus.
Academic and Research Misconduct:
Academic misconduct is an act by a student, or by students working on a team project, which may result in a false evaluation of the student(s), or which represents a deliberate attempt to unfairly gain an academic advantage. Academic misconduct includes: please refer to page 111 in the 2006/2007 Undergraduate Calendar.
Plagiarism Detection Software:
Wilfrid Laurier University uses software that can check for plagiarism. Students may be required to submit their written work in electronic form and have it checked for plagiarism.
STEP: Science & Technology Endowment Program:
The Program was established in 1995, with the opening of the New Science Building. Students in the Departments of Biology, Chemistry, Physics and Computer Science and Psychology approved a voluntary student contribution program designed to enhance educational experience and opportunities of undergraduate students in these areas. GET INVOLVED!