Overview
JChem Cartridge adds chemical intelligence to the Oracle platform. Data can be searched by structure, substructure and similarity criteria through extending Oracle’s native SQL language. Chemical data can be easily inserted and modified using SQL. Most industry standard chemical formats (MOL/SDF/RDF – v2.0 and v3.0, SMILES, SMARTS, CML, etc) are natively handled using JChem indices. The Cartridge enables all chemical database management and search features of JChem Base from any SQL-capable platform.
In addition to chemical database management and search functions, JChem Cartridge also supports structure transformations with our Standardizer and Reactor toolkits and structure based predictions via ChemAxon’s Chemical Terms language and Calculator Plugins, as well as providing chemical format conversions including image generation.
FAQ
Expand all Close all
What is JChem Cartridge?
JChem Cartridge adds chemical intelligence to the Oracle platform. Data can be searched by structure, substructure and similarity criteria through extending Oracle’s native SQL language.
What is JChem Cartridge good for?
Chemical data can be easily inserted and modified using SQL. Most industry standard chemical formats (MOL/SDF/RDF – v2.0 and v3.0, SMILES, SMARTS, CML, etc) are natively handled using JChem indices. The Cartridge enables all chemical database management and search features of JChem Base from any SQL-capable platform.
Who uses JChem Cartridge?
Chemists, cheminformaticians or anyone who want to store chemical structures and relatad data in a database.
However, JChem Cartridge requires high level knowledge of Oracle and SQL.
Do I have to do programming for using JChem Cartridge?
Yes.
What kind of additional software is needed?
Java 5 or later, Oracle 9.2 or later.
Is it possible to manage relational data from multiple database tables?
Yes. Oracle’s table join sql statements can be used, and the same filterQuery mechanism as for JChem Base.
How many structures can be handled?
Which molecular file formats are supported?
All major molecular formats can be stored (formats created by MDL, Daylight, ChemAxon) in structure tables.
Related forum threads
Irrelevant trans not ignored? (March 10th, 03:31pm)
“
Hi,
Since JChem 5.3 the default stereo model is the comprehensive model (for some query and markush tables the local model):
https://www.chemaxon.com/jchem/doc/user/query_stereochemistry.html#stereomodels
So the symmetric targets are matched ...”
View replies or
Join the discussion
JChem Cartridge
