![Page 1: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/1.jpg)
Metadata at ICPSR
Sanda Ionescu, ICPSR
![Page 2: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/2.jpg)
Metadata at ICPSR-Catalog Records-
• Created by data processors, who fill out a Web-based form:– Fixed fields,– DDI 2.x and 3.0 compatible
![Page 3: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/3.jpg)
Metadata at ICPSR-Catalog Records-
![Page 4: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/4.jpg)
Metadata at ICPSR-Catalog Records-
• Review and approval by metadata specialist• Stored in ORACLE database• Exported from database to DDI 2.1 XML• XML files stored on server (file system)• HTML and PDF presentation created dynamically
(through XSLT stylesheets) at user request• HTML presentation for viewing only; PDF is
downloadablehttp://www.icpsr.umich.edu/cocoon/ICPSR/STUDY/08589.xml
![Page 5: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/5.jpg)
Metadata at ICPSR-Catalog Records-
• DDI-XML files searched by field from home page to retrieve studies (Inktomisearch)
![Page 6: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/6.jpg)
Metadata at ICPSR-Codebooks-
• HERMES – in-house automated process to generate (most of) the study distribution package:– Input:
• SPSS system or portable• Optional pre-formatted (question) text file
– Output: • Full suite of statistical formats (setups and system)• ASCII data file• DDI 2.1 file with frequencies and question text if available
![Page 7: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/7.jpg)
![Page 8: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/8.jpg)
Metadata at ICPSR-Codebooks-
• DDI 2.1 file may be converted to PDF to generate – An “ICPSR” codebookhttp://www.icpsr.umich.edu/cgi-bin/bob/archive2?study=4699&path=ICPSR&docsonly=yes
– Part of the publicly distributed codebook as other non-DDI resources may be incorporated
http://www.icpsr.umich.edu/cgi-bin/bob/archive2?study=4512&path=ICPSR&docsonly=yes
• In some instances a DDI-based codebook will not be generated
http://www.icpsr.umich.edu/cgi-bin/bob/archive2?study=9522&path=ICPSR&docsonly=yes
![Page 9: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/9.jpg)
Metadata at ICPSR-Codebooks-
• The DDI 2.1 file with variables description– Is archived– Is downloaded into the Social Science Variables
Database (SSVD)
![Page 10: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/10.jpg)
Metadata at ICPSRSocial Science Variables Database
• Also built in ORACLE, but currently a separate entity, with links to studies’ and series’ descriptions.
• Includes variable-level metadata.• Is DDI 2.x and 3.0 compliant (input and output)• Will enable variable-level searches across studies
and series of studies (simple SQL queries - retrieve matches, do not infer relevance)
![Page 11: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/11.jpg)
Integrating DDI 3 into ArchivesSRO-ICPSR collaboration project
Common RELATIONAL DATABASE model for data documentation- Compliant with DDI 3.0 -
Common RELATIONAL DATABASE model for data documentation- Compliant with DDI 3.0 -
Blaiseoutput
Blaiseoutput
SAS/SPSS/Stata files
SAS/SPSS/Stata files DDI 2.xDDI 2.x DDI 3.0DDI 3.0Other…Other…
Client Applications… Web Applications…
SRO: ICPSR:
ICPSR: Variable-level Search
ICPSR projects will be able to use documentation generated by SRO projects…
![Page 12: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/12.jpg)
Metadata at ICPSR-Online analysis-
• Survey Documentation and Analysis (SDA) – Approx. 475 studies – data and documentation in
proprietary format (ddl), DDI 2.x-compatible.– Nesstar - used only as a “test” (currently not in
production mode)https://www.icpsr.umich.edu/ICPSR/access/sda.html
![Page 13: Metadata at ICPSR Sanda Ionescu, ICPSR. Metadata at ICPSR -Catalog Records- Created by data processors, who fill out a Web-based form: – Fixed fields,](https://reader036.vdocuments.us/reader036/viewer/2022062621/551bfe2a550346ad4f8b4aa3/html5/thumbnails/13.jpg)
Metadata at ICPSR
• Other study documentation– Questionnaires– User guides– Data definitions
Distributed in machine-readable, but non-searchable formats – PDF, ASCII, Excel, etc.
http://www.icpsr.umich.edu/cgi-bin/bob/archive2?study=4512&path=ICPSR&docsonly=yes