Database Design

AusStage solves a fundamental problem for research on live performance. Any one who’s interested in theatre, dance, opera or musicals probably has a collection of programs, flyers, advertising, and ticket stubs, perhaps newspaper clippings of articles, photographs, reviews and the like. In themselves, these ephemera are not especially valuable. For the most part, these collections remain hidden, under the bed, stuck in a drawer, tucked away in a shoe box. But taken together, as a collection, they attest to the experience of what happened in the theatre. They are tokens of our participation in the culture of live performance.

AusStage began by asking what if all those programs, flyers, ticket stubs, newspaper clippings and so on were combined into a collection that everyone could share? What kind of knowledge about performance could we then accumulate and create? That’s the basic idea – a national repository of performing arts information – a collaboratively constructed, freely accessible, relational database – a network of performance researchers from universities, collections, industry organisations and government agencies sharing their knowledge, pooling their experience and expertise.

The Event Index

At the heart of AusStage is a relational database of live events, built using data models designed for recording information about the performing arts.

The Event table in AusStage records distinct happenings, defined by title, date and venue; typically, a performance or series of performances at a venue. This is AusStage’s core table and the main focus for data entry activity. The basic information required to create an event record is the name of the event, the venue, the date, the primary genre, and the status of the event. Other information may also be recorded, such as contributors and organisations associated with the even, and further details on content, genre, information sources and related resources.

Three other tables record vital information relating to events:

There are two categories of data entry: prospective entry of data on current events and retrospective entry of data on past events. This distinction is important because the data-collection techniques vary. Prospective data on current events have been collected since 1 January 2001 from a variety of publications by personnel working various locations around Australia. Our strategy for sustaining prospective data entry places an emphasis on professional production and government-funded organisations.

Retrospective data collection on past events uses other sources and will take many years to complete. The sources for retrospective data are dispersed in a variety of locations. We approach retrospective data entry by identifying blocks of data that can be mined for information. A block of data is a collection of programs or reviews or articles in one location. Thus each library, museum or company can provide us with many blocks of data. The three blocks we began with were:

AusStage continues to work with many collections and organisations to add data on past events to AusStage. We encourage contributions from users. Contact us if you would like to add data to AusStage. We provide training and support to enable artists, researchers and organisations to enter data.

Resource Directory

How do people research the performing arts in Australia? With so many significant collections, both large and small, how do they find what they're looking for?

AusStage can help users find items in collections. Whether searching for people, venues, organisations or productions, AusStage can direct users to digital resources and material objects in libraries, archives and museums.

The Resource Directory is a data set of information on collections, items and resources related to Australia's performing arts heritage. Its core records are bibliographic citations of newspaper articles and theatre reviews. But we have expanded it to accommodate descriptions of a wide range of resource types: text, pictures, sound recordings, moving images, physical objects, digital resources and so on that relate to an event, or to contributors, organisations, venues and so on. The resource table also integrates records describing whole collections of performing arts material in publicly accessible archives, libraries and museums.

The Resource Directory is used by researchers in universities and collections, government agencies and industry organisations. Its aim is to provide information on where research resources are located. It allows a search of relevant source material without the immediate need for extensive travel. Such an extensive listing of these resources has not previously been attempted or made available online. In this way, AusStage assists researchers in discovering and accessing the rich history and heritage of the performing arts in Australia, improving opportunities for research and education, and increasing the visibility and accessibility of performing arts collections.

The Resource Directory supports discovery and access to items in collections in various ways by:

The Resource Directory is built upon the Dublin Core Metadata Element Set. It supports an extensible array of resource types and description styles, including collection-level, item-level, and bibliographic descriptions. Resource records are integrated into AusStage through associations with records in the Event, Contributor, Organisation, Venue, Content Indicator, Secondary Genre and Resource tables. Resource records may also link externally to online resources using persistent URLs. AusStage exports and imports in XML and other text formats so that metadata can be shared with digital repositories and catalogues.

We encourage contributions from users. Contact us if you would like to add resources to AusStage.