2017•Unpublished venueRequires access

An Efficient Query Optimization for Object Oriented Database

Bharti Joshi, Rustom D. Morena

Open publisher page 1 citations

Abstract

Query processing in Object Oriented Database management system is an active research area. Query Optimizer is very complex module in query processing which is programmed to optimize query execution. In this paper the design and implementation of Query Optimizer using C# .NET of Object Oriented databases is described. A novel method “Extent_Hash Search” for direct access in object oriented database is proposed. In the proposed method, a query is searched using the ExtentIds which shows an improvement with respect to earlier query optimization techniques. Same method gives better performance for nested query too.

About this research paper

What this paper is about

Query processing in Object Oriented Database management system is an active research area. Query Optimizer is very complex module in query processing which is programmed to optimize query execution. In this paper the design and implementation of Query Optimizer using C# .NET of Object Oriented databases is described. A novel method “Extent_Hash Search” for direct access in object oriented database is proposed. In the proposed method, a query is searched using the ExtentIds which shows an improvement with respect to earlier query optimization techniques. Same method gives better performance for nested query too.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Query processing in Object Oriented Database management system is an active research area. Query Optimizer is very complex module in query processing which is programmed to optimize query execution. In this paper the design and implementation of Query Optimizer using C# .NET of Object Oriented databases is described. A novel method “Extent_Hash Search” for direct access in object oriented database is proposed. In the proposed method, a query is searched using the ExtentIds which shows an improvement with respect to earlier query optimization techniques. Same method gives better performance for nested query too.

Key concepts: Computer science, Query optimization, View, Sargable, Database theory, Database, Information retrieval, Query language

Related papers

Back to paper searchBrowse research topicsOriginal source
An Efficient Query Optimization for Object Oriented Database — Research Paper | ScholarLens