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
TRANSLATORSERVICEand user "ServiceUser" with user roleTRANSLATORSERVICEare 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
htmlhelpare redirected toishhtmlhelp; - Legacy electronic document types (EDTs) like
EDT-WORDare 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 SCHEMAandEXECUTE. - 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.
- During normal operation it is possible to run with revoked
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
autotaskinstead of our database jobTRIDKANALYZEDB. This leads to a faster DBUpgradeTool (DBUT) run. - The performance is improved when passing larger data sets to our
*_VALUEStables, like for exampleSTRING_VALUESorNUMBER_VALUES.
Required differences when upgrading our database from a previous Oracle setup to Oracle RDBMs 12c:
- We stepped away from the Oracle deprecated
UTF8character set in favor ofAL32UTF8.AL32UTF8character set. - Reduced tablespaces to only
ISH_DATA_M,ISH_INDEX_MandISRC_PAGE. Storage clauses are removed. NLS_LENGTH_SEMANTICSremainsBYTEand no longer required to switch toCHAR.- Reduced minimal
isourceuser 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_samplingto 0 instead of the default setting 2.