01451nam a22001337a 4500 56172 56169 Khanzada, Taooz Javed 14MSIT21 Supervisor Dr. Muhammad Saleem Vighio Automated Tool For Query Normalization & Elimination Of Redound Ancy Nawabshah: QUEST, 2016. 43P, : ABSTRACT Redundancy and complexity have adversely ineradicable effects on performance of the database management system (DBMS), during the execution of queries. DBMS software takes more time as compared to normal processing of queries, when queries are complex and contain redundancy. To respond the user more quickly, there is need to execute queries more efficiently i.e., the queries that take less time to execute and consume less resources. Therefore we have suggested a new technique that before to take on execution process, queries should be normalized or simplified and must remove redundancy and complexity from query, then DBMS should perform whole execution process. Our research presents a tool in which we have implemented an algorithm with idempotent and equivalence rules. The proposed tool automatically performs normalization upon complex and redundant queries, and as a result provides an efficient normalized query which makes further processing (optimization and execution process) faster. Department of Information Technology https://tinyurl.com/ycxtxwpf THESIS 0 0 0 0 RESEARCH RESEARCH 2016-11-28 0 MP/13-131 2016-11-28 00:00:00 THESIS 0 0 0 0 RESEARCH RESEARCH 2018-10-01 0 MP/26-280 2018-10-01 00:00:00 THESIS