250 likes | 369 Views
Agrovoc Maintenance Interface. Margherita Sini – GILW May 2003. Thesaurus Maintenance Tool. It is an interface for managing a “working copy” of the AGROVOC thesaurus For GILW to internal maintenance of AGROVOC
E N D
Agrovoc Maintenance Interface Margherita Sini – GILW May 2003
Thesaurus Maintenance Tool • It is an interface for managing a “working copy” of the AGROVOC thesaurus • For GILW to internal maintenance of AGROVOC • Possible use on related countries for editing specific languages (standalone or on-line version) • The DB (when validated) will be reflected over the on-line version, ftp version, CDROM version, etc.
Elements CLIENT • Server Side • Web Server: apache • Database: mysql • Web Interface: PHP • Client side • Browser SERVER EDIT Interface (php) working Database (mysql)
PHP Interface • Freeware, Platform Independent • Dynamic access to MySQL database with a direct connection (no odbc jdbc) • Easy managed and easy integration with other tools / web systems
MySQL Database • Freeware, Platform Independent • Free window-based tools to manage the database • Data can be managed with MS Access • Table definition and data import in batch mode
Functionalities (1) • Search • Add new terms (EN, FR, DE, IT, ….) • Edit/Add terms labels (EN, FR, DE, IT, ….) • Delete terms (Mark as deleted) • Edit relationships between terms • Edit descriptions (scope note, comments, history, etc)
Functionalities (2) • Export to TagText, RDF, others (?) – ongoing • Domain specific terms – ongoing • Help page
DataWork Flow working Database (mysql) EDIT Interface (php) VALIDATION SUBJECT EXPERTS On-line database (oracle) “CD ROM” database (cds isis) Files On-lineInterface (asp) CD ROM Interface (webisis)
Improvements (1) • More testing… and make more robust • Help on-line and project documentation • Multilingual Interface • Improve connection performances • Controlled access (Login/Password): limit access to modify functions
Improvements (2) • Full implementation Arabic / Chinese • Additional functions: • Domain specific terms excluding species, geograph. and chemical terms • Connection to additional domain-specific lists • “Do you mean…” in case of 0 results • Create a standalone version (CD ROM)
Working plan • Conversion ms access database to mysql: 1 day (todo 0.5 day) • Development of the interface: 20 days (todo 5 days) • Testing: 1 week (never ending…) • Move to a server: (todo 1 day)
References • http://www.mysql.com • http://www.php.net/