ABSTRACT

Optimize Your Chemical DatabaseDesign and Use of Relational Databases in Chemistry helps programmers and users improve their ability to search and manipulate chemical structures and information, especially when using chemical database "cartridges". It illustrates how the organizational, data integrity, and extensibility properties of relational dat

Introduction. Relational Database Fundamentals. Structured Query Language (SQL). Relational Database Management Systems (RDBMS). Client and Web Applications. Data Storage, Searching, and Manipulation. Computer Representations of Molecular Structures. Molecular Fragments and Fingerprints. Reactions and Transformations. PostgreSQL Extensions. Three-Dimensional Molecular Structure Tables. More on Client and Web Interfaces to RDBMS. Applications. Appendix. Index.