A Comprehensive Survey on Optimizing Storage Models, Data Layouts, and System Catalogs
Abstract
This survey compares four papers that propose solutions for optimizing the storage model, data layout, and system catalogs in data management systems for hybrid workloads, which consist of both analytical and transactional queries. These solutions include a main memory hybrid storage engine that separates the storage of analytical and transactional data and uses a sophisticated query optimizer, a hands-free adaptive store that adjusts the storage layout based on access patterns, a hybrid storage engine that combines the strengths of row- and column- store systems and a column layout optimization method that considers both analytical and transactional access patterns and uses ghost values to support updates. These papers highlight the importance of designing storage systems specifically for hybrid workloads and the need for further research in this area.
Keywords: Adaptive storage, dynamic operators, adaptive hybrids, main memory, workloads, hybrid
storage, workloads
INTRODUCTION
In recent years, there has been a growing interest in the design of storage engines that can effectively support hybrid workloads, which are characterized by a mix of long-running analytical queries and short-lived transactions. These hybrid workloads are increasingly common in modern systems and pose unique challenges for storage engine design due to the need to balance the conflicting requirements of high-throughput analytical processing and low-latency transactional processing.
Keyworde: Adaptive storage, dynamic operators, adaptive hybrids, main memory, workloads, hybrid storage, workloads
Full Text PDF
Refrences:
1. Ortiz-Prado E, Simbaña-Rivera K, Gomez-Barreno L, Rubio-Neira M, Guaman LP, Kyriakidis NC,
Muslin C, Jaramil AMG, Barba-Ostra C, Robalino DC, San-Miguel HS, Unigarro L, Zalakeviciute
R, Gadian N, Lopez-Cortes, A. Clinical, molecular, and epidemiological characterization of the
SARS-CoV-2 virus and the Coronavirus Disease 2019 (COVID-19), a comprehensive literature
review. Diagnostic Microbiology and Infectious Disease. 2020; 98(1): 115094.
2. Dutta P, Paul S, Kumar A. Comparative analysis of various supervised machine learning techniques
for diagnosis of COVID-19. Electronic Devices, Circuits, and Systems for Biomedical
Applications. 2021; 2021: 521–540p.
3. Dutta P, Paul S, Obaid AJ, Pal S, Mukhopadhyay K. Feature Selection based Artificial Intelligence
Techniques for the Prediction of COVID like Diseases. Journal of Physics: Conference Series.
2021; 1963(1): 012167.
4. Bakar NA, Rosbi S. Effect of Coronavirus disease (COVID-19) to tourism industry. International
Journal of Advanced Engineering Research and Science. 2020; 7(4): 189–193p.
5. Dhand R, Li J. Coughs and sneezes: their role in transmission of respiratory viral infections,
including SARS-CoV-2. American Journal of Respiratory and Critical Care Medicine. 2020;
202(5): 651–659p.
6. Hafeez A, Ahmad S, Siddqui SA, Ahmad M, Mishra S. A review of COVID-19 (Coronavirus
Disease-2019) diagnosis, treatments and prevention. EJMO. 2020; 4(2): 116–125p.
7. Parvin F, Islam S, Urmy Z, Ahmed S. The symptoms, contagious process, prevention and post
treatment of COVID-19. European Journal of Physiotherapy and Rehabilitation Studies. 2020; 1(1):
81–105p.
8. Sarkar D, Biswas M. (Jun 2020). COVID 19 Pandemic: A real-time forecasts & prediction of
confirmed cases, active cases using the ARIMA model & Public Health in West Bengal, India.
Available from: https://www.medrxiv.org/content/10.1101/2020.06.06.20124180v1.full.
9. Viswa Chaitanya Chandu. (May 2020). Timeseries forecasting of COVID-19 confirmed cases with
ARIMA model in the South East Asian countries of India and Thailand: A comparative case study.
Available from: https://www.medrxiv.org/content/10.1101/2020.05.16.20103895v1.
10. Johnson EB, Trautman LJ. The Demographics of Death: An Early Look at COVID-19, Cultural
and Racial Bias in America. Hastings Const LQ. 2020; 48: 357p.
11. Alam MS, Sultana R, Haque MA. Vulnerabilities of older adults and mitigation measures to address
COVID-19 outbreak in Bangladesh: A review. Social Sciences & Humanities Open. 2022; 6(1):
100336.
12. Gupta R, Pal SK. (Mar 2020). Trend analysis and forecasting of COVID-19 outbreak in India.
Available from: https://www.medrxiv.org/content/10.1101/2020.03.26.20044511v1.
13. Biswas B, Subhra Debdas, Samanta S, Mohanty S. Covid-19 data analysis of India and future
forecasting using FbProphet. 2021 International Conference in Advances in Power, Signal, and
Information Technology (APSIT). Bhubaneswar, India. 2021, Oct 8–10. DOI:
10.1109/APSIT52773.2021.9641221.
14. Eren ME, Solovyev N, Raff E, Nicholas C, Johnson B. COVID-19 kaggle literature organization.
In: Proceedings of the ACM Symposium on Document Engineering; 2020. 1–4p.
15. Glas T. (2022). Asset pricing and investment styles in digital assets. Springer Nature. [Online]
Available from: https://www.wiley.com/en-in/Time+Series+Analysis:+Forecasting
+and+Control,+5th+Edition-p-9781118675021.
16. Sato RC. Disease management with ARIMA model in time series. Sao Paulo: Einstein. 2013; 11:
128–131p.
17. Box GE, Hillmer SC, Tiao GC. Analysis and modeling of seasonal time series. In: Seasonal analysis
of economic time series. Cambridge: National Bureau of Economic Research; 1978. 309–344p.
18. Box G. Box and Jenkins: time series analysis, forecasting and control. In: A Very British Affair.
London: Palgrave Macmillan; 2013. 161–215p.
19. Wabomba MS, Mutwiri M, Fredrick M. Modeling and forecasting Kenyan GDP using
autoregressive integrated moving average (ARIMA) models. Science Journal of Applied
Mathematics and Statistics. 2016; 4(2): 64–73p.
20. Goel I, Sharma S, Kashiramka S. Effects of the COVID-19 pandemic in India: an analysis of policy
and technological interventions. Health Policy and Technology. 2021; 10(1): 151–164p.
21. Kumar M, Anand M. An application of time series ARIMA forecasting model for predicting
sugarcane production in India. Studies in Business and Economics. 2014; 9(1): 81–94p.
22. Khashei M, Bijari M. A novel hybridization of artificial neural networks and ARIMA models for
time series forecasting. Applied Soft Computing. 2011; 11(2): 2664–2675p.