US 7,321,895 B2 | ||
Timeline condition support for an abstract database | ||
Richard D. Dettinger, Rochester, Minn. (US); and Daniel P. Kolz, Rochester, Minn. (US) | ||
Assigned to International Business Machines Corporation, Armonk, N.Y. (US) | ||
Filed on Jan. 14, 2005, as Appl. No. 11/35,710. | ||
Prior Publication US 2006/0161523 A1, Jul. 20, 2006 | ||
Int. Cl. G06F 17/00 (2006.01); G06F 17/30 (2006.01) |
U.S. Cl. 707—101 [707/3; 707/4] | 3 Claims |
1. A method for processing an abstract query that includes a temporal conditional expression, comprising:
receiving, from a requesting entity, an abstract query composed from a plurality of logical fields specified by a database
abstraction model, wherein each logical field has an access method mapping the logical field to data in an underlying physical
database, wherein the abstract query specifies (i) a set of conditional expressions, wherein each conditional expression includes
a logical field, a conditional operator, and a comparison value, and wherein at least one conditional expression specifies
a temporal operator relating the logical field and comparison value, and (ii) a set of logical fields defining result fields
for which query results, satisfying the set of conditional expressions, are returned;
generating an equivalent conditional expression corresponding to the at least one conditional expression, wherein the generated
equivalent conditional expression does not include the temporal operator, and wherein the equivalent conditional expression
is composed from numerical or logical operators;
merging other conditional expressions specified by the abstract query with the equivalent conditional expression;
generating, from the merged conditional expressions and the set of logical fields used to retrieve a set of query results,
a resolved query of the underlying physical database, wherein generating an equivalent conditional expression, merging other
conditional expressions with the equivalent conditional expression, and generating a resolved query of the underlying physical
database are done by operation of a computer processor;
issuing the resolved query to the underlying physical database to retrieve the set of query results; and
displaying a graphical representation of the set of query results that indicates a position of data elements included in the
query results on a timeline according to a timeline metadata included in at least one logical field.
|