Database Object Modification via Pre-generated Stored Procedures
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional storage area network management applications require significant time and resources to manage and modify object hierarchies stored in relational databases, as they need to populate entire object hierarchies in memory and execute numerous SQL commands for changes, leading to inefficiencies in processing and resource utilization.
Innovation Solution
Generating a set of operational instructions, such as a stored procedure, before receiving a modification command to anticipate and efficiently carry out changes in the relational database, reducing the need for real-time relationship identification and processing time by analyzing metadata to identify impacted database contents and generating pre-executable commands.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If conventional storage area network management applications populate entire object hierarchies in memory and execute numerous SQL commands for modifications, then the system can manage and modify database objects, but the processing time and resource usage increase significantly
Solution Approach 1:
The system performs preliminary actions by analyzing metadata to identify the specific database contents that will be impacted by a modification command before actually executing the modification. This allows the system to prepare and execute only the necessary SQL commands rather than populating entire object hierarchies or executing numerous unnecessary commands, thereby reducing processing time and improving database modification efficiency
2Productivity
If conventional applications execute numerous SQL commands to carry out object modifications, then the modifications can be applied to the database, but the number of commands and processing overhead increase
Solution Approach 1:
The system merges multiple individual SQL commands into a single optimized command by analyzing the metadata to determine all impacted database contents beforehand. Instead of executing numerous separate SQL commands to modify different parts of the database, the system consolidates these operations into one efficient command, reducing processing overhead and improving execution efficiency
Data Source
AI summary
Techniques herein involve anticipating the application of a command to modify objects having associated object data stored in a relational database. Prior to receipt of an object modification command that causes a modification to a respective object and/or an object hierarchy, a computer process generates a set of operational instructions to carry out the object modification command. Generally, the computer process analyzes a structure for storing object data in a relational database to identify information in the relational database that will be impacted as a result of executing a corresponding object modification command. Based on analysis of the structure, the computer process generates the set of operational instructions. The execution of the set of operational instructions to carry out the command causes the respective object and/or object hierarchy to be modified as well as causes a corresponding modification to contents of a relational database storing respective object data.