Transaction Support for DataWeb Applications - A Requirement\u27s Perspective

W eb-based purely providing read-only access to information in terms of static HTML pages. Rather, more and more web-based information systems store (part of) the information within a database system (DBS) and generate HTML pages on demand. Such information systems are often called DataWeb Applications. Different users interact with the system, and often they perform changes concurrently. As an example in the area of electronic commerce, consider a web-based tourism information system, where an unpredictable number of a priori unknown tourists are allowed to book various tourism facilities at the same time. Whereas financial and security issues of such electronic commerce transactions are extensively discussed in literature, very few work exists on the database transaction aspect in terms of consistency and reliability of electronic commerce transactions and of DataWeb applications in general. The objective of this paper is to discuss the specific requirements that different architectures of DataWeb applications and the web itself pose on transaction management, and to identify promising technologies for enabling web transaction services

Detecting anomalous longitudinal associations through higher order mining

The detection of unusual or anomalous data is an important function in automated data analysis or data mining. However, the diversity of anomaly detection algorithms shows that it is often difficult to determine which algorithms might detect anomalies given any random dataset. In this paper we provide a partial solution to this problem by elevating the search for anomalous data in transaction-oriented datasets to an inspection of the rules that can be produced by higher order longitudinal/spatio-temporal association rule mining. In this way we are able to apply algorithms that may provide a view of anomalies that is arguably closer to that sought by information analysts.Sydney, NS

A Review of integrity constraint maintenance and view updating techniques

Two interrelated problems may arise when updating a database. On one hand, when an update is applied to the database, integrity constraints may become violated. In such case, the integrity constraint maintenance approach tries to obtain additional updates to keep integrity constraints satisfied. On the other hand, when updates of derived or view facts are requested, a view updating mechanism must be applied to translate the update request into correct updates of the underlying base facts. This survey reviews the research performed on integrity constraint maintenance and view updating. It is proposed a general framework to classify and to compare methods that tackle integrity constraint maintenance and/or view updating. Then, we analyze some of these methods in more detail to identify their actual contribution and the main limitations they may present.Postprint (published version

Influence of aging on mechanical properties of the femoral neck using an inverse method.

Today, we are facing rapid aging of the world population, which increases the incidence of hip fractures. The gold standard of bone strength assessment in the laboratory is micro-computed finite element analysis (μFEA) based on micro-computed tomography (μCT) images. In clinics, the standard method to assess bone fracture risk is based on areal bone mineral density (aBMD), measured by dual-energy X-ray absorptiometry (DXA). In addition, homogenized finite element analysis (hFEA) constructed from quantitative computed tomography reconstructions (QCT) predicts clinical bone strength more accurately than DXA. Despite considerable evidence of degradation of bone material properties with age, in the past fifty years of finite element analysis to predict bone strength, bone material parameters remained independent of age. This study aims to assess the influence of age on apparent modulus, yield stress, and strength predictions of the human femoral neck made by laboratory-available bone volume fraction (BV/TV) and μFEA; and by clinically available DXA and hFEA. Using an inverse method, we test the hypothesis that FEA material parameters are independent of age. Eighty-six human femora were scanned with DXA (aBMD) and with QCT. The femoral necks were extracted and scanned at 16 μm resolution with μCT. The grayscale images were downscaled to 32 μm and 65 μm for linear and non-linear analyses, respectively, and segmented. The μFE solver ParOSolNL (non-linear) and a standard hFEA method were applied to the neck sections with the same material properties for all samples to compute apparent modulus, yield stress, and strength. Laboratory-available BV/TV was a good predictor of apparent modulus (R2 = 0.76), almost as good as μFEA (R2 = 0.79). However, yield stress and strength were better predicted by μFEA (R2 = 0.92, R2 = 0.86, resp.) than BV/TV (R2 = 0.76, R2 = 0.76, resp.). For clinically available variables, prediction of apparent modulus was better with hFEA than aBMD (R2 = 0.67, R2 = 0.58, resp.). hFEA outperformed aBMD for predictions of yield stress (R2 = 0.63 vs R2 = 0.34 for female and R2 = 0.55 for male) and strength (R2 = 0.48 vs R2 = 0.33 for female and R2 = 0.15 for male). The inclusion of age did not improve the multiple linear models for apparent modulus, yield stress, and strength. The resolution of the μFE meshes seems to account for most morphological changes induced by aging. The errors between the simulation and the experiment for apparent modulus, yield stress, and strength were age-independent, suggesting no rationale for correcting tissue material parameters in the current FE analysis of the aging femoral neck

Enterprise Resource Planning Systems Research: An Annotated Bibliography

Despite growing interest, publications on ERP systems within the academic Information Systems community, as reflected by contributions to journals and international conferences, is only now emerging. This article provides an annotated bibliography of the ERP publications published in the main Information Systems journals and conferences and reviews the state of the ERP art. The publications surveyed are categorized through a framework that is structured in phases that correspond to the different stages of an ERP system lifecycle within an organization. We also present topics for further research in each phase

Construction graphique d'entrepôts et de magasins de données

National audienceNowadays, decisional systems have became a significant research topic in databases. Data warehouses and data marts are the main elements of such systems. This paper presents our decisional support system. We present graphical interfaces which help the administrator to build data warehouses and data marts. We present a data warehouse building interface based on an object-oriented conceptual model. This model allows the warehouse data historisation at three levels: attribute, class and environment. Also, we present a data mart building interface which allows warehouse data to be reorganised through a multidimensional object-oriented model

WEDAGEN: A synthetic web database generator

To improve searching and processing of information on the web, a web warehousing system called WHOWEDA is being developed at the Centre for Advanced Information Systems (CAIS). This system incorporates a Web Information Coupling Model that describes the web objects and their relationships and a web algebra consisting of web operators to manipulate the web objects. In order to measure the performance of WHOWEDA and similar systems that manipulate web information, a synthetic web database generator called WEDAGEN (WEb DAtabase GENerator) has been developed. It has the capability of generating web databases of different sizes and complexities determined by a set of user specified parameters. This paper presents the issues in the design and implementation of WEDAGEN. It also gives a detailed description of its system components and the strategy to generate synthetic web databases. A preliminary assessment of the use of WEDAGEN has been reported. 1 Introduction 1.1 Background The Wold Wi..