WordNet 2.0 data files in MySQL format

We took the Prolog database format WordNet 2.0 files and converted them to MySQL batch script format. All you need to do is download the zip file below, unzip it to a directory of your choosing, and import the files in to MySQL. The unextracted file named wordnet20-from-prolog-all-3.sql will create the necessary tables and database for you.  The database name is wn_pro_mysql.

Click here to download wordnet20-from-prolog-all-3.zip.  (The compressed file is 7.5MB and the uncompressed SQL batch file is 47MB)

** UPDATE NOTE: If you downloaded the original wordnet20-from-prolog-all-1.zip or older file you need to download the latest version.  There was a problem with the original conversion which lead to some WordNet entries being improperly discarded and the several of the smaller tables were malformed. **

If you have any problems, then come to our WordNet Developerís Forum and post a message in the MySQL forum section.
 

Documentation notes

Since these MySQL data files were derived from the Prolog format files, you should download the original Prolog format package to get the package documentation files.  These documentation files will explain to you the table structure and field definitions found in the MySQL tables created by wordnet20-from-prolog-all.sql.

However, make sure you read this:

We renamed the original table names used in the Prolog data files to longer more explanatory names.  When reading the original Prolog documentation files, use the following table to map the original Prolog file names to the new MySQL table names found in the wn_pro_mysql database:

Prolog file to MySQL table name translation table

 

Prolog File Name

MySQL Table Name

Definition

wn_s.pl

wn_synset

synset pointers

wn_g.pl

wn_gloss

gloss pointers

wn_hyp.pl

wn_hypernym

hypernym pointers

wn_ent.pl

wn_entails

entailment pointers

wn_sim.pl

wn_similar

similar pointers

wn_mm.pl

wn_mbr_meronym

member meronym pointers

wn_ms.pl

wn_subst_meronym

substance meronym pointers

wn_mp.pl

wn_part_meronym

part meronym pointers

wn_der.pl

wn_derived

derivational morphology pointers

wn_cls.pl

wn_class_member

class (domain) pointers

wn_cs.pl

wn_cause

cause pointers

wn_vgp.pl

wn_verb_group

grouped verb pointers

wn_at.pl

wn_attr_adj_noun

attribute pointers

wn_ant.pl

wn_antonym

antonym pointers

wn_sa.pl

wn_see_also

see also pointers

wn_ppl.pl

wn_participle

participle pointers

wn_per.pl

wn_pertainym

pertainym pointers

wn_fr.pl

wn_verb_frame

frame pointers

 

 

 

[Android] [Robot Sales Rpt] [Downloads] [AliceBot E] [WordNet MySQL] [AI Forums] [Robots News] [Search Assist] [Google Translate] [Medical Robotics] [Free Speech Reco] [Review Service] [Consumer Robots] [Combat Robots] [projects] [Amazon Startup Challenge] [Privacy Policy] [Transparent Lang]

(c) 2004 Android Technologies, Inc and its licensors

Robot Forum - for the discussion of robots & robotics!

Contact Us

 

PRIVACY POLICY