Abstract: A server auditing process that stores only a single up-to-date data record along with the differences relative to previous changes in the record that allow the user to move “backward in time” to recreate previous values. The auditing feature introduces a baseline database table and a difference database table for each existing database table. The baseline table stores the most recent auditing data and the differences table complements the baseline table by storing pairs in the form of attribute name and previous value. By applying difference rows to baseline data, the user is able to recreate the data as it existed at any given timestamp and at a minimal storage cost. The architecture minimizes the impact of auditing on system performance by employing an asynchronous priority queue so that task processing is deferred until the system has adequate resources and other work is not affected.

Abstract: A project management system is enabled to handle multiple currencies within managed projects. An exchange series includes currency definition parameters such as currency pairing, frequency of rate change, and effective date of exchange rate. Using the exchange series and a strong definition of cost for tasks and resources (i.e. indicating currency type along with value of cost), the project management system allows costs to be entered in local currency. Project level roll-ups are calculated employing time-phased currency conversion based on whether the cost is variable or fixed. For scheduling, speculative conversions are facilitated based on latest actual exchange rate information. Local and project currency costs are provided to a project server for enterprise level roll-ups and multi-project management.

Abstract: A server auditing process that stores only a single up-to-date data record along with the differences relative to previous changes in the record that allow the user to move “backward in time” to recreate previous values. The auditing feature introduces a baseline database table and a difference database table for each existing database table. The baseline table stores the most recent auditing data and the differences table complements the baseline table by storing pairs in the form of attribute name and previous value. By applying difference rows to baseline data, the user is able to recreate the data as it existed at any given timestamp and at a minimal storage cost. The architecture minimizes the impact of auditing on system performance by employing an asynchronous priority queue so that task processing is deferred until the system has adequate resources and other work is not affected.