18400870. DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS simplified abstract (Microsoft Technology Licensing, LLC)
Contents
- 1 DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS - A simplified explanation of the abstract
- 1.4 Simplified Explanation
- 1.5 Potential Applications
- 1.6 Problems Solved
- 1.7 Benefits
- 1.8 Potential Commercial Applications
- 1.9 Possible Prior Art
- 1.10 Unanswered Questions
- 1.11 Original Abstract Submitted
DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS
Organization Name
Microsoft Technology Licensing, LLC
Inventor(s)
Sarvesh Singh of Issaquah WA (US)
Alan Dale Halverson of Verona WI (US)
Sandeep Lingam of Redmond WA (US)
Srikumar Rangarajan of Sammamish WA (US)
DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS - A simplified explanation of the abstract
This abstract first appeared for US patent application 18400870 titled 'DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS
Simplified Explanation
Methods for data visibility in nested transactions in distributed systems involve unique nested transaction identifiers for data management and versioning across multiple data sets and compute pools within a logical server overseen by a transaction manager.
- Distributed executions of queries are performed in processing systems according to isolation level protocols.
- Nested transaction identifiers are generated and encoded in data rows to enforce correct data visibility.
- Data visibility is restricted to previously committed data from distributed transactions and tasks.
- Local commits for completed transactions and tasks minimize transaction manager interactions.
- Instant rollbacks are enabled for aborted transactions and tasks.
Potential Applications
This technology can be applied in:
- Distributed databases
- Cloud computing environments
- Financial systems
Problems Solved
- Ensuring data consistency in distributed systems
- Managing data visibility in nested transactions
Benefits
- Improved data management and versioning
- Enhanced data visibility control
- Minimized transaction manager interactions
Potential Commercial Applications
Optimizing data processing in:
- E-commerce platforms
- Healthcare systems
- Supply chain management
Possible Prior Art
One possible prior art in this field is the use of distributed transaction managers in database systems to ensure data consistency and integrity.
Unanswered Questions
How does this technology handle network failures in distributed systems?
The abstract does not provide information on how this technology addresses network failures and their impact on data visibility and transaction management.
What are the scalability limitations of this method in large-scale distributed systems?
The abstract does not discuss the scalability limitations of this method when applied to large-scale distributed systems.
Original Abstract Submitted
Methods for data visibility in nested transactions in distributed systems are performed by systems and devices. Distributed executions of queries are performed in processing systems according to isolation level protocols with unique nested transaction identifiers for data management and versioning across one or more data sets, one or more compute pools, etc., within a logical server via a single transaction manager that oversees the isolation semantics and data versioning. A distributed query processor of the systems and devices performs nested transaction versioning for distributed tasks by generating nested transaction identifiers, encoded in data rows, which are used to enforce correct data visibility. Data visibility is restricted to previously committed data from distributed transactions and tasks, and is blocked for distributed transactions and tasks that run concurrently. Local commits for completed transactions and tasks are used to minimize transaction manager interactions, and instant rollbacks are enabled for aborted transactions and tasks.