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

2017 IEEE 3rd International Conference on Engineering Technologies and Social Sciences (ICETSS) Pub Date : 2017-08-01 DOI:10.1109/ICETSS.2017.8324187

M. S. Vighio, T. J. Khanzada, Mukesh Kumar

{"title":"分析冗余对关系数据库系统性能的影响","authors":"M. S. Vighio, T. J. Khanzada, Mukesh Kumar","doi":"10.1109/ICETSS.2017.8324187","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":228333,"journal":{"name":"2017 IEEE 3rd International Conference on Engineering Technologies and Social Sciences (ICETSS)","volume":"12 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2017-08-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"2","resultStr":"{\"title\":\"Analysis of the effects of redundancy on the performance of relational database systems\",\"authors\":\"M. S. Vighio, T. J. Khanzada, Mukesh Kumar\",\"doi\":\"10.1109/ICETSS.2017.8324187\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":228333,\"journal\":{\"name\":\"2017 IEEE 3rd International Conference on Engineering Technologies and Social Sciences (ICETSS)\",\"volume\":\"12 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2017-08-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"2\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2017 IEEE 3rd International Conference on Engineering Technologies and Social Sciences (ICETSS)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICETSS.2017.8324187\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2017 IEEE 3rd International Conference on Engineering Technologies and Social Sciences (ICETSS)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICETSS.2017.8324187","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 2

摘要

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

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

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 (ICETSS)

自引率

0.00%

发文量