1 / 12

ICPSR-SRO Shared Data Model Project

ICPSR-SRO Shared Data Model Project. Mary Vardigan Director, DDI Alliance. Both are units of the Institute for Social Research, University of Michigan Inter-university Consortium for Political and Social Research (ICPSR) ICPSR is a large social science data archive

torgny
Download Presentation

ICPSR-SRO Shared Data Model Project

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. ICPSR-SRO Shared Data Model Project Mary VardiganDirector, DDI Alliance

  2. Both are units of the Institute for Social Research, University of Michigan Inter-university Consortium for Political and Social Research (ICPSR) ICPSR is a large social science data archive Survey Research Operations (SRO) SRO is a data collection center The Partners

  3. Worked together on the National Survey of Family Growth, sponsored by NCHS, to create an interactive codebook Partnered again on the Collaborative Psychiatric Epidemiology Surveys, sponsored by NIMH This involved a harmonization of three datasets and interactive documentation featuring question comparison and five languages Past Collaborations

  4. Together, SRO and ICPSR cover the life cycle of research data We share a need for rich, high-quality metadata We want to comply with metadata standards – in particular, the Data Documentation Initiative (DDI) We need to pass data easily from SRO to ICPSR without information loss Rationale for Collaboration

  5. Shared data model and database design for survey metadata to enhance collaboration Challenges: Different computing platforms Different end products Different staff orientations New SRO-ICPSR Joint Project

  6. Offline\Local Application User specifies files (location, file type, etc.) using an application Blaise Datamodel (BMI) Blaise Database (BDB) Other File Types (e.g. SAS, SPSS, etc) DDI 2 or 3 File Task B and D <Metadata & Data> <Transform--ations> Task B SRO Blaise Parsing Tool Other Importing Tool Online or Offline Client Relational Database (offline SQL Server Express) Client Relational Database (offline SQL Server Express) SRO Relational Database (online/networked SQL Server) ICPSR Relational Database (online/networked Oracle) <Data Storage> Task A Display meta-data Edit / Reviewmeta-data Export code-book Export ques-tionnaire Export data <Application Logic> Tasks C and D Stand-alone client application Client application with sync data <XML/WSDL> SRO/ICPSR/Other web client • ICPSR web client:: • Variable Search • Internal Variable Browser • NSFG Data Management Web server ICPSR Import Tool

  7. SRO Tools to complement MQDS, which produces XML documentation from Blaise instruments Tool to permit external users to add metadata for the National Survey of Family Growth ICPSR Variable-level database that permits users to search across the ICPSR collection; compare variables; create new datasets and questionnaires Products and Benefits

  8. Should allow nearly seamless data sharing between SRO and ICPSR Covers survey data life cycle from data production to data publication Creates a competitive set of services that we can continue to market Ultimately brings more data to a wider audience Other Benefits of the Project

  9. Phase 1 Design and development of the database (April 30, 2008) Modification of MQDS to export to and read from the database (April 30, 2008) Interface to allow remote user access for NSFG (July 31, 2008) ICPSR Social Science Variables Database (Late 2008) Project Phases

  10. Preview of SSVD Search Results

  11. Preview of Variable Display

More Related