Microsoft technology licensing, llc (20240134880). DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS simplified abstract

From WikiPatents
Jump to navigation Jump to search

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 20240134880 titled 'DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS

Simplified Explanation

Methods for data visibility in nested transactions in distributed systems involve performing distributed executions of queries in processing systems according to isolation level protocols with unique nested transaction identifiers for data management and versioning across multiple data sets and compute pools within a logical server. A single transaction manager oversees the isolation semantics and data versioning, while a distributed query processor generates nested transaction identifiers encoded in data rows to enforce correct data visibility. Data visibility is restricted to previously committed data from distributed transactions and tasks, blocking access for concurrent transactions and tasks. Local commits for completed transactions and tasks minimize transaction manager interactions, and instant rollbacks are enabled for aborted transactions and tasks.

  • Distributed executions of queries in processing systems
  • Isolation level protocols with unique nested transaction identifiers
  • Data management and versioning across multiple data sets and compute pools
  • Single transaction manager overseeing isolation semantics and data versioning
  • Distributed query processor generating nested transaction identifiers for correct data visibility
  • Restriction of data visibility to previously committed data
  • Blocking access for concurrent transactions and tasks
  • Local commits for completed transactions and tasks
  • Instant rollbacks for aborted transactions and tasks

Potential Applications

The technology can be applied in various fields such as finance, healthcare, e-commerce, and telecommunications for managing distributed transactions and tasks efficiently.

Problems Solved

This technology solves the problem of ensuring data visibility and versioning in nested transactions within distributed systems, preventing data inconsistencies and conflicts.

Benefits

The benefits of this technology include improved data integrity, reduced transaction manager interactions, and efficient handling of distributed tasks and transactions.

Potential Commercial Applications

The technology can be commercially applied in cloud computing platforms, database management systems, and enterprise resource planning software for enhanced data management and transaction processing.

Possible Prior Art

One possible prior art in this field is the use of distributed databases with transaction managers to handle concurrent transactions and ensure data consistency.

Unanswered Questions

How does this technology impact the scalability of distributed systems?

The article does not provide information on how this technology affects the scalability of distributed systems in terms of handling a large number of transactions and tasks simultaneously.

What are the potential security implications of implementing this technology?

The article does not address the potential security risks or implications of implementing this technology in distributed systems, such as data breaches or unauthorized access to sensitive information.


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.