Enterprise Data Management
University of Otago
Dunedin, New Zealand
Area of Study
Computer Info Systems, Information Sciences
Taught In English
INFO 211 and (INFO 212 or INFO 214)
Course Level Recommendations
ISA offers course level recommendations in an effort to facilitate the determination of course levels by credential evaluators.We advice each institution to have their own credentials evaluator make the final decision regrading course levels.
Recommended U.S. Semester Credits3 - 4
Recommended U.S. Quarter Units4 - 6
Hours & Credits
A study of data management practices in the context of large-scale enterprise information systems, from both an administrative and a technical perspective.
Data are a critical corporate resource, so the design, construction and management of the corporate database is of strategic importance to any organisation. The paper prepares students for the world of enterprise-scale data management.
Three 1-hour "lectorial" (part lecture, part tutorial) classes per week
One 2-hour computer laboratory class per week
The paper focuses on four main topic areas:
- Database programming
- Database administration
- Data warehouses
- Managing "big data" (NoSQL, NewSQL, etc)
- Design and implement a server-side application programming interface(API) for a database
- Analyse the performance of a database system to identify potential problem areas and then choose, implement and test appropriate database tuning solutions
- Identify and explain the roles and responsibilities of a database administrator
- Identify potential database hazards and suggest ways to avoid or reduce the impact of these hazards and recover from them
- Create a simple data warehouse and perform analytic queries on it
- Identify and explain the differences between "traditional" database management systems and more recent NoSQL and NewSQL DBMSs and when each should be used
Courses and course hours of instruction are subject to change.
Eligibility for courses may be subject to a placement exam and/or pre-requisites.
Some courses may require additional fees.
Credits earned vary according to the policies of the students' home institutions. According to ISA policy and possible visa requirements, students must maintain full-time enrollment status, as determined by their home institutions, for the duration of the program.
Please reference fall and spring course lists as not all courses are taught during both semesters.
Availability of courses is based on enrollment numbers. All students should seek pre-approval for alternate courses in the event of last minute class cancellations
Please note that some courses with locals have recommended prerequisite courses. It is the student's responsibility to consult any recommended prerequisites prior to enrolling in their course.