The leading knowledge platform for the financial technology industry
The leading knowledge platform for the financial technology industry

A-Team Insight Blogs

Unifying Data for the End-User

The data that traders, researchers and risk managers need is often located across many systems. While ETL, middle-ware and traditional golden copy approaches are useful for data management, they don’t provide the business user with an easy way of analyzing this distributed data, says Xenomorph in its new white paper “TimeScape Data Unification”.

A key business and technical challenge for many large financial institutions is to knit together their many disparate data sources, databases and systems into one consistent framework that can meet the ongoing demands of the business, its clients and regulators, the vendor says. For example, post-crisis it is clear that risk managers need easy and more timely access to all kinds of data, regardless of data type (positional, market, entity), hosting system or data source.

Some have responded to this issue by implementing a middleware or ETL-type infrastructure. However, this is a technical solution to the data integration problem and does not go far enough in delivering a business-focused way of presenting data and allowing the more complex business objects to be analysed. As a result, risk management and trading staff are still left with the challenge of how best to access related datasets across a variety of disparate systems.

The data warehouse approach to golden copy data management can be very effective, but this can be difficult to implement in a short time-frame, particularly if the technology used lacks flexibility in its data model and is faced with a variety of intertwined legacy systems. Traditional golden copy management is often siloed alongside a particular asset class, type of data or business function and does not deal with the management of data once it has been delivered to downstream systems and users. Additionally, these traditional data management approaches often lack real-time analytical and business functionality.

Companies looking to satisfy the need for business-user access to data across multiple systems should consider a “distributed golden copy” approach. This federated approach deals with disparate and distributed sources of data and should also provide easy end-user interactivity whilst maintaining data quality and auditability. Access to data is normalised in real-time but the data itself is not duplicated in other databases and systems, hence problems with inconsistency are reduced.

“Data management for the end consumer is an often overlooked area and the federated approach to accessing distributed systems is an attractive architecture, one that can be used to augment ETL and centralized golden copy. This form of data virtualization is a very powerful data management technique, but it should be applied with the needs of both end users and technologists in mind,” concludes Brian Sentance, CEO Xenomorph.

Related content

WEBINAR

Upcoming Webinar: Getting ready for Sustainable Finance Disclosure Regulation (SFDR) and ESG – what action should asset managers be taking now?

Date: 8 June 2021 Time: 10:00am ET / 3:00pm London / 4:00pm CET Duration: 50 minutes Interest in Environmental, Social and Governance (ESG) investment has exploded in recent years, bringing with it regulation and a requirement for buy-side firms to develop ESG strategies and meet disclosure obligations. The sell-side can help here by integrating ESG...

BLOG

How to Combine Data Science and Analytics to Drive Business Value Out of Data

Data science and analytics are critical to driving value out of data, delivering business insight at speed, and gaining competitive advantage. With so much at stake, financial institutions need a strategy that puts data scientists in business units, identifies appropriate technologies and tools, and scales solutions beyond proofs of concept. This week’s A-Team Group webinar...

EVENT

RegTech Summit APAC

RegTech Summit APAC will explore the current regulatory environment in Asia Pacific, the impact of COVID on the RegTech industry and the extent to which the pandemic has acted a catalyst for RegTech adoption in financial markets.

GUIDE

Regulatory Data Handbook 2020/2021 – Eighth Edition

This eighth edition of A-Team Group’s Regulatory Data Handbook is a ‘must-have’ for capital markets participants during this period of unprecedented change. Available free of charge, it profiles every regulation that impacts capital markets data management practices giving you: A detailed overview of each regulation with key dates, data and data management implications, links to...