Data trend analysis

A computing system, comprising:

• a processor;
• a memory operably connected to the processor;
• a non-transitory computer-readable storage medium operably connected to the processor and storing computer-executable instructions that when executed by at least the processor cause the computing system to:
• receive, by at least the processor, a request for trending analysis on project data, where the request includes a trend range and a time basis;
• in response to determining that an item table is associated with the time basis of the request, select, by at least the processor, the item table from amongst a plurality of item tables that are each associated with a corresponding time basis, where the item table includes a record for each time increment of the time basis, where each respective record includes an effective time for the respective time increment;
• select, by at least the processor, a set of records in the item table that fall within the trend range;
• generate, by at least the processor, a snapshot of the project data for each effective time in each respective selected record in the item table, wherein the generation includes:
• maintaining a history table that stores a version history for each record in the project data that has ever been modified,
• maintaining a transaction table that stores a transaction record for each record in the project data that has ever been modified, and
• executing a trend view on the history table, the transaction table, and a base table that stores base records corresponding to a current version of the records in the project data, to create a snapshot for each effective time in the selected item table records;
• and
• in response to the request for trending analysis, return, by at least the processor, the generated snapshots of project data.

A computer-implemented method comprising, with a processor:

• receiving a request for trending analysis on project data, where the request includes a trend range and a time basis;
• in response to determining that an item table is associated with the time basis of the request, selecting the item table from amongst a plurality of item tables that are each associated with a corresponding time basis, where the item table includes a record for each time increment of the time basis, where each respective record includes an effective time for the respective time increment;
• selecting a set of records in the item table that fall within the trend range;
• generating a snapshot of the project data for each effective time in each respective selected record in the item table, wherein the generating includes:
• maintaining a history table that stores a version history for each record in the project data that has ever been modified,
• maintaining a transaction table that stores a transaction record for each record in the project data that has ever been modified, and
• executing a trend view on the history table, the transaction table, and a base table that stores base records corresponding to a current version of the records in the project data to create a snapshot for each effective time in the selected item table records;
• and
• in response to the request for trending analysis, returning the generated snapshots of project data.