Design of a unified data with business rules storage model for OLTP and OLAP systems

This paper reviews the literature concerning the practice of using Online Analytical Processing (OLAP) systems to recall information stored by Online Transactional Processing (OLTP) systems. Such a review provides a basis for discussion on the need for the information that are recalled through OLAP systems to maintain the contexts of transactions with the data captured by the respective OLTP system. The paper observes an industry trend involving the use of OLTP systems to process information into data, which are then stored in databases without the business rules that were used to process information and data stored in OLTP databases without associated business rules. This includes the necessitation of a practice, whereby, sets of business rules are used to extract, cleanse, transform and load data from disparate OLTP systems into OLAP databases to support the requirements for complex reporting and analytics. These sets of business rules are usually not the same as business rules used to capture data in particular OLTP systems. The paper argues that, differences between the business rules used to interpret these same data sets, risk gaps in semantics between information captured by OLTP systems and information recalled through OLAP systems. Literature concerning the modeling of business transaction information as facts with context as part of the modelling of information systems were reviewed to identify design trends that are contributing to the design quality of OLTP and OLAP systems. The paper then argues that; the quality of OLTP and OLAP systems design has a critical dependency on the capture of facts with associated context, encoding facts with contexts into data with business rules, storage and sourcing of data with business rules, decoding data with business rules into the facts with the context and recall of facts with associated contexts. The paper proposes UBIRQ, a design model to aid the co-design of data with business rules storage for OLTP and OLAP purposes. The proposed design model provides the opportunity for the implementation and use of multi-purpose databases, and business rules stores for OLTP and OLAP systems. Such implementations would enable the use of OLTP systems to record and store data with executions of business rules, which will allow for the use of OLTP and OLAP systems to query data with business rules used to capture the data. Thereby ensuring information recalled via OLAP systems preserves the contexts of transactions as per the data captured by the respective OLTP system.

Interacting controls on innate sources of CO2 efflux from a calcareous arid zone soil under experimental acidification and wetting

More than half of global soil carbon is stored as carbonates, primarily in arid and semi-arid zones. Climate change models predict more frequent and severe rainfall events in some parts of the globe, many of which are dominated by calcareous soils. Such events trigger substantial increases in soil CO2 efflux. We hypothesised that the primary source of CO2 emissions from calcareous, arid zone soil during a single wetting event is abiotic and that soil acidification and wetting have a positive, potentially interacting, effect. We manipulated soil pH, soil moisture, and controlled soil respiration by gamma irradiating half of an 11 day incubation experiment. All manipulated experimental treatments had a rapid and enormous effect on CO2 emission. Respiration contributed ca. 5% of total CO2 efflux; the major source (carbonate buffering) varied depending on the extent of acidification and wetting. Maximum CO2 efflux occurred when pH was lowest and at intermediate matric potential. CO2 efflux was lowest at native pH when soil was air dry. Our data suggest that there may be an underestimate of soil-atmosphere carbon fluxes in arid ecosystems with calcareous soils. There is also a clear potential that these soils may become net carbon sources depending on changes in rainfall patterns, rainfall acidity, and future land management. Our findings have major implications for carbon cycling in arid zone soil and further study of carbon dynamics in these terrestrial systems at a landscape level will be required if we are to improve global climate and carbon cycling models.

Global patterns of plant root colonization intensity by mycorrhizal fungi explained by climate and soil chemistry

Aim Most vascular plants on Earth form mycorrhizae, a symbiotic relationship between plants and fungi. Despite the broad recognition of the importance of mycorrhizae for global carbon and nutrient cycling, we do not know how soil and climate variables relate to the intensity of colonization of plant roots by mycorrhizal fungi. Here we quantify the global patterns of these relationships. Location Global. Methods Data on plant root colonization intensities by the two dominant types of mycorrhizal fungi world-wide, arbuscular (4887 plant species in 233 sites) and ectomycorrhizal fungi (125 plant species in 92 sites), were compiled from published studies. Data for climatic and soil factors were extracted from global datasets. For a given mycorrhizal type, we calculated at each site the mean root colonization intensity by mycorrhizal fungi across all potentially mycorrhizal plant species found at the site, and subjected these data to generalized additive model regression analysis with environmental factors as predictor variables. Results We show for the first time that at the global scale the intensity of plant root colonization by arbuscular mycorrhizal fungi strongly relates to warm-season temperature, frost periods and soil carbon-to-nitrogen ratio, and is highest at sites featuring continental climates with mild summers and a high availability of soil nitrogen. In contrast, the intensity of ectomycorrhizal infection in plant roots is related to soil acidity, soil carbon-to-nitrogen ratio and seasonality of precipitation, and is highest at sites with acidic soils and relatively constant precipitation levels. Main conclusions We provide the first quantitative global maps of intensity of mycorrhizal colonization based on environmental drivers, and suggest that environmental changes will affect distinct types of mycorrhizae differently. Future analyses of the potential effects of environmental change on global carbon and nutrient cycling via mycorrhizal pathways will need to take into account the relationships discovered in this study.

Soil conditioning and plant-soil feedbacks in a modified forest ecosystem are soil-context dependent

Aims There is potential for altered plant-soil feedback (PSF) to develop in human-modified ecosystems but empirical data to test this idea are limited. Here, we compared the PSF operating in jarrah forest soil restored after bauxite mining in Western Australia with that operating in unmined soil. Methods Native seedlings of jarrah (Eucalyptus marginata), acacia (Acacia pulchella), and bossiaea (Bossiaea ornata) were grown in unmined and restored soils to measure conditioning of chemical and biological properties as compared with unplanted control soils. Subsequently, acacia and bossiaea were grown in soils conditioned by their own or by jarrah seedlings to determine the net PSF. Results In unmined soil, the three plant species conditioned the chemical properties but had little effect on the biological properties. In comparison, jarrah and bossiaea conditioned different properties of restored soil while acacia did not condition this soil. In unmined soil, neutral PSF was observed, whereas in restored soil, negative PSF was associated with acacia and bossiaea. Conclusions Soil conditioning was influenced by soil context and plant species. The net PSF was influenced by soil context, not by plant species and it was different in restored and unmined soils. The results have practical implications for ecosystem restoration after human activities.

Designing a sampling scheme to reveal correlations between weeds and soil properties at multiple spatial scales

Weeds tend to aggregate in patches within fields and there is evidence that this is partly owing to variation in soil properties. Because the processes driving soil heterogeneity operate at different scales, the strength of the relationships between soil properties and weed density would also be expected to be scale-dependent. Quantifying these effects of scale on weed patch dynamics is essential to guide the design of discrete sampling protocols for mapping weed distribution. We have developed a general method that uses novel within-field nested sampling and residual maximum likelihood (REML) estimation to explore scale-dependent relationships between weeds and soil properties. We have validated the method using a case study of Alopecurus myosuroides in winter wheat. Using REML, we partitioned the variance and covariance into scale-specific components and estimated the correlations between the weed counts and soil properties at each scale. We used variograms to quantify the spatial structure in the data and to map variables by kriging. Our methodology successfully captured the effect of scale on a number of edaphic drivers of weed patchiness. The overall Pearson correlations between A. myosuroides and soil organic matter and clay content were weak and masked the stronger correlations at >50 m. Knowing how the variance was partitioned across the spatial scales we optimized the sampling design to focus sampling effort at those scales that contributed most to the total variance. The methods have the potential to guide patch spraying of weeds by identifying areas of the field that are vulnerable to weed establishment.

Microbial decomposition of skeletal muscle tissue (Ovis aries) in a sandy loam soil at different temperatures

A laboratory experiment was conducted to determine the effect of temperature (2, 12, 22 °C) on the rate of aerobic decomposition of skeletal muscle tissue (Ovis aries) in a sandy loam soil incubated for a period of 42 days. Measurements of decomposition processes included skeletal muscle tissue mass loss, carbon dioxide (CO2) evolution, microbial biomass, soil pH, skeletal muscle tissue carbon (C) and nitrogen (N) content and the calculation of metabolic quotient (qCO2). Incubation temperature and skeletal muscle tissue quality had a significant effect on all of the measured process rates with 2 °C usually much lower than 12 and 22 °C. Cumulative CO2 evolution at 2, 12 and 22 °C equaled 252, 619 and 905 mg CO2, respectively. A significant correlation (P<0.001) was detected between cumulative CO2 evolution and tissue mass loss at all temperatures. Q10s for mass loss and CO2 evolution, which ranged from 1.19 to 3.95, were higher for the lower temperature range (Q10(2– 12 °C)>Q10(12–22 °C)) in the Ovis samples and lower for the low temperature range (Q10(2–12 °C)requirements at lower temperature.

Soil phosphorus dynamics and phytoavailability from sewage sludge at different stages in a treatment stream

The effect of different stages of sewage sludge treatment on phosphorus (P) dynamics in amended soils was determined using samples of undigested liquid (UL), anaerobically digested liquid (AD) and dewatered anaerobically digested (DC) sludge. Sludges were taken from three points in the same treatment stream and applied to a sandy loam soil in field-based mesocosms at 4, 8 and 16t ha−1 dry solids. Mesocosms were sown with perennial ryegrass (Lolium perenne cv. Melle), and the sward was harvested after 35 and 70 days to determine yield and foliar P concentration. Soils were also sampled during this period to measure P transformations and the activities of acid phosphomonoesterase and phosphodiesterase. Data show that the AD amended soils had the greatest plant-available and foliar P content up to the second harvest, but the UL amended soils had the greatest enzyme activity. Characterisation of control and 16t ha−1 soils and sludge using solution 31P nuclear magnetic resonance (NMR) spectroscopy after NaOH–EDTA extraction revealed that P was predominantly in the inorganic pool in all three sludge samples, with the highest proportion (of the total extracted P) as inorganic P in the anaerobically digested liquid sludge. After sludge incorporation, P was immobilised to organic species. The majority of organic P was in monoester-P forms, while the remainder of organic P (diester P and phosphonate P) was more susceptible to transformations through time and showed variation with sludge type. These results show that application of sewage sludge at rates as low as 4t ha−1 can have a significant nutritional benefit to ryegrass over an initial 35-day growth and subsequent 35-day re-growth periods. Differences in P transformation, and hence nutritional benefit, between sludge types were evident throughout the experiment. Thus, differences in sludge treatment process alter the edaphic mineralisation characteristics of biosolids derived from the same source material.

Are sulfurous soil amendments (S0, Fe(II)SO4, Fe(III)SO4) an effective tool in the restoration of heathland and acidic grassland after four decades of rock phosphate Fertilization?

This paper deals with the complex issue of reversing long-term improvements of fertility in soils derived from heathlands and acidic grasslands using sulfur-based amendments. The experiment was conducted on a former heathland and acid grassland in the U.K. that was heavily fertilized and limed with rock phosphate, chalk, and marl. The experimental work had three aims. First, to determine whether sulfurous soil amendments are able to lower pH to a level suitable for heathland and acidic grassland re-creation (approximately 3 pH units). Second, to determine what effect the soil amendments have on the available pool of some basic cations and some potentially toxic acidic cations that may affect the plant community. Third, to determine whether the addition of Fe to the soil system would sequester PO4− ions that might be liberated from rock phosphate by the experimental treatments. The application of S0 and Fe(II)SO4− to the soil was able to reduce pH. However, only the highest S0 treatment (2,000 kg/ha S) lowered pH sufficiently for heathland restoration purposes but effectively so. Where pH was lowered, basic cations were lost from the exchangeable pool and replaced by acidic cations. Where Fe was added to the soil, there was no evidence of PO4− sequestration from soil test data (Olsen P), but sequestration was apparent because of lower foliar P in the grass sward. The ability of the forb Rumex acetosella to apparently detoxify Al3+, prevalent in acidified soils, appeared to give it a competitive advantage over other less tolerant species. We would anticipate further changes in plant community structure through time, driven by Al3+ toxicity, leading to the competitive exclusion of less tolerant species. This, we suggest, is a key abiotic driver in the restoration of biotic (acidic plant) communities.

Fine-scale temporal characterization of trends in soil water dissolved organic carbon and potential drivers

Long-term monitoring of surface water quality has shown increasing concentrations of Dissolved Organic Carbon (DOC) across a large part of the Northern Hemisphere. Several drivers have been implicated including climate change, land management change, nitrogen and sulphur deposition and CO2 enrichment. Analysis of stream water data, supported by evidence from laboratory studies, indicates that an effect of declining sulphur deposition on catchment soil chemistry is likely to be the primary mechanism, but there are relatively few long term soil water chemistry records in the UK with which to investigate this, and other, hypotheses directly. In this paper, we assess temporal relationships between soil solution chemistry and parameters that have been argued to regulate DOC production and, using a unique set of co-located measurements of weather and bulk deposition and soil solution chemistry provided by the UK Environmental Change Network and the Intensive Forest Monitoring Level II Network . We used statistical non-linear trend analysis to investigate these relationships at 5 forested and 4 non-forested sites from 1993 to 2011. Most trends in soil solution DOC concentration were found to be non-linear. Significant increases in DOC occurred mostly prior to 2005. The magnitude and sign of the trends was associated qualitatively with changes in acid deposition, the presence/absence of a forest canopy, soil depth and soil properties. The strongest increases in DOC were seen in acidic forest soils and were most clearly linked to declining anthropogenic acid deposition, while DOC trends at some sites with westerly locations appeared to have been influenced by shorter-term hydrological variation. The results indicate that widespread DOC increases in surface waters observed elsewhere, are most likely dominated by enhanced mobilization of DOC in surficial organic horizons, rather than changes in the soil water chemistry of deeper horizons. While trends in DOC concentrations in surface horizons have flattened out in recent years, further increases may be expected as soil chemistry continues to adjust to declining inputs of acidity.

Upgrading a TCABR data analysis and acquisition system for remote participation using Java, XML, RCP and modern client/server communication/authentication

The TCABR data analysis and acquisition system has been upgraded to support a joint research programme using remote participation technologies. The architecture of the new system uses Java language as programming environment. Since application parameters and hardware in a joint experiment are complex with a large variability of components, requirements and specification solutions need to be flexible and modular, independent from operating system and computer architecture. To describe and organize the information on all the components and the connections among them, systems are developed using the extensible Markup Language (XML) technology. The communication between clients and servers uses remote procedure call (RPC) based on the XML (RPC-XML technology). The integration among Java language, XML and RPC-XML technologies allows to develop easily a standard data and communication access layer between users and laboratories using common software libraries and Web application. The libraries allow data retrieval using the same methods for all user laboratories in the joint collaboration, and the Web application allows a simple graphical user interface (GUI) access. The TCABR tokamak team in collaboration with the IPFN (Instituto de Plasmas e Fusao Nuclear, Instituto Superior Tecnico, Universidade Tecnica de Lisboa) is implementing this remote participation technologies. The first version was tested at the Joint Experiment on TCABR (TCABRJE), a Host Laboratory Experiment, organized in cooperation with the IAEA (International Atomic Energy Agency) in the framework of the IAEA Coordinated Research Project (CRP) on ""Joint Research Using Small Tokamaks"". (C) 2010 Elsevier B.V. All rights reserved.

Lipopeptides Produced by a Soil Bacillus Megaterium Strain

A soil microorganism identified as Bacillum megaterium was found to produce several antibiotics substances after growth for 20 h at 37A degrees C in a mineral culture medium. Analysis both by electron spray ionization (ESI) and matrix-assisted laser desorption ionization-time of flight (MALDI-TOF) mass spectrometry (MS) identified these substances as lipopeptides. Predominant peaks at m/z 1,041 and m/z 1,065 revealed ions which are compatible with surfactins and lichenysins, respectively. Two other ions m/z 1,057 and m/z 1,464 were further studied by collision-induced dissociation (CID) unveiling an iturin A at the first and fengycins A and B at the second m/z peaks. The CID spectrum of the m/z 1,464 ion also suggests the existence of fengycins A and B variants in which Ile was changed to Val in the position 10 of the peptide moiety. Raw mixtures of all these compounds were also assayed for antibiotic features. The data enlighten the unusual diversity of the lipopeptide mixture produced by a sole Bacillus species.

Insights into the Molecular Requirements for the Anti-obesity Activity of a Series of CB1 Ligands

Two-dimensional and 3D quantitative structure-activity relationships studies were performed on a series of diarylpyridines that acts as cannabinoid receptor ligands by means of hologram quantitative structure-activity relationships and comparative molecular field analysis methods. The quantitative structure-activity relationships models were built using a data set of 52 CB1 ligands that can be used as anti-obesity agents. Significant correlation coefficients (hologram quantitative structure-activity relationships: r 2 = 0.91, q 2 = 0.78; comparative molecular field analysis: r 2 = 0.98, q 2 = 0.77) were obtained, indicating the potential of these 2D and 3D models for untested compounds. The models were then used to predict the potency of an external test set, and the predicted (calculated) values are in good agreement with the experimental results. The final quantitative structure-activity relationships models, along with the information obtained from 2D contribution maps and 3D contour maps, obtained in this study are useful tools for the design of novel CB1 ligands with improved anti-obesity potency.

Application of chemometric methods in the evaluation of chemical and spectroscopic data on organic matter from Oxisols in sewage sludge applications

Chemometric methods can contribute to soil research by permitting the extraction of more information from the data. The aim of this work was to use Principal Component Analysis to evaluate data obtained through chemical and spectroscopic methods on the changes in the humification process of soil organic matter from two tropical soils after sewage sludge application. In this case, humic acids extracted from Typic Eutrorthox and Typic Haplorthox soils with and without sewage sludge application for 7 consecutive years were studied. The results obtained for all of the samples and methods showed two clusters: samples extracted from the two soil types. These expected results indicated the textural difference between the two soils was more significant than the differences between treatments (control and sewage sludge application) or between depths. In this case, an individual chemometric treatment was made for each type of soil. It was noted that the characterization of the humic acids extracted from soils with and without sewage sludge application after 7 consecutive years using several methods supplies important results about changes in the humification degree of soil organic matter, These important result obtained by Principal Component Analysis justify further research using these methods to characterize the changes in the humic acids extracted from sewage sludge-amended soils. (C) 2009 Elsevier B.V. All rights reserved.

Agent-Oriented Data Curation in Bioinformatics

The practitioners of bioinformatics require increasing sophistication from their software tools to take into account the particular characteristics that make their domain complex. For example, there is a great variation of experience of researchers, from novices who would like guidance from experts in the best resources to use to experts that wish to take greater management control of the tools used in their experiments. Also, the range of available, and conflicting, data formats is growing and there is a desire to automate the many trivial manual stages of in-silico experiments. Agent-oriented software development is one approach to tackling the design of complex applications. In this paper, we argue that, in fact, agent-oriented development is a particularly well-suited approach to developing bioinformatics tools that take into account the wider domain characteristics. To illustrate this, we design a data curation tool, which manages the format of experimental data, extend it to better account for the extra requirements placed by the domain characteristics, and show how the characteristics lead to a system well suited to an agent-oriented view.

Agent-Oriented Data Curation in Bioinformatics

The practitioners of bioinformatics require increasing sophistication from their software tools to take into account the particular characteristics that make their domain complex. For example, there is a great variation of experience of researchers, from novices who would like guidance from experts in the best resources to use to experts that wish to take greater management control of the tools used in their experiments. Also, the range of available, and conflicting, data formats is growing and there is a desire to automate the many trivial manual stages of in-silico experiments. Agent-oriented software development is one approach to tackling the design of complex applications. In this paper, we argue that, in fact, agent-oriented development is a particularly well-suited approach to developing bioinformatics tools that take into account the wider domain characteristics. To illustrate this, we design a data curation tool, which manages the format of experimental data, extend it to better account for the extra requirements placed by the domain characteristics, and show how the characteristics lead to a system well suited to an agent-oriented view.