Abstract: Systems, methods, and other embodiments associated with history and scenario data tracking are described. In one embodiment, a method includes receiving a request for trending analysis on project data. The request includes a trend range and a time basis. The method also includes selecting a set of records that fall within the trend range from an item table associated with the time basis, and generating a snapshot of the project data for each effective time in each selected record in the item table. The generating includes executing a trend view on (i) a history table storing a version history for every record modified, (ii) a transaction table storing a transaction history for every record modified, and (iii) a base table storing base records corresponding to a current version of the records to create the snapshot. The snapshots of project data are returned in response to the request for trending analysis.

Abstract: Systems, methods, and other embodiments associated with history and scenario data tracking are described. In one embodiment, a method includes receiving a request for trending analysis on project data. The request includes a trend range and a time basis. The method also includes selecting a set of records that fall within the trend range from an item table associated with the time basis, and generating a snapshot of the project data for each effective time in each selected record in the item table. The generating includes executing a trend view on (i) a history table storing a version history for every record modified, (ii) a transaction table storing a transaction history for every record modified, and (iii) a base table storing base records corresponding to a current version of the records to create the snapshot. The snapshots of project data are returned in response to the request for trending analysis.

Abstract: Systems, methods, and other embodiments associated with history and scenario data tracking are described. In one embodiment, a method includes receiving a request for trending analysis on project data. The request includes a trend range and a time basis. An item table associated with the time basis is selected. The item table includes a record for each time increment of the time basis. Each respective record in the item table includes an effective time for the respective time increment. The method further includes selecting a set of records in the item table that fall within the trend range; and generating a snapshot of the project data for each effective time in each respective selected record in the item table. The generated snapshots of project data are returned in response to the request for trending analysis.

Abstract: Systems, methods, and other embodiments associated with history and scenario data tracking are described. In one embodiment, a method includes recording, in an overlay table, a scenario comprising a set of respective modified records resulting from respective operations performed on respective selected records in project data, such that the selected records remain unmodified in the project data. In response to a request for the project data as modified by the scenario, the method includes combining records in the project data with the modified records in the overlay table to create a scenario result, such that the selected records are not included in the scenario result.

Abstract: Systems, methods, and other embodiments associated with history and scenario data tracking are described. In one embodiment, a method includes receiving a request for trending analysis on project data. The request includes a trend range and a time basis. An item table associated with the time basis is selected. The item table includes a record for each time increment of the time basis. Each respective record in the item table includes an effective time for the respective time increment. The method further includes selecting a set of records in the item table that fall within the trend range; and generating a snapshot of the project data for each effective time in each respective selected record in the item table. The generated snapshots of project data are returned in response to the request for trending analysis.

Abstract: Systems, methods, and other embodiments associated with history and scenario data tracking are described. In one embodiment, a method includes recording, in an overlay table, a scenario comprising a set of respective modified records resulting from respective operations performed on respective selected records in project data, such that the selected records remain unmodified in the project data. In response to a request for the project data as modified by the scenario, the method includes combining records in the project data with the modified records in the overlay table to create a scenario result, such that the selected records are not included in the scenario result.