18400870. DATA VISIBILITY FOR NESTED TRANSACTIONS IN DISTRIBUTED SYSTEMS simplified abstract (Microsoft Technology Licensing, LLC)

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 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.

Retrieved from "http://wikipatents.org/index.php?title=18400870._DATA_VISIBILITY_FOR_NESTED_TRANSACTIONS_IN_DISTRIBUTED_SYSTEMS_simplified_abstract_(Microsoft_Technology_Licensing,_LLC)&oldid=59072"