Abstract
Databases are fundamental part of managing data. Storing multimedia-based objects like graphics image, videos, audio, etc in databases is a basic need of everyday users. However, storing these objects in the relational databases is not possible because relational databases support single value data. To store these complex objects, object-oriented databases were introduced. Object-oriented databases support all the features of object-oriented programming languages, such as, inheritance, encapsulation, polymorphism, etc, along with other features of the databases. This project provides an introduction to the object-oriented databases along with its features, design of an object model and design of the classes, objects and queries. Another major functionality of a database is to respond to the users, i.e., process user queries. Efficiency with speed is an important feature in today’s market. So there is a need to properly process and optimize a query. This project provides the basic idea of hydrid-hash pointer (HP) based approach and multiwavefront (MW) approach for processing the queries. The focus of this project is to design an optimization function and implement this function on Select and Join queries. This project analyzes the performance of the Select and Join queries. Performance factors will include query execution time, memory space requirement and response time. This project makes recommendations for novice object-oriented database developers in developing applications where data retrieval time (execution time plus response time) is an important factor.