Aggregated Site Collection View for Web Application Restoration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Restoring web applications that utilize multiple content databases is challenging due to the difficulty in finding and selecting appropriate backup data sets, as content is distributed across databases, making it hard to restore the application to a coherent state.
Innovation Solution
A graphical user interface is developed to display an aggregated view of site collections from multiple databases, allowing users to select and restore specific site collections based on recovery times, with backup and restore software that stores topology information to determine included databases and site collections.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If content is distributed across multiple databases for web application storage, then storage capacity and organization are improved, but restoration complexity and difficulty increase
Solution Approach 1:
The system segments the web application content into multiple site collections, each stored in separate databases. The restoration interface further segments the restoration process by allowing users to selectively restore individual site collections rather than requiring restoration of entire databases, thus reducing restoration complexity while maintaining storage capacity benefits
Solution Approach 2:
The patent introduces an intermediary restoration management system that sits between the distributed databases and the user. This intermediary aggregates information from multiple databases, presents a unified view to users, and coordinates the restoration process across databases, thereby simplifying the complexity of restoring distributed content
2Ease of manufacture
If backup data is stored separately for each database, then data organization is improved, but ease of operation for restoration deteriorates
Solution Approach 1:
The restoration interface merges the view of multiple separate database backups into a single aggregated display. Users see all site collections from all databases in one unified interface, can filter and search across them, and select what to restore without needing to navigate to each database separately, thus improving ease of operation while maintaining data organization
Solution Approach 2:
The restoration system provides a universal interface that works with any number of databases and site collections. The same interface adapts to display and manage backups from one database or multiple databases, making the system multi-functional and easy to operate regardless of the underlying data organization structure
3Reliability
If users must navigate through multiple databases to find backup data, then data security and organization are improved, but time efficiency deteriorates
Solution Approach 1:
The system performs preliminary actions by pre-aggregating and pre-indexing information about all site collections and their locations in databases before restoration is needed. The unified interface is prepared in advance to quickly display available backups, allowing users to immediately search and select what to restore without time-consuming navigation through multiple databases
Data Source
AI summary
A system and method for restoring site collections stored in different content databases of a web application are disclosed. A restoration GUI may be displayed. Displaying the restoration GUI may include determining a plurality of databases used for the web application. For each respective database of the plurality of databases, one or more site collections stored in the database may be determined. Displaying the graphical user interface may further comprise displaying an aggregated view of the site collections stored in each database of the plurality of databases. The aggregated view may enable each site collection to be selected for restoration.