[LinLLXZ11] Ziyu Lin, Yongxuan Lai, Chen Lin, Yi Xie and Quan Zou. Maintaining Internal Consistency of Report for Real-time OLAP with Layer-based View. APWeb’2011.LNCS 6612, pp. 143–154, 2011.(EI收录,Accession number: 20111713937412).[全文PDF下载]
Maintaining Internal Consistency of Report for Real-Time OLAP with Layer-Based View
Ziyu Lin1,, Yongxuan Lai2, Chen Lin1, Yi Xie1, and Quan Zou1
1 Department of Computer Science, Xiamen University, Xiamen, China
2 Software School, Xiamen University, Xiamen, China
Abstract. 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.
Keywords: OLAP; report consistency.