Installing Data Normalization Module Databases

The Data Normalization Module provides a load utility to install databases for the Advanced Transformer, Open Parser, and Table Lookup components. The database files that you install depend on the databases you have licensed. Use this list of database tables to determine which files you should download and install. For more information on the tables contained in each database, refer to the reference documentation for each component.

Stage Available Databases
Advanced Transformer Data Normalization Module - Base Tables
Open Parser
  • Data Normalization Module - Base Tables
  • Core Names Database
  • Company Names Database
  • Arabic Plus Pack
  • Asian Plus Pack
Table Lookup
  • Data Normalization Module - Base Tables
  • Core Names Database
  • Arabic Plus Pack
  • Asian Plus Pack
  • ZREPLACE (Used by the SAP Module for French address validation)
  1. If you have Oracle environment variables set in your profile, these environment variables may interfere with DVD database loading processes. If you experience database loading problems and are using Oracle, check that the Oracle environment variables are not active when you perform the DVD database loads.
  2. Make sure that Spectrum™ Technology Platform is stopped. To stop Spectrum™ Technology Platform, change the working directory to the bin directory of where Spectrum™ Technology Platform is installed, then type the following command:
    ./server.stop
  3. Insert the database DVD or download the database from www.g1.com/support.
    Note: If you download the database from the technical support web site, it will be downloaded as a zip file. Unzip the database before proceeding with the installation.
  4. If you are installing from DVD and your system does not auto-mount, issue the appropriate mount command to indicate that the DVD device is a file system.

    If necessary, issue the /etc/filesystem command to update your system so that it recognizes this file system. Specify the correct device name for the DVD device on your system.

    Note: Your system must allow DVDs created under the ISO 9660 format to be mounted as a file system.
  5. Change the working directory to the bin directory of where Spectrum™ Technology Platform is installed.
  6. Source the "setup" bourne shell script to setup the environment by typing the following command:
    . ./setup
  7. Execute the script for installing the database by typing the following command:
    ./installdb_dnm
  8. Follow the prompts as the script verifies your environment and database location.
    Note: You may install databases on a network share, but performance will be affected since you will be accessing them on a network rather than accessing them locally.
  9. Open the file <SpectrumDirectory>/server/bin/wrapper/wrapper.conf in a text editor.
  10. Increase the Java settings for initial heap size (wrapper.java.initmemory) and maximum heap size (wrapper.java.maxmemory) to reflect the total amount of memory required for the Arabic Plus Pack and Asian Plus Pack.
    • Arabic Plus Pack: 5.5 GB
    • Asian Plus Pack - Chinese: 32 MB
    • Asian Plus Pack - Japanese: 1.6 GB
    • Asian Plus Pack - Korean: 8 MB
    • Core Names: 1.1 GB
  11. Save and close wrapper.conf.
  12. Start the Spectrum™ Technology Platform by changing the working directory to the bin directory of where Spectrum™ Technology Platform is installed, then type the following command:
    ./server.start