his.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Evaluation of view maintenance with complex joins in a data warehouse environment
University of Skövde, Department of Computer Science.
2002 (English)Independent thesis Advanced level (degree of Master (One Year))Student thesis
Abstract [en]

Data warehouse maintenance and maintenance cost has been well studied in the literature. Integrating data sources, in a data warehouse environment, may often need data cleaning, transformation, or any other function applied to the data in order to integrate it. The impact on view maintenance, when data is integrated with other comparison operators than defined in theta join, has, however, not been closely looked at in previous studies.

In this study the impact of using a complex join in data warehouse environment is analyzed to measure how different maintenance strategies are affected when data needs to be integrated using other comparison operators than defined in a theta join. The analysis shows that maintenance cost is greatly increased when using complex joins since such joins often lack optimization techniques which are available when using a theta join. The study shows, among other things, that the join aware capability of sources is not of importance when performing complex joins, and incremental view maintenance is better approach than using recomputed view maintenance, when using complex joins. Strategies for maintaining data warehouses when data is integrated using a complex join are therefore different than when a theta join is used, and different maintenance strategies need to be applied.

Place, publisher, year, edition, pages
Skövde: Institutionen för datavetenskap , 2002. , 10 p.
Keyword [en]
Data warehouses, view maintenance, join algorithms
National Category
Information Science
Identifiers
URN: urn:nbn:se:his:diva-714OAI: oai:DiVA.org:his-714DiVA: diva2:3115
Presentation
(English)
Uppsok
samhälle/juridik
Supervisors
Available from: 2008-02-04 Created: 2008-02-04 Last updated: 2009-05-08

Open Access in DiVA

fulltext(1313 kB)237 downloads
File information
File name FULLTEXT01.psFile size 1313 kBChecksum MD5
929db1f0c9c738abd402ac403a18ac2e1d9e81793f2ca797fe88a01ac530fff7dce43c16
Type fulltextMimetype application/postscript
fulltext(365 kB)233 downloads
File information
File name FULLTEXT02.pdfFile size 365 kBChecksum SHA-512
148396b235db880669c99482b6556ebeb0c07e58216e43e72a8703a64059b35d158f92d6ba2fb8afab09ed7a031dba6422b23e94192b376a8f33c53243a71a73
Type fulltextMimetype application/pdf

By organisation
Department of Computer Science
Information Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 470 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

Total: 487 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf