Dataset Information

Healthcare Research and Analytics Data Infrastructure Solution: A Data Warehouse for Health Services Research.

ABSTRACT: BACKGROUND:Health services researchers spend a substantial amount of time performing integration, cleansing, interpretation, and aggregation of raw data from multiple public or private data sources. Often, each researcher (or someone in their team) duplicates this effort for their own project, facing the same challenges and experiencing the same pitfalls discovered by those before them. OBJECTIVE:This paper described a design process for creating a data warehouse that includes the most frequently used databases in health services research. METHODS:The design is based on a conceptual iterative process model framework that utilizes the sociotechnical systems theory approach and includes the capacity for subsequent updates of the existing data sources and the addition of new ones. We introduce the theory and the framework and then explain how they are used to inform the methodology of this study. RESULTS:The application of the iterative process model to the design research process of problem identification and solution design for the Healthcare Research and Analytics Data Infrastructure Solution (HRADIS) is described. Each phase of the iterative model produced end products to inform the implementation of HRADIS. The analysis phase produced the problem statement and requirements documents. The projection phase produced a list of tasks and goals for the ideal system. Finally, the synthesis phase provided the process for a plan to implement HRADIS. HRADIS structures and integrates data dictionaries provided by the data sources, allowing the creation of dimensions and measures for a multidimensional business intelligence system. We discuss how HRADIS is complemented with a set of data mining, analytics, and visualization tools to enable researchers to more efficiently apply multiple methods to a given research project. HRADIS also includes a built-in security and account management framework for data governance purposes to ensure customized authorization depending on user roles and parts of the data the roles are authorized to access. CONCLUSIONS:To address existing inefficiencies during the obtaining, extracting, preprocessing, cleansing, and filtering stages of data processing in health services research, we envision HRADIS as a full-service data warehouse integrating frequently used data sources, processes, and methods along with a variety of data analytics and visualization tools. This paper presents the application of the iterative process model to build such a solution. It also includes a discussion on several prominent issues, lessons learned, reflections and recommendations, and future considerations, as this model was applied.

SUBMITTER: Ozaydin B

PROVIDER: S-EPMC7303827 | biostudies-literature | 2020 Jun

REPOSITORIES: biostudies-literature

ACCESS DATA

Publications

Healthcare Research and Analytics Data Infrastructure Solution: A Data Warehouse for Health Services Research.

Ozaydin Bunyamin B Zengul Ferhat F Oner Nurettin N Feldman Sue S SS

Journal of medical Internet research 20200604 6

<h4>Background</h4>Health services researchers spend a substantial amount of time performing integration, cleansing, interpretation, and aggregation of raw data from multiple public or private data sources. Often, each researcher (or someone in their team) duplicates this effort for their own project, facing the same challenges and experiencing the same pitfalls discovered by those before them.<h4>Objective</h4>This paper described a design process for creating a data warehouse that includes the ...[more]

PMID: 32496199

Similar Datasets

Project description:BackgroundResearch addressing value in healthcare requires a measure of cost. While there are many sources and types of cost data, each has strengths and weaknesses. Many researchers appear to create study-specific cost datasets, but the explanations of their costing methodologies are not always clear, causing their results to be difficult to interpret. Our solution, described in this paper, was to use widely accepted costing methodologies to create a service-level, standardized healthcare cost data warehouse from an institutional perspective that includes all professional and hospital-billed services for our patients.MethodsThe warehouse is based on a National Institutes of Research-funded research infrastructure containing the linked health records and medical care administrative data of two healthcare providers and their affiliated hospitals. Since all patients are identified in the data warehouse, their costs can be linked to other systems and databases, such as electronic health records, tumor registries, and disease or treatment registries.ResultsWe describe the two institutions' administrative source data; the reference files, which include Medicare fee schedules and cost reports; the process of creating standardized costs; and the warehouse structure. The costing algorithm can create inflation-adjusted standardized costs at the service line level for defined study cohorts on request.ConclusionThe resulting standardized costs contained in the data warehouse can be used to create detailed, bottom-up analyses of professional and facility costs of procedures, medical conditions, and patient care cycles without revealing business-sensitive information. After its creation, a standardized cost data warehouse is relatively easy to maintain and can be expanded to include data from other providers. Individual investigators who may not have sufficient knowledge about administrative data do not have to try to create their own standardized costs on a project-by-project basis because our data warehouse generates standardized costs for defined cohorts upon request.

Project description:ContextWe describe a participatory framework that enhanced and implemented innovative changes to an existing distributed health data network (DHDN) infrastructure to support linkage across sectors and systems. Our processes and lessons learned provide a potential framework for other multidisciplinary infrastructure development projects that engage in a participatory decision-making process.ProgramThe Childhood Obesity Data Initiative (CODI) provides a potential framework for local and national stakeholders with public health, clinical, health services research, community intervention, and information technology expertise to collaboratively develop a DHDN infrastructure that enhances data capacity for patient-centered outcomes research and public health surveillance. CODI utilizes a participatory approach to guide decision making among clinical and community partners.ImplementationCODI's multidisciplinary group of public health and clinical scientists and information technology experts collectively defined key components of CODI's infrastructure and selected and enhanced existing tools and data models. We conducted a pilot implementation with 3 health care systems and 2 community partners in the greater Denver Metro Area during 2018-2020.EvaluationWe developed an evaluation plan based primarily on the Good Evaluation Practice in Health Informatics guideline. An independent third party implemented the evaluation plan for the CODI development phase by conducting interviews to identify lessons learned from the participatory decision-making processes.DiscussionWe demonstrate the feasibility of rapid innovation based upon an iterative and collaborative process and existing infrastructure. Collaborative engagement of stakeholders early and iteratively was critical to ensure a common understanding of the research and project objectives, current state of technological capacity, intended use, and the desired future state of CODI architecture. Integration of community partners' data with clinical data may require the use of a trusted third party's infrastructure. Lessons learned from our process may help others develop or improve similar DHDNs.

Project description:BackgroundThis study examines research knowledge infrastructures (RKIs) found in health systems. An RKI is defined as any instrument (i.e., programs, interventions, tools) implemented in order to facilitate access, dissemination, exchange, and/or use of evidence in healthcare organisations. Based on an environmental scan (17 key informant interviews) and scoping review (26 studies), we found support for a framework that we developed that outlines components that a health system can have in its RKI. The broad domains are climate for research use, research production, activities used to link research to action, and evaluation.The objective of the current study is to profile the RKI of three types of health system organisations--regional health authorities, primary care practices, and hospitals--in two Canadian provinces to determine the current mix of components these organisations have in their RKI, their experience with these components, and their views about future RKI initiatives.MethodsThis study will include semistructured telephone interviews with a purposive sample region of a senior management team member, library/resource centre manager, and a 'knowledge broker' in three regional health authorities, five or six purposively sampled hospitals, and five or six primary care practices in Ontario and Quebec, for a maximum of 71 interviewees. The interviews will explore (a) which RKI components have proven helpful, (b) barriers and facilitators in implementing RKI components, and (c) views about next steps in further development of RKIs.DiscussionThis is the first qualitative examination of potential RKI efforts that can increase the use of research evidence in health system decision making. We anticipate being able to identify broadly applicable insights about important next steps in building effective RKIs. Some of the identified RKI components may increase the use of research evidence by decision makers, which may then lead to more informed decisions.

Project description:BackgroundIntegrated data repositories (IDRs), also referred to as clinical data warehouses, are platforms used for the integration of several data sources through specialized analytical tools that facilitate data processing and analysis. IDRs offer several opportunities for clinical data reuse, and the number of institutions implementing an IDR has grown steadily in the past decade.ObjectiveThe architectural choices of major IDRs are highly diverse and determining their differences can be overwhelming. This review aims to explore the underlying models and common features of IDRs, provide a high-level overview for those entering the field, and propose a set of guiding principles for small- to medium-sized health institutions embarking on IDR implementation.MethodsWe reviewed manuscripts published in peer-reviewed scientific literature between 2008 and 2020, and selected those that specifically describe IDR architectures. Of 255 shortlisted articles, we found 34 articles describing 29 different architectures. The different IDRs were analyzed for common features and classified according to their data processing and integration solution choices.ResultsDespite common trends in the selection of standard terminologies and data models, the IDRs examined showed heterogeneity in the underlying architecture design. We identified 4 common architecture models that use different approaches for data processing and integration. These different approaches were driven by a variety of features such as data sources, whether the IDR was for a single institution or a collaborative project, the intended primary data user, and purpose (research-only or including clinical or operational decision making).ConclusionsIDR implementations are diverse and complex undertakings, which benefit from being preceded by an evaluation of requirements and definition of scope in the early planning stage. Factors such as data source diversity and intended users of the IDR influence data flow and synchronization, both of which are crucial factors in IDR architecture planning.

Dataset Information

Healthcare Research and Analytics Data Infrastructure Solution: A Data Warehouse for Health Services Research.

Publications

Healthcare Research and Analytics Data Infrastructure Solution: A Data Warehouse for Health Services Research.

Similar Datasets

OmicsDI is part of the ELIXIR infrastructure

Tweets