Implementing%20a%20Statistical%20Data%20Warehouse:

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 data quality
Improved provider relations
Better service 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 capacityall 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
OECD Statistical Information System (SIS)
Architecture
7
IMF Information Map
Internal User
Public
Business Partners
Information Portals
Email
Publications
Info Exchange
Extranets
News
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
IMF Statistical Information Management
Environment


Data Dissemination
Data Collection



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
000030 Economic Data Dissem IT9009 EDSS
IT10130 EDW 000041 Economist Models Suite IT9320
Econometric Software IT10145 High End Computing
9
Memorandum of Understanding

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

10
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