--- title: Data Warehousing Alternatives Weighed description: Data Warehousing Alternatives Weighed --- ![websites-group](https://articles.marketsmedia.com/hubfs/raw_assets/public/MarketsMedia_August2021/images/new-MMG-01.svg) [![](https://articles.marketsmedia.com/hubfs/raw_assets/public/MarketsMedia_August2021/images/dropdown-new-marketsmedia-logo.svg)](https://www.marketsmedia.com/) [![](https://articles.marketsmedia.com/hubfs/raw_assets/public/MarketsMedia_August2021/images/dropdown-menu-traders-redlogo.svg)](https://www.tradersmagazine.com/) [![](https://articles.marketsmedia.com/hubfs/raw_assets/public/MarketsMedia_August2021/images/dropdown-menu-bestexe-logo.svg)](https://www.bestexecution.net/) [![](https://articles.marketsmedia.com/hubfs/raw_assets/public/MarketsMedia_August2021/images/dropdown-menu-fidesk-logo.svg)](https://www.fixglobal.com/) [![](https://articles.marketsmedia.com/hubfs/raw_assets/public/MarketsMedia_August2021/images/dropdown-fixglobal-new-logo.svg)](https://www.fixglobal.com/) - [*Facebook*](https://www.facebook.com/MarketsMedia/) - [*Twitter*](https://twitter.com/marketsmedia) - [*Linkedin*](https://www.linkedin.com/company/markets-media-llc) - [Newsletter](https://articles.marketsmedia.com/data-warehousing-alternatives-weighed#popup-newsletter) #### Want the latest news on securities markets -- FREE? Sign up to receive exclusive articles on topics including: - Equity market structure - Profiles of buy-side investment firms - The evolution of multi-asset-class trading - Regulation and its implications for markets - The search for liquidity in fixed income markets - The convergence of fintech and capital markets Select one or more newsletters you would like to receive: menu [![Markerts media](https://articles.marketsmedia.com/hubfs/raw_assets/public/MarketsMedia_August2021/images/header%20logo.svg "Markerts media")](https://articles.marketsmedia.com/) - [Latest News](https://articles.marketsmedia.com/tag/latest-news) - Latest News - Data Warehousing Alternatives Weighed Search - [Home](https://articles.marketsmedia.com/) - [Trending](https://articles.marketsmedia.com/tag/trending) - [Featured](https://articles.marketsmedia.com/tag/daily-email-feature) - [Sectors](https://articles.marketsmedia.com/tag/sectors) - [From The Markets](https://articles.marketsmedia.com/tag/from-the-markets) - [AWARDS](https://articles.marketsmedia.com/tag/events) - [Newsletter](https://awards.marketsmedia.com/newsletter-sign-up) - [Newsletter](https://articles.marketsmedia.com/data-warehousing-alternatives-weighed#popup-newsletter) Hide search Search - NewsLetter ![](https://articles.marketsmedia.com/hubfs/Imported_Blog_Media/trading-up-occ-iex-select-board-members-citadel-lands-lieblich-573x379-Jul-07-2022-09-34-11-57-AM.jpg) [ON THE MOVE: Citi Hires Artie Ambrose;...](https://articles.marketsmedia.com/on-the-move-citi-hires-artie-ambrose-natalie-a-brown-to-mesirow) ![](https://articles.marketsmedia.com/hubfs/Imported_Blog_Media/Depositphotos_445735906_L.jpg) [Trading Adapts to ESG and Sustainable...](https://articles.marketsmedia.com/trading-adapts-to-esg-and-sustainable-investing) ![](https://articles.marketsmedia.com/hubfs/Imported_Blog_Media/iStock-917493152-Jul-07-2022-09-34-19-09-AM.jpg) [Focus on FX Execution Connectivity](https://articles.marketsmedia.com/focus-on-fx-execution-connectivity) ![](https://articles.marketsmedia.com/hubfs/Imported_Blog_Media/Depositphotos_333839538_L.jpg) [TRACE Turns 20](https://articles.marketsmedia.com/trace-turns-20) 08.31.2011 By Terry Flanagan Latest News # Data Warehousing Alternatives Weighed 08.31.2011 By Terry Flanagan [Share](https://www.facebook.com/share.php?u=https://articles.marketsmedia.com/data-warehousing-alternatives-weighed) [Tweet](https://twitter.com/intent/tweet?text=US+ETFs+Have+Record+Net+Inflows&url=https://articles.marketsmedia.com/data-warehousing-alternatives-weighed) [Share](https://www.linkedin.com/cws/share?url=https://articles.marketsmedia.com/data-warehousing-alternatives-weighed) Regulatory focus on data drives out-of-the-box solutions. Burning issues of data management driven by regulatory reforms are causing financial firms to seek out-of-the-box technology solutions. “Risk management driven by regulatory and client pressure is one of the hot topics in data management for our clients,”  Brian Sentance, CEO of Xenomorph, told Markets Media.  “Regulation and reduced availability of trading capital is also a driving force behind increased data quality and transparency in financial markets.” In the derivatives markets, the move to centralized clearing is an industry changing initiative, but there is also much to done in successfully managing portfolios of more complex derivative products following the crisis. Regulatory focus on data, for example with initiatives such as the Office of Financial Research (OFR) in the U.S., will make more financial institutions to look at data as an important resource to be managed and analyzed as a part of institutional governance, and not just as an adhoc consequence of implementing one system or another. “Once a data management foundation is in place, perhaps driven by regulation initially, such a foundation will also become recognized as a key source of competitive agility and advantage,” said Sentence. The data that traders, researchers and risk managers need is often located across many systems. While ETL, middleware 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. Companies looking to satisfy the need for business-user access to data across multiple systems should consider a “distributed golden copy” approach, a pragmatic architecture for improving the accessibility, transparency and quality of data in a systems environment that contains many legacy systems and databases. “This approach involves looking at your existing sources of data, and analyzing whether there are any existing systems or databases that should continue to be a primary source/origin of data, given the difficulty or impracticability of replacing such systems given the resources or timelines available,” Sentence said. "Distributed golden copy is not a single answer, but rather an approach that can work in concert with ETL and data warehousing solutions to improve data transparency and hence quality.” [Share](https://www.facebook.com/share.php?u=https://articles.marketsmedia.com/data-warehousing-alternatives-weighed) [Tweet](https://twitter.com/intent/tweet?text=US+ETFs+Have+Record+Net+Inflows&url=https://articles.marketsmedia.com/data-warehousing-alternatives-weighed) [Share](https://www.linkedin.com/cws/share?url=https://articles.marketsmedia.com/data-warehousing-alternatives-weighed) ![email](https://articles.marketsmedia.com/hubfs/Markets%20Media/email.svg) ### NEWSLETTER SIGN UP And receive exclusive articles on securities markets ### Related articles 1. [![](https://articles.marketsmedia.com/hs-fs/hubfs/Imported_Blog_Media/EMCA-WINNERS.jpeg?width=376&height=250&name=EMCA-WINNERS.jpeg)](https://articles.marketsmedia.com/european-markets-choice-awards-2022-the-winners) Latest News ## [European Markets Choice Awards 2022 – The Winners](https://articles.marketsmedia.com/european-markets-choice-awards-2022-the-winners) On 5 June Markets Media held its first in person European Markets Choice Awards event in London. 07.06.2022 By Markets Media 2. [![](https://articles.marketsmedia.com/hs-fs/hubfs/Imported_Blog_Media/trading-up-occ-iex-select-board-members-citadel-lands-lieblich-573x379-Jul-07-2022-09-34-11-57-AM.jpg?width=376&height=250&name=trading-up-occ-iex-select-board-members-citadel-lands-lieblich-573x379-Jul-07-2022-09-34-11-57-AM.jpg)](https://articles.marketsmedia.com/on-the-move-citi-hires-artie-ambrose-natalie-a-brown-to-mesirow) Daily Email Feature ## [ON THE MOVE: Citi Hires Artie Ambrose; Natalie A. Brown to Mesirow](https://articles.marketsmedia.com/on-the-move-citi-hires-artie-ambrose-natalie-a-brown-to-mesirow) The weekly recap of new hires, promotions and job changes in capital markets trading and technology. 07.05.2022 By Anna Lyudvig, Traders Magazine 3. [![](https://articles.marketsmedia.com/hs-fs/hubfs/Imported_Blog_Media/339299_345359258874293_1089957387_o.jpg?width=376&height=250&name=339299_345359258874293_1089957387_o.jpg)](https://articles.marketsmedia.com/summer-trading-2012-10-years-on) Latest News ## [Summer Trading 2012, 10 Years On](https://articles.marketsmedia.com/summer-trading-2012-10-years-on) A look back at a Markets Media event from a decade ago. 07.05.2022 By Traders Magazine [![MarketsMedia](https://articles.marketsmedia.com/hubfs/MarketsMedia.svg "MarketsMedia")](http://marketsmedia.com) - [About us](https://www.marketsmedia.com/about-us) - [Careers](https://www.marketsmediagroup.com/careers) - [Contact](https://www.marketsmediagroup.com/contact) - [Advertise](https://www.marketsmediagroup.com/advertise) - [Newsletter](https://awards.marketsmedia.com/newsletter-sign-up) - [Corporate Site](https://marketsmediagroup.com) - © 2026 Markets Media Holdings LLC - - Terms & Conditions - Privacy Policy {{ standard\_footer\_includes }}