Enterprise Data Management

University of Otago

Course Description

  • Course Name

    Enterprise Data Management

  • Host University

    University of Otago

  • Location

    Dunedin, New Zealand

  • Area of Study

    Computer Info Systems, Information Sciences

  • Language Level

    Taught In English

  • Prerequisites

    INFO 211 and (INFO 212 or INFO 214)

  • Course Level Recommendations

    Upper

    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.

    Hours & Credits

  • Credit Points

    18
  • Recommended U.S. Semester Credits
    3 - 4
  • Recommended U.S. Quarter Units
    4 - 6
  • Overview

    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.

    Teaching Arrangements
    Three 1-hour "lectorial" (part lecture, part tutorial) classes per week
    One 2-hour computer laboratory class per week

    Course Structure
    The paper focuses on four main topic areas:
    - Database programming
    - Database administration
    - Data warehouses
    - Managing "big data" (NoSQL, NewSQL, etc)

    Learning Outcomes
    - 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

Course Disclaimer

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.