Database Technology

Course aim

To introduce techniques used in web data management and databases, including XML, distributed databases, data warehouses, data mining and other special databases.

Course content

PRINCIPLES AND CONCEPTS OF TRANSACTION MANAGEMENT:- Transaction management and concurrency control in databases.
DISTRIBUTED DATABASE SYSTEMS:- Architecture; fragmentation and allocation; distributed transaction management; design of distributed databases, client-server architecture.
DATA WAREHOUSES:- Architecture, design and use of data warehouses, data mining techniques.
TEMPORAL DATABASES:- Transaction time and valid time, temporal query languages, implementation of temporal databases (attribute-versioning, tuple-versioning).
ACTIVE DATABASES: - Event-Condition-Action paradigm, database triggers, coupling modes, types of events.
DATA ON THE WEB: - Xquery, database support for XML-data.

Textbook(s)

T. Connolly and C. Begg 2009, Database Systems: A Practical Approach to Design, Implementation, and Management, 5th, Addison Wesley IBSN 978-0-321-60110-0.

Prerequisite(s)

Common to all relevant programs
Subject Area & Catalogue Number	Course Name
INFS 1019	Web and Database Development

Corequisite(s)

Nil

Teaching method

Component	Duration
INTERNAL, MAWSON LAKES
Lecture	2 hours x 13 weeks
Tutorial	1 hour x 13 weeks
Computer Practical	1 hour x 11 weeks
INTERNAL, OFFSHORE, SEPANG INSTITUTE OF TECHNOLOGY
Lecture	2 hours x 13 weeks
Tutorial	1 hour x 13 weeks
Computer Practical	1 hour x 11 weeks
EXTERNAL, MAWSON LAKES, DISTANCE EDUCATION
External (online materials)	N/A x N/A
External (moderated discussion boards)	N/A x N/A
INTERNAL, OFFSHORE, HELP COLLEGE OF ARTS AND TECHNOLOGY
Lecture	2 hours x 13 weeks
Tutorial	1 hour x 13 weeks
Computer Practical	1 hour x 11 weeks
INTERNAL, OFFSHORE, HELP COLLEGE OF ARTS AND TECHNOLOGY (INTENSIVE)
Lecture	4 hours x 7 weeks
Tutorial	2 hours x 7 weeks
Computer Practical	2 hours x 6 weeks

Note: These components may or may not be scheduled in every study period. Please refer to the timetable for further details.

Assessment

Assignment 1, Assignment 2, Examination, Tests (in tutorials), Tests (on-line)

Fees

EFTSL*: 0.125
Commonwealth Supported program (Band 2)
To determine the fee for this course as part of a Commonwealth Supported program, go to:
How to determine your Commonwealth Supported course fee. (Opens new window)

Fee-paying program for domestic and international students
International students and students undertaking this course as part of a postgraduate fee paying program must refer to the relevant program home page to determine the cost for undertaking this course.

Non-award enrolment
Non-award tuition fees are set by the university. To determine the cost of this course, go to:
How to determine the relevant non award tuition fee. (Opens new window)

Not all courses are available on all of the above bases, and students must check to ensure that they are permitted to enrol in a particular course.

* Equivalent Full Time Study Load. Please note: all EFTSL values are published and calculated at ten decimal places. Values are displayed to three decimal places for ease of interpretation.