{"title":"交通信息系统的关系数据库工作优化","authors":"I. Saiapina","doi":"10.32703/2617-9040-2022-40-23","DOIUrl":null,"url":null,"abstract":"Informatization of society poses new challenges and requirements for information systems in transport, which are responsible for data processing and storage. A significant number of performance problems in developed applications are related to databases, because often poor database performance directly affects the application's slowdown. For the normal functioning of the processes of diagnostics of rolling stock and automation systems, decision-making, and the formation of reports in the transport industry, the task of optimizing the management of databases and ensuring their productivity under the condition of simultaneous multi-user access arises. The article discusses the stages of query execution and approaches to increasing the efficiency of the query optimizer. The main factors that depend on the performance of queries in information systems based on relational databases are analyzed. Optimization criteria can include such performance estimates as time required to generate a report, query execution time, speed of finding data in non-indexed fields, maximum number of simultaneous accesses to data in multi-user mode, speed of indexing, as well as update, delete and add operations.","PeriodicalId":33465,"journal":{"name":"Zbirnik naukovikh prats'' Derzhavnogo universitetu infrastrukturi ta tekhnologii seriia Transportni sistemi i tekhnologiyi","volume":" ","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2022-12-28","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"RELATIONAL DATABASE WORK OPTIMIZATION OF THE TRANSPORT INFORMATION SYSTEM\",\"authors\":\"I. Saiapina\",\"doi\":\"10.32703/2617-9040-2022-40-23\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Informatization of society poses new challenges and requirements for information systems in transport, which are responsible for data processing and storage. A significant number of performance problems in developed applications are related to databases, because often poor database performance directly affects the application's slowdown. For the normal functioning of the processes of diagnostics of rolling stock and automation systems, decision-making, and the formation of reports in the transport industry, the task of optimizing the management of databases and ensuring their productivity under the condition of simultaneous multi-user access arises. The article discusses the stages of query execution and approaches to increasing the efficiency of the query optimizer. The main factors that depend on the performance of queries in information systems based on relational databases are analyzed. Optimization criteria can include such performance estimates as time required to generate a report, query execution time, speed of finding data in non-indexed fields, maximum number of simultaneous accesses to data in multi-user mode, speed of indexing, as well as update, delete and add operations.\",\"PeriodicalId\":33465,\"journal\":{\"name\":\"Zbirnik naukovikh prats'' Derzhavnogo universitetu infrastrukturi ta tekhnologii seriia Transportni sistemi i tekhnologiyi\",\"volume\":\" \",\"pages\":\"\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-12-28\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Zbirnik naukovikh prats'' Derzhavnogo universitetu infrastrukturi ta tekhnologii seriia Transportni sistemi i tekhnologiyi\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.32703/2617-9040-2022-40-23\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Zbirnik naukovikh prats'' Derzhavnogo universitetu infrastrukturi ta tekhnologii seriia Transportni sistemi i tekhnologiyi","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.32703/2617-9040-2022-40-23","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0

摘要

社会信息化对负责数据处理和存储的交通运输信息系统提出了新的挑战和要求。在开发的应用程序中,大量的性能问题都与数据库有关,因为糟糕的数据库性能通常会直接影响应用程序的运行速度。为了保证交通运输行业中车辆和自动化系统的诊断、决策和报告形成过程的正常运行,在多用户同时访问的条件下,优化数据库的管理并保证其生产力的任务应运而生。本文讨论了查询执行的各个阶段以及提高查询优化器效率的方法。分析了关系数据库信息系统中影响查询性能的主要因素。优化标准可以包括诸如生成报告所需的时间、查询执行时间、在非索引字段中查找数据的速度、在多用户模式下对数据的最大同时访问次数、索引速度以及更新、删除和添加操作等性能估计。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
RELATIONAL DATABASE WORK OPTIMIZATION OF THE TRANSPORT INFORMATION SYSTEM
Informatization of society poses new challenges and requirements for information systems in transport, which are responsible for data processing and storage. A significant number of performance problems in developed applications are related to databases, because often poor database performance directly affects the application's slowdown. For the normal functioning of the processes of diagnostics of rolling stock and automation systems, decision-making, and the formation of reports in the transport industry, the task of optimizing the management of databases and ensuring their productivity under the condition of simultaneous multi-user access arises. The article discusses the stages of query execution and approaches to increasing the efficiency of the query optimizer. The main factors that depend on the performance of queries in information systems based on relational databases are analyzed. Optimization criteria can include such performance estimates as time required to generate a report, query execution time, speed of finding data in non-indexed fields, maximum number of simultaneous accesses to data in multi-user mode, speed of indexing, as well as update, delete and add operations.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
自引率
0.00%
发文量
28
审稿时长
27 weeks
期刊最新文献
Comparative analysis of damages and defects in rails of different railway transport systems Developing an efficient road-based batch freight delivery technology for intercity connections with a focus on resource conservation Modeling of transport infrastructure: ontological approach Determination of the efficiency of the modernization of passenger car bodies Commercial and legal conditions for the organization of sea passenger transportation
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1