D5.3 Final report on database content, structure and performance Deliverable 5.3 consists in the release of the Final report on database content, structure and performance. The Report contains the following main sections: (1) Introduction, describing DB objectives (2) Database design and implementation, which describes methodology, operating environment, and templates for data collection, (3) Database tests, (4) DB handling and functionalities, (5) DB maintenance and enhancement, and (6) DB website statistics. The Technical Report contains the following major sections: 1. INTRODUCTION The introduction briefly illustrates the principal and specific objectives of the INCREASE database project. It gives information on how WP5activities were developed in the framework of the INCREASE project with the aim to provide a comprehensive integrated database containing information and data from experiments on the potential effects of climate change on shrubland ecosystems in Europe. Data has been collected at six research infrastructures where large scale field experiments were conducted for a period of time ranging from 4 to 10 years. Data include experimental observations and scientific results on the effects of climatic treatments on vegetation and soil. These data represent a relevant source of knowledge for research studies on ecology, ecophysiology, and climate change impact studies. WP5 activities took advantage of being coordinated with similar initiatives such as the ESF project CLIMMANI (Climate Change Manipulation Experiments in Terrestrial Ecosystems), whose general purpose is to facilitate networking between past and current terrestrial ecosystem research. 2. DATABASE DESIGN AND IMPLEMENTATION In this section of the document a detailed description of the basic steps followed in designing and implementing the INCREASE DB is reported: a) Requirement analysis, In this section is described how data requirements from all sites were determined, and information were described and relationships between data were classified. In addition, the reviews of existing databases and database activities are reported. b) Methodology, this part describes the conceptual design, (the information content of the database expressed as entities and the relationships between entities (E-R schema) are defined, data and their objects are showed in a Data Models); the logical design (starting from the conceptual schema and taking into account the estimated applied data load, the E-R schema was restructured and translated in a logical model, which has an effective impact on the performance of database and ease of administration); and the physical design (the logical data model was transformed into a physical implementation based on the specific Database management System (DBMS) and operating system to be used for deployment). c) Operating environment, which describes (1) the Data Base Management System (DBMS) Environment, (2) the server operating system, (3) the hardware of the physical server, (4) the web server, and (5) the client application. d) Template for data collection, in this part structure and functionalities of excel templates developed for collecting data are described. For each macro-category of data a specific template was developed: Site, Site soil, Meteorology, Micrometeorology, Plant, Soil, Fauna, Water chemistry, and Plant diversity. 3. DATABASE TESTS This section describes tests done prior to DB implementation for validating and test for verifying the INCREASE DB performances. Tests were performed on two different levels: (1) targets (Units, Integration, System) and (2) objectives (alpha and beta tests, performance/stress test, security). 4. DATABASE HANDLING AND FUNCTIONALITIES a) Database website interface, This section describes the website interface used for connecting internal and external users to the INCREASE DB. b) Users and roles, this section gives a detailed description of different levels of access for different users with specific roles and permissions (System administrator, Uploaders - site coordinators and contributors, Downloaders - INCREASE community and authorized external users, Report viewer - external users, Users associated with specific sites), as reported in the INCREASE document "Infrastructure Intellectual Property Policy for Database Access". c) Functionalities, In this section the major characteristics and functionalities of DB are described: data uploading, data verification after uploading, data queries, data download, public and private pages with secure accesses. 5. DATABASE MAINTENANCE AND ENHANCEMENT In this section the maintenance activities conducted to monitor the operation and functioning of the system, and, when necessary, to repair and enhance the system are described. Ordinary maintenance activities included user list updating, user support, maintenance systems engineering (e.g. analysis of log and checking of server performance). 6. DATABASE/WEBSITE STATISTICS This section provides information about usage statistics of the production version of the INCREASE DB, since its online activation such as: the number of uploaded records per site and domain, the number of unique visitors of the website per month, the number queries by internal users in relation to data download operations.
Final report on database content, structure and performance - Final Technical Report
Pierpaolo Duce;Carla Cesaraccio;Alessandra Piga;Pierpaolo Pirino;Sara Bortolu;
2014
Abstract
D5.3 Final report on database content, structure and performance Deliverable 5.3 consists in the release of the Final report on database content, structure and performance. The Report contains the following main sections: (1) Introduction, describing DB objectives (2) Database design and implementation, which describes methodology, operating environment, and templates for data collection, (3) Database tests, (4) DB handling and functionalities, (5) DB maintenance and enhancement, and (6) DB website statistics. The Technical Report contains the following major sections: 1. INTRODUCTION The introduction briefly illustrates the principal and specific objectives of the INCREASE database project. It gives information on how WP5activities were developed in the framework of the INCREASE project with the aim to provide a comprehensive integrated database containing information and data from experiments on the potential effects of climate change on shrubland ecosystems in Europe. Data has been collected at six research infrastructures where large scale field experiments were conducted for a period of time ranging from 4 to 10 years. Data include experimental observations and scientific results on the effects of climatic treatments on vegetation and soil. These data represent a relevant source of knowledge for research studies on ecology, ecophysiology, and climate change impact studies. WP5 activities took advantage of being coordinated with similar initiatives such as the ESF project CLIMMANI (Climate Change Manipulation Experiments in Terrestrial Ecosystems), whose general purpose is to facilitate networking between past and current terrestrial ecosystem research. 2. DATABASE DESIGN AND IMPLEMENTATION In this section of the document a detailed description of the basic steps followed in designing and implementing the INCREASE DB is reported: a) Requirement analysis, In this section is described how data requirements from all sites were determined, and information were described and relationships between data were classified. In addition, the reviews of existing databases and database activities are reported. b) Methodology, this part describes the conceptual design, (the information content of the database expressed as entities and the relationships between entities (E-R schema) are defined, data and their objects are showed in a Data Models); the logical design (starting from the conceptual schema and taking into account the estimated applied data load, the E-R schema was restructured and translated in a logical model, which has an effective impact on the performance of database and ease of administration); and the physical design (the logical data model was transformed into a physical implementation based on the specific Database management System (DBMS) and operating system to be used for deployment). c) Operating environment, which describes (1) the Data Base Management System (DBMS) Environment, (2) the server operating system, (3) the hardware of the physical server, (4) the web server, and (5) the client application. d) Template for data collection, in this part structure and functionalities of excel templates developed for collecting data are described. For each macro-category of data a specific template was developed: Site, Site soil, Meteorology, Micrometeorology, Plant, Soil, Fauna, Water chemistry, and Plant diversity. 3. DATABASE TESTS This section describes tests done prior to DB implementation for validating and test for verifying the INCREASE DB performances. Tests were performed on two different levels: (1) targets (Units, Integration, System) and (2) objectives (alpha and beta tests, performance/stress test, security). 4. DATABASE HANDLING AND FUNCTIONALITIES a) Database website interface, This section describes the website interface used for connecting internal and external users to the INCREASE DB. b) Users and roles, this section gives a detailed description of different levels of access for different users with specific roles and permissions (System administrator, Uploaders - site coordinators and contributors, Downloaders - INCREASE community and authorized external users, Report viewer - external users, Users associated with specific sites), as reported in the INCREASE document "Infrastructure Intellectual Property Policy for Database Access". c) Functionalities, In this section the major characteristics and functionalities of DB are described: data uploading, data verification after uploading, data queries, data download, public and private pages with secure accesses. 5. DATABASE MAINTENANCE AND ENHANCEMENT In this section the maintenance activities conducted to monitor the operation and functioning of the system, and, when necessary, to repair and enhance the system are described. Ordinary maintenance activities included user list updating, user support, maintenance systems engineering (e.g. analysis of log and checking of server performance). 6. DATABASE/WEBSITE STATISTICS This section provides information about usage statistics of the production version of the INCREASE DB, since its online activation such as: the number of uploaded records per site and domain, the number of unique visitors of the website per month, the number queries by internal users in relation to data download operations.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
