International Business Machines Corporation

Chih-Cheng Hsu

David Joseph Wisneski

George F Hongell

Harisch R Nayak

Methods and apparatus for executing a query on dynamic properties of a plurality of objects in a database are provided. In one implementation, the method includes obtaining a query; determining that a first portion of the query comprises a method for accessing a dynamic property of the plurality of objects; obtaining mapping data associated with the dynamic property of the plurality of objects, the mapping data mapping the dynamic property to a pre-determined location in the database; translating the first portion of the query in accordance with the mapping data such that the first portion of the query is executable against the pre-determined location in the database without creating instances of the plurality of objects; executing the query including executing the translated first portion of the query without creating instances of the plurality of objects; and displaying a result of the executed query to a user.

Method and apparatus for executing a query on dynamic properties of objects in a database

The present invention provides a method and system for a query on dynamic properties of objects. The method includes: obtaining a query; determining that the query pertains to at least one mapped dynamic property; obtaining mapping data for the at least one mapped dynamic property; and translating the query for the at least one mapped dynamic property according to the mapping data to run against a database. The method uses the stored mapping data of the dynamic property to translate the query on the mapped dynamic property such that it may be run against the database. In this manner, queries on mapped dynamic properties are performed through pushdown rather than in object space. This increases the efficiency of the queries.

Growing community of inventors

Los Angeles, CA, United States of America

Chih-Cheng Hsu