Work Item Versioning for Historical Data Preservation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing tracking systems for work-related items in collaborative environments lack the ability to effectively preserve historical data and protect against accidental or malicious changes, as they do not retain prior versions of updated work items.
Innovation Solution
Implementing a method that stores full copies of all prior versions of work items in a database, along with version identifiers, allowing for historical data retrieval and providing query and display features to manage and audit work-item changes, thus ensuring a fully auditable database.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If full copies of all prior versions of work items are retained in the database, then historical data preservation and data protection against accidental or malicious changes are improved, but database size and storage requirements increase
Solution Approach 1:
The patent implements versioning by creating and storing copies of work items at different versions. Each work item maintains a history of its versions, with each version being a copy of the work item at a specific point in time. This allows full copies of prior versions to be retained in the database, enabling historical data preservation and protection against accidental or malicious changes while managing storage through structured version storage.
2Loss of information
If version identifiers and full copies of prior versions are stored, then auditability and historical data retrieval are improved, but system complexity increases
Solution Approach 1:
The patent segments the work item data into distinct versions, each identifiable by a version identifier. The version history is segmented into discrete version records that can be individually retrieved and managed. This segmentation allows the system to maintain comprehensive historical data while organizing it in a manageable structure that reduces retrieval complexity.
Solution Approach 2:
The system performs preliminary actions by automatically creating and storing version copies at the time of work item updates. Version identifiers are assigned and stored in advance, enabling future retrieval and auditing without requiring complex real-time tracking mechanisms. This preliminary versioning approach simplifies the overall system architecture while ensuring historical data availability.
Data Source
AI summary
A method for work-item tracking, in a computer system that includes client computers and at least one server maintaining a database, includes defining at least one work item, associating version identifiers with corresponding versions of at least one work item, and storing, in the database, work-item data. The work-item data can include the current version of the work item, one or more prior versions of the work item, and the version identifiers. A computer readable medium is encoded with a program that, when executed, can perform the method for work-item tracking.