| Peer-Reviewed

Google Cloud Services for Collecting, Processing, Analyzing, and Visualizing the Types of COVID-19 Vaccines

Received: 16 June 2022     Accepted: 11 July 2022     Published: 28 July 2022
Views:       Downloads:
Abstract

This study analyzes the types of COVID-19 vaccines used in different countries in Google Cloud native services. Big Query, a Google Cloud data analytics product, is used for data analytics. The python application is developed for data visualization of types of COVID-19 vaccines, and the application deployed in Google Cloud handles the data collection methodology. Google Cloud composer establishes the connection to the World Health Organization portal. Apache Airflow directed acyclic graph (DAG) runs in a Cloud Composer environment and Google Data Studio for data visualization. Google Guild members fully support the Google cloud Nature Labs projects. The motivation behind this project is our recent work on creating the ecosystem in Google Cloud for customers. The discovery, identification of Google service, the workload migration is designed for Google Cloud. The python application parses the types of vaccines of COVID-19 data in JSON format. The big query, a serverless data analytics of Google cloud, performs the classes of vaccines used in different countries. The python application parses the JSON file format and generates the report of the types the COVID-19 vaccines. Python application performs the data visualization in Google cloud, and Google data studio completes the functional requirement of reporting layer. The approach to studying the types of vaccines used in different countries is unique. As always, the data clenching task is a tedious task. Thanks to the research sponsor, SerpAPI provides the Google search results of variance of COVID-19 vaccines and chemical composition of vaccines of companies. The developed solution and the work products are highly reusable, and customers benefit from the outcome of this research assignment in the Google cloud innovation project of Nature Labs. The Google cloud native offers the dynamics for the scientific community on the study of types of vaccines for vaccine manufacturing companies. We conclude that out of thirty vaccine manufacturing companies, the World Health Organization (WHO) disapproves of Wuhan CNBG.

Published in International Journal of Data Science and Analysis (Volume 8, Issue 4)
DOI 10.11648/j.ijdsa.20220804.11
Page(s) 94-118
Creative Commons

This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.

Copyright

Copyright © The Author(s), 2022. Published by Science Publishing Group

Keywords

COVID-19 Vaccine Types, Python Data Analytics, Google Compute Engine, Google SerpAPI, Google Cloud SQL, COVID-19 Vaccines Dataset, Analytics COVID-19 Vaccines, Google Cloud Big Query

References
[1] V. Ramamurthy et al., The Life-Saving Mission for COVID-19 Vaccination on Google Cloud (GC) Ecosystem, International Journal of Science and Research (IJSR), ISSN: 2319-7064, SJIF (2022): 7.94, pages 1365-1365.
[2] Han X, Xu P, Ye Q. Analysis of COVID-19 vaccines: Types, thoughts, and application. J Clin Lab Anal. 2021 Sep; 35 (9): e23937. DOI: 10.1002/jcla.23937. Epub 2021 Aug 15. PMID: 34396586; PMCID: PMC8418485.
[3] He Q, Mao Q, Zhang J, Bian L, Gao F, Wang J, Xu M, Liang Z. COVID-19 Vaccines: Current Understanding on Immunogenicity, Safety, and Further Considerations. Front Immunol. 2021 Apr 12; 12: 669339. DOI: 10.3389/fimmu.2021.669339. PMID: 33912196; PMCID: PMC8071852.
[4] Centers for Disease Control and Prevention. (2020). CDC Methods for the Establishment and Management of Public Health Rapid Response Teams for Disease Outbreaks. Atlanta: Centers for Disease Control and Prevention. https://www.cdc.gov/globalhealth/healthprotection/errb/pdf/RRTManagementGuidance-508.pdfpdf icon
[5] Wibawa T. COVID-19 vaccine research and development: ethical issues. Trop Med Int Health. 2021 Jan; 26 (1): 14-19. DOI: 10.1111/tmi.13503. Epub 2020 Oct 19. PMID: 33012020; PMCID: PMC7675299.
[6] Hellewell, J., Abbott, S., Gimma, A., Bosse, N., Jarvis, C., & Russell, T. et al. (2020). Feasibility of controlling COVID-19 outbreaks by isolation of cases and contacts. The Lancet, 8 (4), 488-496. https://doi.org/10.1016/S2214-109X(20)30074-7external icon
[7] Amanat F, Krammer F. SARS-CoV-2 Vaccines: Status Report. Immunity. 2020 Apr 14; 52 (4): 583-589. doi: 10.1016/j.immuni.2020.03.007. Epub 2020 Apr 6. PMID: 32259480; PMCID: PMC7136867.
[8] World Health Organization. (2020). COVID-19 Strategy Update. Geneva: WHO. Retrieved 11 May 2020, from https://www.who.int/publications-detail/COVID-19-strategy-update—14-April-2020external icon
[9] World Health Organization. (2020). COVID-19: Operational Planning Guidelines and COVID-19 Partners Platform to support country preparedness and response. Retrieved 28 April 2020, from https://openwho.org/courses/UNCT-COVID-19-preparedness-and-response-ENexternal icon.
[10] Centers for Disease Control and Prevention. (2020). COVID-19 72-hour Response Plan Checklist. Atlanta: CDC. https://www.cdc.gov/coronavirus/2019-ncov/global-COVID-19/index.html
[11] Chuang, Isaac and Ho, Andrew, HarvardX and MITx: Four Years of Open Online Courses -- Fall 2012-Summer 2016 (December 23, 2016). Available at SSRN: https://ssrn.com/abstract=2889436 or http://dx.doi.org/10.2139/ssrn.2889436
[12] Lopez, G., Seaton, D. T., Ang, A. M., Tingley, D., & Chuang, I. L. (2017). Google BigQuery for Education: Framework for Parsing and Analyzing edX MOOC Data. Proceedings of the Fourth (2017) ACM Conference on Learning @ Scale. Davidson College. 2015. A Liberal Arts Take on Tech. https://www.davidson.edu/news/news-stories/
[13] Costello, E., Corcoran, M., Barnett, J. S., Birkmeier, M., Cohn, R., Ekmekci, O. ... Walker, B. (2014). Information and communication technology to facilitate learning for students in the health professions: Current uses, gaps, and future directions. Online Learning: Official Journal of the Online Learning Consortium, 18 (4). Retrieved from http://olj.onlinelearningconsortium.org/index.php/jaln/article/view/512/118 edX Documentation. 2016. Research Guide. (2016). http://edx.readthedocs.io/projects/devdata/en/latest/.
[14] Harvard Vice Provost for Advances in Learning Research. 2016. Harvard VPAL Private Datasets Documentation. (2016). http://dx.doi.org/10.7910/DVN/RTVIEM.
[15] Harvard Gazette. 2016. MOOCS Ahead. (2016). http://news.harvard.edu/gazette/story/2016/07/moocs-ahead/.Google. 2016. Google App Engine. (25 October 2016). https://cloud.google.com/appengine/docs.
[16] Harvard and MIT. 2016a. edx2bigquery. (25 October 2016). https://github.com/mitodl/edx2bigquery.
[17] Harvard and MIT. 2016b. analytics. (25 October 2016). https://github.com/mitodl/xanalytics.
[18] Andrew Dean Ho, Isaac Chuang, Justin Reich, Cody Austin Coleman, Jacob Whitehill, Curtis G, Northcutt, Joseph Jay Williams, John D Hansen, Glenn Lopez, and Rebecca Petersen. 2015. Harvard and MITx: Two years of Open Online Courses, Fall 2012 - Summer 2014. Available at SSRN 2586847 (2015).
[19] Andrew Dean Ho, Justin Reich, Sergiy O Nesterko, Daniel Thomas Seaton, Tommy Mullaney, Jim Waldo, and Isaac Chuang. 2014. HarvardX and MITx: The First Year of Open Online Courses, Fall 2012 - Summer 2013. Available at SSRN 2381263 (2014).
[20] Maxmind. 2016. GeoIP2 City Database. (2016). https://www.maxmind.com/en/geoip2-city.
[21] Kalyan Veeramachaneni, Franck Dernoncourt, Colin Taylor, Zachary Pardos, and Una-May O’Reilly. 2013.
[22] Moocdb: Developing data standards for MOOC data science. In AIED 2013 Workshops Proceedings Volume. Citeseer, 17.
[23] Elise Young. 2015. Educational privacy in the online classroom: FERPA, MOOCs, and the big data problem. Harv. J. Law & Tec 28 (2015), 549–593. John Zornig. 2016. MOOCczar. (25 October 2016). https://github.com/UQ-UQx/MOOCczar
[24] Wan Y, Shang J, Graham R, Baric RS, Li F. Receptor Recognition by the Novel Coronavirus from Wuhan: an Analysis Based on Decade-Long Structural Studies of SARS Coronavirus. J Virol. 2020 Mar 17; 94 (7): e00127-20. DOI: 10.1128/JVI.00127-20. PMID: 31996437; PMCID: PMC7081895.
[25] World Health Organization. (2020). Coronavirus disease (COVID-19) outbreak: health workers' rights, roles, and responsibilities, including key considerations for occupational safety and health. Geneva: WHO. Retrieved 11 May 2020, from https://www.who.int/publications-detail/coronavirus-disease-(COVID-19)-outbreak-rights-roles-and-responsibilities-of-health-workers-including-key-considerations-for-occupational-safety-and-health external icon
[26] Pfeiffer, Paul N, Blow, Adrian J, Ph.D.; Miller, Erin, MS; Forman, Jane, ScD; Dalack, Gregory W, MD; et al. (2012), Peers and Peer-Based Interventions in Supporting Reintegration and Mental Health Among National Guard Soldiers: A Qualitative Study. Military Medicine; 177, 12: 1471.
[27] Greden, J. F., Valenstein, M., Spinner, J., Blow, A., Gorman, L. A., Dalack, G. W., Marcus, S., and Kees, M. (2010), Buddy-to-Buddy, a citizen soldier peer support program to counteract stigma, PTSD, depression, and suicide. Annals of the New York Academy of Sciences, 1208: 90–97. DOI: 10.1111/j.1749-6632.2010.05719.
[28] Finnegan, A., Lauder, W., & McKenna, H. (2016). The challenges and psychological impact of delivering nursing care within a war zone. Nursing Outlook, 64 (5), 450-458.
[29] World Health Organization. (2020). Course: RRT Training Packages for COVID-19. Retrieved 28 April 2020, from https://extranet.who.int/hslp/training/course/view.php?id=327external icon.
[30] World Health Organization. (2020). Health Security Learning Platform. Retrieved 28 April 2020, from https://extranet.who.int/hslp/training/external icon.
[31] Chen, J. (2020). Pathogenicity and transmissibility of 2019-nCoV—A quick overview and comparison with other emerging viruses. Microbes and Infection, 22 (2), 69-71. https://doi.org/10.1016/j.micinf.2020.01.004external icon
[32] World Health Organization. (2020). Considerations in the investigation of cases and clusters of COVID-19. Geneva: WHO. Retrieved 12 May 2020, from https://www.who.int/publications-detail/considerations-in-the-investigation-of-cases-and-clusters-of-COVID-19external icon
[33] World Health Organization. (2020). Laboratory testing for COVID-19 in suspect human cases. Geneva: WHO. Retrieved 12 May 2020, from https://apps.who.int/iris/handle/10665/331329external icon
[34] Centers for Disease Control and Prevention. (2020). Strategic Priority Infection Prevention and Control Activities for Non-US Healthcare Settings. Atlanta: CDC. Retrieved 12 May 2020, from https://www.cdc.gov/coronavirus/2019-ncov/hcp/non-us-settings/index.html
[35] World Health Organization. (2020). Infection prevention and control during health care when COVID-19 is suspected. Geneva: WHO. Retrieved 12 May 2020, from https://www.who.int/publications-detail/infection-prevention-and-control-during-health-care-when-novel-coronavirus-(ncov)-infection-is-suspected-20200125external icon
[36] World Health Organization. (2020). Operational considerations for case management of COVID-19 in health facilities and community. Geneva: WHO. Retrieved 12 May 2020, from https://www.who.int/publications-detail/operational-considerations-for-case-management-of-COVID-19-in-health-facility-and-communityexternal icon
[37] World Health Organization. (2020). Risk communication and community engagement readiness and response to COVID-19. Geneva: WHO. Retrieved 12 May 2020, from https://www.who.int/publications-detail/risk-communication-and-community-engagement-readiness-and-initial-response-for-novel-coronaviruses-(-ncov)external icon
[38] World Health Organization. (2020). Risk assessment and management of exposure of health care workers in the context of COVID-19: interim guidance, 19 March 2020. Geneva: WHO. Retrieved 11 May 2020, from https://apps.who.int/iris/handle/10665/331496external icon
[39] Krishnan S. P. T. Krishnan S. P. T. Jose L. Ugia Gonzalez, Getting Started with Google Cloud Platform, January 2015, DOI: 10.1007/978-1-4842-1004-8_2.
[40] Krishnan S. P. T. Jose L. Ugia Gonzalez, Google App Engine, January 2015, DOI: 10.1007/978-1-4842-1004-8_5.
Cite This Article
  • APA Style

    Ramamurthy Valavandan, Subhendu Ghosh, Kumaraswamy Reddy, Prasanth Parayatham, Ubaiyadulla Sherif, et al. (2022). Google Cloud Services for Collecting, Processing, Analyzing, and Visualizing the Types of COVID-19 Vaccines. International Journal of Data Science and Analysis, 8(4), 94-118. https://doi.org/10.11648/j.ijdsa.20220804.11

    Copy | Download

    ACS Style

    Ramamurthy Valavandan; Subhendu Ghosh; Kumaraswamy Reddy; Prasanth Parayatham; Ubaiyadulla Sherif, et al. Google Cloud Services for Collecting, Processing, Analyzing, and Visualizing the Types of COVID-19 Vaccines. Int. J. Data Sci. Anal. 2022, 8(4), 94-118. doi: 10.11648/j.ijdsa.20220804.11

    Copy | Download

    AMA Style

    Ramamurthy Valavandan, Subhendu Ghosh, Kumaraswamy Reddy, Prasanth Parayatham, Ubaiyadulla Sherif, et al. Google Cloud Services for Collecting, Processing, Analyzing, and Visualizing the Types of COVID-19 Vaccines. Int J Data Sci Anal. 2022;8(4):94-118. doi: 10.11648/j.ijdsa.20220804.11

    Copy | Download

  • @article{10.11648/j.ijdsa.20220804.11,
      author = {Ramamurthy Valavandan and Subhendu Ghosh and Kumaraswamy Reddy and Prasanth Parayatham and Ubaiyadulla Sherif and Vikram Sharma and Pragathi Sri and Vijayachandran Ramachandran and Surasa Mukherjee and Nitin Ambekar and Dinesh Sai Teja Neeli and Vijender Singh and Santosh Baran and Praveen Brian and Hanumantha Raj and Musheer Ahmed and Saurabh Uniyal},
      title = {Google Cloud Services for Collecting, Processing, Analyzing, and Visualizing the Types of COVID-19 Vaccines},
      journal = {International Journal of Data Science and Analysis},
      volume = {8},
      number = {4},
      pages = {94-118},
      doi = {10.11648/j.ijdsa.20220804.11},
      url = {https://doi.org/10.11648/j.ijdsa.20220804.11},
      eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ijdsa.20220804.11},
      abstract = {This study analyzes the types of COVID-19 vaccines used in different countries in Google Cloud native services. Big Query, a Google Cloud data analytics product, is used for data analytics. The python application is developed for data visualization of types of COVID-19 vaccines, and the application deployed in Google Cloud handles the data collection methodology. Google Cloud composer establishes the connection to the World Health Organization portal. Apache Airflow directed acyclic graph (DAG) runs in a Cloud Composer environment and Google Data Studio for data visualization. Google Guild members fully support the Google cloud Nature Labs projects. The motivation behind this project is our recent work on creating the ecosystem in Google Cloud for customers. The discovery, identification of Google service, the workload migration is designed for Google Cloud. The python application parses the types of vaccines of COVID-19 data in JSON format. The big query, a serverless data analytics of Google cloud, performs the classes of vaccines used in different countries. The python application parses the JSON file format and generates the report of the types the COVID-19 vaccines. Python application performs the data visualization in Google cloud, and Google data studio completes the functional requirement of reporting layer. The approach to studying the types of vaccines used in different countries is unique. As always, the data clenching task is a tedious task. Thanks to the research sponsor, SerpAPI provides the Google search results of variance of COVID-19 vaccines and chemical composition of vaccines of companies. The developed solution and the work products are highly reusable, and customers benefit from the outcome of this research assignment in the Google cloud innovation project of Nature Labs. The Google cloud native offers the dynamics for the scientific community on the study of types of vaccines for vaccine manufacturing companies. We conclude that out of thirty vaccine manufacturing companies, the World Health Organization (WHO) disapproves of Wuhan CNBG.},
     year = {2022}
    }
    

    Copy | Download

  • TY  - JOUR
    T1  - Google Cloud Services for Collecting, Processing, Analyzing, and Visualizing the Types of COVID-19 Vaccines
    AU  - Ramamurthy Valavandan
    AU  - Subhendu Ghosh
    AU  - Kumaraswamy Reddy
    AU  - Prasanth Parayatham
    AU  - Ubaiyadulla Sherif
    AU  - Vikram Sharma
    AU  - Pragathi Sri
    AU  - Vijayachandran Ramachandran
    AU  - Surasa Mukherjee
    AU  - Nitin Ambekar
    AU  - Dinesh Sai Teja Neeli
    AU  - Vijender Singh
    AU  - Santosh Baran
    AU  - Praveen Brian
    AU  - Hanumantha Raj
    AU  - Musheer Ahmed
    AU  - Saurabh Uniyal
    Y1  - 2022/07/28
    PY  - 2022
    N1  - https://doi.org/10.11648/j.ijdsa.20220804.11
    DO  - 10.11648/j.ijdsa.20220804.11
    T2  - International Journal of Data Science and Analysis
    JF  - International Journal of Data Science and Analysis
    JO  - International Journal of Data Science and Analysis
    SP  - 94
    EP  - 118
    PB  - Science Publishing Group
    SN  - 2575-1891
    UR  - https://doi.org/10.11648/j.ijdsa.20220804.11
    AB  - This study analyzes the types of COVID-19 vaccines used in different countries in Google Cloud native services. Big Query, a Google Cloud data analytics product, is used for data analytics. The python application is developed for data visualization of types of COVID-19 vaccines, and the application deployed in Google Cloud handles the data collection methodology. Google Cloud composer establishes the connection to the World Health Organization portal. Apache Airflow directed acyclic graph (DAG) runs in a Cloud Composer environment and Google Data Studio for data visualization. Google Guild members fully support the Google cloud Nature Labs projects. The motivation behind this project is our recent work on creating the ecosystem in Google Cloud for customers. The discovery, identification of Google service, the workload migration is designed for Google Cloud. The python application parses the types of vaccines of COVID-19 data in JSON format. The big query, a serverless data analytics of Google cloud, performs the classes of vaccines used in different countries. The python application parses the JSON file format and generates the report of the types the COVID-19 vaccines. Python application performs the data visualization in Google cloud, and Google data studio completes the functional requirement of reporting layer. The approach to studying the types of vaccines used in different countries is unique. As always, the data clenching task is a tedious task. Thanks to the research sponsor, SerpAPI provides the Google search results of variance of COVID-19 vaccines and chemical composition of vaccines of companies. The developed solution and the work products are highly reusable, and customers benefit from the outcome of this research assignment in the Google cloud innovation project of Nature Labs. The Google cloud native offers the dynamics for the scientific community on the study of types of vaccines for vaccine manufacturing companies. We conclude that out of thirty vaccine manufacturing companies, the World Health Organization (WHO) disapproves of Wuhan CNBG.
    VL  - 8
    IS  - 4
    ER  - 

    Copy | Download

Author Information
  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Kyndryl Solutions Private Limited, Google Cloud Guild, Nature Labs Project, Bangalore, India

  • Sections