Abstract: An abstraction layer (50) is provided for facilitating accessing a database (10) containing database records each including a plurality of fields stored in one or more tables (12, 14). The abstraction layer (50) includes a control table (52) containing control records corresponding to database fields. Each control record contains metadata associated with the corresponding database field. The abstraction layer (50) also includes at least one additional table (54, 56, 58, 60, 62, 64, 66, 70, 72, 74, 80) 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 (30) accesses the database (10) using metadata obtained from the abstraction layer (50).
Type:
Application
Filed:
July 24, 2003
Publication date:
January 27, 2005
Inventors:
Naga Ayachitula, JoAnn Brereton, Adarsh Gupta, Michael Schwartz
Abstract: A software program (12) is configured to initiate, process, and terminate user sessions (22, 26). A resource deallocation module (50) is linked to the software program (12) 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 (40) is invoked by the software program with respect to said user session subsequent to the deallocation performed by the resource deallocation module (50) and prior to the termination of said user session.
Type:
Application
Filed:
July 28, 2003
Publication date:
February 3, 2005
Inventors:
Naga Ayachitula, JoAnn Brereton, Shu-Ping Chang, Michael Schwartz
Abstract: 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.
Type:
Grant
Filed:
November 15, 2013
Date of Patent:
July 9, 2019
Assignee:
International Business Machines Corporation
Abstract: 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.
Type:
Application
Filed:
September 5, 2013
Publication date:
March 5, 2015
Applicant:
International Business Machines Corporation
Abstract: 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.
Type:
Grant
Filed:
September 5, 2013
Date of Patent:
July 9, 2019
Assignee:
International Business Machines Corporation
Abstract: 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.
Type:
Application
Filed:
November 15, 2013
Publication date:
March 5, 2015
Applicant:
International Business Machines Corporation
Abstract: 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.
Type:
Grant
Filed:
April 9, 1999
Date of Patent:
January 22, 2002
Assignee:
International Business Machines Corporation
Inventors:
Anna Rosa Coden, JoAnn Piersa Brereton, Michael Stephen Schwartz
Abstract: 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.
Type:
Grant
Filed:
June 30, 1998
Date of Patent:
October 3, 2000
Assignee:
International Business Machines Corporation
Inventors:
JoAnn Piersa Brereton, Anna Rosa Coden, Michael Stephen Schwartz
Abstract: An aspect of product recommendation processes includes classifying customers into groups based on commonly shared, predefined characteristics and common financial transaction activities conducted. For each service offered, the product recommendation processes include estimating a cost of recommendation of the service; and estimating, for each of the customers in a group, a transaction risk of providing the service.
Type:
Application
Filed:
September 16, 2013
Publication date:
March 19, 2015
Applicant:
International Business Machines Corporation
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: Embodiments relate to a transactional risk daily limit (TRDL) update alarm. Customer data including historical transaction data and customer profile data is accessed, along with economic data from an external data source. A TRDL alarm analytics model is applied to the customer data and the economic data to predict a number of transactions in a specified time period that are expected to exceed a TRDL. The TRDL alarm analytics model takes into account a payment transaction pattern associated with the customer. A threshold value is compared to the number of transactions in the specified time period that are expected to exceed the TRDL. An increase in the TRDL is requested to be applied at least during the specified time period based on the number of transactions in the specified time period that are expected to exceed the TRDL being greater than the threshold value.
Type:
Application
Filed:
September 16, 2013
Publication date:
March 19, 2015
Applicant:
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: Disclosed is a device for recording evoked neural responses. The device comprises: a plurality of electrodes including one or more stimulus electrodes, a first sense electrode, and a second sense electrode; a stimulus source for providing a stimulus to be delivered via the one or more stimulus electrodes to a neural pathway in order to evoke a compound action potential on the neural pathway; measurement circuitry for processing a signal sensed at the first sense electrode and second sense electrode, the sensed signal comprising the evoked compound action potential; and impedance compensation means configured to compensate for an impedance difference, the impedance difference being a difference between an impedance associated with the first sense electrode and an impedance associated with the second sense electrode.
Type:
Application
Filed:
April 14, 2022
Publication date:
June 13, 2024
Applicant:
Saluda Medical Pty Ltd
Inventors:
Peter Scott Vallack Single, Jonathan Brereton Scott, Joanne Carol Shiels Olecko
Abstract: An aspect of product pricing includes classifying customers into groups based on shared, predefined characteristics and financial transactions, and identifying services rendered and available but not rendered. For each customer, a risk associated with a service is estimated; availability and prices of the service by third parties are determined; a price for the service set by the entity is compared with the prices set by the third parties; and a demand for the service of the entity is estimated as a function of the availability and prices of the service by the third parties. For each customer, a probability that the customer will purchase the service is estimated based on the demand, and a price for the service that is customized for the customer is calculated, as a function of the risk, the demand, and the probability of purchase, and in view of a target profit and/or target revenue.
Type:
Application
Filed:
September 16, 2013
Publication date:
March 19, 2015
Applicant:
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: Embodiments relate to a transactional risk daily limit (TRDL) update alarm. Customer data including historical transaction data and customer profile data is accessed, along with economic data from an external data source. A TRDL alarm analytics model is applied to the customer data and the economic data to predict a number of transactions in a specified time period that are expected to exceed a TRDL. The TRDL alarm analytics model takes into account a payment transaction pattern associated with the customer. A threshold value is compared to the number of transactions in the specified time period that are expected to exceed the TRDL. An increase in the TRDL is requested to be applied at least during the specified time period based on the number of transactions in the specified time period that are expected to exceed the TRDL being greater than the threshold value.
Type:
Application
Filed:
January 16, 2014
Publication date:
March 19, 2015
Applicant:
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: Embodiments relate to analytics-driven automated reconciliation of financial transactions. External information is correlated with a plurality of financial transaction reconciliation exceptions associated with a sequence of financial transactions over a period of time. A plurality of causal factors is identified from the external information associated with a pattern of the financial transaction reconciliation exceptions. A plurality of more recent financial transactions is monitored for the causal factors. An exception prediction alert is issued based on identifying the causal factors in the more recent financial transactions prior to detecting a new financial transaction reconciliation exception associated with the more recent financial transactions.
Type:
Application
Filed:
January 15, 2014
Publication date:
March 19, 2015
Applicant:
International Business Machines Corporation
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: Embodiments relate to intraday cash flow optimization. Transactions are accessed on a business-to-business integration network from a plurality of sources linked with payment delivery system data from a financial service system. The transactions are associated with two or more compartmentalized entities. The transactions are characterizes based on the payment delivery system data and an analysis of customer profile data. The transactions associated with two or more compartmentalized entities are linked as integrated information based on the characterizing of the transactions. An intraday receivables prediction engine and an intraday payables prediction engine are applied to the integrated information to produce an estimation of intraday cash flow. The estimation of intraday cash flow is monitored relative to intraday operations optimization conditions. An alert is generated based on determining that at least one of the intraday operations optimization conditions is met.
Type:
Application
Filed:
January 15, 2014
Publication date:
March 19, 2015
Applicant:
International Business Machines Corporation
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: Embodiments relate to intraday cash flow optimization. Transactions are accessed on a business-to-business integration network from a plurality of sources linked with payment delivery system data from a financial service system. The transactions are associated with two or more compartmentalized entities. The transactions are characterizes based on the payment delivery system data and an analysis of customer profile data. The transactions associated with two or more compartmentalized entities are linked as integrated information based on the characterizing of the transactions. An intraday receivables prediction engine and an intraday payables prediction engine are applied to the integrated information to produce an estimation of intraday cash flow. The estimation of intraday cash flow is monitored relative to intraday operations optimization conditions. An alert is generated based on determining that at least one of the intraday operations optimization conditions is met.
Type:
Application
Filed:
September 16, 2013
Publication date:
March 19, 2015
Applicant:
International Business Machines Corporation
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: Embodiments relate to analytics driven assessment of transactional risk daily limits (TRDLs). Customer data that includes historical transaction data and customer profile data associated with a customer is accessed by a processor. Economic data from an external data source is accessed via a network. A TRDL assessment model is applied, by a processor, to the customer data and the economic data to generate a TRDL for the customer.
Type:
Application
Filed:
January 16, 2014
Publication date:
March 19, 2015
Applicant:
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: Embodiments relate to analytics driven assessment of transactional risk daily limit (TRDL) exceptions. A transaction that includes a request to make a payment from an account associated with a customer is received and it is determined that processing the payment will result in exceeding a TRDL. Customer data including historical transaction data and customer profile data associated with the customer is accessed by a processor. Economic data from an external data source is accessed via a network from an external data source. A TRDL exception assessment model is applied, by the processor, to the transaction, the customer data, and the economic data to generate an approval recommendation for the request and a confidence level associated with the approval recommendation.
Type:
Application
Filed:
September 16, 2013
Publication date:
March 19, 2015
Applicant:
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: An aspect of customer selection processes includes classifying, by a computer processor, customers of an entity into groups based on commonly shared, predefined characteristics among the customers. For each of the groups: services rendered for corresponding customers are identified; for each of the services rendered, a risk relationship and a reward relationship between each of the corresponding customers and the service is determined; and for each of the services rendered, a score that defines a combination of the risk relationship and the reward relationship is calculated. For each of the services rendered by the entity, the corresponding score is applied to a candidate customer having a set of characteristics matching the characteristics of one of the groups, and the service is offered to the candidate customer as a function of the score.
Type:
Application
Filed:
January 31, 2014
Publication date:
March 19, 2015
Applicant:
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian
Abstract: An aspect of product pricing includes classifying customers into groups based on shared, predefined characteristics and financial transactions, and identifying services rendered and available but not rendered. For each customer, a risk associated with a service is estimated; availability and prices of the service by third parties are determined; a price for the service set by the entity is compared with the prices set by the third parties; and a demand for the service of the entity is estimated as a function of the availability and prices of the service by the third parties. For each customer, a probability that the customer will purchase the service is estimated based on the demand, and a price for the service that is customized for the customer is calculated, as a function of the risk, the demand, and the probability of purchase, and in view of a target profit and/or target revenue.
Type:
Application
Filed:
January 31, 2014
Publication date:
March 19, 2015
Applicant:
International Business Machines Corporation
Inventors:
JoAnn P. Brereton, Arun Hampapur, Hongfei Li, Robin Lougee, Buyue Qian