Microsoft technology licensing, llc (20240184674). DATABASE REVERSION WITH BACKUP DATA STRUCTURES simplified abstract

From WikiPatents
Jump to navigation Jump to search

DATABASE REVERSION WITH BACKUP DATA STRUCTURES

Organization Name

microsoft technology licensing, llc

Inventor(s)

Varun Joshi Kishanlal Joshi of Bellevue WA (US)

Anil Kumar Ruia of Sammamish WA (US)

Yogesh Bansal of Sammamish WA (US)

DATABASE REVERSION WITH BACKUP DATA STRUCTURES - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240184674 titled 'DATABASE REVERSION WITH BACKUP DATA STRUCTURES

The abstract describes a system for database reversion, including a database engine, log engine, backup engine, and memory buffer. The system allows for the creation of a backup data structure to facilitate database reversion by storing images of pages in the active database.

  • Database engine hosts an active database
  • Log engine generates transaction logs
  • Backup engine creates backup data structure
  • Memory buffer stores updated copies of pages
  • Page timestamp indicates most recent update
  • Backup engine stores images of pages for reversion

Potential Applications: - Data recovery in case of errors or corruption - Version control for databases - Disaster recovery planning

Problems Solved: - Data loss prevention - Efficient database reversion process - Improved data management and control

Benefits: - Enhanced data security - Simplified database maintenance - Increased reliability of database operations

Commercial Applications: Title: "Advanced Database Reversion System for Enhanced Data Security" This technology can be used in industries such as finance, healthcare, and e-commerce for secure data management and disaster recovery planning.

Prior Art: There may be existing systems for database backup and recovery, but the specific combination of features in this system may be unique.

Frequently Updated Research: Stay updated on advancements in database management systems and data recovery technologies to enhance the efficiency and effectiveness of this system.

Questions about Database Reversion:

Question 1: How does this system compare to traditional database backup methods? Answer: This system offers a more efficient and reliable way to revert databases to previous states compared to traditional backup methods.

Question 2: Can this system handle large databases with high transaction volumes? Answer: The system's design allows for scalability to handle large databases and high transaction volumes effectively.


Original Abstract Submitted

a system for database reversion is described. the system comprises: a database engine configured to host an active database; a log engine configured to generate transaction logs for transactions affecting the active database; a backup engine configured to create a backup data structure to allow for database reversion; and a memory buffer separate from the active database. a page in the active database has an associated page timestamp indicating a most recent update of the page in the active database. the database engine is configured to flush an updated copy of a page in the memory buffer to the active database. the backup engine is configured to, prior to the flush, store an image of the page in the active database to the backup data structure when the page in the active database is older than the time value related to the creation time of the backup data structure.