Analytical Database

14,000,000 Leading Edge Experts on the ideXlab platform

Scan Science and Technology

Contact Leading Edge Experts & Companies

Scan Science and Technology

Contact Leading Edge Experts & Companies

The Experts below are selected from a list of 228 Experts worldwide ranked by ideXlab platform

Roland Hiederer - One of the best experts on this subject based on the ideXlab platform.

  • data update and model revision for soil profile Analytical Database of europe of measured parameters spade m2
    2010
    Co-Authors: Roland Hiederer
    Abstract:

    The Soil Profile Analytical Database of Europe of Measured parameters (SPADE/M) is part of the distribution package of the Soil Geographic Database of Eurasia (SGDBE). Typical combinations of profile parameters and morphological characteristics of the sample site were intended to support the definition of generalized rules for estimating pedological and hydrological properties of the pedo-transfer rule (PTR) Database of the SGDBE. In 2005 the data of the SGDBE were transferred to a common data storage structure. In 2008 original hard-copies on profile measurements were re-discovered at the National Soil Resources Institute, Cranfield University (NSRI). To make the original data more generally available the profiles were added to the existing Database. This step required changes to the structure of the Database and a validation of the all entries for accurate and reliable data storage and retrieval. How to obtain EU publications Our priced publications are available from EU Bookshop (http://bookshop.europa.eu), where you can place an order with the sales agent of your choice. The Publications Office has a worldwide network of sales agents. You can obtain their contact details by sending a fax to (352) 29 29-42758. The mission of the JRC is to provide customer-driven scientific and technical support for the conception, development, implementation and monitoring of EU policies. As a service of the European Commission, the JRC functions as a reference centre o f science and technology for the Union. Close to the policy-making process, it serves the common interest of the Member States, while being independent of special interests, whether private or national. LB -N A -2433-EN -C

  • Data Update and Model Revision for Soil Profile Analytical Database of Europe of Measured Parameters (SPADE/M2)
    2010
    Co-Authors: Roland Hiederer
    Abstract:

    The Soil Profile Analytical Database of Europe of Measured parameters (SPADE/M) is part of the distribution package of the Soil Geographic Database of Eurasia (SGDBE). Typical combinations of profile parameters and morphological characteristics of the sample site were intended to support the definition of generalized rules for estimating pedological and hydrological properties of the pedo-transfer rule (PTR) Database of the SGDBE. In 2005 the data of the SGDBE were transferred to a common data storage structure. In 2008 original hard-copies on profile measurements were re-discovered at the National Soil Resources Institute, Cranfield University (NSRI). To make the original data more generally available the profiles were added to the existing Database. This step required changes to the structure of the Database and a validation of the all entries for accurate and reliable data storage and retrieval. How to obtain EU publications Our priced publications are available from EU Bookshop (http://bookshop.europa.eu), where you can place an order with the sales agent of your choice. The Publications Office has a worldwide network of sales agents. You can obtain their contact details by sending a fax to (352) 29 29-42758. The mission of the JRC is to provide customer-driven scientific and technical support for the conception, development, implementation and monitoring of EU policies. As a service of the European Commission, the JRC functions as a reference centre o f science and technology for the Union. Close to the policy-making process, it serves the common interest of the Member States, while being independent of special interests, whether private or national. LB -N A -2433-EN -C

  • soil profile Analytical Database for europe spade reconstruction and validation of the measured data spade m
    Geografisk Tidsskrift-danish Journal of Geography, 2006
    Co-Authors: Roland Hiederer, Robert J A Jones, Joel Daroussin
    Abstract:

    Abstract Geografisk Tidsskrift, Danish Journal of Geography 106(1):71–85, 2006 The Soil Profile Analytical Database of Europe of Measured profiles (SPADE/M) was created to provide a common structure for storing harmonized information on typical soil profile properties of European soils. The main difficulty encountered in constructing the Database was the transfer of the source data from individual electronic spreadsheet pages to the more rigid structure of a relational Database. The data in spreadsheet format had been collected more than 12 years earlier but pressure was mounting for the capability to link these data to the Soil Map of Europe. A semi-automatic process was implemented to transfer data from nominal positions on the spreadsheet page to an intermediate structure highlighting any deviations from expected values. Conflicting situations were solved by manual intervention and expert judgement. Data in the intermediate structure were subjected to a validation procedure with the aim of storing unif...

  • Soil Profile Analytical Database for Europe (SPADE): Reconstruction and Validation of the Measured Data (SPADE/M)
    Geografisk Tidsskrift-danish Journal of Geography, 2006
    Co-Authors: Roland Hiederer, Robert J A Jones, Joel Daroussin
    Abstract:

    Abstract Geografisk Tidsskrift, Danish Journal of Geography 106(1):71–85, 2006 The Soil Profile Analytical Database of Europe of Measured profiles (SPADE/M) was created to provide a common structure for storing harmonized information on typical soil profile properties of European soils. The main difficulty encountered in constructing the Database was the transfer of the source data from individual electronic spreadsheet pages to the more rigid structure of a relational Database. The data in spreadsheet format had been collected more than 12 years earlier but pressure was mounting for the capability to link these data to the Soil Map of Europe. A semi-automatic process was implemented to transfer data from nominal positions on the spreadsheet page to an intermediate structure highlighting any deviations from expected values. Conflicting situations were solved by manual intervention and expert judgement. Data in the intermediate structure were subjected to a validation procedure with the aim of storing unif...

Masaru Kitsuregawa - One of the best experts on this subject based on the ideXlab platform.

  • modeling query energy costs in Analytical Database systems with processor speed scaling
    Database and Expert Systems Applications, 2018
    Co-Authors: Yuto Hayamizu, Kazuo Goda, Masaru Kitsuregawa
    Abstract:

    Energy efficiency in Analytical Database systems is becoming increasingly important because of the rapid growth in energy consumed by data centers driven by the recent big data boom. Previous studies showed that processor speed scaling has the potential to improve energy efficiency of Analytical queries. These results, however, were obtained from measurement of specific queries. The power–performance characteristics of processor speed scaling specific to Analytical Database systems still remains unexplored despite their importance in energy efficient Analytical query processing. We tackle this problem by modeling the energy costs of Analytical queries with processor speed scaling based on query processing throughput. Our experimental evaluation shows that our energy model can be fitted within an error of 1.65% and can be used to identify power–performance characteristics of Analytical queries.

  • DEXA (2) - Modeling Query Energy Costs in Analytical Database Systems with Processor Speed Scaling
    Lecture Notes in Computer Science, 2018
    Co-Authors: Yuto Hayamizu, Kazuo Goda, Masaru Kitsuregawa
    Abstract:

    Energy efficiency in Analytical Database systems is becoming increasingly important because of the rapid growth in energy consumed by data centers driven by the recent big data boom. Previous studies showed that processor speed scaling has the potential to improve energy efficiency of Analytical queries. These results, however, were obtained from measurement of specific queries. The power–performance characteristics of processor speed scaling specific to Analytical Database systems still remains unexplored despite their importance in energy efficient Analytical query processing. We tackle this problem by modeling the energy costs of Analytical queries with processor speed scaling based on query processing throughput. Our experimental evaluation shows that our energy model can be fitted within an error of 1.65% and can be used to identify power–performance characteristics of Analytical queries.

Arwyn Jones - One of the best experts on this subject based on the ideXlab platform.

  • development of a harmonised soil profile Analytical Database for europe a resource for supporting regional soil management
    SOIL Discussions, 2019
    Co-Authors: Jeppe Aagaard Kristensen, Robert J A Jones, Thomas Balstrøm, Arwyn Jones, Luca Montanarella, Panos Panagos, Henrik Breuningmadsen
    Abstract:

    Abstract. Soil mapping is an essential method for obtaining a spatial overview of soil resources that are increasingly threatened by environmental change and population pressure. Despite recent advances in digital soil-mapping techniques based on inference, such methods are still immature for large-scale soil mapping. During the 1970s, 1980s and 1990s, soil scientists constructed a harmonised soil map of Europe ( 1:1 000 000 ) based on national soil maps. Despite this extraordinary regional overview of the spatial distribution of European soil types, crude assumptions about soil properties were necessary for translating the maps into thematic information relevant to management. To support modellers with Analytical data connected to the soil map, the European Soil Bureau Network (ESBW) commissioned the development of the soil profile Analytical Database for Europe (SPADE) in the late 1980s. This Database contains soil Analytical data based on a standardised set of soil Analytical methods across the European countries. Here, we review the principles adopted for developing the SPADE Database during the past five decades, the work towards fulfilling the milestones of full geographic coverage for dominant soils in all the European countries (SPADE level 1) and the addition of secondary soil types (SPADE level 2). We illustrate the application of the Database by showing the distribution of the root zone capacity and by estimating the soil organic carbon (SOC) stocks at a depth of 1  m for Europe to be 60×1015 g . The increased accuracy, potentially obtained by including secondary soil types (level 2), is shown in a case study to estimate SOC stocks in Denmark. Until data from systematic cross-European soil-sampling programmes have sufficient spatial coverage for reliable data interpolation, integrating national soil maps and locally assessed Analytical data into a harmonised Database remains a powerful resource to support soil resources management at regional and continental scales by providing a platform to guide sustainable soil management and food production.

  • Development of a harmonized soil profile Analytical Database for Europe: A resource for supporting regional soil management
    2019
    Co-Authors: Jeppe Aagaard Kristensen, Robert J A Jones, Thomas Balstrøm, Arwyn Jones, Luca Montanarella, Panos Panagos, Henrik Breuning-madsen
    Abstract:

    Abstract. Soil mapping is an essential method to obtain a spatial overview of soil resources that are increasingly threatened by environmental change and population pressure. Despite recent advances in digital soil mapping techniques based on inference, such methods are still immature for large-scale soil mapping. During the 1970s, 80s and 90s, soil scientists constructed a harmonized soil map of Europe (1 : 1M) based on national soil maps. Despite this extraordinary regional overview of the spatial distribution of European soil types, crude assumptions about soil properties were necessary to translate the maps into thematic maps relevant for management. To support modellers with Analytical data connected to the soil map, the European Soil Bureau commissioned the development of the Soil Profile Analytical Database for Europe (SPADE) in the late 1980s. This Database contains soil Analytical data based on a standardized set of soil Analytical methods across the European countries. Here, we review the principles adopted for developing the SPADE Database during the past five decades, and the work towards fulfilling the milestones of full geographic coverage for dominant soils in all the European countries (SPADE level 1), and the addition of secondary soil types (SPADE level 2). We demonstrate the application of the Database by showing the distribution of the root zone capacity, and by estimating the soil organic carbon (SOC) stocks to a depth of 1 m for EU-27 to 76 × 1015 g. The increased accuracy, potentially obtained by including secondary soil types (level 2), is demonstrated in a case study of estimating SOC stocks in Denmark. In the lack of systematic cross-European soil analysis schemes, integrating national soil maps and locally assessed Analytical data into a harmonized Database is a powerful resource to support soil resources management at regional and continental scales by providing a platform to guide sustainable soil management and food production.

  • assessment of the pesticide leaching risk at the pan european level the europearl approach
    Journal of Hydrology, 2004
    Co-Authors: A Tiktak, Arwyn Jones, Juan Pineros Garcet, Marnik Vanclooster
    Abstract:

    Contamination of the groundwater is an important side-effect of the usage of plant protection products in agriculture. Today, the use of plant protection products that potentially contaminate the groundwater is banned by registration procedures at both the European level (Council Directive 91/414/EEC), and the level of individual member states. The Directive places great importance on the use of models to calculate Predicted Environmental Concentrations (PECs) as a basis for assessing the environmental risks. In the first tier of the current procedure, point scale leaching models are combined with a limited number of worst-case scenarios to assess PEC groundwater in Europe. An alternative procedure would be to use spatially distributed leaching models. Such models provide policy makers with a wealth of additional information, allowing identification of high and low risk areas in terms of spatially varying environmental and land use properties. In this study, such a spatially distributed leaching model, the EuroPEARL model, was implemented to assess the leaching risk of plant protection products at the Pan-European scale. This model is one of the products that has been delivered within the framework of the APECOP project (FP5-QLK-1999-01238), which is a European project supporting the harmonised registration of plant protection products in Europe. Simulations were performed for 1062 unique combinations of Soil Mapping Unit, Climate Zone and Country. Soil properties, including soil horizon designations, were obtained from the Soil Profile Analytical Database of Europe. Daily weather data were obtained from the MARS Database. Other data like irrigation data, crop data and product properties have been compiled from various sources, such as inventories, field-studies and the literature. The 1062 unique combinations together represent 75% of the total agricultural area of the European Union. Austria, Sweden and Finland could not be included in the simulations, because there was insufficient soil 2 profile information for these countries. Results are presented with a resolution of 10 x 10 km(2), which is the highest justifiable resolution based on the EU soil map 1: 1,000,000. The Pan-European results confirm that the predicted leaching concentration generally increases with precipitation and irrigation and decreases with increasing organic matter content. Because of the strong sensitivity of the leaching concentration to soil properties, there is a strong variability of the calculated leaching concentration at relatively short distances. Results further indicate that due to large irrigation amounts combined with large temporal variation of rainfall in the Southern European countries, the trend in the calculated leaching risks from North to South was less than expected. This implies that areas of high leaching risk ('hotspots') as assessed by means of the EuroPEARL model occur in all countries of the European Union, including the Southern European countries. (C) 2003 Elsevier B.V. All rights reserved.

Marnik Vanclooster - One of the best experts on this subject based on the ideXlab platform.

  • assessment of the pesticide leaching risk at the pan european level the europearl approach
    Journal of Hydrology, 2004
    Co-Authors: A Tiktak, Arwyn Jones, Juan Pineros Garcet, Marnik Vanclooster
    Abstract:

    Contamination of the groundwater is an important side-effect of the usage of plant protection products in agriculture. Today, the use of plant protection products that potentially contaminate the groundwater is banned by registration procedures at both the European level (Council Directive 91/414/EEC), and the level of individual member states. The Directive places great importance on the use of models to calculate Predicted Environmental Concentrations (PECs) as a basis for assessing the environmental risks. In the first tier of the current procedure, point scale leaching models are combined with a limited number of worst-case scenarios to assess PEC groundwater in Europe. An alternative procedure would be to use spatially distributed leaching models. Such models provide policy makers with a wealth of additional information, allowing identification of high and low risk areas in terms of spatially varying environmental and land use properties. In this study, such a spatially distributed leaching model, the EuroPEARL model, was implemented to assess the leaching risk of plant protection products at the Pan-European scale. This model is one of the products that has been delivered within the framework of the APECOP project (FP5-QLK-1999-01238), which is a European project supporting the harmonised registration of plant protection products in Europe. Simulations were performed for 1062 unique combinations of Soil Mapping Unit, Climate Zone and Country. Soil properties, including soil horizon designations, were obtained from the Soil Profile Analytical Database of Europe. Daily weather data were obtained from the MARS Database. Other data like irrigation data, crop data and product properties have been compiled from various sources, such as inventories, field-studies and the literature. The 1062 unique combinations together represent 75% of the total agricultural area of the European Union. Austria, Sweden and Finland could not be included in the simulations, because there was insufficient soil 2 profile information for these countries. Results are presented with a resolution of 10 x 10 km(2), which is the highest justifiable resolution based on the EU soil map 1: 1,000,000. The Pan-European results confirm that the predicted leaching concentration generally increases with precipitation and irrigation and decreases with increasing organic matter content. Because of the strong sensitivity of the leaching concentration to soil properties, there is a strong variability of the calculated leaching concentration at relatively short distances. Results further indicate that due to large irrigation amounts combined with large temporal variation of rainfall in the Southern European countries, the trend in the calculated leaching risks from North to South was less than expected. This implies that areas of high leaching risk ('hotspots') as assessed by means of the EuroPEARL model occur in all countries of the European Union, including the Southern European countries. (C) 2003 Elsevier B.V. All rights reserved.

  • assessment of the pesticide leaching at the pan european level using a spatially distributed model
    XII Pesticide chemistry symposium: pesticide in air plant soil and water system, 2003
    Co-Authors: A Tiktak, Juan Pineros Garcet, Ashley Jones, Marnik Vanclooster
    Abstract:

    This paper describes the implementation of a Pan-European spatially distributed pesticide leaching model, referred to as EuroPEARL. Simulations were performed for 1062 unique combinations of Soil Mapping Unit, Climate Zone and Country. Soil properties were obtained from the Soil Profile Analytical Database of Europe. Daily weather data were obtained from the MARS Database. Irrigation data, crop data and product properties were compiled from various sources, such as inventories, field-studies and the literature. The 1062 unique comb inations together represent 75% of the total agricultural area of the EU. Results confirm that the predicted leaching concentration generally increases with precipitation and irrigation and decreases with increasing organic matter content. Because of the strong sensitivity of the leaching concentration to soil properties, there is a strong variability of the calculated leaching concentration at relatively short distances. Due to large irrigation amounts combined with large temporal variation of rainfall in the Southern European countries, areas of high leaching risk (‘hotspots’) as assessed by means of the EuroPEARL model occur in all countries of the European Union, including the Southern European countries.

Robert J A Jones - One of the best experts on this subject based on the ideXlab platform.

  • development of a harmonised soil profile Analytical Database for europe a resource for supporting regional soil management
    SOIL Discussions, 2019
    Co-Authors: Jeppe Aagaard Kristensen, Robert J A Jones, Thomas Balstrøm, Arwyn Jones, Luca Montanarella, Panos Panagos, Henrik Breuningmadsen
    Abstract:

    Abstract. Soil mapping is an essential method for obtaining a spatial overview of soil resources that are increasingly threatened by environmental change and population pressure. Despite recent advances in digital soil-mapping techniques based on inference, such methods are still immature for large-scale soil mapping. During the 1970s, 1980s and 1990s, soil scientists constructed a harmonised soil map of Europe ( 1:1 000 000 ) based on national soil maps. Despite this extraordinary regional overview of the spatial distribution of European soil types, crude assumptions about soil properties were necessary for translating the maps into thematic information relevant to management. To support modellers with Analytical data connected to the soil map, the European Soil Bureau Network (ESBW) commissioned the development of the soil profile Analytical Database for Europe (SPADE) in the late 1980s. This Database contains soil Analytical data based on a standardised set of soil Analytical methods across the European countries. Here, we review the principles adopted for developing the SPADE Database during the past five decades, the work towards fulfilling the milestones of full geographic coverage for dominant soils in all the European countries (SPADE level 1) and the addition of secondary soil types (SPADE level 2). We illustrate the application of the Database by showing the distribution of the root zone capacity and by estimating the soil organic carbon (SOC) stocks at a depth of 1  m for Europe to be 60×1015 g . The increased accuracy, potentially obtained by including secondary soil types (level 2), is shown in a case study to estimate SOC stocks in Denmark. Until data from systematic cross-European soil-sampling programmes have sufficient spatial coverage for reliable data interpolation, integrating national soil maps and locally assessed Analytical data into a harmonised Database remains a powerful resource to support soil resources management at regional and continental scales by providing a platform to guide sustainable soil management and food production.

  • Development of a harmonized soil profile Analytical Database for Europe: A resource for supporting regional soil management
    2019
    Co-Authors: Jeppe Aagaard Kristensen, Robert J A Jones, Thomas Balstrøm, Arwyn Jones, Luca Montanarella, Panos Panagos, Henrik Breuning-madsen
    Abstract:

    Abstract. Soil mapping is an essential method to obtain a spatial overview of soil resources that are increasingly threatened by environmental change and population pressure. Despite recent advances in digital soil mapping techniques based on inference, such methods are still immature for large-scale soil mapping. During the 1970s, 80s and 90s, soil scientists constructed a harmonized soil map of Europe (1 : 1M) based on national soil maps. Despite this extraordinary regional overview of the spatial distribution of European soil types, crude assumptions about soil properties were necessary to translate the maps into thematic maps relevant for management. To support modellers with Analytical data connected to the soil map, the European Soil Bureau commissioned the development of the Soil Profile Analytical Database for Europe (SPADE) in the late 1980s. This Database contains soil Analytical data based on a standardized set of soil Analytical methods across the European countries. Here, we review the principles adopted for developing the SPADE Database during the past five decades, and the work towards fulfilling the milestones of full geographic coverage for dominant soils in all the European countries (SPADE level 1), and the addition of secondary soil types (SPADE level 2). We demonstrate the application of the Database by showing the distribution of the root zone capacity, and by estimating the soil organic carbon (SOC) stocks to a depth of 1 m for EU-27 to 76 × 1015 g. The increased accuracy, potentially obtained by including secondary soil types (level 2), is demonstrated in a case study of estimating SOC stocks in Denmark. In the lack of systematic cross-European soil analysis schemes, integrating national soil maps and locally assessed Analytical data into a harmonized Database is a powerful resource to support soil resources management at regional and continental scales by providing a platform to guide sustainable soil management and food production.

  • Soil Profile Analytical Database for Europe (SPADE): Reconstruction and Validation of the Measured Data (SPADE/M)
    Geografisk Tidsskrift-danish Journal of Geography, 2006
    Co-Authors: Roland Hiederer, Robert J A Jones, Joel Daroussin
    Abstract:

    Abstract Geografisk Tidsskrift, Danish Journal of Geography 106(1):71–85, 2006 The Soil Profile Analytical Database of Europe of Measured profiles (SPADE/M) was created to provide a common structure for storing harmonized information on typical soil profile properties of European soils. The main difficulty encountered in constructing the Database was the transfer of the source data from individual electronic spreadsheet pages to the more rigid structure of a relational Database. The data in spreadsheet format had been collected more than 12 years earlier but pressure was mounting for the capability to link these data to the Soil Map of Europe. A semi-automatic process was implemented to transfer data from nominal positions on the spreadsheet page to an intermediate structure highlighting any deviations from expected values. Conflicting situations were solved by manual intervention and expert judgement. Data in the intermediate structure were subjected to a validation procedure with the aim of storing unif...

  • soil profile Analytical Database for europe spade reconstruction and validation of the measured data spade m
    Geografisk Tidsskrift-danish Journal of Geography, 2006
    Co-Authors: Roland Hiederer, Robert J A Jones, Joel Daroussin
    Abstract:

    Abstract Geografisk Tidsskrift, Danish Journal of Geography 106(1):71–85, 2006 The Soil Profile Analytical Database of Europe of Measured profiles (SPADE/M) was created to provide a common structure for storing harmonized information on typical soil profile properties of European soils. The main difficulty encountered in constructing the Database was the transfer of the source data from individual electronic spreadsheet pages to the more rigid structure of a relational Database. The data in spreadsheet format had been collected more than 12 years earlier but pressure was mounting for the capability to link these data to the Soil Map of Europe. A semi-automatic process was implemented to transfer data from nominal positions on the spreadsheet page to an intermediate structure highlighting any deviations from expected values. Conflicting situations were solved by manual intervention and expert judgement. Data in the intermediate structure were subjected to a validation procedure with the aim of storing unif...

  • soil profile Analytical Database for the european union
    Geografisk Tidsskrift-danish Journal of Geography, 1995
    Co-Authors: Henrik Breuningmadsen, Robert J A Jones
    Abstract:

    Danish Journal of Geography 95: 49–58, 1995. In 1985 the European Communities now the European Union published a soil map covering all the Community countries. This map has been digitized, but for modelling purposes it was necessary to compile a Soil Profile Analytical Database connected to the European Communities Soil Map. This compilation commenced in 1992 following a decade of expert group meetings concerning European soil and land data. This account describes the events that led to the decision to develop this Database, and how it was compiled.