Suncorp to decommission data warehouses

 

Installs more processors for assembly on demand.

Suncorp Group will decommission its six enterprise data warehouses in the coming 18 months to improve the scalability and speed of its analytics.

The group has deployed software systems and 200 processor cores to allow it to search through and analyse 100TB of data from disparate sources on demand and in near real-time.

Suncorp’s business intelligence strategy architect Shaun Deierl told the CeBIT Big Data conference yesterday that the new data strategy had been two years in the making.

“The whole philosophy of structuring data at the point of acquiring it doesn’t work,” he said.

“We have a claims system with 2000 tables. We’re really agile, so there [are] changes to the underlying data structure every week.

“For you to have a traditional warehousing space to keep up with that, you never keep up with it.”

Deierl told conference delegates that the group had moved away from traditional extract, transform, load (ETL) processes, redeploying 14 ETL professionals earlier this year.

His 175-person analytics team used IBM’s InfoSphere Change Data Capture (CDC) technology to scrape data from various backend systems, including mainframe and midrange technology.

Data was then fed into an IBM Netezza analytics platform, and queried using Java models.

Suncorp also evaluated Oracle and SAS platforms, and installed Hadoop big data analytics technology early last year but was "struggling to find the problem to solve" with the latter.

Deierl noted that the move away from data warehousing took “courage” – one of Suncorp’s six core values – especially given the amount of investment behind each of the warehouses.

He said the system had been used to analyse the insurance claims experience for about a tenth the cost so far.

“Return on investment is really hard to say because we provide the data but you’ve got to use it,” he noted.

“We’ve been delivering for the past 12 months … Every two weeks, we have to prove [the system’s value].”

Deierl said Suncorp had not forced business units to move away from data warehouses but aimed to attract them to the new architecture instead.

The business intelligence team planned to cease supporting various systems in step with Suncorp’s simplification plan.

It would then treat any decommissioned data warehouses as one of several sources of data to be scraped with CDC.

“Some of these warehouses are six terabytes and they don’t change much, and most of it is indexing,” Deierl noted.

“We take the warehouse as a source, so we hook CDC up to it and the warehouse is basically a proxy for all the systems that we want to turn off.”

Ideally, Deierl said Suncorp hoped to treat data like it did IT infrastructure, moving it from closed, proprietary systems to ubiquity.

“If you have a Google-like experience where you type in a word and it then does that without having data modellers in between, it’s brilliant,” he said.

Copyright © iTnews.com.au . All rights reserved.


Suncorp to decommission data warehouses
 
 
 
Top Stories
Frugality as a service: the Amazon story
Behind the scenes, Amazon Web Services is one lean machine.
 
Negotiating with the cloud email megavendors
[Blog post] Lessons from Woolworths’ mammoth migration.
 
Qld govt to move up to 149k staff onto Office 365
Australia's largest deployment, outside of the universities.
 
 
Sign up to receive iTnews email bulletins
   FOLLOW US...

Latest VideosSee all videos »

The great data centre opportunity on Australia's doorstep
The great data centre opportunity on Australia's doorstep
Scott Noteboom, CEO of LitBit speaking at The Australian Data Centre Strategy Summit 2014 in the Gold Coast, Queensland, Australia. http://bit.ly/1qpxVfV Scott Noteboom is a data centre engineer who led builds for Apple and Yahoo in the earliest days of the cloud, and who now eyes Asia as the next big opportunity. Read more: http://www.itnews.com.au/News/372482,how-do-we-serve-three-billion-new-internet-users.aspx#ixzz2yNLmMG5C
Interview: Karl Maftoum, CIO, ACMA
Interview: Karl Maftoum, CIO, ACMA
To COTS or not to COTS? iTnews asks Karl Maftoum, CIO of the ACMA, at the CIO Strategy Summit.
Susan Sly: What is the Role of the CIO?
Susan Sly: What is the Role of the CIO?
AEMO chief information officer Susan Sly calls for more collaboration among Australia's technology leaders at the CIO Strategy Summit.
Meet the 2014 Finance CIO of the Year
Meet the 2014 Finance CIO of the Year
Credit Union Australia's David Gee awarded Finance CIO of the Year at the iTnews Benchmark Awards.
Meet the 2014 Retail CIO of the Year
Meet the 2014 Retail CIO of the Year
Damon Rees named Retail CIO of the Year at the iTnews Benchmark Awards for his work at Woolworths.
Robyn Elliott named the 2014 Utilities CIO of the Year
Robyn Elliott named the 2014 Utilities CIO of the Year
Acting Foxtel CIO David Marks accepts an iTnews Benchmark Award on behalf of Robyn Elliott.
Meet the 2014 Industrial CIO of the Year
Meet the 2014 Industrial CIO of the Year
Sanjay Mehta named Industrial CIO of the Year at the iTnews Benchmark Awards for his work at ConocoPhillips.
Meet the 2014 Healthcare CIO of the Year
Meet the 2014 Healthcare CIO of the Year
Greg Wells named Healthcare CIO of the Year at the iTnews Benchmark Awards for his work at NSW Health.
Meet the 2014 Education CIO of the Year
Meet the 2014 Education CIO of the Year
William Confalonieri named Healthcare CIO of the Year at the iTnews Benchmark Awards for his work at Deakin University.
Meet the 2014 Government CIO of the Year
Meet the 2014 Government CIO of the Year
David Johnson named Government CIO of the Year at the iTnews Benchmark Awards for his work at the Queensland Police Service.
Q and A: Coalition Broadband Policy
Q and A: Coalition Broadband Policy
Malcolm Turnbull and Tony Abbott discuss the Coalition's broadband policy with the press.
AFP scalps hacker 'leader' inside Australia's IT ranks.
AFP scalps hacker 'leader' inside Australia's IT ranks.
The Australian Federal Police have arrested a Sydney-based IT security professional for hacking a government website.
NBN Petition Delivered To Turnbull's Office
NBN Petition Delivered To Turnbull's Office
UTS CIO: IT teams of the future
UTS CIO: IT teams of the future
UTS CIO Chrissy Burns talks data.
New UTS Building: the IT within
New UTS Building: the IT within
The IT behind tomorrow's universities.
iTnews' NBN Panel
iTnews' NBN Panel
Is your enterprise NBN-ready?
Introducing iTnews Labs
Introducing iTnews Labs
See a timelapse of the iTnews labs being unboxed, set up and switched on! iTnews will produce independent testing of the latest enterprise software to hit the market after installing a purpose-built test lab in Sydney. Watch the installation of two DL380p servers, two HP StoreVirtual 4330 storage arrays and two HP ProCurve 2920 switches.
The True Cost of BYOD
The True Cost of BYOD
iTnews' Brett Winterford gives attendees of the first 'Touch Tomorrow' event in Brisbane a brief look at his research into enterprise mobility. What are the use cases and how can they be quantified? What price should you expect to pay for securing mobile access to corporate applications? What's coming around the corner?
Ghost clouds
Ghost clouds
ACMA chair Chris Chapman says there is uncertainty over whether certain classes of cloud service providers are caught by regulations.
Was the Snowden leak inevitable?
Was the Snowden leak inevitable?
Privacy experts David Vaile (UNSW Cyberspace Law and Policy Centre) and Craig Scroggie (CEO, NextDC) claim they were not surprised by the Snowden leaks about the NSA's PRISM program.
Latest Comments
Polls
Which bank is most likely to suffer an RBS-style meltdown?





   |   View results
ANZ
  21%
 
Bankwest
  9%
 
CommBank
  11%
 
National Australia Bank
  17%
 
Suncorp
  24%
 
Westpac
  19%
TOTAL VOTES: 1428

Vote