Design of a Performance Evaluation Tool for Multimedia ...

Design of a Performance Evaluation Tool for
Multimedia Databases with Special Reference
to Oracle




Submitted in fulfilment of the requirements for the degree of


MASTER OF SCIENCE


By


Tonia Stakemire




Computer Science Department
Rhodes University
Grahamstown
South Africa


April 2003ABSTRACT

Increased production and use of multimedia data has led to the development of a more
advanced Database Management System (DBMS), like an Object Relational Database
Management System (ORDBMS). These advanced databases are necessitated by the
complexity in structure and the functionality required by multimedia data. Unfortunately, no
suitable benchmarks exist with which to test the performance of databases when handling
multimedia data. This thesis describes the design of a benchmark to measure the performance
of basic functionality found in multimedia databases.

The benchmark, called MORD (Multimedia Object Relational Databases), targets Oracle, a
well known commercial Object Relational Database Management System (ORDBMS) that
can handle multimedia data. Although MORD targets Oracle, it can easily be applied to other
Multimedia Database Management System (MMDBMS) as a result of a design that stressed
its portability, and simplicity. MORD consists of a database schema, test data, and code to
simulate representative queries on multimedia databases.

A number of experiments are described that validate MORD and ensure its ...