Design and implementation of a multimedia DBMS: modification and deletion

Abstract

At the Naval Postgraduate School, computer science students are currently working on a multimedia database management (MDBMS) project. This prototype designed in 1988, has the ability to capture, store, manage, retrieve and present both standard data, like alphanumerics and numerics, and media data. Media data in this thesis refers to graphics, signals, sound and image and is stored using the abstract data type (ADT) concept. The MDBMS is built upon a conventional INGRES DBMS using ADT's. The multimedia database management system (MDBMS) can integrate audio, image and formatted data so that these forms of data can process in the following ways: create tables, insert, delete, and retrieve. A complete database management system, requires deletion and modification operations to remove data already stored in a MDBMS or modify data in MDBMS storage. Formatted data is passed directly to INGRES for all types of processing. However, the inclusion of media data types in the MDBMS requires additional data structures and applications for modifying data that the INGRES catalog management cannot process directly. the special handling, SQL operations required to process data are discussed. This thesis concentrates on the design and implementation operations for deletion and modification of formatted and unformatted data in the MDBMS.