DDMAL / linkedmusic-datalake

To create mapping strategies for various music databases into our data lake
https://virtuoso.staging.simssa.ca
0 stars 4 forks source link

Modify or refine the Wiki "Several-Ways-of-CSV-to-Virtuoso-LinkedData..." #103

Open candlecao opened 3 months ago

candlecao commented 3 months ago

The wiki to be modified: https://github.com/DDMAL/linkedmusic-datalake/wiki/Several-Ways-of-CSV-to-Virtuoso-LinkedData%E2%80%90%E2%80%90Account-for-%5BMethod-II%5D-we-are-using-currently.

candlecao commented 3 months ago

CSV2RDF

  1. How many methods?
  2. Their respective pros and cons.
  3. How to use those method?
  4. What are we currently using, why?
candlecao commented 2 months ago

Hi Ich. @fujinaga I just have updated the documentation of "CSV2RDF into Virtuoso" to the main branch. Please navigate to csv2rdf > documentation_HowToConvertCSV2RDFIntoVirtuoso > Documentation_CSV2RDF_Virtuoso.docx.

Please know that I divided the former Method 1 into 2 methods: (1) Virtuoso Conductor + SPARQL (2) ISQL of Terminal + R2RML

Then please review 6.2.1, 6.2.2 in the document.

Thank you!

candlecao commented 2 months ago

@dchiller Hi Dylan, I just added a folder with documentation and some other files for reference to main branch. You may notice that. Thanks.

dchiller commented 2 months ago

@candlecao Do we have a cloud version of Virtuoso currently installed? I'm wondering if I can follow along your instructions without installing virtuoso locally...

candlecao commented 2 months ago

Yes, we have. Here: https://virtuoso.staging.simssa.ca/. UserName: dba, Password: mysecret But if you are not at DDMAL office site, you will have to use VPN to access that.

dchiller commented 2 months ago

Thank you!

candlecao commented 2 months ago

To get a further absolute conclusion--which is the best way, we need further experiments about using R2RML in the future. Just hold on.