MySql Knowledge Resources

@TODO: The links for downloading the resources refer now to the old BIUTEE webpage. Refer to new Maven repository.

These knowledge resources are stored as MySQL tables, provided as compressed .sql files. In order to use them:

1. Download the resources from the links in the table below. Each file represents one MySQL schema, and may contain several knowledge resources. Note that you don't need to download them all, you may download only the schema files containing the resources you wish to use.
2. Install the free SQL server MySQL.
3. Install its administration tool MySQL Workbench.
4. Run the server.
5. Connect to the server via MySQL Workbench, and in it:
   1. Create a user named db_readonly, with password BIUTEE: Users and Privileges --> Add Account
   2. Import the schema files to the database: Data Import/Restore --> Import from Dump Project Folder --> (input folder path containing uncompressed .sql files) --> Load Folder Contents --> (select all required schemas) --> Start Import
   3. Make sure user db_readonly has read (SELECT) privileges to all of the tables in the imported schemas.
6. Define an environment variable named MYSQL with a value referring to the MySQL server address (name or IP address) and port. For example: dbsql.cs.biu.ac.il:3306.

Schema Name	Knowledge Resources in Configuration	Schema Download	File Size (Compressed)
BAP (Directional Similarity)	BAP	Download	111 MB
Lin Similarity	LIN_DEPENDENCY_ORIGINAL, LIN_PROXIMITY_ORIGINAL	Download	236 MB
Original DIRT	ORIG_DIRT	Download	55 MB
Wikipedia Knowledge Resource	WIKIPEDIA	Download	214 MB
Binary Lin, Dependency Reuters	BINARY_LIN, LIN_DEPENDENCY_REUTERS	Download	2.4 GB
Framenet	FRAMENET	Download	228 KB
Geo (Geographical Knowledge Resource)	GEO	Download	1.4 MB
ReVerb (Distributional Similarity with Global Constraints)	REVERB	Download	161 MB