Snowflake inc. (20240378187). FENCING MECHANISM OF STATEMENTS FOR DISTRIBUTED MULTI-VERSION CONCURRENCY CONTROL simplified abstract
Contents
FENCING MECHANISM OF STATEMENTS FOR DISTRIBUTED MULTI-VERSION CONCURRENCY CONTROL
Organization Name
Inventor(s)
Nikolaos Romanos Katsipoulakis of Redwood City CA (US)
Alexander Miller of San Mateo CA (US)
FENCING MECHANISM OF STATEMENTS FOR DISTRIBUTED MULTI-VERSION CONCURRENCY CONTROL - A simplified explanation of the abstract
This abstract first appeared for US patent application 20240378187 titled 'FENCING MECHANISM OF STATEMENTS FOR DISTRIBUTED MULTI-VERSION CONCURRENCY CONTROL
The subject technology involves receiving a request to commit a transaction, writing a metadata version of a table to a metastore, registering a background worker, triggering an execution node job, storing identifiers of active transactions in a datastore, and unlocking the table after the job is completed.
- Technology receives transaction request
- Writes metadata version of table to metastore
- Registers background worker
- Triggers execution node job
- Stores identifiers of active transactions
- Unlocks table after job completion
Potential Applications: - Database management systems - Transaction processing systems - Distributed computing platforms
Problems Solved: - Efficient transaction handling - Improved data consistency - Scalable execution of jobs
Benefits: - Enhanced performance - Simplified transaction management - Increased system reliability
Commercial Applications: Title: "Enhanced Transaction Management Technology for Database Systems" This technology can be used in various industries such as finance, e-commerce, and healthcare for managing large volumes of transactions efficiently and reliably.
Questions about the technology: 1. How does this technology improve data consistency in transaction processing systems? 2. What are the key advantages of using a background worker for triggering execution node jobs in database management systems?
Frequently Updated Research: Stay updated on the latest advancements in transaction processing systems and distributed computing platforms to enhance the efficiency and reliability of database management systems.
Original Abstract Submitted
the subject technology determines that a request to commit a transaction has been received. the subject technology prior to committing the transaction, performs a write operation to store a metadata version of a table associated with the transaction in a metastore. the subject technology performs a register operation to register a background worker. the subject technology performs, by the background worker, a trigger operation to perform an execution node job on an execution node. the subject technology retrieves, by the execution node job, a set of identifiers of active transactions. the subject technology performs, by the execution node job, a write operation to store the metadata version of the table and the set of identifiers in a datastore. the subject technology receives, by the background worker, an indication that the execution node job has successfully completed. the subject technology performs an unlock operation to unlock the table.
