ABSTRACT

Data warehousing has, perhaps, been the most costly system development in the history of financial services. The concept of data warehousing grew out of regional and departmental consolidation projects in which large relational databases were used to store relatively large quantities of data and make these data available to standard query tools such as SQL and various SQL-based interfaces. These queries were very useful in helping departments track customer behavior, P&L, and, in combination with applications written in VB, C++, and SQL-PLUS, they helped departments and regional entities within financial institutions track market trends, manage risk, and develop predictions.