Analysis of the effects of redundancy on the performance of relational database systems

机译：冗余对关系数据库系统性能的影响分析

获取原文

获取原文并翻译 | 示例

页面导航

摘要
著录项
相似文献
相关主题

摘要

Redundancy in user queries reduce the performance of database management system software. A remedy is to simplify queries before their processing. This paper, presents a tool that simplifies queries in the initial phase of their processing. Simplification use idempotent and equivalence rules for simplification. Also, the tool automatically performs normalization of complex and redundant queries, and as a result provides a simplified query along with the cost of simplification process. Experimental results show that the queries involving redundancy and complexity take more time and resources as compared to executing simple and non-redundant queries.

机译：用户查询中的冗余会降低数据库管理系统软件的性能。一种补救措施是在处理查询之前简化查询。本文提出了一种在查询处理的初始阶段简化查询的工具。简化使用幂等和等价规则进行简化。此外，该工具会自动执行复杂和冗余查询的规范化，从而提供简化的查询以及简化过程的成本。实验结果表明，与执行简单和非冗余查询相比，涉及冗余和复杂性的查询要花费更多的时间和资源。

著录项

来源
《2017 IEEE 3rd International Conference on Engineering Technologies and Social Sciences》|2017年|1-5|共5页
会议地点 Bangkok(TH)
作者
Muhammad Saleem Vighio; Taooz J. Khanzada; Mukesh Kumar;
展开▼
作者单位

Department of Information Technology, Quaid-e-Awam University of Engineering, Science Technology, Nawabshah, Sindh, Pakistan;

Department of Information Technology, Quaid-e-Awam University of Engineering, Science Technology, Nawabshah, Sindh, Pakistan;

Department of Information Technology, Quaid-e-Awam University of Engineering, Science Technology, Nawabshah, Sindh, Pakistan;

展开▼
会议组织
原文格式 PDF
正文语种 eng
中图分类
关键词
Tools; Redundancy; Structured Query Language; Complexity theory; Database systems; Servers;

机译：工具;冗余;结构化查询语言;复杂性理论;数据库系统;服务器;;

相似文献

外文文献
中文文献
专利

1. Query Performance of the IFC Model Server Using an Object-Relational Database Approach and a Traditional Relational Database Approach [J] . Ghang Lee, Jiyong Jeong, Jongsung Won, Journal of Computing in Civil Engineering . 2014,第2期

机译：使用对象关系数据库方法和传统关系数据库方法的IFC模型服务器的查询性能
2. Automatic Conversion of Relational Databases into Ontologies : A Comparative Analysis of Protege Plug-Ins Performances [J] . Kgotatso Desmond Mogotlane, Jean Vincent Fonou-Dombeu International Journal of Web & Semantic Technology . 2016,第3a4期

机译：关系数据库自动转换为本体：Protege插件性能的比较分析
3. Formal Concept Analysis in Relational Database and Rough Relational Database [J] . Feng Jiang, Yuefei Sui, Cungen Cao Fundamenta Informaticae . 2007,第4期

机译：关系数据库和粗糙关系数据库中的形式概念分析
4. Analysis of the effects of redundancy on the performance of relational database systems [C] . Muhammad Saleem Vighio, Taooz J. Khanzada, Mukesh Kumar IEEE International Conference on Engineering Technologies and Social Sciences . 2017

机译：冗余对关系数据库系统性能的影响分析
5. Examining the Relationship Between Query Performances when Using Different Data Models Within Relational Database Systems [D] . Alsup, Andrew H. 2021

机译：在关系数据库系统中使用不同的数据模型时检查查询性能之间的关系
6. Statistical and Probabilistic Analysis. New Tools for Analysis and Representation: XS: An Analysis and Synthesis System for Linear Regression Constructed by Integrating a Graphical Statistical System a Relational Database System and an Expert System Shell [O] . R.S. Johannes, C. Hendricks Brown, Lynn E. Onstad 1989

机译：统计和概率分析。分析和表示的新工具：XS：通过集成图形统计系统关系数据库系统和专家系统外壳构建的线性回归分析和综合系统
7. Comparative Performance Analysis of MySQL and SQL Server Relational Database Management Systems in Windows Environment [O] . Amlanjyoti Saikia, Sherin Joy, Dhondup Dolma, 2015

机译：Windows环境中MySQL和SQL Server关系数据库管理系统的比较绩效分析

Analysis of the effects of redundancy on the performance of relational database systems

摘要

著录项

相似文献

相关主题

期刊订阅