IDEAS home Printed from https://ideas.repec.org/h/wsi/wschap/9789811239069_0006.html
   My bibliography  Save this book chapter

Data Warehousing

In: RISK ANALYTICS From Concept to Deployment

Author

Listed:
  • EDWARD H K NG

Abstract

It is almost impossible to support analytics directly from operational or legacy systems. Organizations that have tried quickly face issues too challenging even for professional IT service providers. There is increasing recognition of this matter, but data warehousing remains a hit and miss undertaking in most places.The criticality of data warehousing has been recognized by the creation of cloud-based data warehouses. That is a boon to many types of industries, but for banks, it may not make a material difference. In most regulatory regimes, banks are required to keep data within their own premises. Even data centers are disallowed except for archived data. Creating a fully owned and controlled data warehouse is not an option.In one bank, around $30m was spent on developing a data warehouse by the IT associate company over 5 years. When the project was completed, not a single piece of datum could be extracted and used for analysis. The bank CEO ordered that this blunder be kept a secret to avoid embarrassment. In reality, such outcomes are fairly common. Knowing the difference between operational and analytical data can help reduce the frustrations often encountered.

Suggested Citation

  • Edward H K Ng, 2021. "Data Warehousing," World Scientific Book Chapters, in: RISK ANALYTICS From Concept to Deployment, chapter 6, pages 69-78, World Scientific Publishing Co. Pte. Ltd..
    • Handle: RePEc:wsi:wschap:9789811239069_0006
    as

    Download full text from publisher

    File URL: https://www.worldscientific.com/doi/pdf/10.1142/9789811239069_0006
    Download Restriction: Ebook Access is available upon purchase.
    File URL: https://www.worldscientific.com/doi/abs/10.1142/9789811239069_0006
    Download Restriction: Ebook Access is available upon purchase.
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    More about this item

    Keywords

    Risk; Modeling; Basel II; Quantification; Data Management; Data Integration; Decision Support; Online Analytical Programming;
    All these keywords.

    JEL classification:

    • D81 - Microeconomics - - Information, Knowledge, and Uncertainty - - - Criteria for Decision-Making under Risk and Uncertainty
    • G32 - Financial Economics - - Corporate Finance and Governance - - - Financing Policy; Financial Risk and Risk Management; Capital and Ownership Structure; Value of Firms; Goodwill

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:wsi:wschap:9789811239069_0006. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Tai Tone Lim (email available below). General contact details of provider: http://www.worldscientific.com/page/worldscibooks .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.