This paper is on Blackboard. If you can't access this paper in Blackboard, please contact the teaching team ASAP.
This paper explores the practical and theoretical concerns of modern approaches to database technologies. It falls into the following three parts:
- Part I introduces the data models developed for databases.
- It covers the hierarchical model, network model, relational model, and the new data models for non-relational database.
- Part II provides two practice sessions on database administration.
- The first session will introduce the administration of a NoSQL database (Cassandra) and its data replication strategies. The second session will introduce the installation and configuration of MySQL, work on resource, data integrity and security management, and design solutions relating to every-day tasks which might be encountered by a working DBA.
- Part III covers advanced database technologies and the current research and a few practical exercises.
- The topics include distributed databases, data mining, time-series databases, key-value stores, graph databases, and embedded databases.
Lectures and Labs
Time and venue: 10am-11:50am, Monday.
At the RED level, lectures and labs will be delivered online.
Lecture slides will be made available in Blackboard as the semester progresses.
Use of the user account you have been given by the department implies acceptance of, and agreement to abide by, departmental regulations, as well as official Otago University computer user policies. You may read more by accessing the information (and following the links) on our information pages on our departmental web site
We need at least one class representative, preferably two. Please give some thought to serving your class in this capacity. We really do want to receive useful feedback on how the paper progresses.
Academic Integrity and Academic Misconduct
Academic integrity means being honest in your studying and assessments. It is the basis for ethical decision-making and behaviour in an academic context. Academic integrity is informed by the values of honesty, trust, responsibility, fairness, respect and courage. Students are expected to be aware of, and act in accordance with, the University’s Academic Integrity Policy.
Academic Misconduct, such as plagiarism or cheating, is a breach of Academic Integrity and is taken very seriously by the University. Types of misconduct include plagiarism, copying, unauthorised collaboration, taking unauthorised material into a test or exam, impersonation, and assisting someone else’s misconduct. A more extensive list of the types of academic misconduct and associated processes and penalties is available in the University’s Student Academic Misconduct Procedures.
It is your responsibility to be aware of and use acceptable academic practices when completing your assessments. To access the information in the Academic Integrity Policy and learn more, please visit the University’s Academic Integrity website or ask at the Student Learning Centre or Library. If you have any questions, ask your lecturer.