Related Experiment Video
Updated: Jun 14, 2026
05:34
Applying Cheminformatics to Develop a Structure Searchable Database of Analytical Methods
Published on: June 6, 2025
OrChem - An open source chemistry search engine for Oracle(R)
Mark Rijnbeek1, Christoph Steinbeck
1Cheminformatics and Metabolism, European Bioinformatics Institute (EBI), Wellcome Trust Genome Campus, Cambridge, UK. markr@ebi.ac.uk.
Journal of Cheminformatics
|March 20, 2010
Summary
An open-source Oracle database extension, OrChem, enables efficient registration, indexing, and searching of chemical structures. It provides fast substructure and similarity searches for large chemical databases.
Area of Science:
- Cheminformatics
- Database Management
- Computational Chemistry
Background:
- Chemical structure registration, indexing, and searching are fundamental in cheminformatics.
- Development of cheminformatics search engines has largely been closed-source.
- There is a need for open-source solutions for managing chemical data in commercial database platforms.
Purpose of the Study:
- To develop an open-source chemistry extension for the Oracle database.
- To add registration, indexing, and searching capabilities for chemical structures.
- To enable fast substructure and similarity searching within large chemical databases.
Main Methods:
- Developed OrChem, an extension for Oracle 11G.
- Integrated the Chemistry Development Kit for cheminformatics functionality.
- Implemented algorithms for efficient similarity and substructure searching.
Main Results:
- OrChem enables rapid similarity searching (seconds for millions of compounds).
- Substructure searching is accelerated using multi-core processing on large datasets.
- The extension provides robust cheminformatics capabilities within a widely used commercial database.
Conclusions:
- OrChem offers an open-source solution for advanced chemical structure searching in Oracle.
- The extension significantly improves the speed and efficiency of handling large chemical datasets.
- OrChem is freely available under the GNU Lesser General Public License.
Related Concept Videos
02:17What is Organic Chemistry?
Organic chemistry is the study of compounds of carbon called organic compounds. Organic compounds either originate from living organisms or are synthesized by chemists. A defining trait of these compounds is the presence of carbon as the principal element, which is bonded to other carbon atoms and other elements such as hydrogen, oxygen, nitrogen, and sulfur. The existence of a wide array of organic molecules is a consequence of carbon atoms’ ability to form up to four strong bonds to other...
01:13Olefin Metathesis Polymerization: Overview
Recently, the development of olefin metathesis polymerization advanced the field of polymer synthesis. Simply put, the reorganization of substituents on their double bonds between two olefins in the presence of a catalyst is known as the olefin metathesis reaction. The use of metathesis reaction for polymer synthesis is called olefin metathesis polymerization.
Ruthenium-based Grubbs catalyst is the most commonly used catalyst for olefin metathesis polymerization. Grubbs catalyst consists of a...
Ruthenium-based Grubbs catalyst is the most commonly used catalyst for olefin metathesis polymerization. Grubbs catalyst consists of a...
01:09Chemical Symbols
A chemical symbol is an abbreviation that is used to indicate an element or an atom of an element. For example, the symbol for mercury is Hg. We use the same symbol to indicate one atom of mercury (microscopic domain) or to label a container of many atoms of the element mercury (macroscopic domain).
Some symbols are derived from the common name of the element; others are abbreviations of the name in another language. Most symbols have one or two letters, but three-letter symbols have been used...
Some symbols are derived from the common name of the element; others are abbreviations of the name in another language. Most symbols have one or two letters, but three-letter symbols have been used...
02:21Chemical and Solubility Equilibria
The free energy change associated with dissolving a solute in a liter of solvent is called the free energy of a solution, ΔGsolution. The overall ΔGsolution is expressed as the balance of ΔGinteraction against the always-favorable free-energy of mixing, ΔGmixing. Solution formation is favorable if ΔGsolution is less than zero, whereas it is unfavorable if ΔGsolution is greater than zero. In short, for a solution to form and complete dissolution to take place, the Gibbs energy change must be...
01:17Chemical Shift: Internal References and Solvent Effects
In an NMR sample, precise measurement of the absolute absorption frequencies of nuclei is difficult. A standard internal reference compound is added, and the frequency difference between the reference signal and sample signals is measured.
The internal reference compound generally used in NMR spectroscopy is tetramethylsilane (TMS). TMS is preferred because it is chemically inert, soluble in NMR solvents, and easily removable. Also, the highly shielded methyl protons in TMS yield an intense...
The internal reference compound generally used in NMR spectroscopy is tetramethylsilane (TMS). TMS is preferred because it is chemically inert, soluble in NMR solvents, and easily removable. Also, the highly shielded methyl protons in TMS yield an intense...
01:19Chemical Reactions
A chemical reaction is a process by which the bonds in the atoms of substances are rearranged to generate new substances. Matter cannot be created or destroyed in a chemical reaction—the same type and number of atoms that make up the reactants are still present in the products. Merely, the rearrangement of chemical bonds produces new compounds.
Chemical Reactions Rearrange Atoms into New Substances
A chemical reaction takes starting materials—the reactants—and changes them into different...
Chemical Reactions Rearrange Atoms into New Substances
A chemical reaction takes starting materials—the reactants—and changes them into different...