Comparative Analysis of Query Optimization in the Object-Oriented Database & Relational Databases Using Clauses

Provided by: International Journal of Advanced Research in Computer Science and Software Engineering (IJARCSSE)
Topic: Data Management
Format: PDF
In this paper, the authors present an approach using database clauses that permits to enrich technique of query optimization existing in the object-oriented databases and the comparative analysis of query optimization for relational databases and object oriented database based on cost, cardinality and no of bytes. Focus is on queries using where, group-by and having clauses. Their experimental study shows that the improvement in the quality of plans is significant only with decrease in cost.

Find By Topic