SIMS-IS146 – 05.04.2005 1

Databases

Visual material used from the film Dpoo Mezzanotte (2004) and the Museo Nationale Del Cinama – Torino (http://www.museonazionaledelcinema.org//

2SIMS-IS146 – 05.04.2005

Storage Paradigm

Request

Retrieve

Title: The Magic MountainAuthor: Thomas MannPublisher: FisherType: Novel

Title: ……Author: ……Publisher: …..Type: …..

Title: ……Author: ……Publisher: …..Type: …..

Database (a collection of records)

Fields (individual elements of information)

Records (a collection of fields)

3SIMS-IS146 – 05.04.2005

Narrative

Flexible

Fixed with respect to medium and presentation

A narrative is a story or part of a story presented from the viewpoint of one of the (possibly fictional) participants or observers.

4SIMS-IS146 – 05.04.2005

Database

A database is an information set with a regular structure.

Information set(theoretically unlimited)

Information set(limited ?)

Extract

Interact

5SIMS-IS146 – 05.04.2005

Database

A database is an information set with a regular structure that facilitates the exploitation of the stored items.

Information set(limited ?)

Interact

Item Data

Metadata

Structure

Process

Hierarchical (XML, MPEG-7)

Relational (RDF)

Object-Oriented

TXT,GIF, JPG, MOV, MPEG, etc.

Make use of ….…. to combine or manipulate

6SIMS-IS146 – 05.04.2005

Database – unstructured content

Task: build something funny

Start here

7SIMS-IS146 – 05.04.2005

Database - Access

Mis-en-Scene• Materiality • Organisation of internal space • Organisation of external space • Setting • Costumes, make-up• Emotional expressions• Lighting and colour design

Duration• Structure

8SIMS-IS146 – 05.04.2005

Database – Reflects the process in the content

Associative (Paradigmatic) Axis

Syntagmatic Axis A

C’’

C’

B C D E

C’’’

9SIMS-IS146 – 05.04.2005

Database – Process guided Access

Processes (e.g. story building,material collection, material manipulationmaterial presentation)

Mis-en-Scene• Materiality • Organisation of internal space • Organisation of external space • Setting • Costumes, make-up• Emotional expressions• Lighting and colour design

Duration• Structure

10SIMS-IS146 – 05.04.2005

Database – Generative Structure

Mis-en-Scene• Materiality • Organisation of internal space • Organisation of external space • Setting • Costumes, make-up• Emotional expressions• Lighting and colour design

Duration• Structure • Role in discourse

11SIMS-IS146 – 05.04.2005

Creative Environment - automatic

Retrieval System

conceptual link information flow

Knowledge Base

Semantic net

Editor

Content Planner

Visual Designer

Structure Planner

Visual Constructor

DB

DB

Video material

Video representation

Development Tools

Filmic and editingknowledge

Inte

rfac

eRetrieval System

conceptual link information flow

Knowledge Base

Semantic net

Editor

DB

DB

Development Tools

Inte

rfac

e

Details in Nack 1996

12SIMS-IS146 – 05.04.2005

Creative Environment – semi-automatic

Details in Nack and Putz 2001.

13SIMS-IS146 – 05.04.2005

Database - Questions

Is a database passive, active or interactive?

Does a database contain meaning or knowledge?

Is a database finite?

Is a database a semiotic space?

What is the relation between point-of-view and multi-user with respect to media databases?

14SIMS-IS146 – 05.04.2005

Next Lecture – 7th of April

Places and CyberspacesGuest Lecture By: Prof. Yehuda Kalay, UC Berkeley Department of Architecture and Director of the UC Berkeley Center for New Media

Readings:Steve Harrison and Paul Dourish. Re-Place-ing Space: The Roles of Place and Space in Collaborative Systems. In: Proceedings of ACM Conference on CSCW. New York: ACM Press, 1996, p. 67-76.