WordNet SQL Builder



wordnet sql builder Bernard Bou bbou@ac-toulouse.fr

1-select and download the modules from the download area into a common space
2-decompress the zip files
3-run restore-[mysql|posgresql][bat|sh]

- disregard warnings about overwriting the restore-[mysql|posgresql][bat|sh] files : these are actually the same in all packages.

- the modules are the following:

wn	WordNet core	this is the core module : it is required by others.
legacy	legacy wordnet	2.0,2.1 senses and sensemaps to 3.0
vn	VerbNet	VerbNet
xwn	XWordNet	XWordNet
bnc	British National Corpus	BNC statistical data

WordNet core

this is the core module : it is required by others.

legacy

legacy wordnet

2.0,2.1 senses and sensemaps to 3.0

VerbNet

xwn

XWordNet

bnc

British National Corpus

BNC statistical data

- unless you modify the scripts you'll need to have MySQL root or PostgreSQL postgres access

- ignore messages about non-existing constraints (the scripts attempt to drop everything before restoring)

LAUNCH

Linux/Unix:
$JAVA_HOME/jre/bin/java -classpath WordNetSQLBuilder.jar:./lib/mysql-connector-java-xxx-bin.jar wnsqlbuilder.Builder WordNetSQLBuilder-mysql.properties [action]
$JAVA_HOME/jre/bin/java -classpath WordNetSQLBuilder.jar:./lib/postgresql-xxx.jdbc4.jar wnsqlbuilder.Builder WordNetSQLBuilder-postgresql.properties [action]
Windows:
"%JAVA_HOME%\jre\bin\java.exe" -classpath WordNetSQLBuilder.jar;./lib/mysql-connector-java-xxx-bin.jar wnsqlbuilder.Builder WordNetSQLBuilder-mysql.properties [action]
"%JAVA_HOME%\jre\bin\java.exe" -classpath WordNetSQLBuilder.jar;./lib/postgresql-xxx.jdbc4.jar wnsqlbuilder.Builder WordNetSQLBuilder-postgresql.properties [action]

builder-[mysql|postgresql].[bat|sh] files are provided for ease of use

ACTION

A list of action parameters is available when the above is run with no action parameter.

PROPERTY FILES

Please refer to example property files

mysql
url = jdbc:mysql://localhost:3306/wordnet30
dbms = mysql
postgresql
url = jdbc:postgresql://localhost:5432/wordnet30
dbms = postgresql

user=wnsql

sql user

password=wnsql

sql user password

home=/opt/nlp/WordNet-3.0

wordnet home

loghome=./logs/mysql

log home

verbose=false

verbose switch

senses=20 /opt/nlp/WordNet-2.0 21 /opt/nlp/WordNet-2.1

legacy senses=[index home]*

sensemaps=21 30 21 * 2.1to3.0 /opt/nlp/WordNet-3.0/sensemap 20 21 20 21 2.0to2.1 /opt/nlp/WordNet-2.1/sensemap

legacy sensemaps=[fromindex toindex fromsenseindex tosenseindex pathsuffix sensemaphome]* (the '*' place-holder used as tosenseindex indicates use of 'senses' table

synsetmaps=20 30 /opt/nlp/wnmaps/mapping-20-30 /opt/nlp/wnmaps/mapping-30-20 21 30 /opt/nlp/wnmaps/mapping-21-30 /opt/nlp/wnmaps/mapping-30-21

legacy synsetmap=[fromindex toindex forwardhome backwardhome]*

sensemapview=20 21 30

fromindex viaindex toindex

xwnhome=/opt/nlp/XWordNet-2.0-1.1

xwordnet home

xwnsensemap=2030

sensemap to use for xwordnet

vnhome=/opt/nlp/verbnet-2.3

verbnet home

vnsense=21

senses to use for verbnet

vnsynsetmap=2130

synsetmap to use for verbnet

bnchome=/opt/nlp/bnc

bnc home

bncmain=bnc.txt

general statistics

bncspwr=bnc-spoken-written.txt

spoken vs written file

bncconvtask=bnc-conv-task.txt

conversational vs task-oriented

bncimaginf=bnc-imag-inf.txt

imaginative vs informational

INCREMENTAL BUILD

resume preceding the wordnet stage will do the trick.