Data warehouse design from XML sources

Golfarelli, Matteo; Rizzi, Stefano; Vrdoljak, Boris

doi:10.1145/512236.512242

Cited by 95 publications

(70 citation statements)

References 6 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…An attribute tree is a directed, acyclic and weakly connected graph that represents a warehouse schema (Golfarelli et al, 2001). Once the reference model is defined, we can submit XML documents to feed the designed warehouse.…”

Section: Proposed Solutionmentioning

confidence: 99%

See 1 more Smart Citation

Warehousing complex data from the web

Boussaïd

Darmont

Bentayeb

et al. 2008

IJWET

View full text Add to dashboard Cite

Data warehousing and Online Analytical Processing (OLAP) technologies are now moving onto handling complex data that mostly originate from the web. However, integrating such data into a decision-support process requires their representation in a form processable by OLAP and/or data mining techniques.We present in this paper a complex data warehousing methodology that exploits eXtensible Markup Language (XML) as a pivot language. Our approach includes the integration of complex data in an ODS, in the form of XML documents; their dimensional modelling and storage in an XML data warehouse; and their analysis with combined OLAP and data mining techniques. We also address the crucial issue of performance in XML warehouses.

show abstract

Section: Proposed Solutionmentioning

confidence: 99%

“…In fact, two attribute trees can easily be merged through a fusion process based on pruning and grafting functions (Golfarelli et al, 2001). At this stage, two cases are possible:…”

Section: Proposed Solutionmentioning

confidence: 99%

Warehousing complex data from the web

Boussaïd

Darmont

Bentayeb

et al. 2008

IJWET

View full text Add to dashboard Cite

show abstract

“…These missing (n-p) subsets of QPS n , denoted as QPS n-1 i | (p+1)≤i≤n, are definitely not FreqQPSs and they fail to satisfy the support or the confidence requirement or both. 2 ,…,QP n-1 ), so for QP i , Freq(QP 1 , QP 2 ,…,QP n ) / Freq(QP i ) < minconf, meaning that QPS n cannot become a n-itemset FreqQPS.…”

Section: Discovering Frequent Query Path Sets In D Qpsmentioning

confidence: 99%

“…The authors of [2] present a semi-automated approach to building a conceptual schema for a data mart starting from XML sources. The work in [3] uses XML to establish an Internet-based data warehouse system to solve the defects of client/server data warehouse systems.…”

Section: Introductionmentioning

confidence: 99%

Building XML Data Warehouse Based on Frequent Patterns in User Queries

Zhang

Ling

Bruckner

et al. 2003

Data Warehousing and Knowledge Discovery

View full text Add to dashboard Cite

Abstract.With the proliferation of XML-based data sources available across the Internet, it is increasingly important to provide users with a data warehouse of XML data sources to facilitate decision-making processes. Due to the extremely large amount of XML data available on web, unguided warehousing of XML data turns out to be highly costly and usually cannot well accommodate the users' needs in XML data acquirement. In this paper, we propose an approach to materialize XML data warehouses based on frequent query patterns discovered from historical queries issued by users. The schemas of integrated XML documents in the warehouse are built using these frequent query patterns represented as Frequent Query Pattern Trees (FreqQPTs). Using hierarchical clustering technique, the integration approach in the data warehouse is flexible with respect to obtaining and maintaining XML documents. Experiments show that the overall processing of the same queries issued against the global schema become much efficient by using the XML data warehouse built than by directly searching the multiple data sources.

show abstract

“…In [4] a technique for conceptual design starting from DTDs [12] is outlined. That approach is now partially outdated due to the increasing popularity of XML Schema; besides, some complex modeling situations were not specifically addressed in the paper.…”

Section: Introductionmentioning

confidence: 99%

Designing Web Warehouses from XML Schemas

Vrdoljak

Banek

Rizzi

2003

Data Warehousing and Knowledge Discovery

Self Cite

View full text Add to dashboard Cite

Abstract. Web warehousing plays a key role in providing the managers with up-to-date and comprehensive information about their business domain. On the other hand, since XML is now a standard de facto for the exchange of semi-structured data, integrating XML data into web warehouses is a hot topic. In this paper we propose a semi-automated methodology for designing web warehouses from XML sources modeled by XML Schemas. In the proposed methodology, design is carried out by first creating a schema graph, then navigating its arcs in order to derive a correct multidimensional representation. Differently from previous approaches in the literature, particular relevance is given to the problem of detecting shared hierarchies and convergence of dependencies, and of modeling many-to-many relationships. The approach is implemented in a prototype that reads an XML Schema and produces in output the logical schema of the warehouse.

show abstract

Data warehouse design from XML sources

Cited by 95 publications

References 6 publications

Warehousing complex data from the web

Warehousing complex data from the web

Building XML Data Warehouse Based on Frequent Patterns in User Queries

Designing Web Warehouses from XML Schemas

Contact Info

Product

Resources

About