Transcript Session 9A: Reporting Scenarios

ESCWA SDMX Workshop
Session: Reporting Scenarios
Bilateral Exchange
Gateway Exchange
Data/Metadata-Sharing
Exchange
query/retrieval
Registration of
Data Source
Data/Metadata
Reporters
RSS or SDMX
Notification
Data/Metadata
Consumers
The Old JEDH (Joint External
Debt Hub) Site
BIS
WEBSITE
IMF
OECD
World
Bank
(Various
Formats)
(3-month production cycle)
JEDH with SDMX
Retrieves data from sites
BIS
IMF
OECD
World
Bank
SDMX-ML
SDMX
“Agent”
SDMX-ML
SDMX-ML
SDMX
Registry
Discover data
and URLs
Data provided
in real time
to site
SDMX-ML
SDMX-ML
SDMX-ML
Loaded into
JEDH DB
(Debtor database)
JEDH Site
FOOD AND AGRICULTURE ORGANIZATION
OF THE UNITED NATIONS
SDMX in Action: Prototype System
FAO SDMX
Registry
2
National
Publication
Server(s)
1
CountrySTAT
3a
Regional
Publication
Server
3b
Flow of FAO CountrySTATRegionSTAT Implementation
4
RegionSTAT
Slide courtesy of the FAO
FOOD AND AGRICULTURE ORGANIZATION
OF THE UNITED NATIONS
Prototype System: Explanation
1
CountryStat National Publication Server
•The web site is published from the files in CountryStat
2
SDMX Publication
•The new CountryStat files are converted to SDMX-ML data sets
and made web accessible on the CountryStat web site
•These files are registered in the FAO SDMX Registry
RegionStat Regional Publication Server
3a
•Queries the registry for new registrations which responds with
registration details including the URL of the new data sets
3b
•Retrieves the new data sets from the CountryStat web site
•Converts the SDMX-ML files to an internal format and integrates
the new data sets with existing RegionStat data sets
4
•Re-publishes the RegionStat web site
Slide courtesy of the FAO
The SDMX Census Hub Pilot project
reference architecture
NSI
SDMX infrastructure
NSI
Census
Data warehouse
SQL
Builder
Eurostat
SDMX
Query
Parser
Web
Service
Data
base
Slide courtesy of Eurostat
SDMX
Generator
Hub
The SDMX Census Hub
Eurostat
Hub