01651nam a22001577a 4500999001700000100007600017245007600093260003000169300001100199500101800210700004101228856003301269942001101302952009001313952009001403  c56172d56169  aKhanzada, Taooz Javed a14MSIT21aSupervisor Dr. Muhammad Saleem Vighio  aAutomated Tool For Query Normalization & Elimination Of Redound Ancy     aNawabshah:bQUEST,c2016.  a43P, :  aABSTRACT


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.
  aDepartment of Information Technology  uhttps://tinyurl.com/ycxtxwpf  cTHESIS  00104070aRESEARCHbRESEARCHd2016-11-28l0pMP/13-131r2016-11-28 00:00:00yTHESIS  00104070aRESEARCHbRESEARCHd2018-10-01l0pMP/26-280r2018-10-01 00:00:00yTHESIS