In my previous post I discussed how we’d like to automate some of our screens – starting from the primary screen, going through data processing and compound selection and completing the secondary (follow up) screen. A key feature of such a workflow is the asynchronous nature of the individual steps. Messaging and Message queues (MQ) provide […]
Molecules & MongoDB – Numbers and Thoughts
In my previous post I had mentioned that key/value or non-relational data stores could be useful in certain cheminformatics applications. I had started playing around with MongoDB and following Rich’s example, I thought I’d put it through its paces using data from PubChem. Installing MongoDB was pretty trivial. I downloaded the 64 bit version for […]
Cheminformatics and Non-Relational Datastores
Over the past year or so I’ve been seeing a variety of non-relational data stores coming up. They also go by terms such as document databases or key/value stores (or even NoSQL databases). These systems are alternatives to traditional RDBMS’s in that they do not require explicit schema defined a priori. While they do not […]
A GPL3 Oracle Cheminformatics Cartridge
Sometime back I had mentioned a new cheminformatics toolkit, Indigo. Recently, Dmitry from SciTouch let me know that they had also developed Bingo, an Oracle cartridge based on Indigo, to perform cheminformatics operations in the database. This expands the current ecosystem of Open Source database cartridges (PGChem, MyChem, OrChem) which pretty much covers all the […]
Oracle Notes
Some handy settings when running a query from the command line via sqlplus set echo off set heading on set linesize 1024 set pagesize 0 set tab on set trims on set wrap off — might want to set column formats here — e.g.: column foo format A10 spool stats — dump results to stats.lst […]