The AGROVOC Concept Server (AGROVOC/CS) Workbench is a web-based working environment consisting of numerous functionalities for the distributed management and enhancement of the AGROVOC/CS built from the AGROVOC thesaurus. Following the Semantic Web’s vision, that emphasizes collaboration in the development of data and metadata to be shared and reused across the web, the management of AGROVOC will progressively be transferred from a few individuals in FAO to a wider community of international AGROVOC experts. These interested and competent users will share the collaborative maintenance and extension of AGROVOC, one of the most frequently used terminological resources for agricultural information management in the world. Maintenance of the future extended AGROVOC will thus be completely decentralized with people worldwide contributing to its development.
This report provides a brief note on the technical aspects of the AGROVOC/CS Workbench. Technical details • Multilingual web interface and content (UTF8).
• The software is developed in pure JAVA (version 1. 5. x), with no calls to any third party modules requiring precompiled DLLs or other operating system specific features. • The Google Web Toolkit (GWT) is used with an Eclipse plug-in for development of the system. It is used to build the system as a fully Java based AJAX client browser application that is compatible with all common web browsers. • Where possible the JSP 2. 0 Expression Language (EL) is used for any JSP development within the project (it’s a way of writing script-less JSP pages).
By using ordering management system, it allows the user to import data and to manage the products that the customer wants such as, product information, buyer’s information, costumer’s prioritization and product costing. PC Troubleshooters runs its business through a manual process in taking the orders of the costumers. Though there are more employees attending to the needs of the costumer, but the ...
Protege OWL api framework is used to connect OWL. • MySQL is used as RDBMS. • The system is DBMS-independent. Additional database abstraction layer for interacting with the OWL backbone and the relational database will be used (e. g. the hibernate persistence and query service, etc. ).
The system follows FAO guidelines for HTML publishing: •
Guidelines for Web site development; • File naming convention and file organization guidelines; • Check list for the clearance of Web sites. In summary, the system is based on the following components: Development components • Eclipse 3. 2 • JAVA-JDK version jdk1. 5. x • Apache Tomcat (that supports JSP and JAVA Servlets) Google Web Toolkit (for AJAX framework), version 1. 4. 60 • Google Web Toolkit Incubator, version 1. 4 • Protege OWL API 3. 4 libraries • Hibernate 3. 0 libraries • Hibernate 4 GWT, version 0. 5 RC2 • MySQL version 5 Server side • Windows XP, Windows 2000, or Linux • Apache Tomcat 5. 5. 9 or higher • JAVA-JDK version jdk1. 5. x or higher • MySQL version 5 or higher • Protege OWL API 3. 4 libraries • Hibernate 3. 0 libraries • Hibernate 4 GWT, version 0. 5 RC2 • WAR file with compiled JAVA files and necessary libraries Current Server Configuration • OS : Debian GNU/Linux 2. 6. 22-2 • CPU: AMD 64 bit • Memory: 8GB • MYSQL version: 5. 0. 45 TOMCAT Version: 6. 0. 14 • Java-JDK: 1. 6. 0_04 Required Application 1. MySQL version 5 or above Available link to download: http://dev. mysql. com/downloads/ 2. Apache Ant version 1. 7. 1 or above Available link to download: http://ant. apache. org/ 3. JAVA JDK version jdk. 1. 5. x or above Available link to download: http://java. sun. com/javase/downloads/index. jsp 4. Apache Tomcat version 6 or above Available link to download: http://tomcat. apache. org/download-55. cgi 5. Protege Version 3. 4 beta Build 130 Available link to download: http://protege. cim3. net/download/old-releases/3. 4%20betas/build-130/full/ 6. GWT Version 1. 4 Build 1. 4. 62
Available link to download: http://code. google. com/webtoolkit/versions. html The Step of Configuration 1. Download AGROVOC Concept Server Workbench code from the CVS Server. 2. Download the sql script from CVS Server at folder named sql. Create the database. • Run the sql script file located at your_directory\SQL\administrator_agrovocwb _v_0_2_beta. sql This will install administrator_agrovocwb database. • Run sql script file to install the owl model database located at your_directory\SQL\blank model _v_0_2_beta. sql Here we have provided blank owl model. • You can convert owl file directly to database by using stand alone java program located at: our_directory\src\org\fao\aoscs\server\protege\convertToDatabaseProject. java • You need the change the variables in the file. |18 private final static String url = “jdbc:mysql://”; | |19 private final static String table = “”; | |20 private final static String user = “”; | |21 private final static String password = “”; | |22 private final static String uri = “file:/c:/”; | 3.
1.SEQUENTIAL FILE ORGANIZATION – records are written consecutively – files are stored in ascending or descending order according to a key field. ADVANTAGE: – easier to maintain than other organizations – especially in terms of adding and deleting records 2.RANDOM FILE ORGANIZATION – implies a predictable relationship between the key used to identify an individual record and ...
To add model in the ontology list, go to database and table and insert new row with these values. Ontology id: (Auto increment) • Ontology Name: Blank Model • Ontology Description: AGROVOC Concept Server Workbench – Blank AOS Module • Database URL: jdbc:mysql://:3306/? requireSSL=false&useUnicode=true&characterEncoding=UTF-8 • Database Driver: com. mysql. jdbc. Driver • Table Name: • Database Username: • Database Password: • Display Ontology on the list: 0 for hide and 1 for Show 4. Use java editor to • Change the configuration of the hibernate file that located in your_directory\src\hibernate. cfg. xml Change the property of your connection password instead of “your_password” and change the property of your connection url instead of “your_url”. 13 your_password | |14 jdbc:mysql://your_url | • Change the configuration of the database properties that located in your_directory\src\org\fao\aoscs\server\owl\DatabaseConnection. properties Change the property of your username of database instead of “your_username” and change the property of your password of database instead of “your_password”. |4 userAdminDB = your_username | |5 passwordAdminDB = your_password | • Change the configuration of the mail file that located in your_directory \src\org\fao\aoscs\utility\Mail. properties
Change the property of your host name instead of “your_mailserver_host”, change the property of your port instead of “your_port”, change the property of your user instead of “your_user”, change the property of your password instead of “your_password” and change the property of your from information instead of “sender_email”. |1 host=your_mailserver_host | |2 port=your_port | |3 user=your_user | |4 password=your_password | |5 from= sender_email | • Run build file to create war file using Apache ANT. 5. Copy the war file to folder of tomcat installation directory. 6. You can use the program by opening your browser and type • http://localhost:8080/your_project_name
Technology Changes Role of Database Administrator The database administrator (DBA) is responsible for managing and coordinating all database activities. The DBA's job description includes database design, user coordination, backup, recovery, overall performance, and database security. The database administrator plays a crucial role in managing data for the employer. In the past the DBA job has ...