SQLUNET



sql unified xnet Bernard Bou 1313ou@gmail.com

project page	download	schema \| mwb	how to query

SQL unified database

all NLP databases are converted to tabular form so that a relational database can handle the data
the targeted form is SQL, and specifically but not exclusively MySql and Sqlite
the tables are made joinable and reference each other, foreign keys are resolved
the end result is an interconnection of databases (NETs) which are thus unified (U) and can be queried with SQL, hence 'SqlUNet'
proof of concept is the Semantikos Android application

Databases

database	version	source	role
Open English WordNet	2022	source	words, senses, relations
SyntagNet	1.0	source	collocations
VerbNet	3.4	source	semantic roles
Propbank	3.1	source	semantic roles
SemLink	2.0.0	source	semantic roles
FrameNet	1.7	source	semantic roles
PredicateMatrix	1.3	source	semantic roles
SUMO	2022	source	ontology, inference
British National Corpus statistical data	2001	source	frequency

Restore

How to restore the database

Builder

The builder utilities that produce the SQL statements are available as two distinct if related projects: oewntk for the wordnet core and sqlbuilder2 for the other xnets.