Repository of group MELODY for the "Graph Databases" course, A.Y. 2024/2025.
Graph Databases is a course of the Master Degree in Computer Engineering of the Department of Information Engineering, University of Padua, Italy.
Graph Databases is part of the teaching activities of the Intelligent Interactive Information Access (IIIA) Hub.
| Surname | Name | |
|---|---|---|
| Di Martino | Ludovico | ludovico.dimartino@studenti.unipd.it |
| Galli | Filippo | filippo.galli@studenti.unipd.it |
| Rigobello | Manuel | manuel.rigobello@studenti.unipd.it |
The goal of the project is to create a graph database containing information about the most popular weekly songs from 1958 to the present. This data will be gathered from various datasets. With this information, it will be possible to make evaluations, for example, on song duration, key used, etc.
MELODY repository
│
└───csv # the csv datasets used
│
└───OntologyDesign # the ontology design diagram and turtle file
│
└───PopulateRDFdb # the python notebooks and output turtle files to populate the db
│ │
│ └───PopulateGenres
│ │
│ └───PopulateGrammyCategories
│ |
│ └───PopulateSongs
│
└───Queries # some example queries
|
└─── README.md
- Grammy dataset: https://www.kaggle.com/code/rajnaruka0698/the-grammy-arwards-analysis/input
- MusicOSet dataset: https://marianaossilva.github.io/DSW2019/#tables
Download melody-ontology.ttl and import it in Protégé to see the skeleton ontology (TBox).
To see the populated ontology import melody-ontology.ttl in GraphDB along with melody-complete-rdf-dataset.ttl containing the data (ABox).
Some example queries are provided and can be run in GraphDB.
Optional. If you want to validate the data with SHACL or add new data, enable the shacl validation in GraphDB and import the SHACL shapes files in GraphDB (see https://graphdb.ontotext.com/documentation/10.8/shacl-validation.html).
All the contents of this repository are shared using the Creative Commons Attribution-ShareAlike 4.0 International License.
