JChem Oracle Cartridge
making Oracle chemically aware
JChem Oracle Cartridge adds chemical intelligence to the Oracle platform using Oracle’s native SQL language. JChem Oracle Cartridge allows users to access the rich chemical database management and search features of JChem Base in a flexible and efficient manner from any SQL-capable platform.
JChem Oracle Cartridge functionality
JChem Oracle Cartridge’s major functionality is to allow the addition, manipulation and searching of chemical data using Oracle’s native SQL language. Most industry standard chemical formats are natively handled using JChem indices. Automatically calculated physico-chemical properties and user-defined fingerprints allow users to create and search custom chemical databases. JChem Oracle Cartridge uses creative solutions to broaden the applicability of JChem’s core functions while still preserving the key benefits of the Java platform. Chemical structures can be stored and searched by superstructure, substructure and full structure. Custom similarity searches using a wide variety of molecular descriptors can also be carried out.
In addition to chemical database management and search functions, JChem Oracle Cartridge provides chemical format conversions including 2D and 3D image generations. It also supports structural transformations using our Standardizer engine as well as virtual library enumeration by Reactor. Structure based predictions and property calculations via ChemAxon’s Chemical Terms language and Calculator Plugins can also be carried out in the JChem Oracle Cartridge framework. Furthermore, ChemAxon’s Markush technology, including all the structure analysis features, is also available as an add-on for JChem Oracle Cartridge.
External services via JChem Oracle Cartridge
Besides the built-in functionality of the JChem platform, Marvin Services provide the user seamless integration of third-party structure manipulations into the Cartridge framework. Marvin Services are available in JChem Oracle Cartridge through the jc_evaluate operator, ensuring easy access to external calculations and web service based operations on structures.
JChem Oracle Cartridge Architecture Overview
The chemical knowledge for JChem Oracle Cartridge comes from ChemAxon’s core Java libraries. Oracle offers the possibility to use existing Java libraries by calling them from Java Stored Procedures that run in a special Java runtime environment tightly integrated with the Oracle RDBMS. To compensate for the performance disadvantage with Oracle Java Stored Procedures JChem Oracle Cartridge performs the computation intensive functions in an external (with respect to Oracle) Java runtime environment capable of runtime byte-code compilation, the JChem Server.
JChem search technology on Oracle
At an abstract level, the JChem Server comprises two main components. JChem Base provides the core chemical functions (e.g. atom-by-atom graph search algorithms (JChem Core)) and is responsible for advanced database searches and updates (Search and Update engines which add an RDBMS-aware layer to the core JChem functions). The JChem Cartridge Adapter component translates JChem Base’s external interfaces to the needs of the JChem Oracle Cartridge in contact with the Oracle platform.
Platform independence and compatibility
JChem Oracle Cartridge works with Oracle versions 11.0 or above. It is platform independent and can be used on various operating systems including Windows, Linux, Solaris and HP-UX. JChem Oracle Cartridge works seamlessly with the most commonly used chemical representations (SMILES, MDL, molfile (v2000 and v3000), MDL SDF, RXN, RDF, MRV, IUPAC name, InChI, Markush DARC, CDX), providing great flexibility on both import and export.