Data Integration, Tabulation and Dissemination Government | Commercial | Research
Beyond Dissemination: Query-based Access 2 nd European DDI Users Conference, Utrecht December 2010 Data Integration, Tabulation and Dissemination Government | Commercial | Research
Background of DDI Initiative © Space-Time Research 2010 3
Limitations of Dissemination-Based Access © Space-Time Research 2010 4
Different Access Models © Space-Time Research 2010 5
Dissemination-Based vs. Query-Based Access Approach Dissemination-Based Query-based Generate specific output data such as cubes Work directly from microdata and create output as required Disclosure control before data released Disclosure control on-the-fly Limit number of cube dimensions to aid usability and disclosure control Unlimited dimensions: cubes created on-demand through UI Make output datasets available for download Customisable output available for download or access through API © Space-Time Research 2010 6
Notes on Query-Based Access © Space-Time Research 2010 7
Architecture 3 rd party apps, internal processes Super. VIEW Easy to use, visualization and interactive reports Super. WEB Output Format Layer – CSV, XLSX, KML, SDMX Ad hoc table/cube creation, charts, thematic maps SDMX Web Services Super. STAR Server Schema discovery, tabulation, confidentiality and metadata services Administrative Services Data Control API Confidentiality Super. STAR Data Repository Provider’s user management system Existing confidentiality routines New routines RDBMS JDBC driver © Space-Time Research 2010 DDI JDBC Driver Text file JDBC Driver 8
DDI Use in Super. STAR: loading data from DDI © Space-Time Research 2010 9
DDI 3 JDBC Driver © Space-Time Research 2010 10
Loading DDI 3. 1 to Super. STAR © Space-Time Research 2010 11
Accessing the statistics: ad hoc tabulation in Super. WEB © Space-Time Research 2010 12
Accessing the statistics: SDMX RESTful API © Space-Time Research 2010 13
Explore Metadata – Retrieve a Data Structure Definition © Space-Time Research 2010 14
Notes on DDI Experience © Space-Time Research 2010 15
Thank you! © Space-Time Research 2010 16
The Demo http: //strmt. dyndns. org/webapi/jsf/login. xhtml © Space-Time Research 2010 17
Скачать презентацию Data Integration Tabulation and Dissemination Government Commercial
b58ce6f5a8bc345d249486cdc4e01339.ppt