Website Repository Delta Logging for Content Rollback

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing website content backup systems fail to track and reverse individual changes, leading to potential malicious changes going undetected until the next scheduled review, requiring entire site or database backups, and lack real-time logging of changes.

Innovation Solution

Implementing a website repository system that logs each change as a delta within a database transaction log, allowing users to identify and reverse specific modifications, providing a user interface for controlling website content and enabling real-time notification of changes.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If entire site or database backups are performed, then website content can be restored, but storage space and time are wasted due to redundant data

Engineering Contradiction:

Improvewebsite content restoration capabilityVSAvoidstorage space waste

Core Design Contradiction:

ReliabilityVSLoss of substance

Solution Approach 1:

The patent segments the website content backup into individual database records rather than backing up the entire database. The system identifies and stores only the specific modified records in the website repository, eliminating the need to store redundant unchanged data. This segmentation approach maintains restoration capability while significantly reducing storage requirements.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent extracts only the modified portions of database content and stores them separately in the website repository. By taking out only the necessary changed records and their associated deltas, the system avoids storing complete backups of unchanged content, thus reducing storage space while preserving the ability to restore website content.

Inventive Principle:

Principle #2Taking out (Extraction)

2Reliability

If scheduled backup reviews are implemented, then website changes can be detected, but malicious changes may go undetected until the next review

Engineering Contradiction:

Improvechange detection capabilityVSAvoiddetection delay

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The patent implements continuous monitoring of database transactions through transaction logs. Every database modification is immediately captured and stored as a delta in the website repository, providing continuous change detection rather than periodic reviews. This eliminates detection delays and allows immediate identification of malicious changes.

Inventive Principle:

Principle #20Continuity of useful action

Solution Approach 2:

The system provides immediate feedback by logging each database transaction and storing it in the website repository in real-time. This continuous feedback mechanism allows the system to detect and alert about malicious changes immediately upon occurrence, rather than waiting for scheduled reviews.

Inventive Principle:

Principle #23Feedback

3Ease of operation

If individual change tracking is implemented, then specific modifications can be reversed, but system complexity increases

Engineering Contradiction:

Improveindividual change reversal capabilityVSAvoidsystem structure complexity

Core Design Contradiction:

Ease of operationVSDevice complexity

Solution Approach 1:

The patent introduces a website repository as an intermediary layer between the database and the website content. This repository stores deltas and modification records, simplifying the complexity by providing a structured intermediate storage mechanism that makes individual change tracking and reversal straightforward without directly complicating the core database system.

Inventive Principle:

Principle #24Intermediary (Mediator)

4Loss of information

If real-time transaction logging is performed, then all changes can be tracked, but processing overhead increases

Engineering Contradiction:

Improvechange tracking completenessVSAvoidprocessing overhead

Core Design Contradiction:

Loss of informationVSUse of energy by moving object

Solution Approach 1:

The patent extracts only the essential modification information (deltas) from database transactions and stores them in the website repository. By taking out only the necessary change data rather than logging complete transaction details, the system maintains complete change tracking while minimizing processing overhead and storage requirements.

Inventive Principle:

Principle #2Taking out (Extraction)

Data Source

PatentUS10747841B2Systems and methods for modifying and restoring website content via a website directory

Publication Date: 2020.08.18 GO DADDY OPERATING CO LLC

AI summary

Systems and method of the present invention provide for one or more server computers configured to identify, within a database transaction log, a dynamic website content in a database and a command modifying the dynamic website content, write the dynamic website content and the command modifying the dynamic website content to a website repository as a delta, receive a request to reverse the command modifying the dynamic website content, identify, within the delta, the command modifying the dynamic website content, and generate and execute a database query configured to reverse the command modifying the dynamic website content.