net.sf.extjwnl.utilities

Class DictionaryToDatabase

java.lang.Object

net.sf.extjwnl.utilities.DictionaryToDatabase

public class DictionaryToDatabase
extends java.lang.Object

DictionaryToDatabase is used to transfer a WordNet file database into an actual database structure.

Field Summary

Fields

Modifier and Type	Field and Description
protected java.sql.Connection	connection The database connection.
protected Dictionary	dictionary
protected java.util.Map<java.lang.Integer,long[]>	idToSynsetOffset Mapping of database id's to synset offset id's.
protected static int	INTERNAL_ID
protected java.util.Map<java.lang.Long,java.lang.Integer>	synsetOffsetToId Mapping of synset offset id's to database id's.
protected static java.lang.String[]	tables
protected static long	TIME

Constructor Summary

Constructors

Constructor and Description
DictionaryToDatabase(Dictionary dictionary, java.sql.Connection conn) Create a new DictionaryToDatabase with a database connection.

Method Summary

Modifier and Type	Method and Description
void	createTables(java.lang.String scriptFilePath) Create the database tables.
static void	importWordnet(java.lang.String propertyFile, java.lang.String tablesScript, java.lang.String driverClass, java.lang.String connectionURL, java.lang.String username, java.lang.String password)
void	insertData() Inserts the data into the database.
static void	main(java.lang.String[] args) Run the program, requires 4 arguments.
protected static int	nextId()
protected void	storeExceptions(java.util.Iterator<Exc> itr) Store the exceptions file.
protected void	storeIndexWords(java.util.Iterator<IndexWord> itr) Store all the index words.
protected void	storeIndexWordSynsets() Store the index word synsets.
protected void	storeSynsets(java.util.Iterator<Synset> itr) Store all of the synsets in the database.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

INTERNAL_ID

protected static int INTERNAL_ID

TIME

protected static long TIME

tables

protected static final java.lang.String[] tables

connection

protected final java.sql.Connection connection

The database connection.

idToSynsetOffset

protected final java.util.Map<java.lang.Integer,long[]> idToSynsetOffset

Mapping of database id's to synset offset id's. 1 to 1.

synsetOffsetToId

protected final java.util.Map<java.lang.Long,java.lang.Integer> synsetOffsetToId

Mapping of synset offset id's to database id's. 1:1.

dictionary

protected final Dictionary dictionary

Constructor Detail

DictionaryToDatabase

public DictionaryToDatabase(Dictionary dictionary,
                            java.sql.Connection conn)

Create a new DictionaryToDatabase with a database connection. JWNL already initialized.

Parameters:

dictionary - the dictionary

conn - the database connection

Method Detail

main

public static void main(java.lang.String[] args)
                 throws JWNLException,
                        java.sql.SQLException,
                        java.io.IOException

Run the program, requires 4 arguments. See DictionaryToDatabase.txt for more documentation.

Parameters:

args - args

Throws:

JWNLException - JWNLException

java.sql.SQLException - SQLException

java.io.IOException - IOException

importWordnet

public static void importWordnet(java.lang.String propertyFile,
                                 java.lang.String tablesScript,
                                 java.lang.String driverClass,
                                 java.lang.String connectionURL,
                                 java.lang.String username,
                                 java.lang.String password)
                          throws java.io.IOException,
                                 JWNLException,
                                 java.sql.SQLException

Throws:

java.io.IOException

JWNLException

java.sql.SQLException

nextId

protected static int nextId()

createTables

public void createTables(java.lang.String scriptFilePath)
                  throws java.io.IOException,
                         java.sql.SQLException

Create the database tables.

Parameters:

scriptFilePath - - the sql script filename

Throws:

java.io.IOException - IOException

java.sql.SQLException - SQLException

insertData

public void insertData()
                throws JWNLException,
                       java.sql.SQLException

Inserts the data into the database. Iterates through the various POS, then stores all the index words, synsets, exceptions of that POS.

Throws:

JWNLException - JWNLException

java.sql.SQLException - SQLException

storeIndexWords

protected void storeIndexWords(java.util.Iterator<IndexWord> itr)
                        throws java.sql.SQLException

Store all the index words.

Parameters:

itr - - the index word iterator

Throws:

java.sql.SQLException - SQLException

storeSynsets

protected void storeSynsets(java.util.Iterator<Synset> itr)
                     throws java.sql.SQLException,
                            JWNLException

Store all of the synsets in the database.

Parameters:

itr - itr

Throws:

java.sql.SQLException - SQLException

JWNLException - JWNLException

storeIndexWordSynsets

protected void storeIndexWordSynsets()
                              throws java.sql.SQLException

Store the index word synsets.

Throws:

java.sql.SQLException - SQLException

storeExceptions

protected void storeExceptions(java.util.Iterator<Exc> itr)
                        throws java.sql.SQLException

Store the exceptions file.

Parameters:

itr - iterator

Throws:

java.sql.SQLException - SQLException