Download - ICONSULTING “Intelligent” Access Control System in Bologna Old Town centre. Bologna, June 2007
ICONSULTING““Intelligent” Access Control System in Bologna Old Town Intelligent” Access Control System in Bologna Old Town centre.centre.
Bologna, June 2007
2
ICONSULTING ICONSULTING is a company focused on Consulting, Design Consulting, Design and Development and Development of Decision Support Systems – Business – Business Intelligence Intelligence
It was founded in 20012001 by a group of young researchers working for the Data Warehouse Lab inside the university university consortiumconsortium called CinecaCineca.
ICONSULTING maintains a strong link with UniversityUniversity by investing in Research and DevelopmentResearch and Development
The inner Research LabResearch Lab (R&D, Thesis, Testing, Products Evaluation) is a warrantee of independenceindependence from all the software vendors.
ICONSULTINGICONSULTING
33
What is BUSINESS INTELLIGENCE?What is BUSINESS INTELLIGENCE?
Business IntelligenceBusiness Intelligence is a broad category of applicationsapplications and technologiestechnologies used to gather,
provide access to, and analyze datadata and informationinformation belonging to an organization.
Decision-making fact-based support fact-based support systemssystems.
Business Intelligence + Raw and disconnected data
=
KNOWLEDGEKNOWLEDGE
4
PlanningStrategic objectives andStrategic objectives and
actions definitionactions definition
ManagementManagement
ProcessProcess
ProgrammingOperational objectives andOperational objectives and
actions definitionactions definition
ControlControl of results accordingControl of results according
to Plans and Programsto Plans and Programs
Action
DASHBOARD and B.P.M. APPLICATIONS
DASHBOARD and SCORECARD
QUERY & REPORTING and MD ANALYSISBI MODELS
Planning and Control cyclePlanning and Control cycle
5
What is done for Public What is done for Public Administrations?Administrations?
Besides our industrial client portfolio, we have realized many Business Intelligence solutions for Public AdministrationsPublic Administrations such as Budget ApplicationsBudget Applications, Management Control SystemsManagement Control Systems, Enterprise Enterprise Management DashboardsManagement Dashboards.
National AgenciesNational AgenciesSviluppo Italia
Regions and Regional Regions and Regional AgenciesAgenciesRegione Emilia Romagna Agrea Arpa Avepa
MunicipalitiesMunicipalitiesComune di Bologna Comune di Reggio Emilia
6
MunicipalityMunicipalityRevenuesRevenues ServicesServices
Services
Officers
Families
Real estates
Districts
Communications
Citizen
Reference BackgroundReference Background
8
MunicipalityMunicipalityRevenuesRevenues ServicesServices
Services
Officers
Families
Real estates
Districts
Communications
People
Social ServicesSocial Services
Social Services(Senior Services,
Education, …)
9
MunicipalityMunicipalityRevenuesRevenues ServicesServices
Services
Officers
Families
Real estates
Districts
Communications
People
Public Works ManagementPublic Works Management
Public Works
10
MunicipalityMunicipalityRevenuesRevenues ServicesServices
Services
Officers
Families
Real estates
Districts
Communications
People
Revenues DashboardRevenues Dashboard
RevenuesDashboard
(ICI, Tarsu,…)
11
MunicipalityMunicipalityRevenuesRevenues ServicesServices
Services
Officers
Families
Real estates
Districts
Communications
People
Traffic ManagementTraffic Management
TrafficManagement
12
Telecontrol systems SIRIO e RITATelecontrol systems SIRIO e RITA
OBJECTIVES
Access to old town centre and to the Limited Traffic Zone are monitored by the telecontrol systems named SIRIO and RITA.
SSirioirio
RRitaita
RR
RRRR
RR
RR
RR
RR
SS
SS
SS
SS
SSSS SS
SS
SS
13
Background for the AnalysisBackground for the Analysis
OBJECTIVES
In order to carry out a complete analysis of the in-traffic of the old town centre, information from various sources is needed:
• Telecontrol system vehicle number plate, gateways, access time and date.
• Authorization’s registers type of access authorization associated to the vehicle
• Transaction databases of Municipalitity Offices Contraventions (PMGU Database) and other information regarding vehicles not recognized automatically at each gateway (SIRIO Database).
SANCTIONSSANCTIONS
ACCESSESACCESSES
AUTHORIZATIONSAUTHORIZATIONS
14
PROJECT GOALSPROJECT GOALS
To show the real benefits of using a BUSINESS INTELLIGENCE application to analyze accesses to a Limited Traffic Zone.
11
Evaluate the CAPABILITY of information integration. 22
Give examples of possible information analyses related to different authorizations and access to SIRIO/RITA.
33
17
Reports: Analysis of Authorized Reports: Analysis of Authorized AccessesAccesses
Analysis of Authorized Accesses by authorization type
18
Reports: Analysis of Authorized Reports: Analysis of Authorized AccessesAccesses
Analysis of Authorized Accesses by authorization type
19
Road Rules Violations AnalysisRoad Rules Violations Analysis
Road Rules Violations Analysis Report related to 2006by detector tipology .
• analysis based on street, number plate, detectors etc
• payments and transgressor profiles analysis
20
Authorizations AnalysisAuthorizations Analysis
OBJECTIVES
Report of Authorization trend within Municipality of Bologna
21
PROTOTYPE: Added ValuesPROTOTYPE: Added Values
DATA INTEGRATION: possibility to put in relation/comparison data coming from various systems and applications. This kind of information results difficult to be handled by non-automated processes.
As a consequence ENHANCE data – integrated data can put in evidence very interesting informations/behaviours, not obtainable otherwise if separate data is to be considered.
Limited Traffic Zone CONTROL: possibility of constantly and on-time monitoring of various tipologies of accesses to ZTL.