Presentazione di PowerPoint Tesoro亲爱的PowerPoint演示.pptVIP

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