advertisement

Iaos From Data Access To Data Integration

50 %
50 %
advertisement
Information about Iaos From Data Access To Data Integration

Published on January 7, 2009

Author: annegrete

Source: slideshare.net

advertisement

From Data Access to Data Integration IAOS, Shanghai 14-16 October 2008 Annegrete Wulff, Statistics Denmark [email_address]

Accessible products Publications (ca. 1850 - ) Municipality statistics databank 1986-98 StatBank Denmark ( www.statbank.dk ) 1998 – Homepage www.dst.dk 1996 -

Publications (ca. 1850 - )

Municipality statistics databank 1986-98

StatBank Denmark ( www.statbank.dk ) 1998 –

Homepage www.dst.dk 1996 -

Dissemination principles Electronic first StatBank is the place for all official statistics StatBank is the source for all publications StatBank is online available & free-of-charge for everyone Simultaneous releases in all media 9:30:00 am Dissemination should address well-defined target groups types of usage … jet still use the same source (data and metadata)

Electronic first

StatBank is the place for all official statistics

StatBank is the source for all publications

StatBank is online available & free-of-charge for everyone

Simultaneous releases in all media 9:30:00 am

Dissemination should address well-defined

target groups

types of usage

… jet still use the same source (data and metadata)

Access Population Labour market Income Finance Agriculture etc. Databank www.statbank.dk

The Statistical Information System Person id: Person N um b er Enterprise id: CBR-No Dwelling id : Ad dress Health Tax Employ- ment Educa- tion Social etc CPR B D R C B R Question- naire Inter- view Cadastre

The case of Denmark To link or not to link - that’s the question!

The Public www.dst.dk SumDatabase Cleaned micro data Statistical registers Print Binding dst.dk Charged statistics and analysis Annonymos micro data for Researchers Subject matter division Dissemination, IT-Centre Aggregation to macro data Publication pdf International organisations - - StatBank Denmark

Users needs More users Variety of users Different user needs User satisfaction surveys

More users

Variety of users

Different user needs

User satisfaction surveys

 

Shift of focus …..1980’s Electronic on-line access Content: more details than on paper Download possibilities Output formats

Electronic on-line access

Content: more details than on paper

Download possibilities

Output formats

Statistics Denmark’s first databank 1986 200 users – and we new them all

Shift of focus …..1990’s Internet access - but also off-line products: CD-ROM Functionality (calculations) Interactive aggregations Contact possibilities – who to ask for more

Internet access

- but also off-line products: CD-ROM

Functionality (calculations)

Interactive aggregations

Contact possibilities – who to ask for more

Internet databank, ver. 1.0 1998 Access “restricted” by a fee

Shift of focus …..2000’s Presentation, layout Documentation Linking, coherence Long time span Search

Presentation, layout

Documentation

Linking, coherence

Long time span

Search

Homepage 2004 Documentation, quality declaration, graphics

Shift of focus …..2008’s Response time Definitions Search and browse Visualisation, maps and graphics Self service Integration with own systems

Response time

Definitions

Search and browse

Visualisation, maps and graphics

Self service

Integration with own systems

StatBank Denmark More than 2,000 tables, several billions of data Links to documentation (declaration of contents) Links to publications Saved queries Data shooting Excel web queries Output formats: Excel, PC-AXIS, xml, SAS, comma separated, time series,… Maps Graphs

More than 2,000 tables, several billions of data

Links to documentation (declaration of contents)

Links to publications

Saved queries

Data shooting

Excel web queries

Output formats: Excel, PC-AXIS, xml, SAS, comma separated, time series,…

Maps

Graphs

2,500 matrices in Danish and English 2 million retrievals HTML table on screen Downloads of a file 77 % only on screen 6 % in maps, 17 % graphs 23% downloads. Of these: 86 % in Excel 9 % in PC-AXIS 5% in other formats

2 million retrievals

23% downloads. Of these:

86 % in Excel

9 % in PC-AXIS

5% in other formats

Many sources of metadata Subject matter division Technical sources Statisticians Statistics Denmark publications Metadataproject Quality declarations Statistical Yearbook & Ten year review Statistical Abstracts Annual publications, Nomenclatures External documents Legal documents etc TIMES, microdata documentation

One source for all metadata Subject matter division Technical sources Statisticians Statistics Denmark publications Metadata project Quality declarations Statistical Yearbook & Ten year review Statistical Abstracts Annual publications, Nomenclatures External documents Legal documents etc TIMES, microdata documentation

Metadata International organisations Annonymos micro data for researchers Charged statistics and analysis dst.dk www.dst.dk code explanations source quality accessability concepts, definitions methodologies contacts release info - StatBank Denmark -

code explanations

source

quality

accessability

concepts, definitions

methodologies

contacts

release info

The process Select the concepts Define the concept Making the definition accessible

Select the concepts

Define the concept

Making the definition accessible

Concepts in the StatBank 850 dimensions 173,000 dimension members 8,000 will be defined

850 dimensions

173,000 dimension members

8,000 will be defined

Born in Denmark and neither of the parents is born in Denmark and has Danish citizenship as well

At least one parent is born in Denmark and has Danish citizenship

Glossary

Thank you

Add a comment

Related pages

From Data Access to Data Integration - docin.com豆丁网 ...

From Data Access to Data Integration IAOS, Shanghai 14-16 October 2008 Annegrete Wulff, Statistics Denmark awu@dst.dk Accessible products ...
Read more

Data Integration

... many applications permit you to produce and consume files for the purpose of data exchange. This makes Data Integration a natural ... Access to raw data.
Read more

Data Integration | Data Integration Info

Data integration involves combining data from several disparate sources, ... Uniform Data Access or Virtual Integration ...
Read more

Introduction to integrating data between Access and a ...

Introduction to integrating data between Access and a SharePoint site. ... Better data integration between Office Access 2007 and SharePoint sites enhances ...
Read more

Data integration - Wikipedia, the free encyclopedia

Data integration involves combining data residing in different sources and ... query interface to summary data sources and no access to the full data.
Read more

Connect to an Access Database

To connect an Integration Services package to a Microsoft Office Access data source requires an OLE DB connection manager and a data provider.
Read more

Pervasive Access to Any Data (Data Integration)

... Data Integration ... 24/7 access to timely ... to use Oracle’s data integration offering for your big data initiatives take a look at our ...
Read more

International Association for Official Statistics (IAOS)

New processes for IAOS members to access the SJIAOS. ... for the paper "Big Data and Semantic Technology: A Future for Data Integration, ...
Read more