1 / 17

GOOD PRACTICES FOR DATA DISSEMINATION

GOOD PRACTICES FOR DATA DISSEMINATION. Juraj Riecan Director, UN-ESCWA Statistics Division. Overview of dissemination practices. Traditional databases. Front-ending. Process-oriented architecture. From recordsets to data cubes. Current dissemination practices. Static file formats.

ian-fulton
Download Presentation

GOOD PRACTICES FOR DATA DISSEMINATION

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. GOOD PRACTICES FOR DATA DISSEMINATION JurajRiecanDirector, UN-ESCWA Statistics Division

  2. Overview of dissemination practices Traditional databases Front-ending Process-oriented architecture From recordsets to data cubes

  3. Current dissemination practices Static file formats Spreadsheets National databases

  4. Static files • Fully controlled presentation • Combine data, text, charts • Quick, easy, cheap √ • Only a snapshot • Data not downloadable • Manual updates X • Key indicators • Highlights >

  5. Spreadsheets • Easy format for data analysis • Downloadable, Customizable √ • Users have to download all • Manual updates X • Data files for further analysis >

  6. National databases • Customized queries • Flexible downloads • Easy updates √ • Important implementation costs • IT infrastructure • System maintenance X • General data dissemination >

  7. Traditional databases Database 3 Database 2 Database 1

  8. Front-ending Database 3 Database 2 Database 1

  9. Process oriented architecture Production Database Dissemination Database Database 3 Database 2 Database 1

  10. Statbank SuperWEB Dissemination Database DevInfo New Chronos Beyond 20/20 PC-Axis OECD.Stat

  11. From recordsets to hypercubes Recordsets Relational databases Hypercubes

  12. Recordsets Evolution from paper records Sequential reading Record = data item & metadata

  13. Relational Databases Reporting country Trade Volume Importing country Flexibility Exporting country Standard Query Language (SQL) Generic database tools

  14. Data Cube (Hypercube) 65+ Age 16-64 0-15 Country C Country Country B Country A 2002 2003 2004 2001 Year

  15. Data Cube (Hypercube) √ Most common approach √ Flexible √ Expandable √ Combining multiple classification √ Easy cross-tabulation

  16. Conclusion – Summary Process oriented Architecture Dissemination databases Hypercube data model

  17. THANK YOU riecan@un.org

More Related