Financial Watch:

UBS Deploys Sapior Redbridge to Enhance DW Performance

Sapior Ltd announces UBS AG, a leading global financial services firm, has deployed Sapior Redbridge, Sapior's specialized surrogate key mapping tool, to speed indexing and join performances of its credit risk data warehouse. Sapior Redbridge enhances data warehouse performance and facilitates the integration of customer data across multiple sources by providing high performance surrogate key look-up and generation especially for data warehouses and marts experiencing high data volumes and arrival rates.

UBS selected Sapior Redbridge to improve efficiency and to better meet the constraints of its data warehouse's daily processing window. In addition to high performance speeds and ease of use and administration, other important selection factors included Redbridge's ability to support multiple surrogate keys per row of input data, execute concurrent sessions on the same surrogate keys, and operate either as an Informatica PowerCenter extension or as a native Unix utility.

Now in production, UBS uses Sapior Redbridge to:

• Enhance performance by reducing the required number of passes through its data
• Enhance performance by concurrently processing multiple data streams
• Unify banking key formats across its many business units
• Protect/Insulate its technical key structures from changes in external key formats
• Generate compact surrogate keys to improve indexing and join processing time and to reduce storage requirements

"We employ Redbridge, Sapior's high performance surrogate key system, in order to substitute long natural banking keys with technical keys which speeds up the indexing and join performances in our credit risk data warehouse," says Andreas Hofer, Director and IT Project Manager of Credit Risk Control -- Framework. "Our quality standards are very high. Sapior Ltd. has met them and has proven to be flexible in adding supplemental features to their product to meet our requirements and expectations."

For a full case study on UBS' use of Sapior Redbridge, visit www.sapior.com.

About Sapior

London-based Sapior Ltd develops software to facilitate data integration and manage changes in copies of corporate data. Sapior Redbridge interoperates with existing ETL infrastructure to streamline the update of dimensional data marts to radically simplify work usually taking 30-50% of the total mart update time. Used by leading companies like UBS AG, Sapior Redbridge is specially designed for data warehouses/marts operating in complex, multi-processing, multi-user environments with increasing data volumes and arrival rates. For more information, contact Sapior at +44-(0)20-8530-4015.

London-based Sapior Ltd develops and markets products to facilitate data integration and manage changes in copies of corporate data. Sapior Redbridge interoperates with existing ETL infrastructure to accelerate and simplify surrogate key lookup and generation, the single longest component occupying 30-50% of the ETL processing time.

As a timely and affordable alternative to custom-built code, Sapior Redbridge minimises the technical difficulties, thus enabling you to benefit from the ease of administration, storage reduction, data anonymization, and query speed improvement that surrogate keys offer. Used by leading companies like UBS AG, Sapior Redbridge is specially designed for data warehouses/marts operating in complex multi-processing, multi-user environments and experiencing increasing data volumes and arrival rates.

Contact Sapior Ltd, London, Barbara Navarro, +44-(0)20-8530-4015, barbara.navarro@sapior.com.