main data repositories on public investments …

MAIN DATA REPOSITORIES ON PUBLIC INVESTMENTS …

CALLS FOR TENDER(Public procurements)

APQ(National resources for regional policy)

MONIT(European Structural Funds)

COMP(Specific investment programme)

MONITORING SYSTEMS ON INVESTMENTS

CAPITAL ACCOUNT

EXPENDITURE

AVCP(National Authority for Surveillance on Public Contracts)

… WERE BORN WITH DIFFERENT PURPOSES…

Progress monitoring (duration and expenditure)

Financial audit

Compliance to regulation

Notification to contractors

… AND INFORMATION IS EXTREMELY HETEROGENEOUS

Variable 1 Variable 2 Variable 3 Variable 4 Variable 5 Variable 6 Variable 7 Variable 8 Variable 9Project 1 DB 1 2 3 DB 1 3 DB 1 2 DB 2 3 DB 2 DB 1 2 3 DB 1 2 3 DB 3 DB 1Project 2 DB 1 3 DB 1 3 DB 1 DB 3 DB DB 1 3 DB 1 3 DB 3 DB 1Project 3 DB 1 2 DB 1 DB 1 2 DB 2 DB 2 DB 1 2 DB 1 2 DB 3 DB 1Project 4 DB 1 3 DB 1 3 DB 1 DB 3 DB DB 1 3 DB 1 3 DB 3 DB 1Project 5 DB 2 3 DB 3 DB 2 DB 2 3 DB 2 DB 2 3 DB 2 3 DB 3 DBProject 6 DB 1 2 3 DB 1 3 DB 1 2 DB 2 3 DB 2 DB 1 2 3 DB 1 2 3 DB 3 DB 1Project 7 DB 1 3 DB 1 3 DB 1 DB 3 DB DB 1 3 DB 1 3 DB 3 DB 1Project 8 DB 1 2 DB 1 DB 1 2 DB 2 DB 2 DB 1 2 DB 1 2 DB DB 1Project 9 DB 1 2 DB 1 DB 1 2 DB 2 DB 2 DB 1 2 DB 1 2 DB DB 1Project 10 DB 1 2 DB 1 DB 1 2 DB 2 DB 2 DB 1 2 DB 1 2 DB DB 1

Exact data

Incoherent data

Wrong data

Missing data

OUR GOAL

ASSEMBLE ALL THE

AVAILABLE INFORMATION

INTO A

UNIQUE FRAMEWORK

FOR THE ANALYSIS

OF PUBLIC INVESTMENTS

TOWARDS INTEGRATION

Data integration

(matching at micro-level)

Informationalapproach

Normativeapproach

MIP–CUP

(new primary key)

NORMATIVE APPROACH

MIP: Monitoring system of public investment (Monitoraggio Investimenti Pubblici), established by the Interministerial Committee for Economic Planning in order to produce timely information on the implementation of development policy (L.144/99).

CUP: Project primary key (Codice unico di progetto), required for each new or on-going project as of 1st Jan 2003 (L.3/03).Must be quoted in every administrative and accounting document, both paper and digital, regarding a public investment project and must be reported in every database related to the above projects (Reg. 24/04).

INFORMATIONAL APPROACH

Recognition of information related to same projects in different data repositories: each repository usually represents the same item in a specific format so that it is virtually unfeasible to find a common variable across different repositories and create an automatic join between information on the same project.

Integration of the related information: as the relevant information on a project is dispersed across several databases, some rules must be defined in order to merge it all into a single repository.

AMOUNT OF INFORMATION INMAIN DATA REPOSITORIES ON PUBLIC INVESTMENTS

APQ

MONIT

COMP

PROJECTS TOTAL VALUE BN€ AVG. EXPENDITURE PY BN€ YEAR RANGE 2000-2004

CALLS FORTENDER

PROJECTSTOTAL VALUE BN€AVG. EXPENDITURE PY BN€YEAR RANGE 1998-2004

AVCP

MISE MONITORING SYSTEMS

PROJECTSTOTAL VALUE BN€ AVG. EXPENDITURE PY BN€ YEAR RANGE 2000-2004

PROJECTSTOTAL VALUE BN€ AVG. EXPENDITURE PY BN€ YEAR RANGE 2002-2004

AVG. EXPENDITURE PY2000-2004BN€ 31.5(CPT-IA)

PROJECTSTOTAL VALUE BN€AVG. EXPENDITURE PY BN€YEAR RANGE 1998-2004

10,500

56.52.3

6.5

320 2.90.3

94,000

71.012.3-15.2

532,000

312.030.1-38.8

A GLIMPSE OF DATA ON PUBLIC INVESTMENTS

AVLP

CALLS FOR TENDER

OUR TOOLS

X445

Version 9.1.3

Client-serverarchitecture

DescriptionOther textual information

QUALITATIVE DATA

AmountsTimesLocation

QUANTITATIVE DATA

Representationof each projectin an N-dimensionalspace

PROJECT MATCHING

THE MATCHING PROCESS

Define a control sample with known matches/no matches

Define a best strategy to retrieve the known matches

Define an optimal stratification for potential matches

Apply the process to stratified test data