Ted Eric Blank - San Jose CA Tammie Dang - Morgan Hill CA Fen-Ling Lin - San Jose CA Randy Mitchell Nakagawa - San Jose CA Bryan Frederick Smith - Morgan Hill CA Craig Leonard Sutton - Palo Alto CA Darren Benjamin Swank - Poughkeepsie NY Hong Sang Tie - San Jose CA Dino Carlo Tonelli - Marlboro NY Annie S. Tsang - Saratoga CA Kouhorng Allen Yang - Saratoga CA Kathryn Ruth Zeidenstein - San Jose CA
Assignee:
International Business Machines Corporation - Armonk NY
A method, apparatus, and article of manufacture for a computer-implemented apportioning system. Work is distributed to processors in a multi-processor system. Initially, during bind-time, a scaling factor is determined for each processor. The scaling factor represents relative processing power in relation to each other processor. Then, portions of a total amount of work are distributed to each processor based on the determined scaling factor of that processor and a determined amount of work for an average processor.
Optimization Of Sql Queries Using Filtering Predicates
Thomas A. Beavin - Milpitas CA Patrick M. Malone - Campbell CA Jerry Mukai - San Jose CA Randy M. Nakagawa - San Jose CA
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 1730
US Classification:
707 2, 707 4, 707 5
Abstract:
A technique for optimizing execution of a query that accesses data stored on a data store connected to a computer. Query predicates involving different data types are identified. A second query predicate is generated which includes matching data types, and if necessary, converted operators. The second query predicate with the matching data types and/or converted operators is executed to obtain a subset of records using an index manager or data manager. The subset of records is converted to the data types of the remaining query predicates. The first query predicate is applied against the subset of records to obtain a result, and the remaining query predicates of the original query are applied to the result of the first query predicate and any other additional converted query predicates to obtain a final result.
System And Method To Simulate Conditions And Drive Control-Flow In Software
Walter Duke Alvey - San Jose CA, US Priya Baliga - San Jose CA, US Ping Li - San Jose CA, US Randy Mitchell Nakagawa - San Jose CA, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 9/45
US Classification:
703 22, 717135
Abstract:
A method, information handling system, and computer program product to simulate conditions in a software module, by identifying, in the software module, whether a simulation environment has been activated, encountering a simulation point in the software module, the simulation point including one or more simulation parameters, and in response to identifying that the simulation environment has been activated and the simulation point has been encountered: invoking a simulation module, the invoking including passing the simulation parameters to the simulation module, comparing, at the simulation module, the simulation parameters with one or more active simulation entries, and returning a simulated condition from the simulation module to the software module in response to the comparing.
System And Method For Establishing Mutual Trust On A Per-Deployment Basis Between Two Software Modules
A system, method, and computer program product for establishing mutual trust on a per-deployment basis between two software modules. For example, the first software module may be a Websphere (WS) Information Integrator (II) deployment instance, and the second software module may be a plugin instance. By executing for this deployment an initial handshake between the software modules, both modules identify themselves and exchange digital certificates received from a trusted certification authority and respective public keys. Subsequent communications for this deployment between the software modules proceed with each module encrypting its communications with the public key of the other module; thereby establishing mutual trust between the software modules for each deployment.
Kimberly Anne Braia - San Jose CA Curt Lee Cotner - Gilroy CA Nelson Mendonca Mattos - San Jose CA Randy M. Nakagawa - San Jose CA Roy Lorenzo Smith - San Jose CA Jerome Quan Wong - Mountain View CA
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 1730
US Classification:
707 9
Abstract:
A method, apparatus, and article of manufacture for a computer implemented authorization system. A statement is to be executed by a computer to manipulate data in a database stored on a data storage device connected to the computer. Initially, an environment of the database from which the statement was invoked is identified. Additionally, a security option is identified. Then, authorization privileges for the statement are determined based on the identified environment and security option.
Access Path Selection For Sql With Variables In A Rdbms
Donald J. Haderle - Los Gatos CA Jerry Mukai - San Jose CA Randy Mitchell Nakagawa - San Jose CA Hong Sang Tie - Morgan Hill CA
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 1730
US Classification:
707 1
Abstract:
A method, apparatus, and article of manufacture for a computer implemented query compiler. A query is executed in a computer, the query being performed by the computer to retrieve data from a database stored on a data storage device connected to the computer. The query is received containing at least one variable. At execution time, a value is determined for each variable in the query. A filter factor is estimated using the determined value for each variable. Then, an access path is determined for the query using the estimated filter factor.
Determining The Optimal Access Path For A Query At Execution Time Using An Actual Value For Each Variable In A Query For Estimating A Filter Factor
Donald J. Haderle - Los Gatos CA Jerry Mukai - San Jose CA Randy Mitchell Nakagawa - San Jose CA Hong Sang Tie - Morgan Hill CA
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 1730
US Classification:
707 4
Abstract:
A method, apparatus, and article of manufacture for a computer implemented query compiler. A query is executed in a computer, the query being performed by the computer to retrieve data from a database stored on a data storage device connected to the computer. The query is received containing at least one variable. At execution time, a value is determined for each variable in the query. A filter factor is estimated using the determined value for each variable. Then, an access path is determined for the query using the estimated filter factor.