Building a Comprehensive Chemical Supplier Catalogue: Technical - - PowerPoint PPT Presentation

building a comprehensive chemical supplier catalogue
SMART_READER_LITE
LIVE PREVIEW

Building a Comprehensive Chemical Supplier Catalogue: Technical - - PowerPoint PPT Presentation

Building a Comprehensive Chemical Supplier Catalogue: Technical Challenges Craig A. James Modgraph Consultants Ltd The Modgraph CSC What is it? A complete system for integrating data from dozens or hundreds of chemical suppliers


slide-1
SLIDE 1

Building a Comprehensive Chemical Supplier Catalogue: Technical Challenges

Craig A. James Modgraph Consultants Ltd

slide-2
SLIDE 2

The Modgraph CSC

  • What is it?

– A complete system for integrating data from dozens or hundreds of chemical suppliers into a single, searchable chemical catalogue

slide-3
SLIDE 3

The Modgraph CSC

  • Why Build It?

– Existing Supplier Databases can be:

  • Incomplete
  • Inconsistent quality
  • Out-of-date information
  • Expensive when deployed widely
  • But … researchers really need a

comprehensive supplier database

slide-4
SLIDE 4

The Modgraph CSC

  • The need is there

– We discovered many customers considered or tried to build their own supplier database systems

  • A do-it-yourself CSC is difficult

– Loading, searching applications must be built from scratch – Database schema is tricky, many pitfalls – Requires an ongoing high level of support

slide-5
SLIDE 5

Requirements for a Supplier Catalogue

User Requirements

  • 1. Consistent, Up-to-Date Chemistry
  • 2. User-Friendly Front End
  • 3. Fast Reagent Searching
  • 4. Supplier Selection / Ordering

Administration Requirements

  • 1. Flexible, Powerful Loader
  • 2. Maintainable with Modest Effort
  • 3. Affordable
slide-6
SLIDE 6

Registration vs. CSC

Relational Database

Information Repository

Chemical Cartridge

Chemistry for Oracle

Chemical Registration

  • Relational Database

– Basic Information Repository – High-performance – Reliable – Manages relations amongst data

slide-7
SLIDE 7

Registration vs. CSC

Relational Database

Information Repository

Chemical Cartridge

Chemistry for Oracle

Chemical Registration

  • Chemistry Cartridge

– Adds ability to store molecules – Indexing for fast search, retrieval and “joins” (chemical relationships)

slide-8
SLIDE 8

Registration vs. CSC

Relational Database

Information Repository

Chemical Cartridge

Chemistry for Oracle

Chemical Registration

  • Chemical Registration

– Deeper information about chemistry – Business Rules – Security – Amendments – Auditing

slide-9
SLIDE 9

Chemical Supplier Catalogue: Simple Chemical Registration

Chemical Supplier Catalogue Relational Database

Information Repository

Chemical Cartridge

Chemistry for Oracle

Chemical Registration

slide-10
SLIDE 10

Example: Bond Normalization

  • Tautomers, electron / proton migration

OH NH OH NH2

slide-11
SLIDE 11

Example: Charge Normalization

O- C OH OH C O- Na+ Na+

slide-12
SLIDE 12

Registration vs. CSC: Chemistry

no yes partial structures no yes relative stereochemistry no yes uncertain stereo centers no yes mixtures / formulations yes yes charge normalization yes yes bond normalization CSC Registry Feature

slide-13
SLIDE 13

Registration vs. CSC: Data Entry

no yes link to assay data no yes amendments

  • ptional

yes full audit trail no yes workflow control / business process yes yes load batches of structures no yes draw & register single structs CSC Registry Feature

slide-14
SLIDE 14

Registration vs. CSC Searching

yes no supplier selection yes no reagent selection yes yes physical properties no yes mixtures & formulations no yes partial & relative stereochemistry yes yes substructure & similarity CSC Registry Feature

slide-15
SLIDE 15

CSC Database “Schema”

SUPPLIER SupplierID Name Address Telephone URL PARENT ParentID SMILES Coord2D ModDate PROPS ParentID MW MF HBD HBA RotBnd VERSION VersionID ParentID SMILES Coord2D MW MF ModDate SAMPLE SampleID VersionID IssueID CASNum Purity BoilingPt MeltingPt Density CATALOG CatalogID SupplierID Price Currency Units ModDate ISSUE IssueID CatalogID Name

slide-16
SLIDE 16

Modgraph CSC Demo

  • René: Key features for CSC

– Web interface – Hitlist concept – Very large databases

slide-17
SLIDE 17

Modgraph CSC Demo

  • René : Special Features for CSC

– Reagent Selection – Supplier Selection – Supplier / Catalogue Management – Holding Table – Salt Table

slide-18
SLIDE 18

Modgraph CSC Demo

  • Steps in Loading Data

– [optional] Create Supplier – [optional] Create Catalogue – Create Issue – Browse for SD File – Analyze SD File – [optional] Map datatypes – Load – Approve & Update

slide-19
SLIDE 19

Modgraph CSC

  • Demo...
slide-20
SLIDE 20

Modgraph CSC

  • Concluding Remarks

– Solves the problem of creating and maintaining a comprehensive, current, searchable chemical catalogue – Uses simplified registration technology – Daylight powers chemical searches – Affordable – Simple but powerful user interface

slide-21
SLIDE 21

Acknowledgements

  • Thanks to:

– Rashmi Mistry, Mike Wainwright, Dave Taylor, David Digby (Modgraph)

  • And of course...

– Jack Delany and the Daylight gang

slide-22
SLIDE 22

Contact

  • For more information:

Modgraph Consultants Ltd http://www.modgraph.co.uk (UK) (01438) 717 217 (USA) 760-212-9201