search

jimregan / mlode

Automatically exported from code.google.com/p/mlode
0 stars 0 forks source link

Provide SPARQLIFY mapping and upload everything #16

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 

Claus please upload and describe everything you have about Wortschatz...

Original issue reported on code.google.com by kur...@googlemail.com on 19 Jul 2012 at 3:15

GoogleCodeExporter commented 9 years ago 
For the mapping see:

https://github.com/AKSW/Sparqlify/blob/master/mappings/Wortschatz.sparqlify

Note: I downloaded one of the MySQL database files from Wortschatz and used 
mysql2psql to convert to PostgreSQL.

sudo apt-get install mysql2psql

Important: Increase the pagination size from 1000 to e.g. 100000000 in 
/var/lib/gems/1.8/gems/mysql2psql-0.1.0/lib/mysql2psql/postgres_db_writer.rb

_counter = reader.paginated_read(table, 100000000) do |row, counter|

runnig mysql2pgqsl will create a config file; adjust parameters as needed 
(pretty self explanatory)

Original comment by RavenArk...@googlemail.com on 19 Jul 2012 at 3:30

GoogleCodeExporter commented 9 years ago 
I meant 

mysql2psql

(seems I can't edit my old comment)

Original comment by RavenArk...@googlemail.com on 19 Jul 2012 at 3:32

GoogleCodeExporter commented 9 years ago 
@Claus no you can not and old comments. Think before you type...

Original comment by kur...@googlemail.com on 20 Jul 2012 at 5:27

GoogleCodeExporter commented 9 years ago

Original comment by kur...@googlemail.com on 20 Jul 2012 at 5:27

GoogleCodeExporter commented 9 years ago 
I have developed an automated mapper from database to RDF, It converts the 
database schema to R2RML (http://www.w3.org/TR/r2rml/), so can you give me the 
postgresql database in order to convert it.

Original comment by mohamedd...@gmail.com on 3 Sep 2012 at 9:08

GoogleCodeExporter commented 9 years ago 
Done for the Swiss-German postgres dump (attached). The given structure is the 
same for all languages except that the language prefix (here 'deu_ch') differs. 
So the remaining R2RML files can be generated using e.g. sed.

Original comment by pypypykn...@gmail.com on 7 Sep 2012 at 4:20

Attachments: