Designing a First-Iteration Data Warehouse for a Financial Application Service Provider

Designing a First-Iteration Data Warehouse for a Financial Application Service Provider

Nenad Jukic (Loyola University, Chicago, USA) and Tania Neild (InfoGrate Incorporated, USA)
Copyright: © 2006 |Pages: 17
DOI: 10.4018/978-1-59904-399-9.ch013
OnDemand PDF Download:


This case study will describe the efforts behind designing a first iteration of an evolutionary, iterative enterprise-wide data warehouse for AIIA Corp., a financial application service provider. The study demonstrates the importance of the following steps during a data warehousing project: a well-defined mission, effective requirement collection, detailed logical definitions, and an efficient methodology for source systems and infrastructure development. AIIA is a financial distributor that offers separately managed account and investment products with practice management services to financial advisors through a Web-based portal that can also be configured and private-labeled for the advisors to use with their clients. Unlike most companies, AIIA offers the advisors a hybrid of investment information and technology solutions, both designed with an open architecture.

Complete Chapter List

Search this Book:
Mehdi Khosrow-Pour
Chapter 1
A. S.C. Hooper
In any cooperative database the participants contribute their data for their own as well as the benefit of the other members, usually with... Sample PDF
LIBNET: A Case Study in Information Ownership and Tariff Incentives in a Collaborative Library Database
Chapter 2
Hamid Nemati, Keith Smith
This case highlights factors that provided the impetus for changing a successful EIS into a data warehouse at the VF Corporation. The data warehouse... Sample PDF
Evolution of an Executive Information System: The Replenishment Data Warehouse at JeansWear
Chapter 3
Susan J. Chinn, Charlotte A. Pryor, John J. Voyer
Two systems faculty from a university was contracted to perform an analysis of information systems at the Algos Center, a small non-profit... Sample PDF
The Algos Center: Information Systems in a Small Non-Profit Organization
Chapter 4
Derrick J. Neufeld, Scott Griffith
Isobord, a start-up company that is setting up a new strawboard production plant in Manitoba, Canada, is facing critical operational problems that... Sample PDF
Isobord's Geographic Information System (GIS) Solution
Chapter 5
Susan Rebstock Williams, Cheryl Aasheim
In February 2001, the Charlotte-Mecklenburg Police Department began the rollout of a “mobile” information system that will eventually enable all... Sample PDF
Information Technology in the Practice of Law Enforcement
Chapter 6
Andreea M. Serban, Gregory A. Malone
Traditionally, administrative computing has been the main, or often only, unit in a campus developing and maintaining the basic operating systems of... Sample PDF
Implementing Relational Database Systems: Implications for Administrative Cultures and Information Resource Management
Chapter 7
Wai K. Law
An island state government agency responsible for publishing monthly import/export data had problems meeting the monthly publication schedule. It... Sample PDF
Public Sector Data Management in a Developing Economy
Chapter 8
Barbara J. Haley, Hugh J. Watson, Dale L. Goodhue
In today’s competitive, high-velocity business environment, companies are focusing their attention on several key areas, including: • Incremental... Sample PDF
The Benefits of Data Warehousing at Whirlpool
Chapter 9
Brian G. Mackie, Norbert L. Ziemer, Nancy L. Russo, Wayne E. Mackie
This case describes the development of a unique, student-centered, online course management systems (OCMS). The system grew from a fairly... Sample PDF
Developing a Homegrown Course Management System: Community/Course Action/Interaction Management System (CAMS)
Chapter 10
Tero Paivarinta, Airi Salminen
A unit of Fortum Service Ltd. operates and maintains the Rauhalahti power plant in Central Finland. In 1996-97, the unit launched a project pursuing... Sample PDF
Deliberate and Emergent Changes on a Way Toward Document Management
Chapter 11
Ai Cheo Yeo, Kate A. Smith
The insurance company in this case study operates in a highly competitive environment. In recent years it has explored data mining as a means of... Sample PDF
Implementing a Data Mining Solution for an Automobile Insurance Company: Reconciling Theoretical Benefits with Practical Considerations
Chapter 12
Lex Wedemeijer
Enterprises need data resources that are stable and at the same time flexible to support current and new ways of doing business. However, there is a... Sample PDF
Long-Term Evolution of a Conceptual Schema at a Life Insurance Company
Chapter 13
Nenad Jukic, Tania Neild
This case study will describe the efforts behind designing a first iteration of an evolutionary, iterative enterprise-wide data warehouse for AIIA... Sample PDF
Designing a First-Iteration Data Warehouse for a Financial Application Service Provider
Chapter 14
Virginia A. Taylor, Caroline M. Coughlin
Historic models of library management are being tested and modified in the digital age because of several interrelated factors. First, the... Sample PDF
A Case Study of One IT Regional Library Consortium: VALE - Virtual Academic Library Environment
Chapter 15
Andy Borchers, Bob Mills
This case describes the evolution of an IT architecture for Prudential Chamberlain Stiehl Realtors (PCSR), a 14-office, 250-sales-agent real estate... Sample PDF
Prudential Chamberlain Stiehl: The Evolution of an IT Architecture for a Residential Real Estate Firm, 1996-2001
About the Editor