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 SYSTEMcommands 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_ListToNumberTableD10was replace with the more optimizedSTRING_SPLIT. Additionally, indices were optimized withIncludeColumns. - For Oracle RDBMs, the
isource/InforShareCMdatabase no longer requires theANYprivilege. Additionally, indices were cleaned up and tuned.
- For Microsoft SQL Server,