CODEWITHSUNDEEP
databasesqlitenlpwordnet
jan
jan

Reputation: 221

understand Wordnet sqlite database

I have downloaded Wordnet sqlite [sqlite-31.db.zip] [https://osdn.net/projects/sfnet_wnsql/]1

The file looks like enter image description here

I can not understand the file. I have a project where I have to use this. But i can't figure it out. what's the meaning of this number?

ex: 5351 4c69 7465

please help!

Upvotes: 1

Views: 751

Answers (1)

user9455968
user9455968

Reputation:

You will need the SQLite command line tool (download). Then you can inspect the database file.

% sqlite3 sqlite-31.db        
SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> .schema
CREATE TABLE adjpositions (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',position CHARACTER (2) NOT NULL,CONSTRAINT pk_adjpositions PRIMARY KEY (synsetid,wordid));
CREATE TABLE adjpositiontypes (position CHARACTER (2) NOT NULL,positionname VARCHAR (24) NOT NULL,CONSTRAINT pk_adjpositiontypes PRIMARY KEY (position));
CREATE TABLE casedwords (casedwordid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',cased VARCHAR (80) NOT NULL,CONSTRAINT pk_casedwords PRIMARY KEY (casedwordid));
CREATE TABLE lexdomains (lexdomainid SMALLINT NOT NULL DEFAULT '0',lexdomainname VARCHAR (32) DEFAULT NULL,lexdomain VARCHAR (32) DEFAULT NULL,pos CHARACTER (1) DEFAULT NULL,CONSTRAINT pk_lexdomains PRIMARY KEY (lexdomainid));
...
sqlite> select count(*) from adjpositions;
1054
sqlite>

Upvotes: 4

Related Questions