Separating Current and Historical Task Data in Project Management
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional project management systems face challenges with accumulating historical data, leading to complex and computationally expensive queries, and often neglect unscheduled tasks, with user interfaces primarily focusing on scheduled tasks.
Innovation Solution
A project management system that separates current and historical task schedule data, allowing for efficient retrieval of current data without querying historical data, and maintains unscheduled tasks as 'to-do lists' displayed distinctly within the system.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If conventional project management systems store both current and historical date information together, then complete historical record is maintained, but query complexity and computational cost increase significantly
Solution Approach 1:
The patent segments historical schedule data from current schedule data into separate database tables. Historical data is stored in tables like TOP_LEVEL_PROJECT_TASK_HISTORY while current data is stored in tables like TOP_LEVEL_PROJECT_TASK. This segmentation allows queries to retrieve only current data without processing historical data, reducing query complexity while maintaining complete historical records for audit and reference purposes.
2Ease of operation
If project management systems focus user interface on scheduled tasks, then scheduled task management is efficient, but unscheduled tasks are neglected and lose visibility
Solution Approach 1:
The patent introduces a new dimension for displaying unscheduled tasks by creating a separate 'To-Do List' view that exists alongside the traditional scheduled task calendar view. This additional dimension allows users to see and manage unscheduled tasks (with revision number 0) without interfering with the efficiency of scheduled task management. The system provides multiple viewing dimensions so users can switch between focused scheduled task management and comprehensive task oversight.
3Adaptability or versatility
If project management systems process all tasks uniformly, then consistent treatment is applied, but unscheduled tasks lack special attention and prioritization
Solution Approach 1:
The patent applies local quality by treating unscheduled tasks differently from scheduled tasks in specific contexts. Unscheduled tasks are identified by revision number 0 and are given special handling in the To-Do List view, where they can be prioritized and attended to separately. This localized special treatment allows the system to maintain consistent processing for scheduled tasks while providing enhanced visibility and prioritization capabilities for unscheduled tasks where needed.
Data Source
AI summary
A project management system manages project schedule data using separate current and historical task schedule data structures. In general, current schedule data is stored separately from historical schedule data, so that the current schedule data may be retrieved separately from the historical task schedule data. The project management system may also maintain unscheduled tasks as “to-do lists.” Tasks may be added to a member's schedule without specifying any planned dates and the tasks are added to the database. The tasks have an associated revision number of 0 to indicate that the tasks were added, but not yet scheduled. The tasks are displayed in the member schedule editor and in Web page schedules. The tasks may then be displayed in the member schedule editor and in Web page schedules in a manner that allows a user to readily determine that the tasks are “to-do list” tasks.