Patents by Inventor John Dietel

John Dietel has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Publication number: 20070112827
    Abstract: A method, system and article of manufacture for processing rule sets and, more particularly, for processing abstract rule sets having one or more abstract rules. One embodiment provides a computer-implemented method of generating recommendations using a suitable rules engine. The method comprises retrieving an abstract rule having a conditional statement and a consequential statement. The consequential statement defines a particular recommendation that is returned when the conditional statement is satisfied. The conditional statement and the consequential statement are defined using logical field definitions defined in an abstraction model that models underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model. The method further comprises transforming the abstract rule into a transformed rule; and executing, by the rules engine, the transformed rule.
    Type: Application
    Filed: November 10, 2005
    Publication date: May 17, 2007
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Richard Dettinger, John Dietel, Daniel Kolz, Jeffrey Tenner
  • Publication number: 20060195437
    Abstract: Methods, apparatuses, and computer program products for materialized query table matching are provided that include receiving a database query, retrieving a materialized query table (MQT) from data storage accessible to a database management system, selecting a join in the materialized query table between a table that is not invoked by the query and a table that is invoked in the query, determining whether the selected join is lossless, and expanding the query to include the lossless join if the selected join is lossless, expanding the query to include the lossless join. Determining whether the selected join is lossless may be carried out by losslessly joining the table that is not invoked by the query to the query, and determining whether the lossless join to the query matches the selected join of the materialized query table.
    Type: Application
    Filed: February 28, 2005
    Publication date: August 31, 2006
    Applicant: International Business Machines Corporation
    Inventor: John Dietel
  • Publication number: 20050160102
    Abstract: A relational database system analyzes each potential join in a query, to determine whether a relation involved in the join is subject to a selection criterion, and evaluate whether that selection criterion or the join per se effects a join reduction. The computational expense of generating a look-ahead predicate comprising the tuples of the second relation matching any applicable selection criterion, is compared to the computational savings that result from the join reduction. The most beneficial look-ahead predicate among all potential joins of relations in the query is identified through iterative analysis of all possible joins.
    Type: Application
    Filed: January 15, 2004
    Publication date: July 21, 2005
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Abdo Abdo, Robert Bestgen, John Dietel
  • Publication number: 20050086208
    Abstract: An apparatus, program product and method utilize a query optimizer that identifies Join types in a query plan that can be replaced to facilitate optimization of the plan. If the query plan is considered to have a tree-graph representation, then the optimizer locates Join nodes to be replaced and substitutes an Inner Join node and additional nodes that do not inhibit optimization strategies and algorithms. As a result, all Outer Joins, whether left or right, and all Exception Joins, whether left or right, can be removed from the query plan before performing optimizations such as predicate movement, GROUP BY movement, ORDER BY movement, and Join enumeration.
    Type: Application
    Filed: October 16, 2003
    Publication date: April 21, 2005
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Robert Bestgen, John Dietel, Robert Downer