Determination Of Factors Affecting ETL Performance In Data Warehouse Projects

Bilgi, özel bir amaca ulaşmak için verinin çeşitli analiz, dönüşüm ve gruplama işlemlerinden geçirilerek, daha sonra kullanılmak üzere yöneticiler için hazır ve faydalı bir hale getirilmiş şeklidir. Veri ambarı, farklı kaynaklarda tanımlanmış verilerin, belirli aralıklarla aktarılarak standart bir format ile tek bir ortamda tutulduğu ortamdır. Veri ambarının güncel olması oldukça önemlidir. Veri ambarının güncelliği ise ETL süreci ile sağlanmaktadır. ETL; Çıkar(Extract), Dönüştür(Transform) ve Yükle(Load) kelimelerinin baş harflerinden oluşmaktadır. Kullanılacak verinin dış kaynaklardan çıkarılması, verinin iş süreçlerine göre birleştirilmesi, dönüştürülmesi ve veri ambarına yüklenmesi sürecidir. Bu sürecin başlangıç faaliyetlerinden biri en uygun ETL yazılımının seçimidir. Bu çalışmada Veriambarı oluşturulmasında ETL yazılım aracı seçimini etkileyen ISO 25010 standardında yer alan faktörlerin ağırlıklandırılması ve yazılım araçları arasında AHP yöntemi ile karar verilmesi amaçlanmaktadır.Information is a form of data that has been subjected to various analysis, transformation and grouping processes to make it available and useful for managers to be used for later purposes. A data warehouse is an environment in which data defined in different sources is transferred in a regular format and kept in a single environment in a standard format. It is very important that the data warehouse is up to date. The actuality of the data warehouse is provided by the ETL process. ETL consists of the initials of the words Extract, Transform and Load. It is the process of extracting the data to be used from external sources, combining the data according to business processes, converting it and loading it into the data warehouse. One of the initial activities of this process is the selection of the most appropriate ETL software. In this study, it is aimed to weight the factors in ISO 25010 standard which affect the choice of ETL software tool in the creation of data warehouse and to make a decision among the software tools by AHP method

Veri Ambarı Projelerinde ETL Performansını Etkileyen Faktörlerin Belirlenmesi

Bilgi, özel bir amaca ulaşmak için verinin çeşitli analiz, dönüşüm ve gruplama işlemlerinden geçirilerek, daha sonra kullanılmak üzere yöneticiler için hazır ve faydalı bir hale getirilmiş şeklidir. Veri ambarı, farklı kaynaklarda tanımlanmış verilerin, belirli aralıklarla aktarılarak standart bir format ile tek bir ortamda tutulduğu ortamdır. Veri ambarının güncel olması oldukça önemlidir. Veri ambarının güncelliği ise ETL süreci ile sağlanmaktadır. ETL;  Çıkar(Extract), Dönüştür(Transform) ve Yükle(Load) kelimelerinin baş harflerinden oluşmaktadır. Kullanılacak verinin dış kaynaklardan çıkarılması, verinin iş süreçlerine göre birleştirilmesi, dönüştürülmesi ve veri ambarına yüklenmesi sürecidir. Bu sürecin başlangıç faaliyetlerinden biri en uygun ETL yazılımının seçimidir. Bu çalışmada Veriambarı oluşturulmasında ETL yazılım aracı seçimini etkileyen ISO 25010 standardında yer alan faktörlerin ağırlıklandırılması ve yazılım araçları arasında AHP yöntemi ile karar verilmesi amaçlanmaktadır

The role of the receptor activator of nuclear factor Kappa-B ligand/osteoprotegerin ratio in vascular diseases: a therapeutic approach

Cardiovascular and bone diseases contribute independently to mortality and global health. The exact mechanisms involved in the pathophysiology shared between bone and vascular diseases are not well defined. Endothelial cells and osteoblasts communicate during osteogenesis, thus establishing a connection between angiogenesis and osteogenesis. One shared mechanism may involve osteoprotegerin (OPG) and its ligand Receptor Activator of NF-κB Ligand (RANKL). The RANKL/OPG ratio is an important modulator for the skeletal, immunological, and vascular systems. OPG levels are elevated due to either osteogenic causes or inflammatory responses in the vasculature. The data obtained from clinical and in vitro studies support the role of the RANKL/OPG ratio as a potential marker for the progression of endothelial damage. Therefore, determining the therapeutic approaches for the targeting RANKL/OPG ratio and evaluating its usage as a biomarker in cardiovascular and bone pathophysiology are needed. By integrating the protective and disease-causing role of OPG with its ligand, this review outlines the role of the RANKL/OPG ratio at the molecular level. We also consider targeted therapeutic approaches

Education of healthcare personnel working with pediatric patients during covid-19 pandemic within the framework of infection control Covid-19 pandemisinde enfeksiyon kontrol çalışmaları çerçevesinde çocuk hastalarla çalışan sağlık personeli eğitimi

© 2020, AVES. All rights reserved.Objective: In the early stages of any epidemic caused by new emerging pathogens healthcare personnel is subject to a great risk. Pandemic caused by SARS-CoV-2, proved to be no exception. Many healthcare workers died in the early stages of pandemic due to inadequate precautions and insufficient protection. It is essential to protect and maintain the safety of healthcare personnel for the confinement of pandemic as well as continuity of qualified healthcare services which is already under strain. Educating healthcare personnel on appropiate use of personal protective equipment (PPE) is as essential as procuring them. Material and Methods: A survey is conducted on 4927 healthcare personnel working solely with pediatric patients from 32 different centers. Education given on PPE usage were questioned and analyzed depending on age, sex, occupation and region. Results: Among four thousand nine hundred twelve healthcare personnel from 32 different centers 91% (n= 4457) received education on PPE usage. Of those who received education only 36% was given both theoretical and applied education. Although there was no differences among different occupation groups, receiving education depended on regions. Conclusion: It is essential to educate healthcare personnel appropiately nationwidely for the continuity of qualified healthcare services during the pandemic

Evaluation of vaccination status of health care workers for recommended vaccines and their acceptance of SARS-CoV-2 vaccines

© 2022 The Author(s). Published with license by Taylor & Francis Group, LLC.Introduction: Health care workers (HCWs) are disproportionately exposed to infectious diseases and play a role in nosocomial transmission, making them a key demographic for vaccination. HCW vaccination rates are not optimal in many countries; hence, compulsory vaccination policies have been implemented in some countries. Although these policies are effective and necessary under certain conditions, resolving HCWs’ hesitancies and misconceptions about vaccines is crucial. HCWs have the advantage of direct contact with patients; hence, they can respond to safety concerns, explain the benefits of vaccination, and counter antivaccine campaigns that escalate during pandemics, as has been observed with COVID-19. Method: A short survey was carried out in May–June 2020 on the vaccination status of HCWs working with pediatric patients with COVID-19. The survey inquired about their vaccination status (mumps/measles/rubella [MMR], varicella, influenza, and diphtheria/tetanus [dT]) and willingness to receive hypothetical future COVID-19 vaccines. The respondents were grouped according to gender, age, occupation, and region. Results: In total, 4927 HCWs responded to the survey. Most were young, healthy adults. The overall vaccination rates were 57.8% for dT in the past 10 years, 44.5% for MMR, 33.2% for varicella, and 13.5% for influenza. Vaccination rates were the highest among physicians. The majority of HCWs (81%) stated that they would be willing to receive COVID-19 vaccines. Conclusion: Although vaccination rates for well-established vaccines were low, a majority of HCWs were willing to receive COVID-19 vaccines when available. Education and administrative trust should be enhanced to increase vaccination rates among HCWs

SARS-CoV-2 seropositivity among pediatric health care personnel just after the first peak of pandemic: A nationwide surveillance.

BACKGROUND: COVID-19 pandemic affected every single person on earth one way or the other. The healthcare personnel were no exception, their responsibilities as well as their risks being immense. METHODS: 4927 healthcare personnel all working in pediatric units at 32 hospitals from seven different regions of Turkey enrolled to the study to determine the seroprevalence of SARS Co-V-2 after the first peak wave. Point of care serologic lateral flow rapid test kit for IgM/IgG was used (Ecotest CE Assure Tech. Co. Ltd.). Seroprevalence and its association with demographic characteristics and possible risk factors were analyzed. RESULTS: Nearly 6.1% of healthcare personnel were found to be seropositive for SARS Co-V- 2. Seropositivity was more common among those who did not universally wear protective masks (10.6% vs 6.1%). Having a COVID-19 co-worker increased the likelihood of infection. The least and the most experienced personnel affected more. Most of the seropositive healthcare personnel (68%) did not have any suspicion that they had COVID-19 previously. CONCLUSIONS: Health surveillance for healthcare personnel involving routine point-of-care nucleic acid testing as well as monitoring PPE adherence would be important strategies to protect healthcare personnel from COVID-19 and to reduce nosocomial SARS-CoV-2 transmission