Incremental Database Object Upgrade via Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing techniques for upgrading database objects often result in undesirable downtime, as they require all database objects to be unavailable, and computationally expensive commands exacerbate the duration and impact of this downtime.
Innovation Solution
A system that uses a database comparator to identify objects for complete or partial modifications based on comparisons with target upgrade objects, employing an incremental conversion process to minimize downtime by allowing modifications during uptime and scheduling them based on modification conditions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If all database objects are modified using traditional techniques, then the system is upgraded to the target version, but the entire system must be unavailable during the upgrade process
Solution Approach 1:
The patent divides the database objects into multiple groups and performs modifications on different groups at different times. The system identifies specific database objects that require modification and processes them in segments rather than all at once, allowing other objects to remain accessible during the upgrade process.
Solution Approach 2:
The system performs preliminary identification and classification of database objects that need modification before initiating the actual modification process. This preliminary action allows the system to plan the upgrade sequence and minimize disruption to available objects.
2Manufacturing precision
If computationally expensive commands are used to modify database objects, then the modification accuracy is improved, but the duration of downtime is extended
Solution Approach 1:
The modification process is segmented into multiple smaller operations performed on different database object groups. This allows computationally expensive commands to be executed on smaller subsets of data, maintaining accuracy while reducing the total time any single modification operation blocks system access.
Solution Approach 2:
The system performs partial modifications on specific database objects that require it, rather than applying expensive commands to all objects. The database comparator intelligently identifies which objects need modification and applies commands only to those, avoiding unnecessary computational overhead on already-updated objects.
3Ease of manufacture
If the entire database system is stopped for upgrade, then all database objects can be modified without constraints, but user access to the system is completely blocked
Solution Approach 1:
The system segments database objects into modifiable groups and non-modifiable groups, allowing users to continue accessing and operating on objects that do not require modification while upgrades are performed on specific segments. This maintains ease of operation for available objects while enabling modifications on targeted objects.
Solution Approach 2:
The database comparator acts as an intermediary that identifies which objects need modification and coordinates the upgrade process. It mediates between the need for system-wide upgrades and the requirement for continuous user access, determining which objects can be safely modified without affecting user operations.
Data Source
AI summary
A computer system can include a database comparator configured to identify a first database object from an original system for a complete modification based on a comparison of the first database object with a plurality of target upgrade database objects, and configured to identify a second database object from the original system for a partial modification based on a comparison of the second database object with the plurality of target upgrade database objects. A complete modification module can be configured to designate, in response to the identification of the first database object, the first database object for the complete modification based on an incremental conversion process. A partial modification module can be configured to designate the second database object for the partial modification based on the incremental conversion process when an instruction to implement the partial modification satisfies at least a portion of a modification condition.