Developing a metadata system for microdata About the project of developing a system for description of microdata at Statistics Sweden.
Download ReportTranscript Developing a metadata system for microdata About the project of developing a system for description of microdata at Statistics Sweden.
Developing a metadata system for microdata About the project of developing a system for description of microdata at Statistics Sweden Agenda • Background/Goals • About the project • Requirements • Content • The application • Future work 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 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 Population Register Real Estate Register Register of Jobs and Activities Business 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 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 The present Metadata system Goals • Replace the current Metadok system • Improved documentation tool • Provide an overview of our data material • The system should contain information for improving comparability Goals • Be a part of a coordinated metadata system • Harmonisation tool • Tool for maintaining, • standardising and making integration registers (matching) No actual content standardisation About the project • “Variable database project“ • 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 Project organisation • Three types of user groups • Statisticians • Methodologists • System analysis's • Reference group • Steering committee • Close cooperation with the Register unit Make documentation easier • Use metadata that already exist • Classifications and standards • Other documentations • Search the metadata repository • Document once - reuse Examples of use • New enquiries • Analyse if the enquiry can be solved with already existing data. • Integration registers Examples of use (cont’d) • Construction of sample frames • Sample design • Estimation • Editing • Time series Examples of use (cont’d) • Modelling data bases • Information on where data are physically stored Harmonisation • Standard variables, object types, • • • • classifications Structuring of registers Value domains Variables Other attributes Contents, metadata about • Variables • Object types and populations • Value domains (classifications) • Register The model Register Register Variant Register Version Object class Population Context Population Variable Conceptual Value domain Object variable Value domain Context variable Value Structure • Register 123 – Register variant A • Register version 1 – Content • Populations • Variables • Value domains – Technical information – Sources Linked information Owner, organisation Different types of documentation Object types, Variables, Value domains Server, database, datatype Links to other systems • Links to: • Archiving system • Data act requests • Product database • Dissemination database The future Metadata system VHS Product Database VHS Future work • Develop the application • Migration • Level of ambition • Content structure • Maintenance and support organisation, including content Summary • Harmonisation tool • Examples of content: • population, object type, variables and value domains Examples of use: search, document and standardise