New in 430
This file contains information about tables and fields in the PlantStar Panorama 430 database.As of 430 the database has been changed from Ingres II to MySql version 5.0. This change will mostly be invisible to the user.
Some items that the user will see are:
- The ability to establish more connections to the database.
- The ability to backup and do maintenance on the database without shutting shop floor applications down.
- A Probable increase in speed for processing of queries.
The database itself has changed little since 420 as most of the effort was used to change from Ingres embedded code to MySql embedded code.
The most important change from a performance perspective is the addition of primary keys to all tables with more than 1 record. In 420 and below Ingres did not have primary keys per se, but allowed unique indices to be added after the fact. The problem with this approach is that a duplicate record can be inserted into a table, and then when the unique index is created, the duplicate record will cause the creation of the unique index to fail. This has been one of the causes for "the system is running slow". This reason will be eliminated in 430.
Several field names where changed because they are reserved words in MySql. They include:
comment has been changed to comments.
year has been changed to prod_year.
lock has been changed to pid_lock.
usage has been changed to com_usage in mcim_com_def.
usage has been changed to prof_usage in prof_def.
usage has been changed to pvar_usage in pvar_def.
Most other table changes have been in the ordering of fields within tables for consistency, and will be invisible to the user unless a "select * from" query is used.