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.

Structure-based energetics of protein interfaces guides foot-and-mouth disease virus vaccine design

Virus capsids are primed for disassembly, yet capsid integrity is key to generating a protective immune response. Foot-and-mouth disease virus (FMDV) capsids comprise identical pentameric protein subunits held together by tenuous noncovalent interactions and are often unstable. Chemically inactivated or recombinant empty capsids, which could form the basis of future vaccines, are even less stable than live virus. Here we devised a computational method to assess the relative stability of protein-protein interfaces and used it to design improved candidate vaccines for two poorly stable, but globally important, serotypes of FMDV: O and SAT2. We used a restrained molecular dynamics strategy to rank mutations predicted to strengthen the pentamer interfaces and applied the results to produce stabilized capsids. Structural analyses and stability assays confirmed the predictions, and vaccinated animals generated improved neutralizing-antibody responses to stabilized particles compared to parental viruses and wild-type capsids.

Genetic dissection of heterosis using epistatic association mapping in a partial NCII mating design

Heterosis refers to the phenomenon in which an F1 hybrid exhibits enhanced growth or agronomic performance. However, previous theoretical studies on heterosis have been based on bi-parental segregating populations instead of F1 hybrids. To understand the genetic basis of heterosis, here we used a subset of F1 hybrids, named a partial North Carolina II design, to perform association mapping for dependent variables: original trait value, general combining ability (GCA), specific combining ability (SCA) and mid-parental heterosis (MPH). Our models jointly fitted all the additive, dominance and epistatic effects. The analyses resulted in several important findings: 1) Main components are additive and additive-by-additive effects for GCA and dominance-related effects for SCA and MPH, and additive-by-dominant effect for MPH was partly identified as additive effect; 2) the ranking of factors affecting heterosis was dominance > dominance-by-dominance > over-dominance > complete dominance; and 3) increasing the proportion of F1 hybrids in the population could significantly increase the power to detect dominance-related effects, and slightly reduce the power to detect additive and additive-by-additive effects. Analyses of cotton and rapeseed datasets showed that more additive-by-additive QTL were detected from GCA than from trait phenotype, and fewer QTL were from MPH than from other dependent variables.

Structural basis for selective inhibition of trypanosomatid glyceraldehyde-3-phosphate dehydrogenase: Molecular docking and 3D QSAR studies

The glycolytic enzyme glyceraldehyde-3 -phosphate dehydrogenase (GAPDH) is as an attractive target for the development of novel antitrypanosomatid agents. In the present work, comparative molecular field analysis and comparative molecular similarity index analysis were conducted on a large series of selective inhibitors of trypanosomatid GAPDH. Four statistically significant models were obtained (r(2) > 0.90 and q(2) > 0.70), indicating their predictive ability for untested compounds. The models were then used to predict the potency of an external test set, and the predicted values were in good agreement with the experimental results. Molecular modeling studies provided further insight into the structural basis for selective inhibition of trypanosomatid GAPDH.

Structural basis for selective inhibition of purine nucleoside phosphorylase from Schistosoma mansoni: Kinetic and structural studies

Selectivity plays a crucial role in the design of enzyme inhibitors as novel antiparasitic agents, particularly in cases where the target enzyme is also present in the human host. Purine nucleoside phosphorylase from Schistosoma mansoni (SmPNP) is an attractive target for the discovery of potential antischistosomal agents. In the present work, kinetic studies were carried out in order to determine the inhibitory potency, mode of action and enzyme selectivity of a series of inhibitors of SmPNP. In addition, crystallographic studies provided important structural insights for rational inhibitor design, revealing consistent structural differences in the binding mode of the inhibitors in the active sites of the SmPNP and human PNP (HsPNP) structures. The molecular information gathered in this work should be useful for future medicinal chemistry efforts in the design of new inhibitors of SmPNP having increased affinity and selectivity. (C) 2010 Elsevier Ltd. All rights reserved.

Camtasia Mania: Using Video in Exemplary Online Course Design

This basis of our presentation is to share a method of creating a fully online course experience for the student. The LMS (Learning Management System) in our presentation will be Blackboard. Our presentation will include the course design (following a weekly syllabus or course weekly module, the various content areas of the course and most importantly, the rich media included in the course. Our presentation will also include the creation process via CAMTASIA, video production software.

Improved Road Design for Future Maintenance - Analysis of Road Barrier Repair Costs

The cost of a road construction over its service life is a function of the design, quality of construction, maintenance strategies and maintenance operations. Unfortunately, designers often neglect a very important aspect which is the possibility to perform future maintenance activities. The focus is mainly on other aspects such as investment costs, traffic safety, aesthetic appearance, regional development and environmental effects. This licentiate thesis is a part of a Ph.D. project entitled “Road Design for lower maintenance costs” that aims to examine how the life-cycle costs can be optimized by selection of appropriate geometrical designs for the roads and their components. The result is expected to give a basis for a new method used in the road planning and design process using life-cycle cost analysis with particular emphasis on road maintenance. The project started with a review of literature with the intention to study conditions causing increased needs for road maintenance, the efforts made by the road authorities to satisfy those needs and the improvement potential by consideration of maintenance aspects during planning and design. An investigation was carried out to identify the problems which obstruct due consideration of maintenance aspects during the road planning and design process. This investigation focused mainly on the road planning and design process at the Swedish Road Administration. However, the road planning and design process in Denmark, Finland and Norway were also roughly evaluated to gain a broader knowledge about the research subject. The investigation was carried out in two phases: data collection and data analysis. Data was collected by semi-structured interviews with expert actors involved in planning, design and maintenance and by a review of design-related documents. Data analyses were carried out using a method called “Change Analysis”. This investigation revealed a complex combination of problems which result in inadequate consideration of maintenance aspects. Several urgent needs for changes to eliminate these problems were identified. Another study was carried out to develop a model for calculation of the repair costs for damages of different road barrier types and to analyse how factors such as road type, speed limits, barrier types, barrier placement, type of road section, alignment and seasonal effects affect the barrier damages and the associated repair costs. This study was carried out using a method called the “Case Study Research Method”. Data was collected from 1087 barrier repairs in two regional offices of the Swedish Road Administration, the Central Region and the Western Region. A table was established for both regions containing the repair cost per vehicle kilometre for different combinations of barrier types, road types and speed limits. This table can be used by the designers in the calculation of the life-cycle costs for different road barrier types.

Supervision as control system : the design of supervision as a regulatory instrument in the social services sector in Sweden

In this article, the prevailing official view of supervision as a regulatory instrument is examined as it applies to the social services sector in Sweden. The study is based on a comparison of the views expressed on the design of supervision as a regulatory instrument by two government commissions, the Supervision Commission and the Commission on Supervision within the Social Services (UTIS), and on the positions taken by the Government regarding the definitions of the concept of supervision proposed by these commissions. The view of supervision as a regulatory instrument expressed in these policy documents is analysed with the help of a theoretical framework describing the components, their functions and the governance characteristics of control systems. In the framework separate interrelated characteristics of the components are identified and summarized into two models of control systems. The analysis shows that supervision in the Swedish social services sector can be described in terms of both a disciplinary and non-disciplinary system. By its system theoretical basis and the identification of interrelated characteristics the study contributes to a broadened understanding of the construction and functions of supervision as a regulatory instrument and of how supervision within the Swedish social sector is meant to be designed.

What is important for you? A qualitative interview study of living with diabetes and experiences of diabetes care to establish a basis for a tailored Patient-Reported Outcome Measure for the Swedish National Diabetes Register

OBJECTIVES: There is a growing emphasis on the perspective of individuals living with diabetes and the need for a more person-centred diabetes care. At present, the Swedish National Diabetes Register (NDR) lacks patient-reported outcome measures (PROMs) based on the perspective of the patient. As a basis for a new PROM, the aim of this study was to describe important aspects in life for adult individuals with diabetes. DESIGN: Semistructured qualitative interviews analysed using content analysis. SETTING: Hospital-based outpatient clinics and primary healthcare clinics in Sweden. PARTICIPANTS: 29 adults with type 1 diabetes mellitus (DM) (n=15) and type 2 DM (n=14). INCLUSION CRITERIA: Swedish adults (≥18 years) living with type 1 DM or type 2 DM (duration ≥5 years) able to describe their situation in Swedish. Purposive sampling generated heterogeneous characteristics. RESULTS: To live a good life with diabetes is demanding for the individual, but experienced barriers can be eased by support from others in the personal sphere, and by professional support from diabetes care. Diabetes care was a crucial resource to nurture the individual's ability and knowledge to manage diabetes, and to facilitate life with diabetes by supplying support, guidance, medical treatment and technical devices tailored to individual needs. The analysis resulted in the overarching theme 'To live a good life with diabetes' constituting the two main categories 'How I feel and how things are going with my diabetes' and 'Support from diabetes care in managing diabetes' including five different categories. CONCLUSIONS: Common aspects were identified including the experience of living with diabetes and support from diabetes care. These will be used to establish a basis for a tailored PROM for the NDR.

Organizational design as an enabler for innovation: evidence from a German Mechanical Engineering Company

Over the past two decades there has been a profusion of empirical studies of organizational design and its relationship to efficiency, productivity and flexibility of an organization. In parallel, there has been a wide range of studies about innovation management in different kind of industries and firms. However, with some exceptions, the organizational and innovation management bodies of literature tend to examine the issues of organizational design and innovation management individually, mainly in the context of large firms operating at the technological frontier. There seems to be a scarcity of empirical studies that bring together organizational design and innovation and examine them empirically and over time in the context of small and medium sized enterprises. This dissertation seeks to provide a small contribution in that direction. This dissertation examines the dynamic relationship between organizational design and innovation. This relationship is examined on the basis of a single-case design in a medium sized mechanical engineering company in Germany. The covered time period ranges from 1958 until 2009, although the actual focus falls on the recent past. This dissertation draws on first-hand qualitative empirical evidence gathered through extensive field work. The main findings are: 1. There is always a bundle of organizational dimensions which impacts innovation. These main organizational design dimensions are: (1) Strategy & Leadership, (2) Resources & Capabilities, (3) Structure, (4) Culture, (5) Networks & Partnerships, (6) Processes and (7) Knowledge Management. However, the importance of the different organizational design dimensions changes over time. While for example for the production of simple, standardized parts, a simple organizational design was appropriate, the company needed to have a more advanced organizational design in order to be able to produce customized, complex parts with high quality. Hence the technological maturity of a company is related to its organizational maturity. 2. The introduction of innovations of the analyzed company were highly dependent on organizational conditions which enabled their introduction. The results of the long term case study show, that some innovations would not have been introduced successfully if the organizational elements like for example training and qualification, the build of network and partnerships or the acquisition of appropriate resources and capabilities, were not in place. Hence it can be concluded, that organizational design is an enabling factor for innovation. These findings contribute to advance our understanding of the complex relationship between organizational design and innovation. This highlights the growing importance of a comprehensive, innovation stimulating organizational design of companies. The results suggest to managers that innovation is not only dependent on a single organizational factor but on the appropriate, comprehensive design of the organization. Hence manager should consider to review regularly the design of their organizations in order to maintain a innovation stimulating environment.

Product functions: interfaces with ergonomic design

In addition to technical quality, increasing emphasis is being placed on the importance of elements such as the appearance and meaning of products. To be successful, therefore, attention must be paid to the aesthetic and symbolic functions of objects as well as to reliability and physical quality. Study of the interfaces of these functions may provide a theoretical basis for the ergonomic design of products. The objective of this review is to attempt to establish the nature of these interfaces.

Pearl millet utilization in ccommercial laying hen diets formulated on a total or digestible amino acid basis

An experiment was carried out to evaluate the effect of replacing corn with pearl millet in commercial layer diets, formulated according to the minimal requirements for total and digestible amino acids. Two hundred and forty Lohmann LSL laying hens with 25 weeks of age were distributed in a completely randomized experimental design according to a 2 x 5 factorial arrangement with 3 replicates of 8 birds. Feed was formulated on two amino acid basis (total or digestible) according to Rostagno et al. (2000) and there were five pearl millet inclusion levels (0%, 25%, 50%, 75%, and 100%). Performance and egg quality were evaluated during five periods of 21 days.At the end of each period, feed intake, egg production, egg weight and feed conversion were evaluated. In the last three days of each period, the following egg quality parameters were evaluated: Haugh Unit, yolk pigmentation index, egg specific weight, shell percentage and shell thickness. Digestible amino acid requirements resulted in decreased feed intake (p<0.01) and increased production costs per mass of eggs (kg) or per dozen eggs (p<0.01) compared to total amino acid requirements. There was a linear reduction in feed intake, egg production, egg weight and yolk pigmentation index with increasing inclusion levels of pearl millet. Therefore, increasing levels of replacement of corn by pearl millet affected bird performance negatively. Besides, production costs were higher with increasing pearl millet levels.

Sunflower meal in commercial layer diets formulated on total and digestible amino acids basis

An experiment was conduced to evaluate the inclusion of sunflower meal (SBM) in commercial layer diets formulated on total or digestible amino acids basis. One hundred forty-four 41-week-old Lohmann LSL layers were distributed in a completely randomized experimental design in a 2 x 4 factorial arrangement with three replications of six birds each. Treatments consisted of a combination of four SBM inclusion levels SBM(0%, 4%, 8%, and 12%) and feed formulation according two amino acid recommendations (total or digestible). The experimental period was divided into five periods of fourteen days. Performance parameters (egg production, feed intake, feed conversion, egg mass) were evaluated for each period. In the last two days of each period, three eggs per replication were collected to evaluate egg quality (Haugh units, specific gravity, egg weight, eggshell thickness, and eggshell percentage). Hens fed on total amino acid recommendation presented the highest values for egg weight. Diets formulated on digestible amino acids basis showed an improvement in eggshell percentage and egg specific gravity. SBM addition in commercial layer diets did not influence performance; however, increasing SBM dietary levels SBM improved eggshell quality.

A DOE based approach for the design of RBF artificial neural networks applied to prediction of surface roughness in AISI 52100 hardened Steel turning

Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)

Determining the structural basis for specificity of ligands using crystallographic screening

Crystallographic screening has been used to identify new inhibitors for potential target for drug development. Here, we describe the application of the crystallographic screening to assess the structural basis of specificity of ligands against a protein target. The method is efficient and results in detailed crystallographic information. The utility of the method is demonstrated in the study of the structural basis for specificity of ligands for human purine nucleoside phosphorylase (PNP). Purine nucleoside phosphorylase catalyzes the phosphorolysis of the N-ribosidic bonds of purine nucleosides and deoxynucleosides. This enzyme is a target for inhibitor development aiming at T-cell immune response modulation and has been submitted to extensive structure-based drug design. This methodology may help in the future development of a new generation of PNP inhibitors.