240 likes | 480 Views
IDEV EDR Software for Germany. Presentation during the meeting of the Cord Working Group May 12, 2004 Luxembourg. Historical Overview. Start of the W3stat Project for Intrastat 1998 Filetransfer and Webform for Intrastat 2000 Interactive Data Entry (IDES) for Intrastat 2001
E N D
IDEVEDR Software for Germany Presentation during the meeting of the Cord Working Group May 12, 2004 Luxembourg
Historical Overview • Start of the W3stat Project for Intrastat 1998 • Filetransfer and Webform for Intrastat 2000 • Interactive Data Entry (IDES) for Intrastat 2001 • W3stat for all central Statistics 2002 • IDEV prototype Software for EDR 2004 • IDEV, E-Workflow and .Core Integration 2005
Organisational Overview • Cooperation in Software Developement • Common IT-standards • 17 Statistical Offices • Federal Statistical Office • 16 State Statistical Offices
Technical Overview • different software in German statistics • StBA: W3stat Intrastat • W3stat used for other centrally processed surveys • Statistik-Online (LDS NRW ) used by various other state statistical offices (presented also at Cord) • Xima Software (Saxonia) • Integration of the Applications very different • no standardization of processes Use of standardized applicationsnot possible or very difficult
Political Overview Initiative Bund Online 2005 Federal Chancellor Gerhard Schröder in his address before the Congress of the Initiative D21 " on 18.09.2000 at the Expo Hannover „..The Federal Government will provide all services of the federal administration electronically by 2005..“ Deutschland-Online
Produce Send Receive Edit Analyse Dissemi- nate PSI NSA Process Overview Statistical Data Flow E-Workflow EDR
Solution Concept for a Unified Software Solution for EDR • Common Layout • Unified technical Architecture • Portability of the Software • common Interfaces • Standardisation of functions and workflow • common online rawdata entry Portable Implementation based on modern technology IDEV - Common Internet Data capture Software
Application Register Other Edi Media Technical Architecture I Encrypted Processing IDEV-WebServer Data Entry Server Firewall Provider of Statistical Information
Software Architecture Java J2EE and other Open Software • Linux : operation system • Apache : web server • Tomcat : servlet engine • OpenSSL : SSL implementation • MySQL : data base • Jboss : application server • Xerces-J : XML parsing and validation • Xalan-J : XSLT transformations
Internet data collection Collection mgmt. DatML/SSP DatML/RAW Standard Software XML data flow business apps CORE (B2B) DatML/RAW DatML/RAW IDEV (online)
XML Interfaces • DatML ( Data Markup Language ) • DatML/RAW : raw data messages • DatML/RES : raw data message response format • DatML/SDF : survey definition format (for enabling business apps to create raw data messages automatically and generically ) • DatML/EDT : data editing and validation • DatML/SET : productive data sets and archiving • DatML/ASK : for describing web forms • DatML/SSP : shared and core components • TabML ( Table Markup Language ) • TabML/LAYOUT: presentation and dissemination purposes • TabML/MATRIX : n-dimensional tables and time series, fully metadata- equipped (non-disclosure, analysis, merging, subsets…)
Web data collection workflow DatML SDF Survey Designer web data collection DatML RES STATSPEZ Metadata System DatML EDT Data Edit Designer CORE (B2B) business apps DatML RAW DatML ASK Forms Designer DatML RAW CORE .reporter HTML JAVA web forms IDEV (online) upload
Data processing workflow STATSPEZ Metadata System Data Edit Designer Data Set Designer Table Designer TabML DatML EDT DatML SET data editing tabulation programs DatML SET DatML RAW DatML SET subject matter apps
Application Functions • For the reporting of Statistical raw data • Metadata, characteristics and values • Parallel reporting (generic) • for multiple surveys • Only characteristics depend on the Survey • for multiple clients and administrations • send and receive side • additional functions • Response and PSI information • corrections of addresses • Possibilities for tests • Data upload for interviewer
IDEV Components PL-EDITOR - data record- PL-checks- PL-procedures Forms-EDITOR - Forms- other PL-checks Respondent DB - Adress Register - User data DATML/EDT Registration DB (IDEVI) jar-Archiv Import .core Authentification DB (IDEVE) Authorisation Web-Server - encryption - ssl
PL-Editor Universal Standard Tool for data editing • server side checks • client Side checks • editing procedures • XML-based
Forms Editor Universal Standard Tool for Definiton of Forms for data collection • Easy to use • automatic data fill ins • Layout support • XML-based
Respondent DB Administrator Standard Tool for the respondents data base • definition of surveys • User authentification • Survey periodicity • Multi User • Multi Administration
Web Server Universal Web Server for Surveys • encryption • checks • Data transformation • data distribution
Core.connect Library Java Iibrary for data transmission to IDEV
Core.reporter Standard Tool for generation of DatML/Raw messages
Fritz Pfrommer Statistisches Bundesamt, D-65180 Wiesbaden Phone: +49 (0)611 / 75-2707 E-Mail: Fritz.Pfrommer@destatis.de Thank you very much for your attention