1 / 12

MAIN DATA REPOSITORIES ON PUBLIC INVESTMENTS …

MONITORING SYSTEMS ON INVESTMENTS. APQ (National resources for regional policy). MONIT (European Structural Funds). COMP (Specific investment programme). MAIN DATA REPOSITORIES ON PUBLIC INVESTMENTS …. AVCP (National Authority for Surveillance on Public Contracts). CAPITAL ACCOUNT

rosalyn-yanez
Download Presentation

MAIN DATA REPOSITORIES ON PUBLIC INVESTMENTS …

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MONITORING SYSTEMS ON INVESTMENTS APQ (National resources for regional policy) MONIT (European Structural Funds) COMP (Specific investment programme) MAIN DATA REPOSITORIES ON PUBLIC INVESTMENTS … AVCP(National Authority for Surveillance on Public Contracts) CAPITAL ACCOUNT EXPENDITURE CALLS FOR TENDER (Public procurements)

  2. … WERE BORN WITH DIFFERENT PURPOSES… • Progress monitoring (duration and expenditure) • Financial audit • Compliance to regulation • Notification to contractors

  3. … AND INFORMATION IS EXTREMELY HETEROGENEOUS Exact data Wrong data Incoherent data Missing data

  4. OUR GOAL ASSEMBLE ALL THE AVAILABLE INFORMATION INTO A UNIQUE FRAMEWORKFOR THE ANALYSIS OF PUBLIC INVESTMENTS

  5. Normativeapproach Informationalapproach MIP–CUP (new primary key) Data integration (matching at micro-level) TOWARDS INTEGRATION

  6. 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).

  7. 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.

  8. AVG. EXPENDITURE PY 2000-2004 BN€ 31.5 (CPT-IA) AMOUNT OF INFORMATION INMAIN DATA REPOSITORIES ON PUBLIC INVESTMENTS MISE MONITORING SYSTEMS APQ PROJECTS TOTAL VALUE BN€ AVG. EXPENDITURE PY BN€ YEAR RANGE 2000-2004 10,500 56.5 2.3 MONIT PROJECTS TOTAL VALUE BN€ AVG. EXPENDITURE PY BN€ YEAR RANGE 2000-2004 6.5 COMP PROJECTS TOTAL VALUE BN€ AVG. EXPENDITURE PY BN€ YEAR RANGE 2002-2004 320 2.9 0.3 AVCP PROJECTS TOTAL VALUE BN€ AVG. EXPENDITURE PY BN€ YEAR RANGE 1998-2004 94,000 71.0 12.3-15.2 CALLS FOR TENDER PROJECTS TOTAL VALUE BN€ AVG. EXPENDITURE PY BN€ YEAR RANGE 1998-2004 532,000 312.0 30.1-38.8

  9. A GLIMPSE OF DATA ON PUBLIC INVESTMENTS AVLP CALLS FOR TENDER

  10. Version 9.1.3 Client-serverarchitecture OUR TOOLS X445

  11. QUALITATIVE DATA QUANTITATIVE DATA Description Other textual information Amounts Times Location Representation of each project in an N-dimensional space PROJECT MATCHING

  12. 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

More Related