An evaluation of the challenges of Multilingualism in Data Warehouse development

In this paper we discuss Business Intelligence and define what is meant by support for Multilingualism in a Business Intelligence reporting context. We identify support for Multilingualism as a challenging issue which has implications for data warehouse design and reporting performance. Data warehouses are a core component of most Business Intelligence systems and the star schema is the approach most widely used to develop data warehouses and dimensional Data Marts. We discuss the way in which Multilingualism can be supported in the Star Schema and identify that current approaches have serious limitations which include data redundancy and data manipulation, performance and maintenance issues. We propose a new approach to enable the optimal application of multilingualism in Business Intelligence. The proposed approach was found to produce satisfactory results when used in a proof-of-concept environment. Future work will include testing the approach in an enterprise environmen

Clustering of patient’s trajectories with an auto-stopped bisecting K-Medoids algorithm

Nowadays, long wait, cancellations and resource overload frequently occur in healthcare, especially in those sectors related to the patients passing through the operating theatre in both United States and the European Union. Since more and more hospitals seek to develop the overall patient pathways instead of the effectiveness of “isolated” departments, the most important work has been defining suitable patient groups for employing process management and simulation tools developed in the recent decades. In this study, we proposed a data mining method, an auto-stopped Bisecting K-Medoids clustering algorithm, to classify patients into groups with homogenous trajectories. This method classifies the patient trajectories with two stages. At the first stage, patients are classified by the complexity of outpatient visits; afterwards, the groups obtained at the first stage are further classified by the original information of the trajectories where all medical appointments including outpatient ones are taken into account. By using a real data set collected from a medium-size Belgian hospital, we demonstrate how the proposed approach works and examine which kinds of trajectories are grouped into the same clusters. According to the experimental results, the proposed method can be used to classify patients into manageable groups with homogenous trajectories, which can be used as a base for the process modelling techniques and simulation tools