Course Title: File Structures and Database Systems

Part A: Course Overview

Course Title: File Structures and Database Systems

Credit Points: 12


Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

ISYS2090

RMIT Intl University Vietnam

Undergraduate

140H Comp Sci & Info Technology

Face-to-Face

Viet2 2014,
Viet1 2015,
Viet3 2015

ISYS1066

Bundoora Campus

Undergraduate

140H Comp Sci & Info Technology

Face-to-Face

Sem 2 2006

ISYS1065

City Campus

Postgraduate

140H Comp Sci & Info Technology

Face-to-Face

Sem 1 2006

ISYS1067

City Campus

Undergraduate

140H Comp Sci & Info Technology

Face-to-Face

Sem 1 2006

Course Coordinator: Falk Scholer

Course Coordinator Phone: +61 3 9925 9831

Course Coordinator Email:fscholer@cs.rmit.edu.au


Pre-requisite Courses and Assumed Knowledge and Capabilities

You should understand fundamental relational database concepts, including relational modelling and design, relational algebra, SQL, and conceptual modelling, equivalent to 004083 Database Concepts.  
You should also have extensive programming skills in the C language and knowledge of advanced data structures and algorithms, equivalent to 004302 Algorithms & Analysis.  


Course Description

This course is the second and final compulsory database course. The course aims to broaden knowledge of the implementation of database systems and to introduce emerging database technologies such as information retrieval. File structures and indexing are discussed, and analytical details presented, that enable students to understand efficiency in query evaluation. The idea of the transaction is introduced along with the necessity of concurrency control and serialisability. Issues of backup and recovery for databases are discussed.


Objectives/Learning Outcomes/Capability Development

On completion of this course you should have gained a good understanding of the file structures and advanced concepts in database systems. Specifically, you should be able to:
• Identify and analyse suitable file structures and indexing techniques for different database systems
• Apply query evaluation, processing, and optimisation techniques in database applications to improve the query processing
• Analyse transaction processing, concurrency control, and recovery techniques in database systems
• Apply information retrieval techniques to efficiently retrieve documents from large text collections.





Overview of Learning Activities

Syllabus material will be presented, explained and illustrated with demonstrations and examples in lectures, classes, or online. Completion of tutorial questions, and laboratory programming exercises and projects, are designed to give further practice in the application of theory and procedures, and to give feedback on your progress and understanding. Private study will consolidate your understanding of the theory and practice.


Overview of Learning Resources

Lists of relevant textbooks, reference texts, resources in the Library and relevant internet sites will be provided.


Overview of Assessment

The assessment for this course comprises practical work involving the development of computer programs, class tests, and a final exam.