Displaying Query Results in AMOS II Graphically using SVG & X3D

There are a lot of tools and libraries on the internet that can represent data visually from various database engines, but these tools or libraries are all commercial products and they do not provide a way to customize the source code for your own needs. Add to that, none of these tools and libraries support representing data from AMOSII which is a main memory object-relational database system developed by Uppsala Database Laboratory (UDBL). We thought it will be interesting to have a tool that can display the result of an AMOSQL query graphically (e.g. Chart) that will help the viewer to better understand the result of the query. It will also serve the purpose of aiding the teaching staff in the University to better formulate course assignments for related courses. Our work will certainly aid the faculty members and other students who may be interested in continuing through this project and make it an extensive library which can represent data results from AMOSII queries as other types of charts. Through this project we have developed a java library that can take the result of any AMOSQL query and display the results graphically in six different types of charts(graphs). We have used SVG (Scalable Vector Graphics) and X3D (Extensible 3D Graphics) for generating the graphs. SVG is a specification language using XML (Extensible Markup Language) file format for describing two-dimensional vector graphics. The SVG specification is an open standard and the most recent version (1.1) is a World Wide Web Consortium (W3C) recommendation. It is supported by all the major browsers; that mean the query result can be displayed on any device that has an Internet browser. X3D is the ISO standard XML-based file format for representing 3D computer graphics, it is the successor to the Virtual Reality Modeling Language (VRML). It supports the ability to encode the scene using XML syntax as well as the Open Inventor-like syntax of VRML97, or binary formatting, and enhanced application programming interfaces (APIs). However it requires plug-in for regular browsers to be able to open X3D scene. The X3D has been used to generate the 3D Plot graph function