Banking On Data - InformationWeek
IoT
IoT
Software // Enterprise Applications
News
7/31/2003
04:19 PM
Rick Whiting
Rick Whiting
Features
50%
50%

Banking On Data

The Bank of New York saves hundreds of thousands of dollars a year using active archive software from Princeton Softech

Every day, the Bank of New York gives its institutional-investor customers an investment-portfolio update, including a snapshot of the day's transactions. And each day, the bank stores these reports, along with copies of monthly and quarterly summary reports, which also are sent to the pension-fund operators, investment firms, insurance companies, thrifts, and government agencies that make up the bank's clients.

But by last year, the bank's database was close to capacity. Those client reports, though rarely accessed, must be maintained for years to meet Internal Revenue Service regulations. The growing volume of stored data threatened the system's performance and the bank's plans to grow its institutional-investor business.

One solution was to expand the system with more hardware and database storage capacity. But that would be costly and would only solve the problem until new capacity limits were reached. "If we wanted to continue to grow this database and continue to serve the number of clients we expect to have, we needed to archive this data offline," says Peter Keaveney, VP and head of the bank's Investment Accounting Systems Division.


Peter Keaveney, VP and head of the Bank of New York's Investment Accounting Systems Division

Active Archive helps the Bank of New York cut costs, VP Keaveney says.
Last fall, the bank installed Active Archive software from Princeton Softech Inc. to offload older data from the bank's operational IBM DB2 database. The system archives data on optical disks and maintains its referential integrity. Although the data is archived offline, it can easily be accessed with a browser-based application. Data also can be brought back to the operational database in bulk or selectively. The project cost about $1 million, Keaveney says.

Today the bank's operational database holds daily client-portfolio reports going back 105 days and two years' of monthly, quarterly, and annual reports. Older reports are stored in the Princeton Softech data archives, which now hold 1.2 billion rows of data.

The bank saves between $50,000 and $60,000 a month by not having to buy additional hardware to accommodate the rapidly expanding operational database, Keaveney says, and it's cut CPU use by 20%. He says database reorganizations and backup-and-restore tasks also are quicker.

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 6, 2016. We'll be talking with the InformationWeek.com editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll