Documentation Center

Database layer changes

Changes and additions impact Microsoft SQL Server and Oracle RDBMs database systems performance, setup or process.

Empty/demo database

This applies to both Microsoft SQL server and Oracle RDBMs. An "empty" database is available in order to facilitate fast setup. A more adapted expression than "empty" would be "ready to use", as this database already contains the basic structure helping an immediate application, as well as all minimal settings.

Specifically:
  • The database is upgraded to Content Manager 2016 level;
  • The latest out-of-the-box configuration files (e.g. Admin.XMLStatusConfiguration.xml) are submitted;
  • The status "Translation Rejected" which is used by Translation Management via the translation jobs is submitted;
  • The user role TRANSLATORSERVICE and user "ServiceUser" with user role TRANSLATORSERVICE are added to support translation jobs;
  • All editor templates are added and released in English, German, Dutch and Japanese;
  • For all output formats Keep default attributes is enabled to improve performance;
  • For Japanese .chm file support with code pages, all output formats with transtype htmlhelp are redirected to ishhtmlhelp;
  • Legacy electronic document types (EDTs) like EDT-WORD are removed;
  • EDTs for new MS Office formats like .docx (EDTDOCX) are submitted with the correct mime type . So, the "empty" database now contains EDTs for the following file extensions: .docx, .ppsx, .pptx, .xlsx, .3dxml, .jar, .mp3, .mpg, .smg, .svg, .svgz, .swf and .zip.

Microsoft SQL Server

Versions
Introducing Microsoft SQL Server 2014SP1 support, next to Microsoft SQL Server 2012 SP2.
Changes
  • During normal operation it is possible to run with revoked db_owner. Still required are: SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, CREATE VIEW, CREATE FUNCTION, CREATE PROCEDURE, REFERENCES, ALTER ANY SCHEMA and EXECUTE.
  • One job with 1 step which contains a stored procedure ISHCore_TrisoftInfoShareJob with optional parameters documented.
  • Only minimal maintenance: rebuild indexes for fragmentation > 10% and update statistics using SQL Server method without full scan.

Oracle RDBMs

Versions
Introducing Oracle RDBMs 12c support.
Ensuing from this:
  • Oracle Data Access Client (ODAC) raised from 11.2.0.4 to 12.1.0.1.2. This version offers us better transaction handling. For .NET components even less distributed MSDTC-promoted transactions.
  • Gathering statistics is now rerouted to the standard Oracle autotask instead of our database job TRIDKANALYZEDB. This leads to a faster DBUpgradeTool (DBUT) run.
  • The performance is improved when passing larger data sets to our *_VALUES tables, like for example STRING_VALUES or NUMBER_VALUES.
Required differences when upgrading our database from a previous Oracle setup to Oracle RDBMs 12c:
  • We stepped away from the Oracle deprecated UTF8 character set in favor of AL32UTF8. AL32UTF8 character set.
  • Reduced tablespaces to only ISH_DATA_M, ISH_INDEX_M and ISRC_PAGE. Storage clauses are removed.
  • NLS_LENGTH_SEMANTICS remains BYTE and no longer required to switch to CHAR.
  • Reduced minimal isource user rights, resulting in matching isrcuser.i and CheckMinimalUserRoles.sql.
  • The documentation describes import/export routines based on Oracle's data pump technology exdp and impdp instead of deprecated exp and imp.
  • Matching new database template file are delivered.
  • Dynamic sampling is new in Oracle RDBMs 12c and gathers statistics on the fly during query execution. However, on all our test environments this had a neutral to adverse effect which made us decide to turn off Dynamic sampling. We set Oracle optimizer_dynamic_sampling to 0 instead of the default setting 2.