Unified Website Editing System with Conflict Resolution
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current website building and deployment systems face challenges in managing concurrent modifications and conflicts while maintaining a live, mission-critical website, as they often require separate development environments and version control systems that are complex and difficult to navigate, especially for non-technical users and large-scale websites with dynamic data.
Innovation Solution
A system that includes a published database for end-users, a draft database for designers, and request handlers to coordinate concurrent viewing and updating, along with a conflict resolver, version control, and auxiliary systems for editing history and change management, allowing for seamless integration of changes without disrupting the live website.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If separate development environments and version control systems are used to manage website changes, then website modification capabilities are improved, but system complexity increases and ease of operation deteriorates
Solution Approach 1:
The patent merges the development environment and production environment into a single unified system. Designers can create and edit website content directly in the production database without needing separate development environments, version control systems, or deployment pipelines. This consolidation eliminates the complexity of managing multiple environments while maintaining full website modification capabilities.
Solution Approach 2:
The patent extracts the essential functionality needed for website modification (content creation, editing, and publishing) from complex version control systems and separate development environments. By taking out only the necessary capabilities and integrating them directly into the production database, the system achieves simplicity without sacrificing modification capabilities.
2Ease of operation
If website changes are made directly to the published database, then ease of operation is improved, but website reliability deteriorates due to potential conflicts and breaks
Solution Approach 1:
The patent implements automatic feedback mechanisms that continuously monitor the published database for conflicts, errors, or inconsistencies. When designers make changes directly to the production database, the system provides real-time feedback about potential issues, validates the changes, and automatically resolves conflicts or prevents operations that would break website integrity, thereby maintaining reliability while allowing direct editing.
3Productivity
If multiple designers edit website content simultaneously, then productivity is improved, but conflict resolution complexity increases
Solution Approach 1:
The patent implements self-service conflict resolution mechanisms where the system automatically detects, resolves, and manages conflicts between simultaneous edits without requiring manual intervention from designers. The published database handles conflict resolution autonomously through automatic validation, error detection, and correction mechanisms, enabling multiple designers to work concurrently without increasing conflict resolution complexity.
4Adaptability or versatility
If schema changes are made to the database, then adaptability is improved, but website reliability worsens due to potential breaking changes
Solution Approach 1:
The patent applies preliminary action by automatically validating and testing schema changes before they are applied to the published database. The system performs pre-checks to ensure that proposed schema modifications will not break existing website functionality or data integrity. This preliminary validation maintains reliability while allowing flexible schema adaptation.
Data Source
AI summary
A system for modifying a website or interactive application, including a published database accessible via an end user data service to present the most up to date version of objects of the website, viewable and editable by at least one user, a draft database accessible via a designer data service and viewable and editable by at least one designer to store edits to the objects of the published database; a published database request handler to coordinate concurrent viewing and updating of the objects between the end user data service and the published database and a draft database request handler to coordinate concurrent viewing, editing and updating of the objects between the designer data service and the draft database and to merge edits and updates to the objects in both the published database and the draft database and to return the merged version of the objects without modifying the published database.


