Explore the vast range of titles available.

PurposeDespite the increasing role of the data warehouse as a supportive decision-making tool in today's business world, academic research for measuring its effectiveness has been lacking. This paucity of academic interest stimulated us to evaluate data warehousing effectiveness in the organizational context of Jordanian banks.Design/methodology/approachThis paper develops a theoretical model specific to the data warehouse system domain that builds on the DeLone and McLean model. The model is empirically tested by means of structural equation modelling applying the partial least squares approach and using data collected in a survey questionnaire from 127 respondents at Jordanian banks.FindingsEmpirical data analysis supported that data quality, system quality, user satisfaction, individual benefits and organizational benefits have made strong contributions to data warehousing effectiveness in our organizational data context.Practical implicationsThe results provide a better understanding of the data warehouse effectiveness and its importance in enabling the Jordanian banks to be competitive.Originality/valueThis study is indeed one of the first empirical attempts to measure data warehouse system effectiveness and the first of its kind in an emerging country such as Jordan.

This paper proposed two models of data warehouse schema for the fire department of DKI Jakarta, where the 1st model contains six tables consisting of 3 fact and 3-dimensional tables, and the 2nd model only contains three fact tables. The 2nd model denormalises the 1st model, where the number of tables is less than the 1st model, where at the end of the day, the 2nd model will reduce the join table process, which increases the SQL performances. These two models have been recognised as fact constellation schema with more than one fact table and sharing dimension and sub-dimension tables. The database resources were collected from http://data.jakarta.go.id under the Fire and Rescue Service Agency. Those two data warehouse schema models were developed based on a report sector list, a report on Hydrants list, and vehicle register reports. This paper proposes to support Automatic Identification Systems (AIS) research, particularly implementing the data warehouse concept.

Abstract Background Electronic health records and many legacy systems contain rich longitudinal data that can be used for research; however, they typically are not readily available. Materials and methods At Kaiser Permanente Southern California (KPSC), a research data warehouse (RDW) has been developed and maintained since the late 1990s and widely extended in 2006, aggregating and standardizing data collected from internal and a few external sources. This article provides a high-level overview of the RDW and discusses challenges common to data warehouses or repositories for research use. To demonstrate the application of the data, we report the volume, patient characteristics, and age-adjusted prevalence of selected medical conditions and utilization rates of selected medical procedures. Results A total of 105 million person-years of health plan enrollment was recorded in the RDW between 1981 and 2018, with most healthcare utilization data available since early or middle 1990s. Among active enrollees on December 31, 2018, 15% were ≥65 years of age, 33.9% were non-Hispanic white, 43.3% Hispanic, 11.0% Asian, and 8.4% African American, and 34.4% of children (2–17 years old) and 72.1% of adults (≥18 years old) were overweight or obese. The age-adjusted prevalence of asthma, atrial fibrillation, diabetes mellitus, hypercholesteremia, and hypertension increased between 2001 and 2018. Hospitalization and Emergency Department (ED) visit rates appeared lower, and office visit rates seemed higher at KPSC compared to the reported US averages. Discussion and conclusion Although the RDW is unique to KPSC, its methodologies and experience may provide useful insights for researchers of other healthcare systems worldwide in the era of big data analysis. Lay Summary Administrative data collected by healthcare organizations at the time of enrollment and during patient care are not always readily available for research. The same data type (eg, hospital admission) may come from multiple data sources in various formats and with inconsistent values, and the change of source data systems over time may leave the data fragmented. In this paper, we described the contents, development, maintenance methodology, and other aspects of a research data warehouse within a large integrated healthcare system, Kaiser Permanente Southern California. We also demonstrated the application of the data in the RDW and the volume of data that can be used for various population-based research projects. With a volume of 105 million person-years of health plan enrollment in 1981–2018 (30 million for Hispanic and 10 million for African American and 7 million for Asian patients), about 19 million clinic/emergency room visits, and more than 200k hospital admissions per year, the research data warehouse offers the opportunity to conduct high-quality population-based research studies.

Nowadays, the growing importance of modelling in software engineering is without a doubt reinforced by the blossoming of model-driven architecture (MDA). In this trend, MDA could be considered the most convenient approach to integrate the modelling process in data warehousing projects. On the other hand, decision-makers are usually unable to express their business needs in a concise way that allows getting a valid data warehouse (DW), mainly due to the lack of standard methodologies and tools devoted to supporting this situation. This fact might expand the gap between the business world and the IT world and causes troublesome difficulties to interpret and model DW requirements. Moreover, applying MDA for this kind of project requires using new tools to avoid this drawback. In this paper, we provide an MDA framework to design DW requirements and generate afterwards the multidimensional schema. The framework is based on UML profiles and presents to decision-makers a graphical tool for modelling their strategic visions in order to build the system-to-be. Besides, the proposal allows for dealing with data historization and metadata in the generated multidimensional model to perform properly the extract transform load process.

Biomedical data warehouses (BDWs) have become an essential tool to facilitate the reuse of health data for both research and decisional applications. Beyond technical issues, the implementation of BDWs requires strong institutional data governance and operational knowledge of the European and national legal framework for the management of research data access and use. In this paper, we describe the compound process of implementation and the contents of a regional university hospital BDW. We present the actions and challenges regarding organizational changes, technical architecture, and shared governance that took place to develop the Nantes BDW. We describe the process to access clinical contents, give details about patient data protection, and use examples to illustrate merging clinical insights. More than 68 million textual documents and 543 million pieces of coded information concerning approximately 1.5 million patients admitted to CHUN between 2002 and 2022 can be queried and transformed to be made available to investigators. Since its creation in 2018, 269 projects have benefited from the Nantes BDW. Access to data is organized according to data use and regulatory requirements. Data use is entirely determined by the scientific question posed. It is the vector of legitimacy of data access for secondary use. Enabling access to a BDW is a game changer for research and all operational situations in need of data. Finally, data governance must prevail over technical issues in institution data strategy vis-à-vis care professionals and patients alike.

Assessment of quality and safety indicators (QSIs) remains often based on time-consuming manual Electronic Health Record (EHR) review. As part of a pilot study to examine the feasibility of automating the calculation of French national QSIs using a Clinical Data Warehouse (CDW), we focused on the measure of door-to-imaging time (DTI time) in stroke management, i.e., the time interval between arrival at the hospital and the first stroke diagnostic imaging, through a retrospective observational study of patients hospitalized in the Greater Paris University Hospitals (AP-HP) for an acute stroke in 2022. We automatically computed the DTI time for more than 6,000 medical records in the CDW using a systematic approach and validated this method by matching the results against the manual AP-HP EHR review from the 2022 French national QSI audit. In this Matched population, CDW and manual EHR review methods agreed on estimating overall indicators, but showed discrepancies in the case-by-case analysis, mainly because of human variability both in EHR completion and manual reviewing. Automation looks promising in a context of limited professional resources but requires structured and validated data, interoperability in the case of inter-institutional stays, and validly measurable QSI.

This paper proposes and experimentally assesses a rewrite/merge approach for supporting real-time data warehousing via lightweight data integration. Real-time data warehouses are becoming more and more relevant actually, due to emerging research challenges such as Big Data and Cloud Computing. Our contribution fulfills limitations of actual data warehousing architectures, which are no suitable to perform classical operations (e.g., loading, aggregation, indexing, OLAP query answering, and so forth) under real-time constraints. The proposed approach is based on intelligent manipulation of SQL statements of input queries, which are decomposed in suitable sub-queries (the rewrite phase) that are finally submitted as (final) input queries to an ad hoc component responsible for the cooperative query answering via a parallel query processing inspired method (the merge phase). This method induces in a novel data warehousing framework where the static phase is separated by the dynamic phase, in order to achieve the real-time processing features. We complete our analytical contributions by means of an extensive experimental campaign where we stress the performance of our proposed real-time data warehousing framework against a popular data warehouse benchmark, and in comparison with traditional architectures, which finally confirms the benefits deriving from our proposal.

This paper presents a comprehensive literature review on the evolution of data-lake technology, with a particular focus on data-lake architectures. By systematically examining the existing body of research, we identify and classify the major types of data-lake architectures that have been proposed and implemented over time. The review highlights key trends in the development of data-lake architectures, identifies the primary challenges faced in their implementation, and discusses future directions for research and practice in this rapidly evolving field. We have developed diagrammatic representations to highlight the evolution of various architectures. These diagrams use consistent notations across all architectures to further enhance the comparative analysis of the different architectural components. We also explore the differences between data warehouses and data lakes. Our findings provide valuable insights for researchers and practitioners seeking to understand the current state of data-lake technology and its potential future trajectory.

Nowadays, every company knows that when making a decision that has a potential in affecting their assets, an accurately processed report is necessary in order to support the reasoning behind their decision. Generating a report for stakeholders quickly and accurately is highly required in assisting them making a data-driven decision. By developing a data warehouse, it is possible for a company to do a data-driven decision making to appeal to their customer segments. This paper proposes a data warehouse model design to analyse the sales data contained in the database. The method that was implemented for this particular data warehouse development is the nine-step methodology designed by Kimball. The results are then presented in pdf form and an interactive dashboard.

Data Warehousing in the Age of the Big Data will help you and your organization make the most of unstructured data with your existing data warehouse.As Big Data continues to revolutionize how we use data, it doesn't have to create more confusion.