公开(公告)号：GB2461817A

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

申请号：GB0914786

申请日：2009-08-25

Applicant: IBM

Inventor： KARN HOLGER ,  OSTLER PAUL

IPC: G06F17/30

Abstract: A method comprising the steps ofidentifying incoming sequences (40) of SQL statements (50) to the database system (18) (step 112);reducing the incoming sequences (40) of SQL statements (50) to their basic structures (60) (step 114);defining transaction identifiers (TI) based on the basic structures (60) of the sequences (40) (step 116). In a preferred embodiment of the invention, during the reduction step (114) statements (50) of the incoming sequence (40) are copied into the basic structure occurring (60) in the order of their first occurrence within the sequence (40), and all repeated occurrences of these SQL statements (50) are ignored.

公开(公告)号：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).