H.S.Bhathiya(110059X) edited section_Conclusion_and_Future_Work__.tex  about 8 years ago

Commit id: fba5b8138baeefeeb2e7b8f460a63dbff57dab65

deletions | additions      

       

\section{Conclusion and Future Work}  Optimization is a challenging task in Databases. databases.  In Apache Derby it currently uses left-deep tree structures. But Bushy trees are much more computationally cost effective. Even though it is efficient, it is hard to implement it in the Derby. To give a solution to this issue we suggest using restricted separate sub queries of the original query initially and join them in a later step. In order to prove our solution we have evaluated and tested our solution with an Oracle Database with the Heuristic Approach we have chosen. Although this implementation outperform for smaller queries involving less number of table joins it is comparatively fast in queries with large number of table joins. As future work we plan to proof the concept with large data sets with higher number of table joins. And then we will implement the bushy tree solution for Derby using left-deep tree structures.\\