Transcript presentation

RIVELA
Database for the Research
on Venice and the Lagoon
Dr. Pierpaolo Campostrini
Dr. Caterina Dabalà
Dr. Stefania De Zorzi
Prof. Renzo Orsini
The Colour of Ocean Data
Brussels, 25 – 27 November 2002
www.corila.it
CORILA
Venice Lagoon
•Complex and delicate environment of high cultural and natural
value.
•Wide researches in several branches.
•Integrated questions and urgent integrated management needs.
•Very long historical series of data.
•New monitoring activities producing huge amount of data.
•Need of high availability of data, tools for consistency checks
and for building comprehensive models
CORILA
Architecture and Socio-economic Environmental
cultural heritage
aspects
processes
CORILA
Research
Programme
2000-2004
Economy
Env. Processes
Architecture
Data
Management
Lagoon of
Venice
CORILA
Transfer of data and information
Universities
Ministry of
Public Works
Municipality
CORILA
Distributed
Information
System
Private
Foundations
International
Research
Centres
National
Research
Council
Other Public
Institutions
CORILA
More than “standard format”
Physics
Engineering
Biology
Common
Data
Model
Chemistry
Tools
USERS
CORILA
Data
Management
Database RIVELA for the Research
on VEnice and the LAgoon
• Permanent and secure storage of information from researches
of CORILA and from other Institutions.
• Interdisciplinary data use.
• Harmonious exchange of data among different databases.
• GIS and other tools for integrated visualization of
heterogeneous data, modelling and statistical analyses.
• Strong involvement of researchers since the early stage
• Internal effective, industry standard instruments, (Oracle and
Intergraph engines) and non-legacy interfaces for users (.csv
for file exchange and internet browser for visualisation)
• Wide dissemination of data to scientific community, the
decision makers and the general public
CORILA
Simplified
conceptual
DB schema
Research
Projects
Static part
Dynamic part
Work
Packages
Activity
Zones
Sampling
Activities
Environmental
Units
Matrixes
Stations
Localities
Types of
Sample
Samples
Apparatus
Parameters
Measurements
Method
CORILA
Search and
Extraction
RIVELA
DB
GIS
Data Input
Access
through GIS
Direct
Access
CORILA
Data input
Measures
Local
storage
Data
transfer
via web
Control
and
consistency
check
DB
population
• parameter
andfor
ancillary
data
No
specificvalues
program
data entry
• methodologies
used
Easy
table format
handled on user desktop
•
auxiliaryon-line
information
(bibliographies, images)
Limited
operation
Consistency control made on the host side
CORILA
Access to data
Direct:
• SQL;
• “individual productivity” tools (Excel, Access).
Via the WEB:
• guided interactive search;
• interrogation through GIS.
CORILA
Guided queries
WHAT
STATIC DB PART
Project, Parameters and
matrices, Methods,
Location
WHERE
WHEN
GIS
instrument
DYNAMIC DB
PART
QUERY
QUERY
TABLE
MAP
Information flux
Internal automatic control
CORILA
Interrogation through GIS
1. Active maps to select any geographical object.
2. Scalable maps and selectable information layers.
3. Spatial and numerical results.
CORILA
Conclusions
RIVELA is an open archive for scientific data on the Venice
Lagoon, aiming also to realize a distributed information system
on the Venice lagoon for an effective use by researches, public
Administrations, stakeholders and lay people, in the framework
of the safeguarding of Venice.
Main goals:
•to avoid any data loss from the researches
•to allow an immediate data availability and quality control
•to allow and encourage interdisciplinary data uses, wide
dissemination and easy access to data.
Main instruments:
Efficient technology and involvement of researchers and of
every data producer, showing them the added value to one’s
own data, accessing larger data pools and using powerful
instruments, both for analysis and visualization.
CORILA
www.corila.it