公开(公告)号：GB2461818A

公开(公告)日：2010-01-20

申请号：GB0914797

申请日：2009-08-25

Applicant: IBM

Inventor： KARN HOLGER ,  STEINBACH TORSTEN

IPC: G06F17/30

Abstract: A method identifying a client application (A1) in a database system (18), the method comprising the steps of:collecting historical data on database transactions (DT) in the database system (18) (step 210);identifying identical database transactions (DT) by assigning unique transaction identifiers (TI) to them (step 212);analyzing patterns of occurrence of said transaction identifiers (TI) (step 214);mapping said patterns of transaction identifiers (TI) to client applications (A1) (step 216). In a preferred embodiment of the invention, identical database transactions are identified by reducing incoming sequences (40) of SQL statements (50) to their basic structures (60) (step 114) and defining transaction identifiers (TI) based on the basic structures (60) of the sequences (40) (step 116).

公开(公告)号：GB2527081A

公开(公告)日：2015-12-16

申请号：GB201410350

申请日：2014-06-11

Applicant: IBM

Inventor： FINNIE JAMES LIAM ,  STEINBACH TORSTEN ,  WURST MICHAEL

IPC: G06F17/30 ,  G06F9/50

Abstract: A method for managing resource consumption in a computing system where the resources are consumed by a plurality of user-defined functions (UDF) performing tasks for a database management system, wherein the UDFs are executed by a plurality of processes external to the database management system. The method comprises providing a resource policy by defining a plurality of threshold values relating to the resource consumption and performing an action e.g. queuing, rejection, suspension, as defined by the policy, on at least one of the UDF. The UDF may run fenced, meaning that they are not executed within the same process as the main database engine but rather by a separate external process i.e. its resource consumption is not controlled by the database management system. The resource policy may denote a rule or set of rules relating to one or more resources of a computing system together with a threshold value for the related resource and an action to invoke if threshold is exceeded.

公开(公告)号：GB2459354A

公开(公告)日：2009-10-28

申请号：GB0905817

申请日：2009-04-03

Applicant: IBM

Inventor： STOLZE KNUT ,  DRAESE OLIVER ,  STAEBLER BENNO ,  STEINBACH TORSTEN

IPC: G06F17/30

Abstract: Emulating a plurality of databases (logical databases 205, 206, 207) using a single physical database 208. A database system (110, fig 1) comprising a plurality of databases (103, fig 1) on a plurality of servers, each database coupled to at least one application 201-203 (101, fig 1) of a set of applications. Consolidation of such a system to a single physical database comprises substituting all logical names from the plurality of databases with a unique physical name for all the plurality of databases. A mapping catalogue (106, fig 1; 316, fig 3) is created which comprises the logical names and their assigned unique physical names, the mapping catalogue being located in a physical layer. Each database is saved with its unique physical names into a different segment 209-211 of the single database 208, the single database being located in the physical layer. A consolidation layer 204 is provided which is coupled to each application 201-203. A separate consolidation layer (105, fig 1; 306-310, fig 3) is provided for each application and is coupled to the mapping catalogue and to the single database. The consolidation layer is adapted to receive queries from the applications, search the mapping catalog, rewrite the queries and forward the rewritten queries to the single database. The response from the single database may also be rewritten. The plurality of databases are simulated as logical databases and consolidation is transparent for the applications.