MISSY 2 Microdata Information System andias wiraalamgesis org

MISSY 2: [Microdata Information System] andias. wira-alam@gesis. org oliver. hopt@gesis. org 1

Information Processes in the Social Sciences Prof. Dr. York Sure Andias Wira Alam Benjamin Zapilko Daniel Hienert Engin Sagbas Frank Sawitzki Oliver Hopt Peggy Fischer Peter Mutschke Dr. Philipp Mayr Philipp Schaer Siegfried Schomisch Ute Koch Simon Bachenberg Timo Wandhöfer Wei Shen 2

Issues: 1. DDI 3. x Editor? 2. DDI Repository? 3. Data Representation? 3

General Work Flow A B Public (Scientific Community) Federal Statistical Office A B The Federal Statistical Office (Destatis)… • provides access to microdata for scientific purposes (scienitifc use files). • provides survey documents for MISSY. • in collaboration with, produces scientific use files of the Microcensus (e. g. anonymisation, construction of variable labels). GESIS provides… • provides metadata for the Microcensus scientific use files on the Web (MISSY): codebook and detailled variable information in DDI 3 format. • study description and study related material (e. g. questionnaires, definitions, interviewer guides). • examples and recommendations on analysing the data. 4

edit store Web. DAV Server Transforming DDI 3. 0 into DBClear format Views c b a XML + XSLT + Groovy Web. Server (Typo 3) request HTML View Web Information System DBClear Data Service DDI Service Software Architecture DDI 3. 0 Editor DDI 3. 0 EDITOR USERS Model 5

MISSY Editor: 1. 2. 3. 4. Entry of Meta. Data: Questionnaires (Variables) of the. German Microcensus (1973 – 2007) with its respective results. has Graphical User Interface (developed using Java. Swing). has DDI 3 Format. has central repository (Web. DAV), location independent, ensures data concurency and integrity. 6

7

DDI Service: 1. 2. 3. 4. converts DDI 3 -Format to DBClear-Format*. stores Meta. Data into DBClear*. manages data consistency. provides Meta. Data-Index. * DBClear is a kind of metadata repository system which is a native GESIS Product. 8

What goes to where? Code. Book& Questionnaire 1. Variable Name (EF Number) 2. Variable Label 3. Question Number (no text and other details) 4. Frequencies Questionnaire 1. Question Number 2. Question Text 9

continued. . . DDI 3 Code. Book& Questionnaire 1. Variable Name (EF Number) 2. Variable Label 3. Question Number 4. Question Text 5. Frequencies <Data. Collection> <Logical. Product> <Physical. Instance> <Question. Scheme> <Category. Scheme> <Statistics> <Variable. Scheme> <Variable. Statistics> <Question. Item> <Variable> 10

DDI to Metadata Repository (DBClear) Database Indexing Lucene Index 11

MISSY Portal: (in general) 1. 2. 3. 4. based on TYPO 3 Content Management System. compliant with the GESIS standard portal system. easy to manage (has a great backend). provides Meta. Data-Index. http: //www. gesis. org/missy/ 12

Web Content in MISSY Portal: (static pages) 1. managed through TYPO 3 backend. 2. contains all important information about MISSY. 13

Web Content in MISSY Portal: (3 details view of the data - dynamic pages) 1. List of Variables (Variablenliste). 2. Subject Outline (Thematische Gliederung). 3. Timeline Matrix of Variables (Variablen. Zeitpunkte-Matrix). 14

15

16

17

Acknowledgement 1. This project is funded by the BMBF Germany (01 UW 0707 - "Servicezentrum für Mikrodaten der GESIS / MISSY II"). Future Work 1. Integrating with regional microcensus. 2. Enhancing our application (e. g. performance, search capabilities, etc) so it can be used also by other studies. 3. “Outside the Box Thinking”: integrating DDI to Linked. Data? 18