Towards data warehouse from open data: Case of COVID-19

Author(s):  
Senda Bouaziz ◽  
Ahlem Nabli ◽  
Faiez Gargouri

Since December 2019, we have detected the appearance of a new virus called COVID-19, which has spread, throughout the world. Everyone today, has given major importance to this new virus. Although we have little knowledge of the disease, doctors and specialists make decisions every day that have a significant impact on public health. There are many and various open data in this context, which are scattered and distributed. For this, we need to capitalize all the information in a data warehouse. For that, in this paper, we propose an approach to create a data warehouse from open data specifically from COVID-19 data. We start with the identification of the relevant sources from the various open data. Then, we collect the pertinent data. After that, we identify the multidimensional concepts used to design the data warehouse schema related to COVID-19 data. Finally, we transform our data warehouse to logical model and create our NoSQL data warehouse with Talend Open Studio for Big Data (TOS_BD).

2017 ◽  
Vol 2 (Suppl. 1) ◽  
pp. 1-8
Author(s):  
Denis Horgan ◽  
Walter Ricciardi

In the world of modern health, despite the fact that we've been blessed with amazing advances of late - the advent of personalised medicine is just one example - “change” for most citizens seems slow. There are clear discrepancies in availability of the best care for all, the divisions in access from country to country, wealthy to poor, are large. There are even discrepancies between regions of the larger countries, where access often varies alarmingly. Too many Member States (with their competence for healthcare) appear to be clinging stubbornly to the concept of “one-size-fits-all” in healthcare and often stifle advances possible through personalised medicine. Meanwhile, the legislative arena encompassing health has grown big and unwieldy in many respects. And bigger is not always better. The health advances spoken of above, an increased knowledge on the part of patients, the emergence of Big Data and more, are quickly changing the face of healthcare in Europe. But healthcare thinking across the EU isn't changing fast enough. The new technologies will certainly speak for themselves, but only if allowed to do so. Acknowledging that, this article highlights a positive reform agenda, while explaining that new avenues need to be explored.


2021 ◽  
Vol 292 ◽  
pp. 02014
Author(s):  
Xingyu Yang ◽  
Tianyu Yan ◽  
Zelong Huang ◽  
Xiaofang Zhang ◽  
Yuchen Zhao ◽  
...  

The COVID-19 epidemic has swept the world, causing serious impact and influence on economic development and residents' life in countries all over the world. This paper takes China as an example, further analyses the characteristics of China's hierarchical medical model based on the international hierarchical medical research planning, and proposes the application of “big data analysis + hierarchical medical” model for the new coronavirus epidemic and other public health emergencies based on the advantages of big data application to solve public health crises, in order to provide a reference for the planning of hierarchical medical system during the epidemic. It is expected to provide reference for the planning of hierarchical medical and health system during the epidemic, which is an innovative attempt of the medical industry.


Author(s):  
Hamid Naceur Benkhaled ◽  
Djamel Berrabah ◽  
Faouzi Boufares

Before the arrival of the Big Data era, data warehouse (DW) systems were considered the best decision support systems (DSS). DW systems have always helped organizations around the world to analyse their stored data and use it in making decisive decisions. However, analyzing and mining data of poor quality can give the wrong conclusions. Several data quality (DQ) problems can appear during a data warehouse project like missing values, duplicates values, integrity constrains issues and more. As a result, organizations around the world are more aware of the importance of data quality and invest a lot of money in order to manage data quality in the DW systems. On the other hand, with the arrival of BD, new challenges have to be considered like the need for collecting the most recent data and the ability to make real-time decisions. This article provides a survey about the exiting techniques to control the quality of the stored data in the DW systems and the new solutions proposed in the literature to face the new Big Data requirements.


Author(s):  
Kunal Parikh ◽  
Tanvi Makadia ◽  
Harshil Patel

Dengue is unquestionably one of the biggest health concerns in India and for many other developing countries. Unfortunately, many people have lost their lives because of it. Every year, approximately 390 million dengue infections occur around the world among which 500,000 people are seriously infected and 25,000 people have died annually. Many factors could cause dengue such as temperature, humidity, precipitation, inadequate public health, and many others. In this paper, we are proposing a method to perform predictive analytics on dengue’s dataset using KNN: a machine-learning algorithm. This analysis would help in the prediction of future cases and we could save the lives of many.


2017 ◽  
Vol 25 (1) ◽  
pp. 47-65
Author(s):  
Tapiwa V. Warikandwa ◽  
Patrick C. Osode

The incorporation of a trade-labour (standards) linkage into the multilateral trade regime of the World Trade Organisation (WTO) has been persistently opposed by developing countries, including those in Africa, on the grounds that it has the potential to weaken their competitive advantage. For that reason, low levels of compliance with core labour standards have been viewed as acceptable by African countries. However, with the impact of WTO agreements growing increasingly broader and deeper for the weaker and vulnerable economies of developing countries, the jurisprudence developed by the WTO Panels and Appellate Body regarding a trade-environment/public health linkage has the potential to address the concerns of developing countries regarding the potential negative effects of a trade-labour linkage. This article argues that the pertinent WTO Panel and Appellate Body decisions could advance the prospects of establishing a linkage of global trade participation to labour standards without any harm befalling developing countries.


Author(s):  
Alyshia Gálvez

In the two decades since the North American Free Trade Agreement (NAFTA) went into effect, Mexico has seen an epidemic of diet-related illness. While globalization has been associated with an increase in chronic disease around the world, in Mexico, the speed and scope of the rise has been called a public health emergency. The shift in Mexican foodways is happening at a moment when the country’s ancestral cuisine is now more popular and appreciated around the world than ever. What does it mean for their health and well-being when many Mexicans eat fewer tortillas and more instant noodles, while global elites demand tacos made with handmade corn tortillas? This book examines the transformation of the Mexican food system since NAFTA and how it has made it harder for people to eat as they once did. The book contextualizes NAFTA within Mexico’s approach to economic development since the Revolution, noticing the role envisioned for rural and low-income people in the path to modernization. Examination of anti-poverty and public health policies in Mexico reveal how it has become easier for people to consume processed foods and beverages, even when to do so can be harmful to health. The book critiques Mexico’s strategy for addressing the public health crisis generated by rising rates of chronic disease for blaming the dietary habits of those whose lives have been upended by the economic and political shifts of NAFTA.


2020 ◽  
Vol 99 (6) ◽  
pp. 15-31
Author(s):  
A.A. Korenkova ◽  
◽  
E.M. Mayorova ◽  
V.V. Bahmetjev ◽  
M.V. Tretyak ◽  
...  

The new coronavirus infection has posed a major public health challenge around the world, but new data on the disease raises more questions than answers. The lack of optimal therapy is a significant problem. The article examines the molecular mechanisms of SARS-CoV-2 infection and the pathogenesis of COVID-19, special attention is paid to features of pathological processes and immune responses in children. COVID-19 leads to a wide diversity of negative outcomes, many of which can persist for at least months. Many of the consequences have yet to be identified. SARS-CoV-2 may provoke autoimmune reactions. Reinfection, herd immunity, vaccines and other prevention measures are also discussed in this review.


2020 ◽  
Vol 15 ◽  
pp. 4
Author(s):  
Sanju George ◽  
Jessy Fenn ◽  
Kripa Robonderdeep

Gambling is a popular pastime in India, as in most cultures across the world. Although research from India is limited, there is enough evidence to suggest that it should be of public health importance. In this brief paper, we look at the evolution of gambling in India and also discuss potential ways forward to address this issue.


2020 ◽  
Vol 10 (2) ◽  
pp. 1-4
Author(s):  
Evgeny Soloviov ◽  
Alexander Danilov

The Phygital word itself is the combination pf physical and digital technology application.This paper will highlight the detail of phygital world and its importance, also we will discuss why its matter in the world of technology along with advantages and disadvantages.It is the concept and technology is the bridge between physical and digital world which bring unique experience to the users by providing purpose of phygital world. It is the technology used in 21st century to bring smart data as opposed to big data and mix into the broader address of array of learning styles. It can bring new experience to every sector almost like, retail, medical, aviation, education etc. to maintain some reality in today’s world which is developing technology day to day. It is a general reboot which can keep economy moving and guarantee the wellbeing of future in terms of both online and offline.


Sign in / Sign up

Export Citation Format

Share Document