Novel Strategies to Speed-Up Query Response
MetadataShow full item record
Intuitive but completely novel strategies have been proposed which provides noteworthy improvement in reducing the query response time, assuming a database is designed in third or higher normal form to avoid obvious design pitfalls. In query construction, the Cartesian product has been replaced by a novel substitution approach, which reduces both the query execution time and space many order magnitudes compared to the traditional approaches, along with other benefits. We had implemented many database-applications with the proposed paradigm to cope with the practical bottlenecks of the database-systems. Hence the proposed paradigm had been rigorously and positively tested for its practical usefulness. The proposed substitution based paradigm, compared to the traditional query execution by Cartesian approach, performs faster and effective having both time and space complexities reduced significantly.
Research Journal of Information Technology
© 2010 Academic Journals Inc. The attached file is reproduced here in accordance with the copyright policy of the publisher. Please refer to the journal's website for access to the definitive, published version.