So, copies of operational data can be updated in real-time AND made available for routine and ad hoc queries and reports.
Queries can be simple, complex or ad hoc, as needed, without significant performance degradation.
The best of all worlds would be to use a high atomic density copy of operational databases for data warehousing, wherein data is updated continuously. Such a VLDB copy could accommodate very large numbers of simultaneous updates and queries - an active data warehouse. This solution is possible with Thunderbolt VLDB . Recent developments are intended to implement a real-time index that will enable a large number of simultaneous updates and complex queries on very large data warehouses. Its strength lies in its capabilities to inexpensively manage geospatial data from oil and gas seismic surveys.