The paper describes a database tool for the management of multimedia assets in a title-production environment. The tool was developed in the context of creating an interactive multimedia program on the life and work of the poet W.B. Yeats. The approaches and lessons described have general application in multimedia title-development environments and will be of interest to any involved in electronic publishing.
Developing multimedia titles necessarily involves the collection of information in a variety of formats: text, still and animated graphics, photographs, video and sound. If the scale of a project is large, managing such resources, or 'assets', can be problematic. This paper describes one approach to the cataloguing and management of assets which has general applicability to the multimedia title development process. As such, it should be of interest to any involved in electronic publishing.
The work referred to in this article was carried out as part of a larger multimedia guidelines research programme, as aspect of which is the production of a teaching resource on the life and works of the Irish poet, W.B. Yeats. The resource is being designed as an introductory program, suitable for use in second- and third-level English Literature courses. The production of the tool for cataloguing and managing resources was a by-product of the initial stages of this work. The research catalogue will be published at a later date in both paper and interactive versions and will be useful in the production of future multimedia, radio or television programmes relating to Yeats.
Because of the need to manage large numbers of multimedia files and the relevance of this topic to title production generally, a multimedia asset research and management database tool was developed.
Because multimedia publishing is a young field and commercially sensitive, the published literature on multimedia production processes is not yet substantial. Some key published references are Bunzel (1994), Hoffos (1992), Howard (1992), Mallon (1994), Philips (1992). And, as in film and television, most multimedia title production operates in a 'seat-of-the-pants' fashion,Ñdevelopers often responding to each project's requirements in an ad hoc manner, according to the development team's composition and experience. It is possible, however, to break down the production process into a sequenced structure of key tasks, even if many counter-examples will be found in practise.
As in film and television, the multimedia title-development process can be divided into three phases: Planning, Production and Post-production.
Who will use the database? The project research assistant, program designer, graphic designer, audio-visual designers/production engineers. Who designs the database? The project manager/interactive designer and research assistant. Who is responsible for maintaining the database? The research assistant. How will the database be used?
To enable the user to
Figure 1
Options at bottom left of screen:
A field omitted from the original design but ultimately considered desirable was one for file resolution. For example, sound files were stored as 16-bit 22kHz AIFF files, many graphics as 16-bit, 240 pixels high x 480 pixels wide PICT images. This information was listed in the product specification.
The Database in Practice
The finished database tool performed well in practice. A number of fields were not utilised as we had anticipated they might be in planning the database structure, particularly the "contacts", "list", "files" and "archived" options. The fact that they were not used extensively in this project, however, does not preclude the need for them in some future project.
The "find" facility proved to be sufficent for most of the team's needs but could not handle looking for multiple entries. This would need to be corrected in any future version.
Conclusions
The electronic publishing industry is expanding exponentially, and interactive multimedia title production grows according, pushing publishers towards the production of new styles of publication with unprecendented capacities for lower-cost, higher-volume data and for diverse media types. How multimedia assets are collected, collated, recorded and managed can significantly influence the title production process, making a difference between projects coming in on time and ones running over because of lost information, duplication of effort, or data-transfer bottlenecks between production team members.
This article has concentrated on highlighting these problems and suggesting how best to avoid them. The multimedia database management system described has been designed to serve the needs of a particular project, the life and works of Yeats; its approaches and lessons, however, apply to the production of any multimedia title involving large numbers of assets.