Methodological guidelines for reducing the complexity of data warehouse development for transactional blood bank systems

Takecian, Pedro Losco; Oikawa, Márcio K.; Braghetto, Kelly Rosa; Rocha, Paulo César da Silva; Lucena, Fred; Kavounis, Katherine; Schlumpf, Karen S.; Acker, Susan; Carneiro-Proietti, Anna Bárbara F.; Sabino, Éster Cerdeira; Custer, Brian; Busch, Michael P.; Ferreira, João Eduardo

doi:10.1016/j.dss.2013.02.008

Cited by 13 publications

(11 citation statements)

References 17 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…All blood donations in 2007 through 2010 of the data warehouse established for the Retrovirus Epidemiological Donor Study II in three Brazilian blood centers were studied: Fundação Pró-Sangue (FPS) in São Paulo State (southeastern region), Fundação Centro de Hematologia e Hemoterapia de Minas Gerais (Hemominas), in Minas Gerais State (southeastern region) and Fundação de Hematologia e Hemoterapia de Pernambuco (HEMOPE) in Pernambuco State (northeastern region) (9,10) .…”

Section: Methodsmentioning

confidence: 99%

Temporal distribution of blood donations in three Brazilian blood centers and its repercussion on the blood supply

Oliveira¹,

Almeida‐Neto²,

Liu³

et al. 2013

Revista Brasileira De Hematologia E Hemoterapia

Self Cite

View full text Add to dashboard Cite

BackgroundSeasonal distribution of blood donation hinders efforts to provide a safe and adequate blood supply leading to chronic and persistent shortages. This study examined whether holidays, geographical area and donation type (community versus replacement) has any impact on the fluctuation of donations. MethodsThe numbers of blood donations from 2007 through 2010 in three Brazilian Retrovirus Epidemiological Donor Study II (REDS-II) participating centers were analyzed according to the week of donation. The weeks were classified as holiday or non-holiday. To compare donations performed during holiday versus non-holiday weeks, tabulations and descriptive statistics for weekly donations by blood center were examined and time series analysis was conducted. ResultsThe average weekly number of donations varied according to the blood center and type of week. The average number of donations decreased significantly during Carnival and Christmas and increased during the Brazilian National Donor Week. The fluctuation was more pronounced in Recife and Belo Horizonte when compared to São Paulo and higher among community donors. ConclusionNational bank holidays affect the blood supply by reducing available blood donations. Blood banks should take into account these oscillations in order to plan local campaigns, aiming at maintaining the blood supply at acceptable levels.

show abstract

Section: Methodsmentioning

confidence: 99%

Temporal distribution of blood donations in three Brazilian blood centers and its repercussion on the blood supply

Oliveira¹,

Almeida‐Neto²,

Liu³

et al. 2013

Revista Brasileira De Hematologia E Hemoterapia

Self Cite

View full text Add to dashboard Cite

show abstract

“…For instance, an organization dealing with security systems may want analytical software that explores the security loopholes in their own organization and offers solutions to handle the concern. Software of such nature cannot be sold to any other party as it may compromise their internal security arrangements (Takecian, et al, 2013). They would thus have to meet the cost of software copyrights and non-disclosure on the part of the developers.…”

Section: Big Data Analyticsmentioning

confidence: 99%

Trends in Data Warehousing Technology

Abimbola¹

2021

International Journal of Data Science and Big Data Analytics

View full text Add to dashboard Cite

The research looks at the concepts associated with data warehousing. These include: cloud computing and big data analytics. By analyzing the growth of these technologies, it is possible to tell the trend in which data will take in the coming future. A lot of data is in use at the moment in very large packets and volumes. The technologies that are associated with data use are associated with data use are immense and greatly spread across all computing gadgets in use. Cell phones, microcomputers, and other computing gadgets all take advantage of data warehousing technology. The research presents a case for the proliferated use of big data technologies across the world. Data use, and data users are separated using the concept of 'abstraction.' As users continue to use big data analytics and warehousing more often, they are less aware of the dangers and concerns in the use and reliance of virtual computing facilities. The study seeks to establish the influence of current technologies on data warehousing and how they lead to the growth of data storage units across the globe. The survey on data warehousing trends is focused on software technologies that highly rely on the data warehousing facilities. Social media is acknowledged as one of the leading factors behind the growth of data warehousing facilities. This research seeks to establish the use of data in social media and other applications. The concept of data analytics is stressed as a key issue in data warehousing. Being that the data in warehouses is highly sophisticated and voluminous; the need for specialized software to undertake sorting and searching purposes is reviewed. The study seeks to establish that the use of big data is an important concept as well. This concept is evaluated and well explained. The concerns with data warehousing are also evaluated in an effort to realize more need to secure data. The research concludes with an appeal for user awareness on data warehouse capabilities. Users are expected to be more aware of the purpose and capability of data and in essence, use these facilities from a professional point of view; not as novices.

show abstract

“…However, these systems are heterogeneous, so obtaining nationwide data is not an easy task. In the Brazilian project, the variables from the US REDS program were adapted to the Brazilian context and a data warehouse was developed by the Institute of Mathematic and Statistics (USP) to receive and validate the data 2 . During REDS-II, data were transferred to a central data-coordinating center.…”

Section: Database Analysesmentioning

confidence: 99%

“…In the Brazilian project, the variables from the US REDS program were adapted to the Brazilian context and a data warehouse was developed by the Institute of Mathematic and Statistics (USP) to receive and validate the data. 2 During REDS-II, data were transferred to a central data-coordinating center. A web application was developed to streamline the process, including a system for data management and quality control checking for consistency.…”

Section: Database Analysesmentioning

confidence: 99%

“…REDS-III includes large research collaborative efforts conducted in the US, Brazil, China and South Africa. The REDS programs have all been structured 1 to establish donor and donation databases that serve as the basis for conducting detailed analyses of blood safety and availability in each country, and to conduct specific protocols that directly address key research questions in blood safety and transfusion medicine in each country 2 …”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Contribution of the Retrovirus Epidemiology Donor Study (REDS) to research on blood transfusion safety in Brazil

Loureiro

Almeida‐Neto

Proietti

et al. 2014

Revista Brasileira de Hematologia e Hemoterapia

Self Cite

View full text Add to dashboard Cite

The Retrovirus Epidemiology Donor Study (REDS) program was established in the United States in 1989 with the purpose of increasing blood transfusion safety in the context of the HIV/AIDS and human T-lymphotropic virus epidemics. REDS and its successor, REDS-II were at first conducted in the US, then expanded in 2006 to include international partnerships with Brazil and China. In 2011, a third wave of REDS renamed the Recipient Epidemiology and Donor Evaluation Study-III (REDS-III) was launched. This seven-year research program focuses on both blood banking and transfusion medicine research in the United States of America, Brazil, China, and South Africa. The main goal of the international programs is to reduce and prevent the transmission of HIV/AIDS and other known and emerging infectious agents through transfusion, and to address research questions aimed at understanding global issues related to the availability of safe blood. This article describes the contribution of REDS-II to transfusion safety in Brazil. Articles published from 2010 to 2013 are summarized, including database analyses to characterize blood donors, deferral rates, and prevalence, incidence and residual risk of the main blood-borne infections. Specific studies were developed to understand donor motivation, the impact of the deferral questions, risk factors and molecular surveillance among HIV-positive donors, and the natural history of Chagas disease. The purpose of this review is to disseminate the acquired knowledge and briefly summarize the findings of the REDS-II studies conducted in Brazil as well as to introduce the scope of the REDS-III program that is now in progress and will continue through 2018.© 2014 Associação Brasileira de Hematologia, Hemoterapia e Terapia Celular. All rights reserved.

show abstract

Methodological guidelines for reducing the complexity of data warehouse development for transactional blood bank systems

Cited by 13 publications

References 17 publications

Temporal distribution of blood donations in three Brazilian blood centers and its repercussion on the blood supply

Temporal distribution of blood donations in three Brazilian blood centers and its repercussion on the blood supply

Trends in Data Warehousing Technology

Contribution of the Retrovirus Epidemiology Donor Study (REDS) to research on blood transfusion safety in Brazil

Contact Info

Product

Resources

About