Patent application number | Description | Published |
20130325826 | MATCHING TRANSACTIONS IN MULTI-LEVEL RECORDS - A method for identifying matching transactions between two log files where each transaction includes one or more statements. Each log file record records the execution of a statement and includes a transaction identifier. Each record in turn in one log file is compared to an advancing window of records in the other log file. A first table contains associations of statements to transactions and transactions to statements for records in the window. If a match is found between a record in the one file and a record in the window, information associating partial transactions in the one file to potential transactions of the records in the window is added to a second table. If an end-of-transaction record is read from the one file, a best match is found between the ended transaction and the potential transactions based on information in the first and second tables. | 12-05-2013 |
20130325829 | MATCHING TRANSACTIONS IN MULTI-LEVEL RECORDS - A method for identifying matching transactions between two log files where each transaction includes one or more statements. Each log file record records the execution of a statement and includes a transaction identifier. Each record in turn in one log file is compared to an advancing window of records in the other log file. A first table contains associations of statements to transactions and transactions to statements for records in the window. If a match is found between a record in the one file and a record in the window, information associating partial transactions in the one file to potential transactions of the records in the window is added to a second table. If an end-of-transaction record is read from the one file, a best match is found between the ended transaction and the potential transactions based on information in the first and second tables. | 12-05-2013 |
20140236976 | MATCH WINDOW SIZE FOR MATCHING MULTI-LEVEL TRANSACTIONS BETWEEN LOG FILES - A predefined number of matches is identified between records in a first file and records in a second file. For the matches, determine the span of the actual range of record positions in the second file relative to the positions of the operation records in the first file within which all matches were found. If the actual span is smaller than the span of a current defined range of record positions by at least a first threshold value, decrease the span of the current defined range. If the actual span is within a second threshold value of the span of the current defined range, increase the span of the current defined range. If an amount above a third threshold value of operation records in the first file are not matched to operation records in the second file, increasing the span of the current defined range. | 08-21-2014 |
20140279945 | MATCHING TRANSACTIONS IN MULTI-LEVEL RECORDS - Identifying matching transactions. First and second log files contain operation records of transactions in a transaction workload, each file recording a respective execution of the transaction workload, the method comprising. A first record location in the first file and an associated window of a defined number of sequential second record locations in the second file are advanced one record location at a time. Whether each operation record of a complete transaction at a first record location has a matching operation record at one of the record locations in the associated window of second record locations is determined. If so, the complete transaction in the first file and the transaction that includes the matching operation records in the second file are identified as matching transactions. | 09-18-2014 |
20140337283 | COMPARING DATABASE PERFORMANCE WITHOUT BENCHMARK WORKLOADS - Database operation records are sequentially read from two or more log files. If the transaction identifier is new and the record is not an end-of-transaction record, an open transactions list entry is created. If the transaction identifier is new and the record is an end-of-transaction record, a transaction type list entry is created or updated. If the transaction identifier is not new and is not an end-of-transaction record, an open transactions list entry is updated. If the transaction identifier is not new and the record is an end-of-transaction record, a transaction type list entry is created or updated. When all log file records are read, analytical comparison between the information associated with two or more of the log files in data fields in the transaction type list entries is performed. | 11-13-2014 |
20140337364 | COMPARING DATABASE PERFORMANCE WITHOUT BENCHMARK WORKLOADS - Database operation records are sequentially read from two or more log files. If the transaction identifier is new and the record is not an end-of-transaction record, an open transactions list entry is created. If the transaction identifier is new and the record is an end-of-transaction record, a transaction type list entry is created or updated. If the transaction identifier is not new and is not an end-of-transaction record, an open transactions list entry is updated. If the transaction identifier is not new and the record is an end-of-transaction record, a transaction type list entry is created or updated. When all log file records are read, analytical comparison between the information associated with two or more of the log files in data fields in the transaction type list entries is performed. | 11-13-2014 |
20150379033 | PARALLEL MATCHING OF HIERARCHICAL RECORDS - Identifying matching transactions between two log files. First and second log files contain operation records of transactions in a transaction workload. The first and second log files are split into first and second corresponding partition files, based on distinct sequences of operation record types beginning operation records of the transactions in each of the log files. A record location in a first partition file, and a window of sequential record locations in a corresponding second partition file at a defined offset relative to the record location in the first file are advanced one record location at a time. If each operation record of a complete transaction at a record location in a first file has a matching record in the associated window of record locations in a second file, the corresponding transactions match. | 12-31-2015 |
20150379052 | PARALLEL MATCHING OF HIERARCHICAL RECORDS - Identifying matching transactions between two log files. First and second log files contain operation records of transactions in a transaction workload. The first and second log files are split into first and second corresponding partition files, based on distinct sequences of operation record types beginning operation records of the transactions in each of the log files. A record location in a first partition file, and a window of sequential record locations in a corresponding second partition file at a defined offset relative to the record location in the first file are advanced one record location at a time. If each operation record of a complete transaction at a record location in a first file has a matching record in the associated window of record locations in a second file, the corresponding transactions match. | 12-31-2015 |