Data Warehousing for Bank Decision-Making

By Barzilay, Amos | American Banker, July 20, 1995 | Go to article overview

Data Warehousing for Bank Decision-Making

Barzilay, Amos, American Banker

Banks are clamoring to incorporate data warehousing into their information technology operations.

The overriding reason is that the technology offers people at all levels - in the front office and back office, from the teller line to the executive suite - the power to make mission-critical decisions more quickly, more accurately, and more easily.

The 1994 Ernst & Young and American Banker Special Report on Technology in Banking estimated discretionary spending on modernization and new technologies would rise 30%, of which 30% was expected to be directed at improving the quality of decision-making.

Data warehousing directly targets decision-making for virtually all critical paths to profitability, starting with profitability analysis itself and extending to risk management (both credit and interest rate risk), improved customer support service, and target marketing of new products.

The demand for data warehousing stems directly from the increasingly competitive landscape of the financial industry, in which banks are relying on technology advances to differentiate themselves and to improve productivity and profitability.

Also spurring the demand is the onslaught of mergers and acquisitions that is bringing together disparate systems and growing volumes of data to be churned and manipulated for decision analysis. The M&A phenomenon alone has challenged all aspects of the information technology infrastructure, from hardware capacity to software capability.

The promise of data warehousing for most organizations reads as follows: Data warehousing consolidates information into a single view from disparate systems throughout the financial institution for analysis and optimized decision-making.

Though most banks have tried for years to bring together information, an overwhelming obstacle has been technology and the costs involved. Information in disparate systems throughout the institution has remained grouped as "islands" for isolated decision-making.

Accurate and timely decision-making has suffered immeasurably. As mergers and acquisitions have become more commonplace, so has the number of disparate systems within the combined institutions. This compounds the problem of bringing together information.

The costs associated with computing and storing large volumes of data have dropped tremendously, putting data warehousing within reach of more bank budgets. It's the consensus that hardware prices drop by half every 18 months in the open systems market and data storage costs drop even more significantly.

The Gartner Group estimates that 10 years ago it cost about $28 million to store one terabyte of data. By the end of the decade, the same of amount of data cost $1,000 to store. It is no wonder we are seeing an increase in the integration of advanced open systems platforms with presiding mainframes and, in many cases, the adoption of replacements for mainframe systems.

But multiprocessing - computers using several processors for parallel processing - has had the greatest impact on the technological merits of data warehousing.

Data base companies have revolutionized the use of this technology by radically improving the cost-effectiveness and performance of processing information.

Parallel processing allows the breakdown of a single query into components, and each component is assigned to a different processor that can operate on its portion in parallel with the others.

This is revolutionary. A bank can now reduce the performance time to answer a query in a linear relationship by the number of processors working on it. For example, if a bank has 20 processors, response time can be reduced 20 times.

Combined with improvements in the cost performance of hardware in the last couple of years, the overall cost-effectiveness of querying has improved by a factor of nearly 100.

In essence, data base technology has delivered a way to cut the time it takes to perform a complex query from 1. …

The rest of this article is only available to active members of Questia

Sign up now for a free, 1-day trial and receive full access to:

  • Questia's entire collection
  • Automatic bibliography creation
  • More helpful research tools like notes, citations, and highlights
  • Ad-free environment

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Cite this article

Cited article

Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)


1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25,

Cited article

Data Warehousing for Bank Decision-Making


Text size Smaller Larger Reset View mode
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Full screen

matching results for page

Cited passage

Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25,

Cited passage

Welcome to the new Questia Reader

The Questia Reader has been updated to provide you with an even better online reading experience.  It is now 100% Responsive, which means you can read our books and articles on any sized device you wish.  All of your favorite tools like notes, highlights, and citations are still here, but the way you select text has been updated to be easier to use, especially on touchscreen devices.  Here's how:

1. Click or tap the first word you want to select.
2. Click or tap the last word you want to select.

OK, got it!

Thanks for trying Questia!

Please continue trying out our research tools, but please note, full functionality is available only to our active members.

Your work will be lost once you leave this Web page.

For full access in an ad-free environment, sign up now for a FREE, 1-day trial.

Already a member? Log in now.