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

A-Team Insight Blogs

MarkLogic and ModelDR Propose a BCBS 239 Compliance Solution Based on Data Point Modelling

MarkLogic and ModelDR are challenging traditional approaches to BCBS 239 compliance with a solution that combines MarkLogic’s non-relational, multiple model database platform and ModelDR’s data point modelling software. The companies detailed their approach in a recent webinar, Sustained Compliance with BCBS 239, and said banks implementing the solution could lower costs, increase agility and ensure data quality while achieving compliance.

The webinar was moderated by Diane Burley, chief content strategist at MarkLogic, and joined by experts Chris Atkinson, solutions architect at MarkLogic, and Greg Soulsby and Simon Roberts, directors at ModelDR.

Atkinson started the conversation explaining the limitations of traditional data management and regulatory compliance processes. He said: “The most common approaches are to coalesce as many data sources as possible into a data warehouse, or to stitch together siloed data. A data warehouse needs a canonical data model that is very rigid. Silos offer more agility, but their cost is significant and if siloed data is put into a data warehouse it becomes brittle. Alternatively, multiple feeds can be sourced many times and calculations can be performed many times. In this scenario, consumers become servers and sources of data to others, but this is expensive, rigid and it is difficult to get a congruent view of data.”

Noting the need for banks to achieve BCBS 239 compliance, but also reduce costs, increase business agility and improve data quality – all contributors to a lower total cost of ownership – Atkinson highlighted a data point modelling solution that is used by the European Banking Authority to turn regulations into specifications. Banks, he said, could also gain from using the solution, which is relatively quick to implement and provides ongoing flexibility and agility for regulatory responses.

Looking at the practicalities of this type of solution, Soulsby described a data point model as a business rather than technology model that provides a base for concerns such as data quality, validation, storage, integration, reporting requirements definition and the generation of XBRL taxonomy. The model is combined with the MarkLogic multiple model database that can store multiple types of data in one database and support queries across the data, making it a good tool for data aggregation.

Atkinson explained: “The clever part is stitching regulatory requirements to data in the database. The data needs to be mapped and metadata attributes need to be created in the database and tagged to an ontology such as FIBO.” Combining the source metadata, ontology, an enterprise data model, and ModelDR data point models for diverse elements such as BCBS 239, MiFID II, data quality, FIBO and Murex with NoSQL and semantic queries it is possible to run queries across the models to generate a view of data that could be used for regulatory or other reporting purposes.

Soulsby says: “The combination of the MarkLogic database platform and ModelDR data point model allows data to be ingested dynamically without ETL tools and queries to be run on the fly in real time against any database in the bank. BCBS 239 suggests banks need these kinds of capabilities.”

Related content

WEBINAR

Recorded Webinar: Managing the transaction reporting landscape post Brexit: MiFID II, SFTR, EMIR

The transaction reporting landscape has, for many financial institutions, expanded considerably in size since the end of the UK’s Brexit transition period on 31 December 2020 and the resulting need for double reporting of some transactions to both EU and UK authorities. It has also changed dramatically following the UK government’s failure to reach equivalence...

BLOG

Qomply and Bovill Team Up on Regulatory Audits

Qomply, a RegTech firm specializing in transactions reporting for MiFIR, SFTR and EMIR, has joined forces with global financial services regulatory consultancy Bovill to develop an end-to-end transaction reporting service for financial institutions. Powered by Qomply’s technology, Bovill will streamline its HealthCheck services to provide clients with immediate feedback on the accuracy and completeness of...

EVENT

TradingTech Summit London

TradingTech Summit London will explore how trading firms are innovating in today’s cloud and digital based environment to create flexible, scalable trading platforms to support speed to market and business agility. Leveraging the cloud, AI and ML technologies to get an edge, automate processes and simplify operations in a cost effective way is the name of the game and will share practical insight from practitioners and technology leaders who are innovating and driving forward change in trading operations.

GUIDE

Entity Data Management Handbook – Seventh Edition

Sourcing entity data and ensuring efficient and effective entity data management is a challenge for many financial institutions as volumes of data rise, more regulations require entity data in reporting, and the fight again financial crime is escalated by bad actors using increasingly sophisticated techniques to attack processes and systems. That said, based on best...