Art of Electronics See Fig 462 Fig 432 in the 3rd Edition

Abstract

In this paper, nosotros are analyzing relational DBMS while working with big data. All experiments and performance tests are implemented in MS SQL Server 2019 Developer Edition and MongoDB. In the beginning, we offset by creating a database that contains not-linked tables (flat tables) with maximum memory consummation. The performance test starts with filling (Insert) the database with millions of rows. Then nosotros continue with information modification operations (Update). Finally, we launch the data cleaning (Delete) test. When all tests pass by and execution time is picked upward for farther analysis, nosotros continue our experiment with relational tables and NoSQL collections. That's why in the 2d part of this paper we accept the aforementioned database structure where we add primary and strange central constraints with cascade update and delete options. When repeating the performance exam, nosotros notice that the table size and execution time take significantly increased.

Keywords

• Relational DBMS
• Functioning test
• Big data
• Link constraints
• DML commands
• MongoDB
• Data drove
• JSON

References

1. Zein, A.N., Borisova, South.V.: The distribution problem of unstructured information when solving data mining tasks on computer clusters. Paper Presented at the CEUR Workshop Proceedings, p. 2570 (2020)

   Google Scholar

2. Komarov, I., Vegera, A., Zein, A., Borisova, Due south., Blazhenova, S., Gavrilov A.: Design of tree-similar database construction for solving test modeling tasks of free energy equipment. In: Proceedings of the 2020 fifth International Conference on Information Technologies in Engineering Education, pp. 14–17. Russian federation, Inforino, Moscow, April 2020

   Google Scholar

3. Faroult, Due south., Robson, P.: The Art of SQL. p. 370. O'Reilly Media, Sebastopol (2006)

   Google Scholar

4. Perkins, B., Hammer, J.V., Reid, J.D.: C# seven Programming with Visual Studio 2017, p. 884. Wrox, Indianapolis (2018)

   Google Scholar

5. Plugge, E., Membrey, P., Hawkins, T.: The Definitive Guide to MongoDB: The NoSQL Database for Cloud and Desktop Computing, p. 327. Apress (2010). ISBN:i-4302-3051-7

   Google Scholar

6. Chodorow, 1000.: MongoDB: The Definitive Guide, 2nd edn. p. 432. O'Reilly, Sebastopol (2013)

   Google Scholar

7. Hows, D., Membrey, P., Plugge, Due east., Hawkins. T.: The Definitive Guide to MongoDB: A Complete Guide to Dealing with Large Data Using MongoDB, 3rd edn. p. 376c. Apress (2015). ISBN: 978-one-842-1183-0

   Google Scholar

8. 50'Heureux, A., Grolinger, Thousand., Elyamany, H.F., Capretz, M.A.Thou.: Machine learning with big information: challenges and approaches. IEEE Access. 5, 7776–7797 (2017). https://doi.org/x.1109/Access.2017.2696365.ISSN2169-3536

   CrossRef  Google Scholar

9. Kitchin, R., McArdle, 1000.: What makes big information, big data? Exploring the ontological characteristics of 26 datasets. Big Data Soc. 3(1), 205395171663113 (2016). https://doi.org/10.1177/2053951716631130. ISSN: 2053-9517

10. Dedić, N., Stanier, C.: Towards differentiating business organisation intelligence, big data, information analytics and cognition discovery. In: Piazolo, F., Geist, Five., Brehm, L., Schmidt, R. (eds.) ERP Future 2016. LNBIP, vol. 285, pp. 114–122. Springer, Cham (2017). https://doi.org/x.1007/978-three-319-58801-8_10

    CrossRef  Google Scholar

11. Alekperov, R.: Evolution and Implementation of an Algorithm for Processing Fuzzy Queries to Relational Databases, vol. 307. SCOPUS (2022). world wide web.scopus.com. https://doi.org/ten.1007/978-three-030-85626-7_104

12. Baumann, P., Misev, D., Merticariu, 5., Huu, B.P.: Array databases: concepts, standards, implementations. J. Big Data 8(one), 1–61 (2021). https://doi.org/10.1186/s40537-020-00399-2

    CrossRef  Google Scholar

13. Vershinin, I.Southward., Mustafina, A.R.: Performance Analysis of PostgreSQL, MySQL, Microsoft SQL Server Systems Based on TPC-H Tests. SCOPUS (2021). www.scopus.com. https://doi.org/10.1109/RusAutoCon52004.2021.9537400

14. Gomes, A.: et al.: An Empirical Functioning Comparison betwixt MySQL and MongoDB on Analytical Queries in the COMEX Database. SCOPUS (2021) www.scopus.com. https://doi.org/10.23919/CISTI52073.2021.9476623

Download references

Aknowledgments

The investigation was carried out inside the framework of the project "Development of Analytical Information Arrangement for Storage and Intellectual Processing of the Results of Experimental and Numerical Studies of Physical Processes Post-obit in the Elements of Energy Processing" with the support of a grant from NRU "MPEI" for implementation of scientific research programs "Energy", "Electronics, Radio Engineering and Information technology", and "Industry four.0, Technologies for Industry and Robotics in 2020–2022".

Author information

Affiliations

1. National Inquiry University "Moscow Power Technology Institute", Krasnokazarmennaya 17, Moscow, 111250, Russian federation

   Svetlana Borisova & Ali Zein

Rights and permissions

Copyright information

© 2022 Springer Nature Switzerland AG

About this paper

Cite this paper

Borisova, Southward., Zein, A. (2022). Disadvantages of Relational DBMS for Large Data Processing. In: Taratukhin, V., Matveev, Yard., Becker, J., Kupriyanov, Y. (eds) Information Systems and Design. ICID 2021. Communications in Computer and Informatics, vol 1539. Springer, Cham. https://doi.org/10.1007/978-3-030-95494-9_23

Download citation

• .RIS
• .ENW
• .BIB

• DOI : https://doi.org/10.1007/978-3-030-95494-9_23

• Published: 28 Jan 2022

• Publisher Proper noun: Springer, Cham

• Impress ISBN: 978-3-030-95493-ii

• Online ISBN: 978-iii-030-95494-9

• eBook Packages: Computer Science Estimator Scientific discipline (R0)

woodsonfrus1939.blogspot.com

Source: https://link.springer.com/chapter/10.1007/978-3-030-95494-9_23

Share this post