17994583. PERFORMANCE ENHANCEMENT FOR WRITING DATABASE PAGES simplified abstract (SAP SE)
Contents
- 1 PERFORMANCE ENHANCEMENT FOR WRITING DATABASE PAGES
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 PERFORMANCE ENHANCEMENT FOR WRITING DATABASE PAGES - A simplified explanation of the abstract
- 1.4 Simplified Explanation
- 1.5 Potential Applications
- 1.6 Problems Solved
- 1.7 Benefits
- 1.8 Potential Commercial Applications
- 1.9 Possible Prior Art
- 1.10 Original Abstract Submitted
PERFORMANCE ENHANCEMENT FOR WRITING DATABASE PAGES
Organization Name
Inventor(s)
Padmaja Dhairyasheel Thorat of Pune (IN)
Mukundakrishnan Parthasarathy of Mumbai (IN)
PERFORMANCE ENHANCEMENT FOR WRITING DATABASE PAGES - A simplified explanation of the abstract
This abstract first appeared for US patent application 17994583 titled 'PERFORMANCE ENHANCEMENT FOR WRITING DATABASE PAGES
Simplified Explanation
The abstract describes a system and method for updating timestamps associated with database pages in a database instance, organizing them into page sets, and writing the updated pages to a persistent data store.
- The system receives a request to update timestamps for database pages.
- It updates the timestamps for each database page in the page sets.
- When the last page in each page set is updated, a write request is issued to write all pages in the set to a persistent data store.
- The updated pages are then written to the persistent data store with their new timestamps.
Potential Applications
This technology could be applied in various database management systems to efficiently update and store database pages.
Problems Solved
1. Ensures that database pages are updated with the latest information before being written to a persistent data store. 2. Helps in maintaining data integrity and consistency in the database.
Benefits
1. Improved performance and efficiency in updating and storing database pages. 2. Reduced risk of data loss or corruption due to outdated information being written to the data store.
Potential Commercial Applications
Optimizing database management systems for faster and more reliable data storage.
Possible Prior Art
There may be existing technologies or methods for updating and storing database pages efficiently, but specific prior art is not provided in this context.
Unanswered Questions
How does this system handle concurrent write requests to the same page set?
The abstract does not mention how the system handles concurrent write requests to the same page set. This could be a potential area of concern in a multi-user database environment.
What mechanisms are in place to ensure data consistency during the write process?
The abstract does not detail the mechanisms used to ensure data consistency during the write process. It would be important to understand how the system maintains data integrity while updating and writing database pages.
Original Abstract Submitted
A system and method including receiving a request to update a timestamp associated with database pages of a database instance logically organized into at least one page set, each of the at least one page set including a plurality of the database pages; updating the timestamp associated with each database page in each respective at least one page set; issuing, in response to updating the timestamp associated with a last database page in each of the at least one page set, a write request to write the plurality of database pages in each of the respective at least one page set to a persistent data store; and writing the plurality of database pages in each of the respective at least one page set to a persistent data store, the plurality of database pages written to the persistent data store having an updated timestamp associated therewith.