International Business Machines Corporation

Paul Miller Bird

Walid Rjaibi

Curt Lee Cotner

David C Kalmuk

Timothy Jon Vincent

Michael Joshua Snowbell

James Willis Pickel

Scott Douglas Walkty

Yuk Kuen Chan

Tammie Dang

William Robert Bireley

Margaret Ann Dong

Stephen Rees

Georgia Carroll Fuller

Gayathiri R Chandran

Yin Ling Cheung

Adrian B Lobo

Scott Ian Logan

Michelle D Lam

Frankie K Sun

David Louis Kaminsky

Rakesh Agrawal

Peter Bergersen Yocom

Sam Sampson Lightstone

Matthew Albert Huras

Xun Xue

Gerald George Kiernan

Yao-Ching Stephen Chen

Patrick Dantressangle

Gary Valentin

Donna N Eng Dillenberger

Hebert Walter Pereyra

Tyrone W A Grandison

Douglas James Doole

Mark Francis Hulber

David C Manners

Allen William Luniewski

Catharina K Wong

George Gerald Kiernan

Michael A F Stuy

Yeung-Kuen See

Francis Wong

Jesse Lee

Yuk-kuen Chan

A middleware processor provisioning process provisions a plurality of processors in a multi-processor environment. The processors themselves may be subdivided in to one or more partitions or processing instances for which a single processing queue is created and a single kernel thread is started. User processing requests are portioned and dispatched across the plurality of processing queues and are serviced by the corresponding kernel process, thereby efficiently using available processing resources while servicing the user processing requests in a desired manner.

Processor provisioning by a middleware processing system

A middleware processor provisioning process provisions a plurality of processors in a multi-processor environment. The processing capability of the multiprocessor environment is subdivided and multiple instances of service applications start protected processes to service a plurality of user processing requests, where the number of protected processes may exceed the number of processors. A single processing queue is created for each processor. User processing requests are portioned and dispatched across the plurality of processing queues and are serviced by protected processes from corresponding service applications, thereby efficiently using available processing resources while servicing the user processing requests in a desired manner.

Processor provisioning by a middleware processing system for a plurality of logical processor partitions

According to an embodiment of the present invention, a system assigns at least one workload a hard share quantity and at least one other workload a soft share quantity or a hard share quantity. The system allocates a resource to the workloads based on the hard share quantity and the soft share quantity of active workloads in a predefined interval. A hard share quantity indicates a maximum resource allocation and a soft share quantity enables allocation of additional available processor time. Embodiments of the present invention further include a method and computer program product for allocating a resource to workloads in substantially the same manner as described above.

Adaptive resource usage limits for workload management

Disclosed is a data processing system-implemented method, a data processing system and an article of manufacture for controlling access to data stored on a database having relational objects for which access restrictions are defined for elements of the relational objects The data processing system-implemented method includes receiving a user request to access one or more relational objects of the database, identifying any access restrictions defined for the one or more relational objects, determining whether any identified access restrictions are applicable to the user request, determining whether any determined applicable access restrictions are to be enforced for the user request, and allowing access to the one or more relational objects based on the determined enforceable access restrictions.

Method for implementing fine-grained access control using access restrictions

A monitoring of a server system during an execution of a server system processing logic, includes: during collection and storage of operational metrics by a given thread in a thread-local memory, determining that a checkpoint within the server system processing logic is reached; determining whether a threshold number of checkpoints have been encountered by the given thread; in response to the threshold number of checkpoints having been encountered, determining whether a threshold time interval since a last rollup of the collected operational metrics has been exceeded; and in response to the threshold time interval being exceeded, performing a rollup of the collected operational metrics from the thread-local memory to an accumulation point in a shared memory, where the accumulation point stores aggregated operational metrics from a plurality of threads.

Efficient monitoring in a software system

According to one embodiment of the present invention, a system, method and computer program product is provided for integrating an external workload manager with a database system. The method according to one embodiment includes a method comprises: receiving a request in a database component, the request including a cross component token; starting a new unit of work in workload management software in the database component, in response to the request; determining, from a cross component workload management unit, a transaction class and a synchronization code using the database component; finding an internal workload in the workload management software that matches the transaction class and the synchronization code of the cross component workload management unit; and using the matching internal workload for the new unit of work.

Efficient integration between an external workload manager and an RDBMS

Disclosed is a data processing-implemented method, a data processing system, and an article of manufacture for modifying a query during compilation of the query. The query includes a request for an element of data from a table in a database and parameters identifying the requested element. The data processing-implemented method includes determining available information from parameters for locating a classification of the requested element and a classification associated with the query, the requested data classification controlling access to the requested element according to the query associated classification, requesting a suggested action from an external system for obtaining a comparison of the requested data classification and the query associated classification based on the available information, receiving the suggested action from the external system responsive to the sent request, and incorporating the suggested action into the query, the suggested action effecting comparison of the requested data classification with the query associated classification.

Method for modifying a query by use of an external system for managing assignment of user and data classifications

A method and system for controlling access to data stored in a table of a database are provided. The method includes marking the table of the database as being protected with fine-grained access control (FGAC), creating a system authorization class for the table of the database, the system authorization class having a default row authorization that prevents access to all rows in the table, the system authorization class being unmodifiable, creating a user authorization class for the table of the database, the user authorization class having a default row authorization that prevents access to all rows in the table, the user authorization class being modifiable, and associating the system authorization class and the user authorization class with the table of the database.

Method and system for using fine-grained access control (FGAC) to control access to data in a database

A method and system for improving access concurrency to information stored in at least one table in a relational database system is disclosed. The method comprises providing a data cache, which stores a portion of the at least one table. The data cache includes a plurality of cache entries, wherein each cache entry comprises a first data item, a second data item, and a cache entry state. The method further comprises retrieving from the at least one table and storing in a cache entry's first data item a representation of committed information for a user, and retrieving from the at least one table and storing in the cache entry's second data item a representation of changes applied to the committed information, but not yet committed in the database system.

Access concurrency for cached authorization information in relational database systems

In a system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.

Computer-readable medium to multiplex multiple application server requests over a single database connection

Growing community of inventors

Markham, Canada

Paul Miller Bird