Documentation Center

Database layer changes (15.1.0)

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

Reduced minimum rights for Oracle databases
The minimum rights required for installing, upgrading or configuring an Oracle database have been reduced. As a result, some ALTER SYSTEM commands now need to be executed by hand rather than by Tridion Docs database scripts.
Additional database
This release introduces the new Metrics database, InfoShareMT, which serves as secondary storage for separate aggregation and calculations of future statistics.
Database refactoring
The refactoring to one database layer (dropping COM+), which was started in Tridion Docs 15, has continued inside the database:
  • For Microsoft SQL Server, ISHCore_ListToStringTableNVC255/ISHCore_ListToNumberTableD10 was replace with the more optimized STRING_SPLIT. Additionally, indices were optimized with IncludeColumns.
  • For Oracle RDBMs, the isource/InforShareCM database no longer requires the ANY privilege. Additionally, indices were cleaned up and tuned.