Oracle Corporation
Data trend 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.