EFFICIENTLY PROCESSING DATA IN TABLE WITH BILLIONS OF RECORDS
Article Sidebar
Open full text
Issue Vol. 12 No. 4 (2022)
-
SCATTERING BY CIRCULAR VOIDS WITH RIGID BOUNDARY: DIRECT AND INVERSE PROBLEMS FOR OPEN AND CLOSE DOMAINS
Tomasz Rymarczyk, Jan Sikora4-10
-
FINITE ELEMENT MODEL FOR ANALYSIS OF CHARACTERISTICS OF SHROUDED ROTOR BLADE VIBRATIONS
Anatoliy Zinkovskii, Kyrylo Savchenko, Yevheniia Onyshchenko, Leonid Polishchuk, Abilkaiyr Nazerke, Bagashar Zhumazhanov11-16
-
EFFICIENTLY PROCESSING DATA IN TABLE WITH BILLIONS OF RECORDS
Piotr Bednarczuk, Adam Borsuk17-20
-
GENERALIZED MODEL OF INFORMATION PROTECTION PROCESS IN AUDIOVISUAL CONTENT DISTRIBUTION NETWORKS
Heorhii Rozorinov, Oleksandr Hres, Volodymyr Rusyn21-25
-
MONITORING OF LINK-LEVEL CONGESTION IN TELECOMMUNICATION SYSTEMS USING INFORMATION CRITERIA
Natalia Yakymchuk, Yosyp Selepyna, Mykola Yevsiuk, Stanislav Prystupa, Serhii Moroz26-30
-
POLARIZATION TOMOGRAPHY OF THE POLYCRYSTALINNE STRUCTURE OF HISTOLOGICAL SECTIONS OF HUMAN ORGANS IN DETERMINATION OF THE OLD DAMAGE
Olexandra Litvinenko, Victor Paliy, Olena Vуsotska, Inna Vishtak, Saule Kumargazhanova31-34
-
ANALYSIS OF UPPER RESPIRATORY TRACT SEGMENTATION FEATURES TO DETERMINE NASAL CONDUCTANCE
Oleg Avrunin, Yana Nosova, Nataliia Shushliapina, Ibrahim Younouss Abdelhamid, Oleksandr Avrunin, Svetlana Kyrylashchuk, Olha Moskovchuk, Orken Mamyrbayev35-40
-
THE USE OF Q-PREPARATION FOR AMPLITUDE FILTERING OF DISCRETED IMAGE
Leonid Timchenko, Natalia Kokriatskaia, Mykhailo Rozvodiuk, Volodymyr Tverdomed, Yuri Kutaev, Saule Smailova, Vladyslav Plisenko, Liudmyla Semenova, Dmytro Zhuk41-46
-
INFORMATION MODEL OF THE ASSESSMENT OF TOURISM SECTOR COMPETITIVENESS IN THE CONTEXT OF EUROPEAN INTEGRATION POLICY
Iryna Prychepa, Oksana Adler, Liliia Ruda, Olexander Lesko, Zlata Bondarenko, Lee Yanan, Dinara Mussayeva47-52
-
FORECASTING BUSINESS PROCESSES IN THE MANAGEMENT SYSTEM OF THE CORPORATION
Svitlana A. Yaremko, Elena M. Kuzmina, Nataliia B. Savina, Iryna Yu. Yepifanova, Halyna B. Gordiichuk, Dinara Mussayeva53-59
-
ELABORATION AND RESEARCH OF A MODEL OF OPTIMAL PRODUCTION AND DEVELOPMENT OF INDUSTRIAL SYSTEMS TAKING INTO ACCOUNT THE USE OF THE EXTERNAL RESOURCES
Dmytro Hryshyn, Taisa Borovska, Aliya Kalizhanova60-66
-
MODELING THE DEVELOPMENT PROCESS OF INCLUSIVE EDUCATION IN UKRAINE
Mariana M. Kovtoniuk, Olena P. Kosovets, Olena M. Soia, Olga Yu. Pinaieva, Vira G. Ovcharuk, Kuralay Mukhsina67-73
-
FREQUENCY-TO-CODE CONVERTER WITH DIRECT DATA TRANSMISSION
Piotr Warda74-77
-
DIGITAL APPROACH TO THERMIONIC EMISSION CURRENT TO VOLTAGE CONVERSION FOR HIGH-VOLTAGE SOURCES OF ELECTRONS
Bartosz Kania78-81
-
[Retracted]: SYSTEM SOFTWARE AT LABORATORY STAND „LIGHTS CONTROL ON THE BASIS OF PROGRAMMABLE LOGIC CONROLLER”
The article has been retracted due to a breach of ethical standards. The editorial board received a report that this work infringes on the copyrights of others. An investigation confirmed the validity of the report, resulting in the decision to retract the work. The evidence in the case is in the possession of the editorial board. The editorial board of the journal also declares that it has followed all procedures for checking the article for unethical practices before its publication in 2022.Laura Yesmakhanova, Raushan Dzhanuzakova, Bauyrzhan Myrkalykov82-86 -
FLAME ANALYSIS BY SELECTED METHODS IN THE FREQUENCY DOMAIN
Żaklin Grądz, Jacek Klimek, Czesław Kozak87-89
Archives
-
Vol. 14 No. 4
2024-12-21 25
-
Vol. 14 No. 3
2024-09-30 24
-
Vol. 14 No. 2
2024-06-30 24
-
Vol. 14 No. 1
2024-03-31 23
-
Vol. 13 No. 4
2023-12-20 24
-
Vol. 13 No. 3
2023-09-30 25
-
Vol. 13 No. 2
2023-06-30 14
-
Vol. 13 No. 1
2023-03-31 12
-
Vol. 12 No. 4
2022-12-30 16
-
Vol. 12 No. 3
2022-09-30 15
-
Vol. 12 No. 2
2022-06-30 16
-
Vol. 12 No. 1
2022-03-31 9
-
Vol. 11 No. 4
2021-12-20 15
-
Vol. 11 No. 3
2021-09-30 10
-
Vol. 11 No. 2
2021-06-30 11
-
Vol. 11 No. 1
2021-03-31 14
-
Vol. 10 No. 4
2020-12-20 16
-
Vol. 10 No. 3
2020-09-30 22
-
Vol. 10 No. 2
2020-06-30 16
-
Vol. 10 No. 1
2020-03-30 19
Main Article Content
DOI
Authors
piotr.bednarczuk@wsei.lublin.pl
Abstract
Over time, systems connected to databases slow down. This is usually due to the increase in the amount of data stored in individual tables, counted even in the billions of records. Nevertheless, there are methods for making the speed of the system independent of the number of records in the database. One of these ways is table partitioning. When used correctly, the solution can ensure efficient operation of very large databases even after several years. However, not everything is predictable because of some undesirable phenomena become apparent only with a very large amount of data. The article presents a study of the execution time of the same queries with increasing number of records in a table. These studies reveal and present the timing and circumstances of the anomaly for a certain number of records.
Keywords:
References
Bednarczuk P.: Optimization in very large databases by partitioning tables, Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska 10(3), 2020, 95–98. DOI: https://doi.org/10.35784/iapgos.2056
Bandle M., Giceva J., Neumann T.: To Partition, or Not to Partition, That is the Join Question in a Real System. International Conference on Management of Data, 2021. DOI: https://doi.org/10.1145/3448016.3452831
Kumar A., Jitendra Singh Y.: A Review on Partitioning Techniques in Database. International Journal of Computer Science and Mobile Computing 13(5), 2014, 342–347.
Microsoft documentation, Data partitioning guidance, https://learn.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning
Qi W., Song J., Yu-bin B.: Near-uniform Range Partition Approach for Increased Partitioning in Large Database. 2nd IEEE International Conference on Information Management and Engineering, 2010, 101–106. DOI: https://doi.org/10.1109/ICIME.2010.5477529
Song J., Bao Y.: NPA: Increased Partitioning Approach for Massive Data in Real-time Data Warehouse. 2nd International Conference on Information Technology Convergence and Services, 2010, 1–6. DOI: https://doi.org/10.1109/ITCS.2010.5581277
Tanvi J., Shivani S.: Refreshing Datawarehouse in Near Real-Time. International Journal of Computer Applications 46(18), 2012, 24–29.
Zheng K. et al.: Data storage optimization strategy in distributed column-oriented database by considering spatial adjacency. Cluster Computing 20, 2017. DOI: https://doi.org/10.1007/s10586-017-1081-3
Article Details
Abstract views: 1874
License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
