1 / 16

THE METADATA MODEL AND DATA PRODUCTION PROCEDURES AND DISSEMINATION

THE METADATA MODEL AND DATA PRODUCTION PROCEDURES AND DISSEMINATION. Marios Fridakis, Greek Social Data Bank at EKKE John Kallas, Greek Social Data Bank at EKKE IASSIST CONFERENCE May 2005. The metadata model has to meet the following requirements…. …for the data producer:

hei
Download Presentation

THE METADATA MODEL AND DATA PRODUCTION PROCEDURES AND DISSEMINATION

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. THE METADATA MODEL AND DATA PRODUCTION PROCEDURES AND DISSEMINATION Marios Fridakis, Greek Social Data Bank at EKKEJohn Kallas, Greek Social Data Bank at EKKE IASSIST CONFERENCE May 2005

  2. The metadata model has to meet the following requirements… • …for the data producer: • Support the documentation of ALL types of studies • …and the data provider: • The administration of all kinds of documents (studies, datasets, files, publications, questionnaires, projects) • The access control • The classification • References between documents • …has to be implemented on a relational database

  3. The Entity Relationship Diagram (ERD) of the complete model

  4. Types of studies • Simple study: Conducted only once for a fixed time point and a fixed universe (space). • Complex study • Repeated over time for fixed space (Repeated study) • Repeated over space for fixed time (Comparative study) • Repeated over space and time (Repeated / Comparative study)

  5. A metadata (sub)model for the simple study

  6. 1

  7. A metadata (sub)model for the complex study

  8. The Documentation Objects (D.O.)

  9. The schema of the D.O.’s

  10. KWRDS M USER_UDEM N M DOCOBJ_KWRDS USERDEM USERS N REFERENCES M N N DOCOBJ_UDEM USER_APRV NOTES_D N M DOCOBJ N M DOCOBJ_APRV NOTES_D_DOB N M ACCPRV 1 PUBLICATIONS FILES QUESTIONNAIRES PROJECTS DATASETS STUDIES The access control

  11. KWRDS M USER_UDEM N M DOCOBJ_KWRDS USERDEM USERS N REFERENCES M N N DOCOBJ_UDEM USER_APRV NOTES_D N M DOCOBJ N M DOCOBJ_APRV NOTES_D_DOB N M ACCPRV 1 PUBLICATIONS FILES QUESTIONNAIRES PROJECTS DATASETS STUDIES The classification

  12. KWRDS M USER_UDEM N M DOCOBJ_KWRDS USERDEM USERS N REFERENCES M N N DOCOBJ_UDEM USER_APRV NOTES_D N M DOCOBJ N M DOCOBJ_APRV NOTES_D_DOB N M ACCPRV 1 PUBLICATIONS FILES QUESTIONNAIRES PROJECTS DATASETS STUDIES References between D.O.’s

  13. Why a relational database? • Complex queries may be written in SQL • Easier to query the whole metadata collection as one large and complex database, in spite of the fact that definitional metadata belong to specific and distinct studies. • RDBMS ‘s are mature and well supported systems.

  14. General remarks and conclusions The metadata model… • …enhances the capabilities of DDI (ver. 2.0) by treating studies and datasets as separate entities, the dataset being the product of the study. Therefore, separate documentation should be produced for studies and datasets in the case that this becomes necessary. • …attempts to document both simple and complex studies. The former is a subset of the latter, thus simple and compound studies are documented under the same model schema.

More Related