Matches in SemOpenAlex for { <https://semopenalex.org/work/W2034347604> ?p ?o ?g. }
Showing items 1 to 69 of
69
with 100 items per page.
- W2034347604 endingPage "109" @default.
- W2034347604 startingPage "87" @default.
- W2034347604 abstract "Abstract Data in the warehouse can be seen as materialized views generated from the underlying multiple data sources. Materialized views are used to speedup query processing on large amounts of data. These views need to be maintained in response to updates in the source data. This is often done using incremental techniques that access data from underlying sources. In the data warehousing scenario, accessing base relations can be difficult, sometimes data sources may be unavailable, since these relations are distributed across different sources. For these reasons, the issue of self-maintainability of the view is an important issue in data warehousing. In this paper we show that the warehouse views can be made self-maintainable if some additional relations, called auxiliary relations, derived from the intermediate results of the view computation can be materialized in the warehouse. We give an algorithm for determining what auxiliary relations need to be materialized in order to make a materialized view self-maintainable. We then propose an efficient self-maintainable incremental algorithm that computes the updates to both the materialized view and the additional relations. The primary objective is to minimize the overall maintenance cost of a given view and the auxiliary relations. One important feature of our algorithm is that it derives the `exact change' to every materialized additional relation, including the materialized view, without accessing the view itself. This feature is important to ensure the correctness of the update to views defined by aggregate functions, and also important in active database applications where triggers are fired by updates to the view. Finally, we compare the maintenance cost of our incremental algorithm to that of counting algorithm and recomputing the view from scratch (naive algorithm)." @default.
- W2034347604 created "2016-06-24" @default.
- W2034347604 creator A5039882708 @default.
- W2034347604 creator A5047987914 @default.
- W2034347604 date "2000-01-01" @default.
- W2034347604 modified "2023-09-24" @default.
- W2034347604 title "Making aggregate views self-maintainable" @default.
- W2034347604 cites W1509663381 @default.
- W2034347604 cites W1516454105 @default.
- W2034347604 cites W1588786932 @default.
- W2034347604 cites W1814445252 @default.
- W2034347604 cites W1968210840 @default.
- W2034347604 cites W1973382888 @default.
- W2034347604 cites W1979809502 @default.
- W2034347604 cites W1996182172 @default.
- W2034347604 cites W1998147193 @default.
- W2034347604 cites W2012670464 @default.
- W2034347604 cites W2037504708 @default.
- W2034347604 cites W2072764742 @default.
- W2034347604 cites W2073824505 @default.
- W2034347604 cites W2117242988 @default.
- W2034347604 cites W2131165411 @default.
- W2034347604 cites W2134600551 @default.
- W2034347604 cites W2164923618 @default.
- W2034347604 cites W2170515491 @default.
- W2034347604 cites W4205167958 @default.
- W2034347604 cites W4245645271 @default.
- W2034347604 doi "https://doi.org/10.1016/s0169-023x(99)00016-6" @default.
- W2034347604 hasPublicationYear "2000" @default.
- W2034347604 type Work @default.
- W2034347604 sameAs 2034347604 @default.
- W2034347604 citedByCount "40" @default.
- W2034347604 countsByYear W20343476042012 @default.
- W2034347604 countsByYear W20343476042013 @default.
- W2034347604 countsByYear W20343476042014 @default.
- W2034347604 countsByYear W20343476042019 @default.
- W2034347604 countsByYear W20343476042022 @default.
- W2034347604 crossrefType "journal-article" @default.
- W2034347604 hasAuthorship W2034347604A5039882708 @default.
- W2034347604 hasAuthorship W2034347604A5047987914 @default.
- W2034347604 hasConcept C159985019 @default.
- W2034347604 hasConcept C192562407 @default.
- W2034347604 hasConcept C41008148 @default.
- W2034347604 hasConcept C4679612 @default.
- W2034347604 hasConceptScore W2034347604C159985019 @default.
- W2034347604 hasConceptScore W2034347604C192562407 @default.
- W2034347604 hasConceptScore W2034347604C41008148 @default.
- W2034347604 hasConceptScore W2034347604C4679612 @default.
- W2034347604 hasIssue "1" @default.
- W2034347604 hasLocation W20343476041 @default.
- W2034347604 hasOpenAccess W2034347604 @default.
- W2034347604 hasPrimaryLocation W20343476041 @default.
- W2034347604 hasRelatedWork W2093578348 @default.
- W2034347604 hasRelatedWork W2358668433 @default.
- W2034347604 hasRelatedWork W2376932109 @default.
- W2034347604 hasRelatedWork W2382290278 @default.
- W2034347604 hasRelatedWork W2390279801 @default.
- W2034347604 hasRelatedWork W2748952813 @default.
- W2034347604 hasRelatedWork W2766271392 @default.
- W2034347604 hasRelatedWork W2890277584 @default.
- W2034347604 hasRelatedWork W2891413102 @default.
- W2034347604 hasRelatedWork W2899084033 @default.
- W2034347604 hasVolume "32" @default.
- W2034347604 isParatext "false" @default.
- W2034347604 isRetracted "false" @default.
- W2034347604 magId "2034347604" @default.
- W2034347604 workType "article" @default.