Abstract: A system, including both an OLTP database and a warehouse database, that is configured to manage the coordination between the OLTP database and the warehouse database. An aspect relates to a combined OLTP and warehouse database which manages duplicate copies, in both the OLTP database and the warehouse database, of data expected to have a relatively high update and query rate. Data which has a low update and query rate is removed from the OLTP database, such that it remains only in the warehouse database. Updates of the duplicate copy data are performed in the OLTP. Periodically, for example every several minutes, data recently changed in the OLTP database is copied to the warehouse database. Queries are optionally primarily handled by the warehouse database, and are supplemented, when necessary, by data from the OLTP database.

Abstract: Various agencies, such as law enforcement and intelligence agencies, deploy monitoring centers that monitor communication networks and analyze the monitored communication. One possible way to reduce storage cost is to apply Information Lifecycle Management (ILM) techniques, which store the content to multiple storage tiers having different performance levels. The monitoring center processes the various items of content in the context of investigation cases. given investigation case may be assigned a certain status, e.g., active or closed. The monitoring center comprises an ILM server that assigns content items to storage tiers based on the investigation cases with which the content items are associated. The ILM server may analyze the state of a given investigation case, and selects an ILM policy based on the state of the case. The ILM policy specifies the storage tier (or tiers) to be used for storing items of data associated with the case.