Skip to main content

Statistical Metadata Support for Data Warehouses

Objective

The implementation of data warehouse technologies in national statistical offices require a higher degree of metadata support, in particular when data warehouses will be accessible for the public sector. The commercial packages on the market are not sufficient in this respect. The project will develop a general and standardised metadata support facility based on standard interfaces to overcome these shortcomings.

Objectives:
Development of a standard metadata repository for data warehouses and standard interfaces to exchange metadata between data warehouses and the basic statistical production system. The aim is to make statistical data warehouse technologies more user-friendly for user access by the public sector. That will support the application of official statistics in the society and broaden the scope of users. The system will operate both in the traditional client/server environment and in the Internet world.

Work description:
Starting with important results of the 4th Framework Programme (in particular the IMIM and IDARESA projects) the project will develop and specify metadata standards necessary for statistical data warehouses. The project will investigate how to create an optimised flow of data and metadata in a statistics production system. Based on these research results a generalised metadata repository for a statistical data warehouse will be designed, developed and implemented. It is the intention to use modern object-oriented methods and tools in all phases of the project. A common interface will be developed to be able to connect the metadata repository both to the traditional statistics production system and the data warehouse environment. The results will be demonstrated as a prototype in a real statistical environment using commercial data warehouse software. An undertaking will be given to the Commission by the participating company from the private sector outlining how the results obtained will be maintained after the lifetime of the project. A plan on marketing strategy will also be presented concerning further development and eventual commercialisation.

Milestones:
- Design of metadata standards for statistical data warehouses
- System architecture for the integration of metadata flow in a statistics production system with data warehouse technology
- Software design
- Implementation of a software prototype
- Implementation of a demonstrator system

Funding Scheme

CSC - Cost-sharing contracts

Coordinator

STATISTICS SWEDEN
Address
Karlavagen 100
104 51 Stockholm
Sweden

Participants (6)

HUNGARIAN CENTRAL STATISTICAL OFFICE
Hungary
Address
Keleti Karoly Utca 5-7
1024 Budapest
INSTITUTO NACIONAL DE ESTATISTICA
Portugal
Address
Avenida. Antonio Jose De Almeida
1000 Lisboa
STATISTICS DENMARK
Denmark
Address
Sejroegade 11
2100 Copenhagen
STATISTISK SENTRALBYRAA
Norway
Address
Kongens Gate 6
0033 Oslo
UNIWERSYTET WARSZAWSKI
Poland
Address
Krakowskie Przedmiescie 26/28
00-927 Warszawa
WORLD SYSTEMS (EUROPE) LIMITED
Luxembourg
Address
2, Rue Albert Borschette
1246 Luxembourg-kirchberg