Patent ID: 8612468
Filing Date: 2013-12-17
Classification: G06F

Abstract:
1. A method of generating a relational query for retrieving data from a relational database management system comprising: receiving, from an object-oriented environment including at least one object model that identifies a set of data objects, an object query containing at least one logical object description in an expression language having predetermined constructs and corresponding developer meta data, wherein the at least one logical object description includes mapping definitions for corresponding object attributes which do not map directly to a column in a database table in a relational database management system (RDBMS) and wherein the corresponding developer meta data includes translation rules written in the expression language that are used to convert the at least one logical object description to corresponding logical relations in the RDBMS; retrieving, from a mapping schema stored in an object relational layer, mappin meta data including (i) object-to-relational mapping information, and (ii) object-to-object mapping information that corresponds to the object query, wherein the mapping meta data describes relationships between objects defined in one or more of the at least one object model and database tables in the RDBMS; determining whether one or more of the at least one logical object description are received more than a predetermined number of times within a time period and, if so determined, generating new instances of object-to-object mapping information based on the one or more of the at least one logical description to add the new instances to the mapping meta data; and translating the object query to an equivalent relational query using the mapping meta data and the developer meta data for retrieving data from the relational database management system to satisfy the object query.