{"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}
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.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
