Matches in SemOpenAlex for { <https://semopenalex.org/work/W2182185637> ?p ?o ?g. }
Showing items 1 to 55 of
55
with 100 items per page.
- W2182185637 abstract "Example1 Suppose wecreate aview, ojview, asshown below. Theviewconsists ofouter joins ofthetables part, Queries containing outer joins arecommonindata lieie anoresfo h P- aaae ealta warehousing applications. Materialized outer-join views pt'key t i k f and oorderkeh is the could greatly speed upmanysuchqueries butmostdatabasee primary keyof oa f n keyrconstraintbe systems donotallow outer joins inmaterialized views. In primary keyoforders. There aSaforeogn keyconstralnt bepart, this isbecause outer-join views could notpreviously andorders. bemaintained efficiently whenbasetables areupdated. Inthis paperweshowhowtoefficiently maintain general create viewoj-view as outer-join views, that is, views composed ofselection, pro- select p-partkey, p_name, p_retailprice, o_orderkey, jection innerandouterjoin. Fore e c s a o_custkey,il_inenumber,l_quantity,lextendedprice Inedconstraints are from partfull outer join exploited toreduce maintenance overhead. Experimental (orders leftouterjoinlineitem onl_orderkey=o_orderkey) results showthat maintaining anouter-join viewneednot onppartkey=l-partkey bemoreexpensive thanmaintaining aninner-join view. Wefirst analyze whattypes oftuples theviewmaycon" @default.
- W2182185637 created "2016-06-24" @default.
- W2182185637 creator A5038175613 @default.
- W2182185637 creator A5057864403 @default.
- W2182185637 date "2007-01-01" @default.
- W2182185637 modified "2023-09-27" @default.
- W2182185637 title "Efficient Maintenance ofMaterialized Outer-Join Views" @default.
- W2182185637 hasPublicationYear "2007" @default.
- W2182185637 type Work @default.
- W2182185637 sameAs 2182185637 @default.
- W2182185637 citedByCount "0" @default.
- W2182185637 crossrefType "journal-article" @default.
- W2182185637 hasAuthorship W2182185637A5038175613 @default.
- W2182185637 hasAuthorship W2182185637A5057864403 @default.
- W2182185637 hasConcept C114614502 @default.
- W2182185637 hasConcept C199360897 @default.
- W2182185637 hasConcept C2776124973 @default.
- W2182185637 hasConcept C2778692605 @default.
- W2182185637 hasConcept C2779960059 @default.
- W2182185637 hasConcept C33923547 @default.
- W2182185637 hasConcept C41008148 @default.
- W2182185637 hasConceptScore W2182185637C114614502 @default.
- W2182185637 hasConceptScore W2182185637C199360897 @default.
- W2182185637 hasConceptScore W2182185637C2776124973 @default.
- W2182185637 hasConceptScore W2182185637C2778692605 @default.
- W2182185637 hasConceptScore W2182185637C2779960059 @default.
- W2182185637 hasConceptScore W2182185637C33923547 @default.
- W2182185637 hasConceptScore W2182185637C41008148 @default.
- W2182185637 hasLocation W21821856371 @default.
- W2182185637 hasOpenAccess W2182185637 @default.
- W2182185637 hasPrimaryLocation W21821856371 @default.
- W2182185637 hasRelatedWork W145595142 @default.
- W2182185637 hasRelatedWork W155158231 @default.
- W2182185637 hasRelatedWork W1984017666 @default.
- W2182185637 hasRelatedWork W1984074239 @default.
- W2182185637 hasRelatedWork W2213008616 @default.
- W2182185637 hasRelatedWork W2373895828 @default.
- W2182185637 hasRelatedWork W2383698799 @default.
- W2182185637 hasRelatedWork W2404915542 @default.
- W2182185637 hasRelatedWork W2740404111 @default.
- W2182185637 hasRelatedWork W2995919996 @default.
- W2182185637 hasRelatedWork W1543070288 @default.
- W2182185637 hasRelatedWork W1586726770 @default.
- W2182185637 hasRelatedWork W1588553671 @default.
- W2182185637 hasRelatedWork W2206469851 @default.
- W2182185637 hasRelatedWork W2285527477 @default.
- W2182185637 hasRelatedWork W2286657454 @default.
- W2182185637 hasRelatedWork W2414091880 @default.
- W2182185637 hasRelatedWork W2738810556 @default.
- W2182185637 hasRelatedWork W2832134883 @default.
- W2182185637 hasRelatedWork W303560973 @default.
- W2182185637 isParatext "false" @default.
- W2182185637 isRetracted "false" @default.
- W2182185637 magId "2182185637" @default.
- W2182185637 workType "article" @default.