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.

The effects of dairy management and processing on quality characteristics of milk and dairy products

Studies within the QLIF project reviewed in this article suggest that organic or low-input management is more likely to result in milk with fatty acid profiles that are higher in α-linolenic acid and/or beneficial isomers of conjugated linoleic acid and antioxidants with up to a 2.5-fold increase in some cases, relative to milk from conventional production. These advantages are preserved during processing, resulting in elevated contents or concentrations of these constituents in processed dairy products of organic or low input origin. Much of the literature suggests that these benefits are very likely to be a result of a greater reliance on forages in the dairy diets (especially grazed grass). Since the adoption of alternative breeds or crosses is often an integral part sustaining these low-input systems, it is not possible to rule out an interaction with genotype in these monitored herds. The results suggest that milk fat composition with respect to human health can be optimized by exploiting grazing in the diet of dairy cows. However, in many European regions this may not be possible due to extremes in temperature, soil moisture levels or both. In such cases milk quality can be maintained by the inclusion of oil seeds in the dairy diets.

A survey on wireless body area networks for eHealthcare systems in residential environments

The progress in wearable and implanted health monitoring technologies has strong potential to alter the future of healthcare services by enabling ubiquitous monitoring of patients. A typical health monitoring system consists of a network of wearable or implanted sensors that constantly monitor physiological parameters. Collected data are relayed using existing wireless communication protocols to the base station for additional processing. This article provides researchers with information to compare the existing low-power communication technologies that can potentially support the rapid development and deployment of WBAN systems, and mainly focuses on remote monitoring of elderly or chronically ill patients in residential environments.