Introduction to the database and digital platform

Musical MC2

Marguerite Chabrol & Gaétan Darquié

June 11, 2016 | Fondation des Etats-Unis (Cité internationale universitaire)

Labex Arts-H2H Investissement d'avenir Labex Arts-H2H

This project is supported by the Labex Arts-H2H and benefits from financial support from the ANR as part of the “Investments for the future” program (ANR-10-LABX-80-01).

Summary

  • Data
  • Exploitation
  • Editor
  • Next steps

1. Data

Data modelisation

Schéma de base de données

Data sources

  • MC2 homemade data (CSV from google spreadsheet)
    • 40 films
    • 477 numbers
    • 384 songs
  • IMDB (OMDB API) : 1200 films
  • IBDB : 2662 stage shows

Data Import

SQL database - 20184 rows

  • completeness (>number)
  • costumes (>number)
  • dancing (>number)
  • ensemble (>number)
  • film
  • integration (>number)
  • mood(>number)
  • number
  • quotation (>number)
  • person (>film)
  • profession
  • social place(>number)
  • song(>number)
  • stage show

  • person (>number)

2. Exploitation

Imported data - first stats

Web application

3. Editor

Last Year Demo - december 2015

First Editor Prototype

Current version

Local demo

4. Next steps

New fonctionnalities

  • Further development for the editor
    • New roles : student, editor, etc.
    • Data validation system
    • Add files system (picture, import csv?)
    • Database options (timestamp)
    • Webmail inscription
  • New explorator scenarii (december)

Editor released date

  • Tests : July & August
  • Released : End of August/Start of September

Thank you

gaetan.darquie@gmail.com

@gaotian