SELECT quantity
FROM tblStores
WHERE quantity>65
AND buildingCode=110
AND chemicalStructure=
AND siUnit='g'
AND country='uk'
AND county='oxfordshire'
A common technique used
to index chemical structure information within modern (O)RDBMS systems such as
Oracle and IBM DB2
is discussed.
There is focus on:
Subgraph isomorphism detection of (sub)structures within
adjacency matrices - algorithms that must be implemented within any serious chemoinformatic
COTS product such as
MDL,
Daylight,
ChemAxon,
Accelrys,
InfoChem,
and Cambridgesoft Oracle Data Cartridge
implementations.
Discussion on (O)RDBMS implementation theory for extensible indexing
of chemical entities, implementation architecture, and available technologies.
Flaws and/or simplicity of approach in many chemically aware DBMS extensible indexing implementations
when dealing with, on occasion, undergraduate chemical concepts.
Chemoinformatic application of RDBMS theory in the 1930's.
The site is discussion only; there is no product to purchase or download and I am not touting a consultancy service.
All feedback is welcome.
My contact details can be found here.