A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
Database System Concepts
Capturing Delays and Valid Times in Data Warehouses—Towards Timely Consistent Analyses
Journal of Intelligent Information Systems - Special issue on data warehousing and knowledge discovery
Realizing active data warehouses with off-the-shelf database technology
Software—Practice & Experience
Managing Time Consistency for Active Data Warehouse Environments
DaWaK '01 Proceedings of the Third International Conference on Data Warehousing and Knowledge Discovery
Relaxed currency and consistency: how to say "good enough" in SQL
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Real-time data warehouse loading methodology
IDEAS '08 Proceedings of the 2008 international symposium on Database engineering & applications
Scheduling to minimize staleness and stretch in real-time data warehouses
Proceedings of the twenty-first annual symposium on Parallelism in algorithms and architectures
Towards Near Real-Time Data Warehousing
AINA '10 Proceedings of the 2010 24th IEEE International Conference on Advanced Information Networking and Applications
Performance optimization of analysis rules in real-time active data warehouses
APWeb'12 Proceedings of the 14th Asia-Pacific international conference on Web Technologies and Applications
Location and route tracking in university from photos without GPS information
PCM'12 Proceedings of the 13th Pacific-Rim conference on Advances in Multimedia Information Processing
Hi-index | 0.00 |
Maintaining internal consistency of report is an important aspect in the field of real-time data warehouses. OLAP and Query tools were initially designed to operate on top of unchanging, static historical data. In a real-time environment, however, the results they produce are usually negatively influenced by data changes concurrent to query execution, which may result in some internal report inconsistency. In this paper, we propose a new method, called layer-based view approach, to appropriately and effectively maintain report data consistency. The core idea is to prevent the data involved in an OLAP query from being changed through using lock mechanism, and avoid the confliction between read and write operations with the help of layer mechanism. Our approach can effectively deal with report consistency issue, while at the same time avoiding the query contention between read and write operations under real-time OLAP environment.