Salesforce, inc. (20240220476). WRITE PROTECTING TENANT DATA IN A MULTI-TENANT DATABASE SYSTEM simplified abstract
Contents
WRITE PROTECTING TENANT DATA IN A MULTI-TENANT DATABASE SYSTEM
Organization Name
Inventor(s)
Sai Rama Raju Alluru of Hyderabad (IN)
WRITE PROTECTING TENANT DATA IN A MULTI-TENANT DATABASE SYSTEM - A simplified explanation of the abstract
This abstract first appeared for US patent application 20240220476 titled 'WRITE PROTECTING TENANT DATA IN A MULTI-TENANT DATABASE SYSTEM
The system described in the abstract performs write protection of data being copied to prevent corruption by applications. Triggers are used to implement this protection, with a list of write-protected tenants stored in a metadata table. The system utilizes statement-level triggers and row-level triggers to check if a tenant is write-protected and roll back operations if necessary.
- Write protection system for data being copied
- Triggers used to implement protection
- List of write-protected tenants stored in a metadata table
- Statement-level triggers cache metadata table in memory
- Row-level triggers check if tenant is write-protected
- Roll back operations if tenant is write-protected
Potential Applications: - Data migration processes - Database management systems - Data security solutions
Problems Solved: - Preventing data corruption during copying - Ensuring data integrity in multi-tenant environments
Benefits: - Enhanced data protection - Improved data reliability - Simplified management of write-protected tenants
Commercial Applications: Title: Enhanced Data Protection System for Database Management This technology can be used in various industries such as healthcare, finance, and e-commerce to safeguard sensitive data during transfers and ensure compliance with data protection regulations.
Questions about the technology: 1. How does the system determine which tenants are write-protected? 2. What are the potential risks of not implementing write protection in data copying processes?
Original Abstract Submitted
a system performs write protection of data that being copied. the write protection protects the data from being corrupted by applications. the system allows writes that are part of the data transfer from the source database. the system uses triggers to implement write protection. the system stores a list of tenants that are write protected in a metadata table. the system implements a statement level trigger that caches the metadata table in memory. if the cache is determined to be older than the limit specified by the ttl, the system reloads the cache. the statement may perform multiple row level operations. a row level operation implements a row level trigger that checks the in-memory data structure to determine whether the tenant is write protected. if the tenant is determined to be write protected, the system rolls back the row level operation.
