Hierarchical Work Record Tracking in Multi-Tenant Databases
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems face challenges in efficiently managing modifications to software applications, particularly in multi-tenant environments, where tracking changes and relationships among work records can be time-consuming and error-prone.
Innovation Solution
A method and system for generating work records associated with code submissions, allowing users to designate parent-child relationships among records, enabling organized tracking and management of code changes within a multi-tenant database environment, using tools like Visualforce and Apex on the Salesforce.com platform.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If conventional means are used to manage modifications to software applications, then software updates can be implemented, but the process becomes time consuming and error prone when there are numerous changes
Solution Approach 1:
The patent segments modifications into discrete work records that can be individually tracked, organized, and managed. Each work record represents a specific change or task, allowing the system to handle numerous modifications systematically rather than as a monolithic process, thereby improving efficiency and reducing errors
Solution Approach 2:
The patent introduces work records as intermediary objects between the modification process and the software application. These work records serve as a mediator layer that captures, tracks, and manages all changes before they are applied to the software, reducing time loss and errors in the modification management process
2Reliability
If conventional means are used to manage modifications to software applications, then software updates can be implemented, but the process becomes error prone when there are numerous changes
Solution Approach 1:
The patent implements feedback mechanisms through work records that track the status, relationships, and progression of modifications. The system provides feedback on which work records are associated with which code changes, allowing users to verify and validate the modification process, thereby improving reliability without being overwhelmed by complexity
Solution Approach 2:
The patent adds a new dimension to modification management by introducing hierarchical relationships (parent-child connections) between work records. This dimensional organization allows complex modifications to be structured in layers, making them more manageable and reliable without increasing operational complexity
3Productivity
If work records are organized into parent-child hierarchies, then tracking and management of code changes becomes more efficient, but the system structure becomes more complex
Solution Approach 1:
The patent segments the work record system into hierarchical levels (parent and child work records) where each segment serves a specific function. Parent work records represent overarching tasks or features, while child work records represent specific sub-tasks or changes. This segmentation improves tracking efficiency by organizing complexity into manageable, functionally distinct segments
Data Source
AI summary
A system and method for tracking work in a database environment. In one embodiment, a method includes generating a plurality of work records, where each work record is associated with code that is submitted for integration into a software application. The method further includes receiving a first indication that designates a first work record of the plurality of work records as a parent work record, and receiving a second indication that designates a second work record of the plurality of work records as a child work record, where the second work record is a child of the first work record.