307773 (v.2) Datamining and Advanced Database Management 601
| Area: | School of Information Systems |
| Credits: | 25.0 |
| Contact Hours: | 4.0 |
| Lecture: | 1 x 2 Hours Weekly |
| Laboratory: | 1 x 2 Hours Weekly |
| Syllabus: | Architecture of a DBMS. Designing constraints and structures for database access - index, hashed cluster, tablespace. Loading and establishing data integrity. Concurrency control. Optimisation techniques. Mining a database for useful information, data warehousing. Designing database for e-commerce. |
| |
| Unit Outcomes: | On successful completion of this unit students will be able to - Design methods and rules for databases and standards for loading database tables. Illustrate an in-depth knowledge of optimization and the concept and principle method of embedded SQL. Apply data warehousing and data mining to enterprise database environments. Design a database for an electronic commerce environment. |
| Text and references listed above are for your information only and current as of September 30, 2003. Please check with the unit coordinator for up-to-date information. |
| Unit References: | Date, C.J., (1991), An Introduction of Database Systems, Vol I and II, 5th ed., Mass, Addison-Wesley. McFadyen,R. and Kanabar, K., (1991), An Introduction to Structured Query Language, Wm. C. Brown, Dubuque. Koch, G. and Loney, K., (1997), Oracle 8 - TheComplete Reference, NY, Osboren McGraw-Hill. |
| Unit Texts: | Hotka, Dan, 2000, Oracle Unleashed (3rd Ed.), SAMS Publishing Company Inc. |
| |
| Unit Assessment Breakdown: | Examination 50%. Presentation 20%. Written Assessment 30%. This is by Grade/Mark assessment. |
| Year | Location | Period | Internal | Area External | Central External | | 2004 | Bentley Campus | Semester 2 | Y | | | |
Current as of: February 2, 2004
CRICOS provider code 00301J
