Java OPM Tools

The java OPM front end tools, for the most part, are written in java. At the server end, C++ and perl are also involved for CGI.

The schema browser is completely written in java. It loads metadata from a plain ascii text file.

The query forms tool uses java to allow the user to graphically specify joins of a query as a first step. After joins are specified, a form may be generated from the java window. When a query form is generated, control is passed to netscape, and the rest of the interaction is handled using HTML forms (with lots of tables), and CGI. The OPM Query Translator (OQT) 4.2, a tool written in C++, takes an OQT query specification, sends it to a backend DBMS such as Sybase or Oracle and returns the results. A version of this translator (oqh4syb or oqh4ora), takes an OQT specification input and formats the output as HTML. This C++ tool is used inside a CGI perl script, oqh4syb.pl (or oqh4ora.pl) to handle CGI translations and HTML page presentation.

An older version of the query tool, as well as a prototype update tool also has the same arrangement of java front end, and C++/perl CGI backend.


Contact: szeto@math.lbl.gov