Skip to main page content
U.S. flag

An official website of the United States government

Dot gov

The .gov means it’s official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you’re on a federal government site.

Https

The site is secure.
The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.

Access keys NCBI Homepage MyNCBI Homepage Main Content Main Navigation
. 2013 Jun 1;55(3):728-739.
doi: 10.1016/j.dss.2013.02.008.

Methodological Guidelines for Reducing the Complexity of Data Warehouse Development for Transactional Blood Bank Systems

Pedro L Takecian  1 , Marcio K Oikawa, Kelly R Braghetto, Paulo Rocha, Fred Lucena, Katherine Kavounis, Karen S Schlumpf, Susan Acker, Anna B F Carneiro-Proietti, Ester C Sabino, Brian Custer, Michael P Busch, João E Ferreira
Affiliations

Methodological Guidelines for Reducing the Complexity of Data Warehouse Development for Transactional Blood Bank Systems

Pedro L Takecian et al. Decis Support Syst. .

Abstract

Over time, data warehouse (DW) systems have become more difficult to develop because of the growing heterogeneity of data sources. Despite advances in research and technology, DW projects are still too slow for pragmatic results to be generated. Here, we address the following question: how can the complexity of DW development for integration of heterogeneous transactional information systems be reduced? To answer this, we proposed methodological guidelines based on cycles of conceptual modeling and data analysis, to drive construction of a modular DW system. These guidelines were applied to the blood donation domain, successfully reducing the complexity of DW development.

Keywords: blood donation process; conceptual modeling; data analysis; data warehouse; heterogeneous systems; modular architecture.

PubMed Disclaimer

Figures

Figure 1
Figure 1
Data Warehouse Architecture for REDS-II.
Figure 2
Figure 2
Conceptual model of normalized database (Extended Entity-Relationship diagram).
Figure 3
Figure 3
Examples of integrity constraints for the donation process.
Figure 4
Figure 4
Data warehouse visualization of blood center versus HCV analysis
Figure 5
Figure 5
Another visualization for blood center values HCV analysis
Figure 6
Figure 6
Number of donations at Hemope blood center per month according to blood type (2010)
Figure 7
Figure 7
Number of donations at Hemope blood center per day according to blood type (Feb/2010)
See this image and copyright information in PMC

References

    1. [Accessed on 14-Feb-2013.];BIOLAP. 2012 http://biolap.sourceforge.net/)
    1. [Accessed on 14-Feb-2013.];CA ERwin Data Modeling. 2012 http://erwin.com/
    1. [Accessed on 14-Feb-2013.];Microsoft Excel. 2012 http://office.microsoft.com/en-us/excel/
    1. [Accessed on 14-Feb-2013.];Pentaho Mondrian Project. 2012 http://mondrian.pentaho.com/
    1. [Accessed on 14-Feb-2013.];SAP Sybase PowerDesigner. 2012 http://www.sybase.com/products/modelingdevelopment/powerdesigner/

LinkOut - more resources