united nations economic commission for europe statistical division the importance of databases in...
TRANSCRIPT
![Page 1: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/1.jpg)
United Nations Economic Commission for EuropeStatistical DivisionUnited Nations Economic Commission for EuropeStatistical Division
The Importance of Databases in the Dissemination Process
Steven Vale, UNECE
![Page 2: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/2.jpg)
Steven Vale - UNECE Statistical Division Slide 220 April 2023
Contents
How are data currently disseminated? Advantages and disadvantages of
different approaches Introduction to data cubes Good practices
![Page 3: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/3.jpg)
Steven Vale - UNECE Statistical Division Slide 320 April 2023
Dissemination Practices
Web sites of statistical agencies for all 56 UNECE member countries checked during spring 2008.
Data dissemination systems and formats recorded.
Not possible to check all national language versions of websites.
![Page 4: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/4.jpg)
Steven Vale - UNECE Statistical Division Slide 420 April 2023
Results
Internet Dissemination ToolsNumber of Countries
%
Static html / pdf / word pages 29 51.8%
Excel spreadsheets 12 21.4%
National database software 17 30.4%
PC-Axis 12 21.4%
Statbank / PC-Axis 3 5.4%
SuperWEB 2 3.6%
![Page 5: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/5.jpg)
Steven Vale - UNECE Statistical Division Slide 520 April 2023
Static html / pdf / word Pages
![Page 6: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/6.jpg)
Steven Vale - UNECE Statistical Division Slide 620 April 2023
Static html / pdf / word Pages
Advantages• Quick, easy and cheap to prepare• Data at a glance• Possible to combine tables, graphics and text• Html and pdf viewers are free
Disadvantages• Only a picture - users can not easily download
or manipulate data• Manual updates
![Page 7: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/7.jpg)
Steven Vale - UNECE Statistical Division Slide 720 April 2023
Excel Spreadsheets
![Page 8: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/8.jpg)
Steven Vale - UNECE Statistical Division Slide 820 April 2023
Excel Spreadsheets
Advantages• Users can download and customize data• Most common format for basic data analysis
Disadvantages• Excel software is not cheap!• Manual updates• User has to download the whole file
![Page 9: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/9.jpg)
Steven Vale - UNECE Statistical Division Slide 920 April 2023
Output Databases
![Page 10: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/10.jpg)
Steven Vale - UNECE Statistical Division Slide 1020 April 2023
Output Databases
Advantages• Interactive with flexible outputs• User friendly (usually!)• Can be tailored to national requirements• Some generic systems available
Disadvantages• Can be expensive to develop and maintain,
particularly if you develop your own system
![Page 11: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/11.jpg)
Steven Vale - UNECE Statistical Division Slide 1120 April 2023
What Do Users Want?
Depends on the type of user Quick access to key figures Options to select and manipulate data Easy export to own analysis packages Graphic visualizations (maps, charts, ..) Appropriate metadata Multiple languages
![Page 12: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/12.jpg)
Steven Vale - UNECE Statistical Division Slide 1220 April 2023
What is a Data Cube?
A multi-dimensional structure containing data points that represent unique combinations of several classifications
A flexible way of storing and disseminating data
![Page 13: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/13.jpg)
Steven Vale - UNECE Statistical Division Slide 1320 April 2023
Two-dimensional Cube
Year
Country 2000 2001 2002 2003
AAA 123 456 124 567 125 678 126 789
BBB 987 654 988 654 989 654 999 654
CCC 35 789 36 789 37 789 38 789
![Page 14: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/14.jpg)
Steven Vale - UNECE Statistical Division Slide 1420 April 2023
Three-dimensional Cube
![Page 15: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/15.jpg)
Steven Vale - UNECE Statistical Division Slide 1520 April 2023
More dimensions are possible,
but not easy to display!
![Page 16: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/16.jpg)
Steven Vale - UNECE Statistical Division Slide 1620 April 2023
Why Data Cubes are Important
Many statistical data management models and systems are based on cubes
Users can select just those data that are of interest
Cubes can easily be expanded, e.g. for extra years, countries, or other categories
At least in theory, cubes can have an infinite number of dimensions
![Page 17: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/17.jpg)
Steven Vale - UNECE Statistical Division Slide 1720 April 2023
Good Practices
Static tables can be useful for key figures For detailed or large datasets, allow users
to create and manipulate their own tables Store data as multi-dimensional cubes Offer graphic visualizations Allow users to download data in a range
of formats (including SDMX)
![Page 18: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/18.jpg)
Steven Vale - UNECE Statistical Division Slide 1820 April 2023
Good Practices (2)
Link data and metadata Share development in an open-source
environment or network, with an electronic forum for discussions and questions
Don’t try to re-invent the wheel!
![Page 19: United Nations Economic Commission for Europe Statistical Division The Importance of Databases in the Dissemination Process Steven Vale, UNECE](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f0e5503460f94c23224/html5/thumbnails/19.jpg)
Steven Vale - UNECE Statistical Division Slide 1920 April 2023
Thank you for listening
Questions?