Case Study : How an Islamic Bank managed data growth and improved application performance using Database Archiving

(1)

Case Study : How an Islamic Bank

managed data growth and improved

application performance using

Database Archiving

Presenter

Dan Stevens

Solix Technologies

(2)

Banking Sector

• The sector growth is fueled by the UAE’s robust

economic growth

• Banks benefit from the favorable demographics,

pushed by the rise in the expatriate workforce

• Majority government ownership supports local banks

• Healthy competition, with minimal pressure on

spreads and margins

• Strong profitability levels

• High asset quality

(3)

Islamic Bank

• Headquartered in Dubai, UAE

• Established 1975

• 62 Branches in UAE

• ~ 400 institutions

• Estimated $3.2 Billion AED in revenue in 2010

• Assets under management in excess of $1 trillion AED

• ~6,900 employees

• Worlds first fully-fledged Islamic bank

• Emirates Real Estate Investment Trust

• Investing in income producing residential and commercial properties

(4)

Application Environment

• Database versions: Oracle10g and 11g

• Application Server: Oracle 11i(11.5.10)

• OS details: IBM-AIX and Solaris10

• Applications:

• Oracle EBS HRMS Application

• Oracle FLEXCUBE Universal Banking

• Financial Record System (FRS) Application

• FinOne

(5)

How Islamic Bank was Growing

• Database currently at ~4 TB

• Estimated annual growth of ~30%

• OEBS

• Implementation of Oracle Financial modules is

causing exponential data growth, severely

affecting E-Business suite performance and

end-user productivity

• Oracle Flexcube

• Data growth impact on the FlexCube core

modules resulting in excruciatingly slow

response time leading to customer

(6)

Challenges for Data Growth

• Impact

• More Data = Less Performance

• Operations options vs Strategic Initiatives

• Hardware Refresh

• Adds more infrastructure but doesn’t fix the problem.

• Purge old data

• No application awareness to retain business continuity

• Archive very few tables to same database

• Couldn’t reduce overall Database size

• Increased storage cost

• Longer backup and recovery cycles

(7)

Strategy for Database Archiving

• Using multiple applications like Oracle E-Business Suite, Oracle

FLEXCUBE Universal Banking, Financial Record System (FRS)

Application, FinOne and PowerCARD application on multiple Oracle

Databases

• Improve Performance of Online business applications with critical

customer transactions

• Cutting down the storage costs and improving efficiencies around

business continuity

• Administration across multiple applications needs to be simple

• Archive historical data to maintain database size at manageable levels

• Improve performance and operational efficiency

• Ensure Data Security by masking sensitive data

(8)

Archiving For Oracle Flexcube

Oracle FlexCube

• The diversity of financial institutions that use Oracle FLEXCUBE bears out its sophisticated capabilities.

• Since 1997, the solution has been helping financial institutions excel in the way they do business.

• The Oracle FLEXCUBE suite includes award-winning solutions for core

banking, retail banking, private

banking, corporate banking, investor servicing, and microfinance.

• Oracle FLEXCUBE is preferred by more than 390 financial institutions in over 125 countries.

Solix and Oracle Flexcube

• Solix EDMS Database Archiving • OEM’ed by Oracle for Oracle

FLEXCUBE Universal Banking Application

• Only Archiving solution that is imbedded in Oracle Vertical Industry Applications.

• Provides features allowing for improvement of application performance and reducing

storage costs while maintaining regulatory compliance and

(9)

Benefits of

Solix Database Archiving

• Improve Application Performance

– Large tables = poor performance

– Removing historical business objects reduces their size

• Improve Operations

– Reduce downtime for Cold Backups, upgrades and disaster recovery – Reduce Cloning time

• Reduce Costs

– Tiered storage can reduce infrastructure costs by 20-50% – Reduce DBA time & cost for tuning and monitoring

– Saves overall storage by reducing the multiplier effect

• Maintain Regulatory Compliance

– Data is maintained in same format and accessible by original application – Manage the lifecycle of data using corporate policies

(10)

Results of Database Archiving

• No business-impacting or unplanned downtimes

• Effectively managing their Oracle E-Business Suite and Oracle

FLEXCUBE Universal Banking environment by allocating data

depending on business value.

• Becoming Self-sufficient, making secure subsets and clones

• Making smaller subsets saving DBA time & costs

• Reducing storage by at least 50%

• Automated high-performance masking to eliminate possibility of data

breaches

• Effectively establish a system for Information Lifecycle Management

(ILM)

(11)

Developing ILM?

• Information Lifecycle Management

• (sometimes abbreviated ILM) is the practice of applying certain policies to the effective management of information throughout its useful life

• Operational

• backup and data protection; disaster recovery, restore, and restart; archiving and long-term retention; data replication; and day-to-day

processes and procedures necessary to manage a storage architecture

• Infrastructure

• logical and physical architectures; the applications dependent upon the storage platforms; security of storage; and data center constraints. Within the application realm, the relationship between applications and the

production, test, and development requirements are generally most relevant for ILM.

• ILM Policy

• overarching storage and information policies that drive management processes. Policies are dictated by business goals and drivers.

(12)

Solix EDMS

Our solutions help enterprise customers manage and protect their

application data assets in an optimized and secure manner to:

1. Enable business agility

through better application

performance and

Application Portfolio

Management

2. Risk avoidance through

compliance of data

retention plus data privacy

laws

3. Enhanced data center

efficiency through

improved productivity,

lower storage and lower

energy costs (Green IT)

(13)

What Problems We Are Solving

Data Masking

Security Compliance Risk Mitigation

Test Data Management

Storage Costs Productivity Time Performance Storage Costs Compliance Business Continuity

Database Archiving

Reduce Maintenance Costs Legacy Data Access Compliance Green IT

(14)

(15)

PeopleSoft Oracle E-Business Suite, BaaN, VSAM BaaN on Informix Custom Applications JD Edwards on SQL Server Oracle E-Business Suite JD Edwards on SQL Server

Solix EDMS Proof Points

Oracle

(16)

Solix EDMS

Application-Awareness

• Out-of-box knowledge to identify transactional business objects

• Business objects can span across several tables, tablespaces and partitions • Examples: Customer, Sales Order, Service Order, Examples: AR Receipts,

Transactions; INV Transactions; GL Journals

(17)

(18)

Drivers for

Solix Application Retirement

Reducing Costs

Regulatory Compliance

 Retiring legacy hardware  Eliminating maintenance &

support costs

 Reducing administrative costs  Proven ROI

 Data retention regulations  eDiscovery requests

 Warranty fulfillment

Consolidating Applications

 Mergers and acquisitions  Application standardization  Upgrading to ERP

Source: “Plan Legacy Application Retirements Carefully”, Gartner, April 2009

●Reduce Maintenance Costs ●Legacy Data Access ●Compliance ●Green IT

Application Retirement

“On average 10% of applications in an

unoptimized portfolio are candidates

for retirement. An additional one-third

can require migration or

rationalization”.

(19)

Solix EDMS Data Masking

• Solix EDMS Data Masking masks sensitive and confidential data based on policies • Leverages metadata from Application-Awareness

• Maintains data referential integrity across entire application • Extensible Architecture

(20)

Solix Test Data Management

Cloning and Sub-setting

• Reduces Cloning Times to Hours

• Smaller clones increase data security

• Smaller clones reduce storage and server requirements

• Smaller clones for Compliance and risk mitigation

(21)

American Tire Distributors (ATD)

“ATD got an expected

performance boost in Oracle E-Business Suite from database archiving. We see a 50 to 60 percent performance

improvement in our nightly batch processing, with no SQL tuning at all Gibson says. It's Huge.”

Revisiting one extreme

example: the seven hours of processing formerly required to merge two customers’

inventory data was reduced to one hour, and with further SQL tuning it now runs in one minute.

Angelic Gibson

Director of IT Operations American Tire Distributors

“Database archiving has also helped ATD move toward a lifecycle

management approach to data, meaning that the company is able to exercise more control over data’s

creation, storage, and deletion. “Going through that lifecycle—from

production to archiving to

elimination—is definitely what we’re putting together as a long-term Strategy”

Tony Vaden CIO

(22)

Solix & Oracle:

(23)