On Data Warehouse

A Graz Sweden Blog


Leave a comment

Data quality, Data Warehouse and Solvency II Compliance

If all processes run on schedule, the insurance industry in the European Union will be staring at new regulation effective 2014. The new directive, Solvency 2, is meant to plug gaps present in its 1973 predecessor, Solvency I – primarily better risk management as well as correcting the inability of the first directive to lead to the harmonization of insurer supervision among member countries. Of course, the need for Solvency 2 has been further expedited by the events of 2008 where insurance companies were hit just as much as banks. For instance, the American International Group (AIG) had to be saved via a $185 billion US government bailout – the largest any US financial institution received.

Continue reading


Leave a comment

Anticipated Fund Manager Re-Alignments with UCITS IV Implementation

With the coming into effect of UCITS IV (Undertakings for Collective Investment in Transferable Securities) in July 2011, one thing is for sure – fund managers in the European Union have had to evolve with the fast changing regulatory environment. And if past respect for UCITS funds in other parts of the world such as Asia is anything to go by, it is only a matter of time before the standards outlined in the new directive become de facto best practice in markets outside the European Union.

Continue reading


Leave a comment

MiFID II Will Mean Increased Demand on Financial Data Warehouse Infrastructure

If there is one category of financial instrument that has been most frequently blamed for the financial crisis that plagued US and European financial markets in 2008, it was derivatives. Predictably, governments in both jurisdictions have moved to review the existing regulatory framework and develop new rules that would reduce the likelihood of such a crisis occurring again. In the US, these new rules were actualized by the Dodd Frank Act of 2010 (in full, the Wall Street Reform and Consumer Protection Act).

Continue reading


Leave a comment

To Get the Technology for Solvency II Right, Insurers Must First Get Workflows Right

Solvency II has 3 pillars – Pillar I that address capital requirements, Pillar II that is focused on workflow, governance and audit, while Pillar 3 details the framework for reporting. Unsurprisingly, Pillar I has attracted the most attention with insurers evaluating their entire business to determine what the new capital requirements will entail. But the significance of Pillar 2 and 3 is gradually dawning on the industry as institutions realize that compliance with these aspects will be just as important.

Continue reading


Leave a comment

Past and present trends shaping the future of data warehousing

No other industry in the world experiences as much change as technology does. True to form, data warehousing as we know it is no longer what it was 5 or 10 years ago. New demands from customers, businesses and regulators continue to push the envelope on data warehouse capability and flexibility. The emergence of what is often referred to as ‘big data’ (terabytes of business information belonging to or under the custody of a single organisation) has introduced substantial challenges for businesses keen on staying on top of spiralling data volume, speed and complexity.
Continue reading


Leave a comment

Basel III and Data Warehouse Infrastructure

2007 to 2009 is a period that will remain etched  in the minds of financial industry policy makers for years to come. Complex financial instruments, wrongly priced risks coupled with pressure to churn ever higher employee bonuses and bank profits all combined to create the biggest financial crisis since the Great Depression. The US and EU financial markets, once assumed impregnable, faced the real possibility of collapse pulling down the global economy in the process. As hundreds of billions of dollars in government bailouts were pumped into banks and insurance companies considered ‘too big to fail’, regulators had to come to grips with the fact that the Basel II guideline on bank risk management had loopholes and inadequacies that had to be addressed to prevent a recurrence. And with that, Basel III was born.

Continue reading


Leave a comment

Content analysis in future data warehouse

The data warehouse market has seen substantial growth over the last 2-3 years despite the difficult economic conditions in the world’s more developed economies. Tech giants such as Microsoft, EMC, Oracle, IBM and Teradata have either rolled out new data warehouse appliances or upgraded their existing product lines.

The expansion of the data warehouse space during such tough times is largely due to a growing realization of the business value and competitive advantage such technology delivers. This business value is in the form of efficient analytics, better business intelligence, ease of forecasting and compliance with regulatory reporting requirements. In fact, the data warehouse has today become mission-critical infrastructure in many businesses.

Continue reading