D6 Database Structure, API and Metadata Mapping

D6 Database Structure, API and Metadata Mapping - Linked...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Linked European Archives for Ethnomusicological Research Deliverable D6 IST-STReP-033808 April 2007 Database Structure, API and Meta- data mapping IST-STReP-033808 Deliverable D6: Database Structure, API and Metadata mapping page: 2 of 18 Project Number : IST-STReP-033808 Project Title : ethnoArc - Linked European Archives for Ethnomusicological Research Deliverable Type : Public Deliverable Number : D6 Contractual Delivery Date : April 30 th , 2007 Actual Date of Delivery : April 27 th , 2007 Title of Deliverable : Database Structure, API and Metadata mapping Contributing Work Package : WP 2 Nature of Deliverable : Report Authors : Christian Fuhrhop (FOKUS), Thomas Jenschar (FOKUS), Raju Vaidya (FOKUS) Abstract This document describes the internal database structure used to store the database description and the metadata, the API to access the data- base and the programming interface for external access to the structure and metadata for searching and metadata mapping. Keyword list metadata specification scheme, internal representation, SQL database, mapping, searching, API IST-STReP-033808 Deliverable D6: Database Structure, API and Metadata mapping page: 3 of 18 Contents 1. INTRODUCTION ........................................................................................................................................... 4 2. DATABASE STRUCTURE............................................................................................................................ 5 2.1 CREATION OF TABLES IN THE SQL DATABASE................................................................................................... 5 2.2 TABLE DATABASEDESCRIPTION...................................................................................................................... 5 2.1 EXAMPLES.......................................................................................................................................................... 7 2.2 TABLES CREATED FOR OBJECTS.......................................................................................................................... 8 2.3 TABLES CREATED FOR RELATIONS ..................................................................................................................... 8 3. API FOR LOCAL DATABASE ACCESS.................................................................................................. 10 3.1 CONFIGURATION OF THE DATABASE ACCESS FOR THE ETHNOARC DATABASE TOOLS.................................. 10 3.2 ACCESSING THE DATABASE STRUCTURE......................................................................................................... 11 3.3 MODIFYING DATABASE CONTENT ................................................................................................................... 13 4. INTERFACE FOR EXTERNAL SEARCH AND METADATA MAPPING........................................ 14 4.1 WEB SEARCHES ................................................................................................................................................ 14 WEB SEARCHES ....
View Full Document

This note was uploaded on 11/22/2009 for the course HR GM600 taught by Professor Na during the Spring '09 term at Keller Graduate School of Management.

Page1 / 18

D6 Database Structure, API and Metadata Mapping - Linked...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online