ttulo

1
Variables System the bridge between metadata and
dissemination

Monica Isfan (monica.isfan_at_ine.pt) Statistics
Portugal
9 11July 2008
2
Overview

• Variables System
• Statistical Indicators
• Register flow
• Transmission and visualization
• Benefits

3
Variables System
ISO/ IEC 11179

• Statistical Survey Design
• Automatic Questionnaire Generations
• Statistical Dissemination
• Facilitate Standardization
• Identify Duplicates
• Facilitate Data Sharing

Variables System
4
Variables System
Production System
Variables System
Dissemination System
5
Dissemination System

• Central data base of statistical indicators
• Inputs ? aggregate data from Production
  Departments
• Outputs ? aggregate data and the associated
  metadata

DDD
Dissemination Data Base
6
Variables System
Variables System
Statistical indicators
Variables
defined
Property Object class (population or statistical
unit) Representation class Value domain
7
Statistical Indicators - Definition
Statistical Indicator
Data element that represents statistical data for
a specified time, place, and other
characteristics. (Terminology on Statistical
Metadata, Conference of European Statisticians
Statistical Standards and Studies Nº 53).
8
Statistical Indicators - Definition
In Variables System
Statistical indicator
defined
Variables

Aggregate Variables
Dimensions

• D1 Time
• D2 Geography
• .
• Dn Other characteristics

9
Aggregate Variables

• Property
• Object class Population
• Representation class Quantity, Ratio, Value,
  etc.
• Value domain Non-enumerated Unit of measure
• Definition and/ or concept
• Formula.

10
Property Resident Population
Population Resident Population
Representation class Quantity
Value domain (0, 8)/ U.M. No.
Concept Resident population (208/ 24-05-1994)
The persons who regardless of the fact that at
the moment of observation ' 000 a.m. of the
reference day ' are present or absent in a given
housing unit, this unit being where they live
during most of the year with their family, or
where they have all or most of their belongings.
Formula No
11
Statistical Indicators - Definition
In Variables System
Statistical indicator
defined
Variables

Aggregate Variables
Dimensions

• D1 Time
• D2 Geography
• .
• Dn Other characteristics

12
Dimensions

• Property
• Object class Statistical Unit
• Representation class Code
• Value domain Classification Level of
  classification
• Definition and/ or concept.

13
Property Sex
Statistical unit Person
Representation class Code
Value domain V00305 Sex (Dissemination MF)
Level 2
Definition Biological difference between male and
female.
14
Statistical Indicators - Name
Aggregate variable
by
D2 Dimension (geography)
,

Name definition
,
Dn-1 Other dimensions
and
Dn Other dimensions
15
Statistical Indicators - Name
Resident population
Aggregate variable
by
Place of residence
,
Dimension (geography)
Sex
Other dimensions
and
Age group
16
Statistical Indicators Register flow

• Step 1. Analyse of data and metadata
• Step 2. Variables and statistical indicators
  proposal
• Step 3. Register and approval of variables

17
Statistical Indicators Register flow

• Analyse/ Search
• Proposal
• Update
• Approve
• Associated Systems
• Concepts
• Sources
• Assistant Entities
• Property
• Object class
• Representation class
• Value domain
• Greatness/ Unit
• Administrative sources
• Other sources
• Files / Version
• Conceptual variable

Select type of source
Survey
Select Methodological Document
Annual estimates of resident population (version
1)
Step 4. Source selection
Select variables
All...
Variables for association
31742007-04-27 gtgt Distribution of the resident
population () 259 2005-09-05 gtgtResident
population (No.)
Word
Resident population
Association between variables and the
methodological document
Aggregate
Derivate
Observation
Dimension
User management
Step 5. Association of aggregate variables
End
18
Statistical Indicators Register flow

• Assistant Entities
• Property
• Object class
• Representation class
• Value domain
• Greatness/ Unit
• Administrative sources
• Other sources
• Files / Version
• Conceptual variable
• Variable

Select variables
Variables for association
All...
1902005-08-03gtgt Reference period
2352005-01-01gtgt Place of residence
3102005-01-01gtgt Sex
Word
age
Association between variables and the
methodological document
Observation
Derivate
Aggregate
Dimension
Select aggregate variable
Cross ref.
2592005-09-05gtgtResident population (No.)
Step 6. Define the cross reference
User management
1902005-08-03gtgt Reference period
2352005-01-01gtgt Place of residence
End
3102005-01-01gtgt Sex
Generate name
Step 7. Associate the dimensions to the selected
aggregate variable
19
Statistical Indicators Register flow
Cross reference
Select aggregate variable
2592005-09-05gtgtResident population (No.)
1902005-08-03gtgt Reference period 2352005-01-01gtgt
Place of residence 3102005-01-01gtgt Sex
2362005-08-29gtgt Age group (by life cycles)
Generate statistical indicator
Cross reference code
Definition
População residente (N.º)_Período de
referência_Local de residência_Sexo_Grupo etário
(por ciclos de vida)
Name
População residente (N.º) por Local de
residência, Sexo e Grupo etário (por ciclos de
vida)
Resident population (No.) by Place of residence,
Sex and Age group ( by life cycle)
Registry
Step 8. Generate the definition and the name of
statistical indicator and execute the registry
20
Statistical Indicators Transmission
Data Base
Data
Statistical Indicators (view)
Metadata
Metadata
Variables System
Statistical Indicators DB
Data
Internet
DataWarehouse
21
Statistical Indicators Visualization
22
Statistical Indicators Visualization
23
Statistical Indicators Visualization
Resident population (No.) by place of residence
(NUTS III)
2007
24
Benefits
Metadata is the key to ensure that information
will survive and continue to be accessible into
the future.
Only used statistical information is useful
statistical information.

• Central reference for aggregate data and
  metadata
• Improving communication and understandability
• Increasing data and metadata sharing.

25
Variables System the bridge between metadata and
dissemination
Thank you for your attention!