Administration Guide for Composite DB

This guide provides background information about the usage of Composite DB in JChem. It contains information about the special configuration issues for Composite DB.

  1. How to use JChem with Composite DB JChem supports Composite DB in read-only mode. SQL DDL and DML commands (Table creation, modification, data insert, update, delete commands) are not applicable. Searching with JChem works with predefined JChem tables which are integrated into a Composite Virtual DB. Composite supports the following JChem supported database systems: Oracle, Microsoft SQL Server, MySQL, DB2, Microsoft Access.

  2. Configuration of a Composite Virtual DB for JChem search Virtualization levels of a Composite DB:

    • Domain

      • Virtual DB

        • Catalog (if physical database supports it)

          • Schema (if physical database supports it. The schema name has to be the same as the physical database's schema name.)

Every physical database table must be published into a Virtual DB. The table might be published directly under a Virtual DB, or under a catalog or schema. The _UL (update log), property and property_CR tables must be in the same virtual DB, catalog or schema.