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.

Anticipating future risk in social-ecological systems using fuzzy cognitive mapping: the case of wildfire in the Chiquitania, Bolivia

Understanding complex social-ecological systems, and anticipating how they may respond to rapid change, requires an approach that incorporates environmental, social, economic, and policy factors, usually in a context of fragmented data availability. We employed fuzzy cognitive mapping (FCM) to integrate these factors in the assessment of future wildfire risk in the Chiquitania region, Bolivia. In this region, dealing with wildfires is becoming increasingly challenging due to reinforcing feedbacks between multiple drivers. We conducted semi-structured interviews and constructed different FCMs in focus groups to understand the regional dynamics of wildfire from diverse perspectives. We used FCM modelling to evaluate possible adaptation scenarios in the context of future drier climatic conditions. Scenarios also considered possible failure to respond in time to the emergent risk. This approach proved of great potential to support decision-making for risk management. It helped identify key forcing variables and generate insights into potential risks and trade-offs of different strategies. All scenarios showed increased wildfire risk in the event of more droughts. The ‘Hands-off’ scenario resulted in amplified impacts driven by intensifying trends, affecting particularly the agricultural production. The ‘Fire management’ scenario, which adopted a bottom-up approach to improve controlled burning, showed less trade-offs between wildfire risk reduction and production compared to the ‘Fire suppression’ scenario. Findings highlighted the importance of considering strategies that involve all actors who use fire, and the need to nest these strategies for a more systemic approach to manage wildfire risk. The FCM model could be used as a decision-support tool and serve as a ‘boundary object’ to facilitate collaboration and integration of different forms of knowledge and perceptions of fire in the region. This approach has also the potential to support decisions in other dynamic frontier landscapes around the world that are facing increased risk of large wildfires.

Influence of rhBMP-2 on bone formation and osseointegration in different implant systems after sinus-floor elevation. An in vivo study on sheep

Background Several studies have reported certain bone morphogenic proteins (BMPs) to have positive effects on bone generation Although some investigators have studied the effects of human recombinant BMP (rhBMP-2) in sinus augmentation in sheep, none of these studies looked at the placement of implants at the time of sinus augmentation Furthermore, no literature could be found to report on the impact that different implant systems, as well as the positioning of the implants had on bone formation if rhBMP-2 was utilized in sinus-lift procedures Purpose The aim of this study was to compare sinus augmentation with rhBMP-2 on a poly-D, L-lactic-co-glycolic acid gelatine (PLPG) sponge with sinus augmentation with autologous pelvic cancellous bone in the maxillary sinus during the placement of different dental Implants Materials and methods Nine adult female sheep were submitted to bilateral sinus-floor elevation In one side (test group) the sinus lift was performed with rhBMP-2 on a PLPG-sponge, while the contralateral side served as the control by using cancellous bone from the iliac crest Three different implants (Branemark (R), 31 (R) and Straumann (R)) were inserted either simultaneously with the sinus augmentation or as a two staged procedure 6 weeks later The animals were sacrificed at 6 and 12 weeks for histological and histomorphometrical evaluations during which bone-to-implant contact (BIC) and bone density (BD) were evaluated Results BD and BIC were significantly higher at 12 weeks in the test group if the Implants were placed at the time of the sinus lift (p < 0 05) No difference was observed between the different implant systems or positions Conclusions The use of rhBMP-2 with PLPG-sponge increased BIC as well as BD in the augmented sinuses if compared to autologous bone Different implant systems and positions of the implants had no effect on BIC or BD (C) 2010 European Association for Cranio-Maxillo-Facial Surgery

Disruption of Saccharomyces cerevisiae by Plantaricin 149 and investigation of its mechanism of action with biomembrane model systems

The action of a synthetic antimicrobial peptide analog of Plantaricin 149 (Pln149a) against Saccharomyces cerevisiae and its interaction with biomembrane model systems were investigated. Pln149a was shown to inhibit S. cerevisiae growth by more than 80% in YPD medium, causing morphological changes in the yeast wall and remaining active and resistant to the yeast proteases even after 24 h of incubation. Different membrane model systems and carbohydrates were employed to better describe the Pln149a interaction with cellular components using circular dichroism and fluorescence spectroscopies, adsorption kinetics and surface elasticity in Langmuir monolayers. These assays showed that Pln149a does not interact with either mono/polysaccharides or zwitterionic LUVs, but is strongly adsorbed to and incorporated into negatively charged surfaces, causing a conformational change in its secondary structure from random-coil to helix upon adsorption. From the concurrent analysis of Pln149a adsorption kinetics and dilatational surface elasticity data, we determined that 2.5 mu M is the critical concentration at which Pln149a will disrupt a negative DPPG monolayer. Furthermore, Pln149a exhibited a carpet-like mechanism of action, in which the peptide initially binds to the membrane, covering its surface and acquiring a helical structure that remains associated to the negatively charged phospholipids. After this electrostatic interaction, another peptide region causes a strain in the membrane, promoting its disruption. (C) 2009 Elsevier B.V. All rights reserved.

Load Adapted Solar Thermal Combisystems - Optical Analysis and Systems Optimization

In a northern European climate a typical solar combisystem for a single family house normally saves between 10 and 30 % of the auxiliary energy needed for space heating and domestic water heating. It is considered uneconomical to dimension systems for higher energy savings. Overheating problems may also occur. One way of avoiding these problems is to use a collector that is designed so that it has a low optical efficiency in summer, when the solar elevation is high and the load is small, and a high optical efficiency in early spring and late fall when the solar elevation is low and the load is large.The study investigates the possibilities to design the system and, in particular, the collector optics, in order to match the system performance with the yearly variations of the heating load and the solar irradiation. It seems possible to design practically viable load adapted collectors, and to use them for whole roofs ( 40 m2) without causing more overheating stress on the system than with a standard 10 m2 system. The load adapted collectors collect roughly as much energy per unit area as flat plate collectors, but they may be produced at a lower cost due to lower material costs. There is an additional potential for a cost reduction since it is possible to design the load adapted collector for low stagnation temperatures making it possible to use less expensive materials. One and the same collector design is suitable for a wide range of system sizes and roof inclinations. The report contains descriptions of optimized collector designs, properties of realistic collectors, and results of calculations of system output, stagnation performance and cost performance. Appropriate computer tools for optical analysis, optimization of collectors in systems and a very fast simulation model have been developed.

Combined solar and pellet heating systems for single-family houses : How to achieve decreased electricity usage, increased system efficiency and increased solar gains

In Sweden, there are about 0.5 million single-family houses that are heated by electricity alone, and rising electricity costs force the conversion to other heating sources such as heat pumps and wood pellet heating systems. Pellet heating systems for single-family houses are currently a strongly growing market. Future lack of wood fuels is possible even in Sweden, and combining wood pellet heating with solar heating will help to save the bio-fuel resources. The objectives of this thesis are to investigate how the electrically heated single-family houses can be converted to pellet and solar heating systems, and how the annual efficiency and solar gains can be increased in such systems. The possible reduction of CO-emissions by combining pellet heating with solar heating has also been investigated. Systems with pellet stoves (both with and without a water jacket), pellet boilers and solar heating have been simulated. Different system concepts have been compared in order to investigate the most promising solutions. Modifications in system design and control strategies have been carried out in order to increase the system efficiency and the solar gains. Possibilities for increasing the solar gains have been limited to investigation of DHW-units for hot water production and the use of hot water for heating of dishwashers and washing machines via a heat exchanger instead of electricity (heat-fed appliances). Computer models of pellet stoves, boilers, DHW-units and heat-fed appliances have been developed and the parameters for the models have been identified from measurements on real components. The conformity between the models and the measurements has been checked. The systems with wood pellet stoves have been simulated in three different multi-zone buildings, simulated in detail with heat distribution through door openings between the zones. For the other simulations, either a single-zone house model or a load file has been used. Simulations were carried out for Stockholm, Sweden, but for the simulations with heat-fed machines also for Miami, USA. The foremost result of this thesis is the increased understanding of the dynamic operation of combined pellet and solar heating systems for single-family houses. The results show that electricity savings and annual system efficiency is strongly affected by the system design and the control strategy. Large reductions in pellet consumption are possible by combining pellet boilers with solar heating (a reduction larger than the solar gains if the system is properly designed). In addition, large reductions in carbon monoxide emissions are possible. To achieve these reductions it is required that the hot water production and the connection of the radiator circuit is moved to a well insulated, solar heated buffer store so that the boiler can be turned off during the periods when the solar collectors cover the heating demand. The amount of electricity replaced using systems with pellet stoves is very dependant on the house plan, the system design, if internal doors are open or closed and the comfort requirements. Proper system design and control strategies are crucial to obtain high electricity savings and high comfort with pellet stove systems. The investigated technologies for increasing the solar gains (DHW-units and heat-fed appliances) significantly increase the solar gains, but for the heat-fed appliances the market introduction is difficult due to the limited financial savings and the need for a new heat distribution system. The applications closest to market introduction could be for communal laundries and for use in sunny climates where the dominating part of the heat can be covered by solar heating. The DHW-unit is economical but competes with the internal finned-tube heat exchanger which is the totally dominating technology for hot water preparation in solar combisystems for single-family houses.

Annual CO-emissions of combined pellet and solar heating systems

Emissions are an important aspect of a pellet heating system. High carbon monoxide emissions are often caused by unnecessary cycling of the burner when the burner is operated below the lowest combustion power. Combining pellet heating systems with a solar heating system can significantly reduce cycling of the pellet heater and avoid the inefficient summer operation of the pellet heater. The aim of this paper was to study CO-emissions of the different types of systems and to compare the yearly CO-emissions obtained from simulations with the yearly CO-emissions calculated based on the values that are obtained by the standard test methods. The results showed that the yearly CO-emissions obtained from the simulations are significant higher than the yearly CO-emissions calculated based on the standard test methods. It is also shown that for the studied systems the average emissions under these realistic annual conditions were greater than the limit values of two Eco-labels. Furthermore it could be seen that is possible to almost halve the CO-emission if the pellet heater is combined with a solar heating system.

Energy efficient and economic renovation of residential buildings with low-temperature heating and air heat recovery

With the building sector accounting for around 40% of the total energy consumption in the EU, energy efficiency in buildings is and continues to be an important issue. Great progress has been made in reducing the energy consumption in new buildings, but the large stock of existing buildings with poor energy performance is probably an even more crucial area of focus. This thesis deals with energy efficiency measures that can be suitable for renovation of existing houses, particularly low-temperature heating systems and ventilation systems with heat recovery. The energy performance, environmental impact and costs are evaluated for a range of system combinations, for small and large houses with various heating demands and for different climates in Europe. The results were derived through simulation with energy calculation tools. Low-temperature heating and air heat recovery were both found to be promising with regard to increasing energy efficiency in European houses. These solutions proved particularly effective in Northern Europe as low-temperature heating and air heat recovery have a greater impact in cold climates and on houses with high heating demands. The performance of heat pumps, both with outdoor air and exhaust air, was seen to improve with low-temperature heating. The choice between an exhaust air heat pump and a ventilation system with heat recovery is likely to depend on case specific conditions, but both choices are more cost-effective and have a lower environmental impact than systems without heat recovery. The advantage of the heat pump is that it can be used all year round, given that it produces DHW. Economic and environmental aspects of energy efficiency measures do not always harmonize. On the one hand, lower costs can sometimes mean larger environmental impact; on the other hand there can be divergence between different environmental aspects. This makes it difficult to define financial subsidies to promote energy efficiency measures.

Population Fluctuations of Formicidae (Hymenoptera) and Araneae (Arachnida) in Two Tillage Systems in the Region of Guaíra-SP

The objective of this study was to elucidate population fluctuations of spider and ant species in forest fragments and adjacent soybean and corn crops under no-tillage and conventional tillage systems, and their correlations with meteorological factors. From Nov 2004 to Apr 2007 sampling of these arthropods at Guaira, São Paulo state was done biweekly during the cropping season and monthly during the periods between crops. To obtain samples at each experimental site, pitfall traps were distributed in 2 transects of 200 m of which 100 m was in the crop, and 100 m was in the forest fragment. Temperature and rainfall were found to have major impacts on fluctuations in population densities of ants of the genus, Pheidole, in soybean and corn crops both grown with conventional tillage and no tillage systems.

Microbial populations and the activity of the soil under agricultural and agricultural-pastoral systems

The effects of agricultural-pastoral and tillage practices on soil microbial populations and activities have not been systematically investigated. The effect of no-tillage (NT), no-tillage agricultural-pastoral integrated systems (NT-I) and conventional tillage (CT) at soil depths of 0-10, 10-20 and 20-30 cm on the microbial populations (bacteria and fungi), biomass-C, potential nitrification, urease and protease activities, total organic matter and total N contents were investigated. The crops used were soybean (in NT, NT-I and CT systems), corn (in NT and NT-I systems) and Tanner grass (Brachiaria sp.) (in NT-I system); a forest system was used as a control. Urease and protease activities, biomass-C and the content of organic matter and total N were higher (p < 0.05) in the forest soil than the other soils. Potential nitrification was significantly higher in the NT-I system in comparison with the other systems. Bacteria numbers were similar in all systems. Fungi counts were similar in the CT and forest, but both were higher than in NT. All of these variables were dependent on the organic matter content and decreased (p < 0.05) from the upper soil layer to the deeper soil layers. These results indicate that the no-tillage agricultural-pasture-integrated systems may be useful for soil conservation.

Artificial neural networks and clustering techniques applied in the reconfiguration of distribution systems

One objective of the feeder reconfiguration problem in distribution systems is to minimize the power losses for a specific load. For this problem, mathematical modeling is a nonlinear mixed integer problem that is generally hard to solve. This paper proposes an algorithm based on artificial neural network theory. In this context, clustering techniques to determine the best training set for a single neural network with generalization ability are also presented. The proposed methodology was employed for solving two electrical systems and presented good results. Moreover, the methodology can be employed for large-scale systems in real-time environment.

Planning and Projects of Secondary Electric Power Distribution Systems

This paper proposes a methodology to achieve integrated planning and projects for secondary distribution circuits. The planning model is formulated as a mixed integer nonlinear programming problem (MINLP). In order to resolve this problem, a tabu search (TS) algorithm is used, with a neighborhood structure developed to explore the physical characteristics of specific geographies included in the planning and expansion of secondary networks, thus obtaining effective solutions as well as low operating costs and investments. The project stage of secondary circuits consists of calculating the mechanical efforts to determine the support structures of the primary and secondary distribution systems and determining the types of structures that should be used in the system according to topological and electrical parameters of the network and, therefore, accurately assessing the costs involved in the construction and/or reform of secondary systems. A constructive heuristic based on information of the electrical and topological conditions between the medium voltage and low voltage systems is used to connect the primary systems and secondary circuits. The results obtained from planning and design simulations of a real secondary system of electric energy distribution are presented.

Riccati-type equations, generalised WZNW equations, and multidimensional Toda systems

We associate to an arbitrary Z-gradation of the Lie algebra of a Lie group a system of Riccati-type first order differential equations. The particular cases under consideration are the ordinary Riccati and the matrix Riccati equations. The multidimensional extension of these equations is given. The generalisation of the associated Redheffer-Reid differential systems appears in a natural way. The connection between the Toda systems and the Riccati-type equations in lower and higher dimensions is established. Within this context the integrability problem for those equations is studied. As an illustration, some examples of the integrable multidimensional Riccati-type equations related to the maximally nonabelian Toda systems are given.

Comparison of simulated periodontal bone defect depth measured in digital radiographs in dedicated and non-dedicated software systems

Objectives: To compare simulated periodontal bone defect depth measured in digital radiographs with dedicated and non-dedicated software systems and to compare the depth measurements from each program with the measurements in dry mandibles.Methods: Forty periodontal bone defects were created at the proximal area of the first premolar in dry pig mandibles. Measurements of the defects were performed with a periodontal probe in the dry mandible. Periapical digital radiographs of the defects were recorded using the Schick sensor in a standardized exposure setting. All images were read using a Schick dedicated software system (CDR DICOM for Windows v.3.5), and three commonly available non-dedicated software systems (Vix Win 2000 v.1.2; Adobe Photoshop 7.0 and Image Tool 3.0). The defects were measured three times in each image and a consensus was reached among three examiners using the four software systems. The difference between the radiographic measurements was analysed using analysis of variance (ANOVA) and by comparing the measurements from each software system with the dry mandibles measurements using Student's t-test.Results: the mean values of the bone defects measured in the radiographs were 5.07 rum, 5.06 rum, 5.01 mm and 5.11 mm for CDR Digital Image and Communication in Medicine (DICOM) for Windows, Vix Win, Adobe Photoshop, and Image Tool, respectively, and 6.67 mm for the dry mandible. The means of the measurements performed in the four software systems were not significantly different, ANOVA (P = 0.958). A significant underestimation of defect depth was obtained when we compared the mean depths from each software system with the dry mandible measurements (t-test; P congruent to 0.000).Conclusions: the periodontal bone defect measurements in dedicated and in three non-dedicated software systems were not significantly different, but they all underestimated the measurements when compared with the measurements obtained in the dry mandibles.