Founded in 1993, Information Processing Center or Informations-Verarbeitungs-Zentrum (IVZ) is a joint facility for public broadcasting institutions. The organization has approximately 80 employees working at its four locations in Berlin, Hamburg, Leipzig, and Cologne. As a full-service provider, IVZ operates and supports public broadcasting institutions’ archive systems. During its radio broadcasting database project, 10 radio broadcasters collaborated by sharing one database instance, causing significant challenges for IVZ in updating and backing up an increasingly high-volume of radio broadcasting databases. Data reorganization during normal operations and during upgrade or damage scenarios (export/import processes, backup recovery and recreation of full-text indexes) exceeded acceptable time windows but was absolutely necessary, as partial data reorganization is crucial to maintaining the full-text indexes of the shared database instance, including upgrades of search documents and the full-text index itself.
IVZ deployed Oracle Advanced Compression with Oracle Database 11g to address these challenges. IVZ can now reorganize full-text indexes 400% faster, which is essential as broadcast data in this environment continues to grow exponentially. By compressing CLOB tables, search documents and full-text information, IVZ also improved speeds when working on damage scenarios, resulting in significantly faster data loss recovery. RMAN, export-import processes, and the rebuilding of search documents and full-text indexes have especially improved. The organization has also reduced its storage media usage by more than 50%, resulting in reducing the cost of storage hardware. IVZ also realized backup application acceleration in online and batch transaction processing, and, thanks to this improvement, can now complete essential batch jobs on time, overnight.