Solutions

JHZ-CS Solutions supporting Relational Database Management System (RDBMS) data sources utilize PERL DBI (Database Independence) provide support most popular SQL database management systems and provide easy migration between database systems with minimal requirements.

To use SQL data sources with JHZ-CS Solutions, a database management system (DBMS) must be previously installed and configured on the web server. PERL DBI DBD (Database Drivers) provides the API (Application Program Interface) to the DBMS. The PERL DBI DBD modules are available as free distributions from CPAN supporting:

Following initial installation JHZ-CS Solutions may continue to use the IID for data management purposes, or optionally data may be migrated to any PERL DBI DBD supportive database system. JHZ-CS Database Maintenance solution may be used to migrate the IID data to the RDBMS.

To activate RDBMS functionality within JHZ-CS Solutions update the file system configuration settings with the required database information specific to the installation. After having successfully migrated the IID data to the RDBMS (see the JHZ-CS Database Maintenance Solution), its possible to easily toggle back and forth from using the RDBMS or IID by changing the configuration switch $use_database from TRUE to FALSE. (The IID serves a back-up data system permitting the system to operate without the RDBMS.)

JHZ-CS achieves its cross-platform support enabling easy migration across systems by adhering to ANSI standard based SQL in support of future requirements.