1 / 11

Implementing a Statistical Data Warehouse: The Case for a Strong Partnership

Implementing a Statistical Data Warehouse: The Case for a Strong Partnership. OECD: Lars Thygesen, Douglas Paterson IMF: Cathy Wright, Patrick Hinderdael. Meeting on the Management of Statistical Information Systems (MSIS), Geneva, May 8-10, 2007. OECD Data Warehouse.

masi
Télécharger la présentation

Implementing a Statistical Data Warehouse: The Case for a Strong Partnership

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Implementing a Statistical Data Warehouse: The Case for a Strong Partnership OECD: Lars Thygesen, Douglas Paterson IMF: Cathy Wright, Patrick Hinderdael Meeting on the Management of Statistical Information Systems (MSIS), Geneva, May 8-10, 2007

  2. OECD Data Warehouse • OECD.Stat established 2004 • Access to OLIS (government) 2005 • Access via Internet 2006 • New dissemination policy 2007-08 • Already shared components with other organisations

  3. The Business Perspective • Same business: production and dissemination of economic data • Much of our data overlap • Both organizations support data sharing via SDMX • Similar organisational structures • Why not combine forces to jointly develop a data warehouse ?

  4. The Business Perspective Improved provider relations Improved data quality Betterservice to data users Improved data and metadata management More cost-effective data work Better structured career opportunity Improved management of data processes Better documentation, storage, access control, archiving of datasets Enhanced analytical capacity—”all about” analysis

  5. The Technology Perspective • Similar development/integration platform and almost identical runtime environments (MS Windows server and clients, MS SQL Server, MS .NET Framework, MS Office suite) • Collaboration tools (MS Sharepoint and Team Foundation Server) • Align code base, functional requirements, development resources, deployment schedules

  6. Production Storage Dissemination OECD.Stat Data Production (incl. StatWorks) Corporate Data Warehouse Online access Web Browser Books CDs etc. MetaStore XML XML Statistical Metadata OECD Statistical Information System (SIS) Architecture

  7. IMF Information Map IMF.ORG HR Prod DB TAIMS Prod Db iFIN Prod DB Other Dept Data Multimedia DB Desk Data Desk Data STA Data WEO Data Dept Docs and Files Internal User Public Business Partners Email Information Portals Publications Info Exchange News Extranets Contact List Info Diss. Data Collection Workflows Information Resource Catalog Intranet Directory of Experts Information Standards and Guidelines Economic Data Warehouse Document/Web Repositories Financial and Administrative Data Warehouse IMF-Wide Metadata Standards Commercial Data & Documents FACTS Prod DB Other Document Stores

  8. Area Depts DMX Excel Aremos Research Aremos IMF Statistical Information Management Environment Data Collection Data Dissemination Data Management Economic Data Warehouse IMF.Stat EDSS Statistics EDF IMF.ORG Statistics Portal Online Databases IFS WEO REOs External Data … National Sources ICS (Excel/SDMXML) Publications Data Analysis External Data OECD Global Insight Haver Analytical Bloomberg Econometric Tools CD ROM Metadata (MetaStore, DSBB) Supporting Capital and Administrative Projects IT10146 WEO Production Redesign IT10060 Metadata Exchange IT10117 .Net migration (EDF) #000019 EDF Enhancements #00031 Balance Sheet Approach IT10112 Financial Soundness Indicators IT10052 EDF Production IT10137 Metadata Repository IT10117 .Net Migration(ICS) IT10021 ICS IT10056 SDMX IT10130 EDW #000041 Economist Models Suite IT9320 Econometric Software IT10145 High End Computing #000030 Economic Data Dissem IT9009 EDSS

  9. Memorandum of Understanding • Responsibilities and rights • Sharing of further developments • Pooling of technical resources • Similar to Open Source • Open to other partners

  10. Governance Management Mandate INFORMATION MANAGEMENT Work Practices Technology & Training Delivering the Data Warehouse Technology – Just one piece of the puzzle Work Practices

  11. The Outcome to Date • In-depth OECD and IMF collaboration since Dec 2006 – OECD staff at IMF in February • Adoption of IMF.Stat: World and Regional Economic Outlooks, International Financial Statistics databases will go live May 2007 • MOU to be signed shortly • Weekly conference calls • Initiating discussion of plans for joint development of enhancements

More Related