International Business Machines Corporation

JoAnn Piersa Brereton

Michael Stephen Schwartz

Arun Hampapur

Ke Zhang

Xuan Liu

Ajay Ashok Deshpande

Eoin Lane

Christopher Scott Milite

Yingjie Li

Jae-Eun Park

Naga A Ayachitula

Hongliang Fei

Alan Jonathan King

Xiao Mei Zheng

Miao He

Songhua Xing

Kimberly D Hendrix

Anna Rosa Coden

Vadiraja S Ramamurthy

Steve Igrejas

Joline Ann Villaranda Uichanco

Shu-Ping Chang

Adarsh Gupta

A simulator is configured to simulate the fulfillment of orders by nodes. Each node has an inventory of products and is capable of shipping the products to destinations in response to receipt of a corresponding order. The simulator divides the nodes into groups and assigns a different priority to each group based on input provided by a user to the simulator to generate an ordered sequence of priorities. The simulator maintains safety stock data corresponding to each node that indicates minimum quantities of the products required to be present at the corresponding node. The simulator selects a current priority of the sequence and next simulates a first group among the groups having the current priority fulfilling the orders for a given product among the products while a quantity of the given product at each of the nodes in the first group is below the minimum quantity in the corresponding safety stock data.

Big data sourcing simulator

A method, system and computer-usable medium are disclosed for understanding and discovering relationships within infrastructure systems via an infrastructure management system. In certain embodiments, the infrastructure systems comprise water and/or transportation systems. Such an infrastructure management system enables accidents to be prevented, traffic to flow normally, water to be conserved, cleaned and delivered safely.

Method of using graphical index maps to provide automated relationship discovery and impact analyses

A software program () is configured to initiate, process, and terminate user sessions (). A resource deallocation module () is linked to the software program () to deallocate allocated external resources of each object of a user session responsive to an impending termination of said user session. An automatic memory management module () is invoked by the software program with respect to said user session subsequent to the deallocation performed by the resource deallocation module () and prior to the termination of said user session.

Method and system for resolving memory leaks and releasing obsolete resources from user session data

An abstraction layer () is provided for facilitating accessing a database () containing database records each including a plurality of fields stored in one or more tables (). The abstraction layer () includes a control table () containing control records corresponding to database fields. Each control record contains metadata associated with the corresponding database field. The abstraction layer () also includes at least one additional table () containing additional metadata. Each database field is selectively associated with one or more selected portions of the additional metadata through metadata contained in the control record corresponding to the database field. A user database application () accesses the database () using metadata obtained from the abstraction layer ().

Data abstraction layer for a database

Query objects are created by a client process. The query objects have one or more sub-query objects and one or more execute methods that are capable of operating on their respective query object to produce one or more query expressions. All of the execute methods are capable of producing the respective query expression that is compatible with a structured query language. A compound query contains one or more boolean expressions of one or more of the query objects. The compound query has one or more compound execute methods which invoke one or more the execute methods of each of the query objects. Each of the execute methods returns their respective query expression and the compound execute method uses one or more common table expressions to combine the query expressions to form a single compound query expression that represents the boolean expression. This single expression can be execute against a database to return a result without executing any of the query expressions against the database individually.

System and method for performance complex heterogeneous database queries using a single SQL expression

A method and data processing system are disclosed for translating an ad-hoc user input string into Structured Query Language. A user input string is parsed placing joiner objects and left parentheses into a temporary pushdown stack and placing query clause objects into a postfix queue. After encountering a query clause object or a right parenthesis, the next item in the pushdown stack is placed in the postfix queue if it is a joiner object. Once the input string is parsed, objects in the postfix queue are placed into a second temporary pushdown stack and also used to form common table expressions using adjacent items in the second pushdown stack. Finally, an SQL SELECT statement is formed using a JOIN on the ids returned by the common table expressions.

Method and system for translating an ad-hoc query language using common

Growing community of inventors

Hawthorne, NY, United States of America

JoAnn Piersa Brereton