Transcript 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.

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
•
•
•
•
•
OECD.Stat established 2004
Access to OLIS (government) 2005
Access via Internet 2006
New dissemination policy 2007-08
Already shared components with other
organisations
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 ?
The Business Perspective
Better service
to data
users
More
cost-effective
data work
Improved
management
of data
processes
Improved
provider
relations
Improved data
and metadata
management
Better documentation,
storage, access
control, archiving
of datasets
Improved
data
quality
Better
structured
career
opportunity
Enhanced
analytical
capacity—”all
about” analysis
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
OECD Statistical Information
System (SIS) Architecture
Production
Storage
Dissemination
OECD.Stat
Data Production
(incl. StatWorks)
Corporate Data
Warehouse
Online
access
Web Browser
Books
MetaStore
Statistical
Metadata
XML
XML
CDs
etc.
IMF Information Map
Internal User
Email
Information
Portals
News
Contact List
Public
Business Partners
IMF.ORG
Publications
Info Diss.
Info Exchange
Extranets
Data Collection
Workflows
Information Resource Catalog
Directory of Experts
Intranet
Information Standards and Guidelines
Economic Data
Warehouse
IMF-Wide
WEO
Data
Desk
Desk
Data
Data
STA
Data
Commercial Data
& Documents
Other
Dept
Data
Financial and
Administrative
Data Warehouse
Document/Web
Repositories
Document
Stores
Metadata
Dept Docs
and Files
Multimedia DB
Standards
FACTS
Prod
DB
iFIN
Prod
DB
TAIMS
Prod
Db
HR
Prod
DB
Other
IMF Statistical Information Management Environment
Data
Collection
Data
Management
Statistics
EDF
National
Sources
Area
Depts
ICS (Excel/SDMXML)
DMX
Excel
Aremos
External Data
Research
Aremos
OECD
Global Insight
Haver Analytical
Bloomberg
Data
Dissemination
Economic Data
Warehouse
IMF.Stat
EDSS
IFS
WEO
REOs
External Data
IMF.ORG
Statistics
Portal
Online
Databases
Data Analysis
Publications
…
Econometric
Tools
CD ROM
Metadata (MetaStore, DSBB)
Supporting Capital and Administrative Projects
IT10117 .Net Migration(ICS)
IT10021 ICS
IT10056 SDMX
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
IT10130 EDW
#000030 Economic Data Dissem
#000041 Economist Models Suite IT9009 EDSS
IT9320 Econometric Software
IT10145 High End Computing
Memorandum of Understanding
•
•
•
•
Responsibilities and rights
Sharing of further developments
Pooling of technical resources
Similar to Open Source
– Open to other partners
Delivering the Data Warehouse
Technology – Just one piece of the puzzle
Governance
Management Mandate
INFORMATION
MANAGEMENT
Work
Practices
&
Training
Technology
Work
Practices
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