International Business Machines Corporation

Ibm Canada Limited - Ibm Canada Limitee

Fen Wang

Victor Chan

Mark William Hubbard

Aalim Lakhani

Daisy Tan

Mark W Hubbard

Embodiments of the present invention address deficiencies of the art in respect to inventory management and provide a method, system and computer program product for multi-tier inventory visibility. In one embodiment of the invention, a multi-tier inventory management data processing system can include an inventory management system coupled to one or more e-commerce applications over an enterprise bus, and multiple different instances of a tier inventory component, each of the instances corresponding to a local inventory cache. Each instance can include program code enabled to manage the local inventory cache and an inventory management API exposing inventory operations on the local inventory cache to other instances of the tier inventory component.

Multi-tier inventory visibility

A system and method of composing a query object for application against a database is provided. The method composes a selection clause for the query. Next, a criteria clause for the query is generated, with the criteria clause comprising input criteria related to the query, additional criteria specified against the query, and generated criteria based on a joint relationship. Next a source clause utilizing elements in the database accessed by the query is generated. A database traversal system and method is provided. The method identifies all tables directly accessible by each table and creates a data structure comprising an entry for each table. The entry comprises an identification field for each table and a link field identifying all tables directly accessible by each table. The data structure is traversed and an optimum path of the traversal paths utilizing data obtained from traversing the data structure is identified.

Method and system for composing a query for a database and traversing the database

Growing community of inventors

Toronto, Canada

Fen Wang