Archive for the 'Digital Technologies' Category

CAARP schema

The basic tables in CAARP are:

* film
* film_title
* film_production_company
* collections
* comment_search
* entity_role_links
* entity_roles
* program_extra_activities
* record_type
* user_role
* url
* user_roles
* company
* film_genre
* genre
* film_country_origin
* country
* state
* language
* film_distributor_company
* comments
* film_release
* sub_dub_sil_sound
* screenings
* screening_type
* billing
* venue
* venue_details
* cit_sub_country
* primary_purpose
* advanced_search
* sound_silent

A full breakdown of the tables is contained in this pdf document:

CAARPDatabaseSchema

Advertisements

Bonza – tables

Main tables for Bonza (further details below)
• PERSON
• COMPANY
• VENUE
• PRODUCTION TITLE
• REFERENCES

Other tables around these describe:
Notes, Roletypes, Images, Country.

There are also tables to do with those who add to the database and tracking their actions.

Database Summary of Purpose
The database was originally created to list references to different people, films and TV productions. The database has since been refurbished to list companies, and venues as well as references, people, and productions.

Bonza was set up by academics in the Media Studies department of RMIT University as a teaching and learning resource with a view to providing students an opportunity to record their research and make it publicly accessible. It had the added effect of allowing detailed referencing in the production of their online essays (and thereby, hopefully, reducing descriptiveness). The database allowed students to link their bibliographic and production references to entries already recorded in the database.

The main tables all include comments fields that allow the user, and subsequent users, to make comments on the particular person, reference, venue, company, or production.

Full list of Tables

Roletype
The roletype table is used to link with the person and company tables to provide lists for the different kinds of roles people/companies undertake in relation to a production reference.

For example the roletype table enables you to list John Smith as a ‘Gaffer’ within a production title.

If John Smith ran his own production design company, the roletype field allows you to list him as the ‘Owner’ of the company.

John Smith’s production company can be listed as a ‘production company’ within a production title.

Continue reading ‘Bonza – tables’

inventory of the datasets used

Dear Homer database-builders/users 

We have been asked to prepare a report for the Homer meeting in December about the databases used in our projects. That’s why we would like to know more about your database, so we can compare it with the other systems in use. It will be appreciated greatly if you could provide some basic information about the structure of your database. Our key question is:Which tables are central to your database, and how would you describe the most important fields or features of each table? To give you an example, below follows  a short description of the Cinema Context, a website and research tool for the history of film culture in The Netherlands from 1896.

We will sort out your answers and distill the main points for discussion at the meeting.  We know all about time constraints but please try to get back to us before December 5th. We need some time to go through your answers and compare them.

Thanks,

Karel and Clara

Example: Cinema Context, a website and research tool for the history of film culture in The Netherlands from 1896.

 General observations:

– The most important tables of Cinema Context have an identifier (ID): a unique number to identify each record.

– Most tables have a link to a table with information about publications and archives to document the data.

– The join tables are not mentioned in this report.– Almost all tables have a field for additional remarks and information.– While the number of tables is limited, the complexity resides in the many links between the tables.

The data model reflects the social network of film culture.  

1. Movie theaters.

1.1. Table Cinema Address describes the location of a venue or an event: city, street, geographical coordinates. The address can be the site of a theater building or an open space like a market place or a fair ground where films are shown in a tent. The table has a link to the table Construction History. Each address has its own ID.

1.2. Table Cinemas has the name of each individual cinema building at a particular location. It has a link to the tables Cinema Address, Cinema Active Period, and Cinema Capacity. Each cinema has its own ID.

1.3. Table Cinema Active Period tells you when a particular cinema opened its doors and when it was closed.

1.4. Table Cinema Capacity describes the number of seats in a cinema and specifies in which year this number became effective.

1.5 Table Construction History lists the main phases in the construction and renovation of the building(s) on a site. It records the year when a new phase started, and gives a brief description of the phase. It has a link to the architect as well as the owner of the building in the table Persons or Companies. 

 2. Film programmes.

2.1. Table Programmes lists the films and live performances of a complete show at a particular venue on a certain date. It also records the order in which the items appeared in the programme. The table consists mainly of links to other tables. It has a link to the table Programme Films to specify the film titles. Similarly, it links to the table Programme Live Performance to specify each stage action. When the films are shown in a regular movie theater building, the table has a link to the table Cinemas. When the event takes place in a temporary facility like a mobile cinema booth at the fair ground, this table has a link to the table Cinema Address and to the table Companies (to identify the corporation who runs the show). Each programme has its own ID.

2.2. Table Programme Films specifies the film titles of the programme with links to the table Titles.

2.3. Table Programme Live Performance specifies the live acts of the programme. The performances are described rudimentary for the moment. 

3. Films.

3.1. Table Titles gives a short description of each film, including the original film title, the country of production and the year of its first release. It has a link to the Internet Movie DataBase for further details about film credits. It also has a link to the table TitleVariations and to the tables Companies and Persons to register the local distributor of the film. Each film has its own ID.

3.2. Table TitleVariations describes the alternative titles of a film used during its history of distribution and exhibition. In particularly, translations of a film title are recorded.  

4. People.

4.1. Table Persons is a listing of individuals involved in the exhibition and distribution of films. It records first name, last name, dates of birth and death. Each individual has its own ID.

 5. Companies.

5.1. Table Companies registers each corporation involved in the exhibition and distribution of films. It describes the name, its legal seat, legal form, date of establishment. It has links to the table Management as well as Daughter Dompanies. Each corporation has its own ID.

5.2. Table Management specifies the company’s management and owners, detailing when they began and ended their involvement in the company.

5.3. Table Daughter Companies specifies the daughter companies, including dates and shares of active ownership.  

Discussion coordinated by Karel Dibbets and Clara Pafort-Overduin


October 2017
M T W T F S S
« Dec    
 1
2345678
9101112131415
16171819202122
23242526272829
3031