Reducing Data Access Time using Table Partitioning Techniques

Veronika Salgová, K. Matiaško
{"title":"Reducing Data Access Time using Table Partitioning Techniques","authors":"Veronika Salgová, K. Matiaško","doi":"10.1109/ICETA51985.2020.9379231","DOIUrl":null,"url":null,"abstract":"Data are used in a large number of different fields. Large databases with huge amounts of data come to the fore. They are a very important part of many of information systems, from commercial systems, through technical and technological systems, the web, and mobile applications to the management of scientific data in various fields. Fast access to data is, therefore, becoming increasingly important today and great emphasis is placed on improving it. Initially, the data access time may be only slightly increased working with smaller tasks, but with a larger number of larger tasks, there is a significantly higher data access time that needs to be reduced. From the point of view of efficiency, it is not appropriate or necessary to access all data, and therefore it is necessary to divide this data into smaller parts and thus create partitions, which will facilitate the execution of certain operations and bring efficiency, whether in terms of time or performance. This paper discusses partitioning, its various techniques, methods, and the benefits it brings. It compares access times to tables with and without partitions, regarding various numbers of table parts that are accessed.","PeriodicalId":149716,"journal":{"name":"2020 18th International Conference on Emerging eLearning Technologies and Applications (ICETA)","volume":"29 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2020-11-12","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2020 18th International Conference on Emerging eLearning Technologies and Applications (ICETA)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICETA51985.2020.9379231","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 1

Abstract

Data are used in a large number of different fields. Large databases with huge amounts of data come to the fore. They are a very important part of many of information systems, from commercial systems, through technical and technological systems, the web, and mobile applications to the management of scientific data in various fields. Fast access to data is, therefore, becoming increasingly important today and great emphasis is placed on improving it. Initially, the data access time may be only slightly increased working with smaller tasks, but with a larger number of larger tasks, there is a significantly higher data access time that needs to be reduced. From the point of view of efficiency, it is not appropriate or necessary to access all data, and therefore it is necessary to divide this data into smaller parts and thus create partitions, which will facilitate the execution of certain operations and bring efficiency, whether in terms of time or performance. This paper discusses partitioning, its various techniques, methods, and the benefits it brings. It compares access times to tables with and without partitions, regarding various numbers of table parts that are accessed.
使用表分区技术减少数据访问时间
数据被用于大量不同的领域。拥有海量数据的大型数据库应运而生。它们是许多信息系统的重要组成部分,从商业系统,通过技术和技术系统,网络和移动应用程序到各个领域的科学数据管理。因此,快速访问数据在今天变得越来越重要,并且非常强调改进它。最初,处理较小的任务时,数据访问时间可能只会略微增加,但是当处理大量较大的任务时,需要减少的数据访问时间就会明显增加。从效率的角度来看,访问所有数据是不合适的,也没有必要,因此有必要将这些数据分成更小的部分,从而创建分区,这将有利于某些操作的执行,并带来效率,无论是在时间上还是在性能上。本文讨论了分区,它的各种技术,方法,以及它带来的好处。它比较有分区和没有分区的表的访问时间,根据访问的表部分的不同数量。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信