Transaction Tracking Module Logging Non-Durable Attributes
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems face challenges in efficiently processing audited transactions, particularly due to the risks associated with intercept libraries and intermediate processes, such as errors in configuration and increased processing path length, as well as the inability to intercept certain system-initiated transactions, leading to inefficiencies and potential inconsistencies in database management.
Innovation Solution
The integration of an Event/Tx Tracking module that joins audited transactions as a monitoring or voting member, allowing for real-time logging, modification, and control of transactions without requiring application code changes, using implicit joining to access additional information and apply enhanced processing functionality across various transaction protocols.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Extent of automation
If intercept libraries or intermediate processes are used to log and control transactions, then transaction monitoring and control capabilities are improved, but processing path length increases and configuration errors occur
Solution Approach 1:
The patent merges the logging and control functionality directly into the transaction processing engine itself, rather than using separate intercept libraries or intermediate processes. The transaction processing engine natively supports logging non-durable attributes to durable storage and enforcing business rules, eliminating the need for external components and reducing processing path length.
Solution Approach 2:
The transaction processing engine performs its own logging and control functions without requiring external intercept libraries or intermediate processes. The engine self-manages the durability conversion of transaction attributes and self-enforces business rules, reducing system complexity and configuration errors.
2Extent of automation
If intercept libraries or intermediate processes are used to intercept transactions, then transaction control capability is improved, but configuration errors and inability to intercept system-initiated transactions occur
Solution Approach 1:
The patent combines transaction initiation and control functionality within the same transaction processing engine. Since system-initiated transactions and application-initiated transactions both pass through the same engine, the engine can uniformly log and control all transactions without configuration errors associated with intercept libraries.
Solution Approach 2:
The patent segments transaction processing into distinct phases (execution, logging, durability conversion, rule enforcement) that can be independently configured and applied to different transaction types. This allows flexible control over application-initiated and system-initiated transactions without requiring separate intercept mechanisms.
3Reliability
If all transaction attributes are made durable through logging, then data durability is improved, but processing overhead increases
Solution Approach 1:
The patent applies durability logging selectively based on the specific attributes and requirements of each transaction, rather than uniformly logging all transaction attributes. The system determines which non-durable attributes need to be converted to durable storage on a per-transaction basis, reducing unnecessary I/O operations while ensuring durability for critical data.
Solution Approach 2:
The patent implements partial durability conversion, where only the necessary non-durable attributes of each transaction are logged to durable storage rather than all attributes. This selective approach balances durability requirements with processing performance by applying durability only where needed.
Data Source
AI summary
A method is provided for logging non-durable attributes of an uncompleted transaction to a persistent storage medium. A tracking engine identifies an uncompleted transaction to be joined, joins the uncompleted transaction, and collects non-durable attributes of the joined uncompleted transaction. The non-durable attributes of the joined uncompleted transaction are made durable by logging them to the persistent storage medium.


