Query conditions on related model entities

Details Query conditions on related model entities Query conditions on related model entities

2005-04-14

2009-08-25

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07580949

ABSTRACT:
Embodiments of the invention provide methods, systems and articles of manufacture for constructing a database abstraction model over an underlying physical database. Typically, queries of the database abstraction model are directed to queries of a model entity defined for the database abstraction model. To compose an abstract query, users select conditions evaluated using data associated with instances of the model entity. Using the database abstraction model, users may compose an abstract query according to logical or intuitive relationships among data elements stored in the underlying database. One addition to the database abstraction model is the ability to apply query criteria against related instances of a model entity. Because model entities may share a predefined relationship, embodiments of the invention allow for users to specify query criteria applied against related instances. Related instances may be identified by invoking a path function provided by the database abstraction model. A path function may be configured to return instances of the model entity that are related to an instance input to the path function.

REFERENCES:
patent: 5047923 (1991-09-01), Elstner et al.
patent: 5713014 (1998-01-01), Durflinger et al.
patent: 5734887 (1998-03-01), Kingberg et al.
patent: 6460043 (2002-10-01), Tabbara et al.
patent: 6687704 (2004-02-01), Russell
patent: 6725227 (2004-04-01), Li
patent: 7185016 (2007-02-01), Rasmussen
patent: 7185317 (2007-02-01), Fish et al.
patent: 7251653 (2007-07-01), Huang et al.
patent: 2002/0091681 (2002-07-01), Cras et al.
patent: 2003/0113727 (2003-06-01), Girn et al.
patent: 2003/0169284 (2003-09-01), Dettinger et al.
patent: 2004/0039736 (2004-02-01), Kilmer et al.
patent: 2004/0193579 (2004-09-01), Dettinger et al.
patent: 2006/0212418 (2006-09-01), Dettinger et al.
U.S. Appl. No. 10/083,075, “Application Portability and Extensibility Through Database Schema and Query Abstraction”, filed Feb. 26, 2002.
U.S. Appl. No. 11/005,418, “Abstract Query Plan”, filed Dec. 6, 2004.
U.S. Appl. No. 10/403,356, “Dealing with Composite Data Through Data Model Entities”, filed Mar. 31, 2003.

Affiliated with

Also associated with

Rating

Query conditions on related model entities does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query conditions on related model entities, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query conditions on related model entities will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4085301