Title :
Incremental maintenance of multi-source views
Author :
Moro, Gianluca ; Sartori, Claudio
Author_Institution :
Dipartimento di Elettronica Inf. e Sistemistica, Bologna Univ., Italy
Abstract :
In recent years, numerous algorithms have been proposed for incremental view maintenance of data warehouses. As a matter of fact, all of them follow almost the same general approach, namely they compute the change of a multi-source view in response to an update message from a data source, following two steps: (i) issue a set of queries against the other data sources, and (ii) compensate the query result due to concurrent updates interfering with the first step. Despite many recent improvements, the compensation approach needs precise detection of interfering updates occurring remotely in autonomous data sources and the assumption that messages are never lost and are delivered in the order in which they are sent. However, in real networks, loss and misordering of messages are usual. In this paper, we propose a maintenance algorithm that does not need the compensation step and that applies to general view expressions of the bag algebra, without any limit on the number of base relations per data source
Keywords :
compensation; concurrency control; data warehouses; losses; query processing; autonomous data sources; bag algebra; base relations; concurrent updates; data warehouses; incremental view maintenance; materialized views; message delivery order; message loss; message misordering; multi-source views; query result compensation; query set issuing; remote interfering updates; update message; Algebra; Concurrent computing; Data warehouses; Frequency; Iterative methods; Maintenance;
Conference_Titel :
Database Conference, 2001. ADC 2001. Proceedings. 12th Australasian
Conference_Location :
Gold Coast, Qld.
Print_ISBN :
0-7695-0966-5
DOI :
10.1109/ADC.2001.904459