Agenda

1. Developing a metadata system for microdata About the project of developing a system for description of microdata at Statistics Sweden

2. Agenda • Background/Goals • About the project • Requirements • Content • The application • Future work

3. Vision: The register system Causes of Death Register Supplementary Benefits Register Vehicles – privately owned Register of Criminal Convictions Education RegisterEmployment Register Population and Housing Census Personal Income and Assets Persons Nominated and Elected Longitudinal Income Register (Linda) Longitudinal Register (Louise) Multi-Generation Register Fertility Register Swedish for Immigrants Adult Education Upper Secondary School 9th Form Register Teacher Register Higher Education Register Persons Enrolled in Education Education-Labour Market Register Income Statements Private Sector Employees, wages County Council Employees, wages Parish Employees, wages Local Authority Employees, wages Civil Service, wages Occupational Register Register of Jobs and Activities Population Register Business Income Demography of Enterprises Payrolls, number of employees Standardised Accounts Monthly Tax Returns Manufacturing VAT Register Foreign Trade Register Vehicles – company owned Agricultural Enterprises Register Register of Schools Geographical Database Real Estate Price Register Renovation Register New Construction Register One or Two Dwelling Buildings Multi-Dwelling Buildings Industrial Real Estate Agricultural Real Estate Valued Estate Units Real Estate Register Business Register

4. The present Metadata system

5. Goals • Replace the current Metadok system • Improved documentation tool • Provide an overview of our data material • The system should contain information for improving comparability

6. Goals • Be a part of a coordinated metadata system • Harmonisation tool • Tool for maintaining, standardising and making integration registers (matching) • No actual content standardisation

7. About the project • “Variabledatabaseproject“ • Started 1 January, 2004 • Summing up from earlier projects • Project group; Research and Development dept and publishing dept • Version 1, for documenting 1 January 2007 • Now – developing the system

8. Project organisation • Three types of user groups • Statisticians • Methodologists • System analysis's • Reference group • Steering committee • Close cooperation with the Register unit

9. Make documentation easier • Use metadata that already exist • Classifications and standards • Other documentations • Search the metadata repository • Document once - reuse

10. Examples of use • New enquiries • Analyse if the enquiry can be solved with already existing data. • Integration registers

11. Examples of use (cont’d) • Construction of sample frames • Sample design • Estimation • Editing • Time series

12. Examples of use (cont’d) • Modelling data bases • Information on where data are physically stored

13. Harmonisation • Standard variables, object classes, classifications • Structuring of registers • Value domains • Variables • Other attributes

14. Contents, metadata about • Variables • Object classes and populations • Value domains (classifications) • Register

15. The model Register Object class Variable Conceptual Value domain Register Variant Object variable Value domain Population Register Version Value Context variable Context Population

16. Structure • Register 123 • Register variant A • Register version 1 • Content • Populations (objects) • Variables • Value domains • Technical information • Sources

17. The future Metadata system VHS VHS Product Database

24. Future work • Develop the application • Migration • Level of ambition • Content structure • Maintenance and support organisation, including content

25. Summary • Harmonisation tool • Examples of content: population, object class, variables and value domains • Examples of use: search, document and standardise