Integrating XML Sources into a Data Warehouse

Vrdoljak, Boris; Banek, Marko; Skočir, Zoran

doi:10.1007/11780397_11

Cited by 8 publications

(6 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Its alternative, that respects the grammar (XSchema), was used. Using this, Vrdoljak et al detail a purchase order analysis [82] along with the associated integration tool [83]. In the proposals, the authors use multiple XML files as data sources and data are linked together with the ID/IDREF XML mechanism.…”

Section: Detailed Presentation Of Researchesmentioning

confidence: 99%

Finding an application-appropriate model for XML data warehouses

Ravat

Teste

Tournier

et al. 2010

Information Systems

View full text Add to dashboard Cite

Section: Detailed Presentation Of Researchesmentioning

confidence: 99%

Finding an application-appropriate model for XML data warehouses

Ravat

Teste

Tournier

et al. 2010

Information Systems

View full text Add to dashboard Cite

“…Solutions intended for the RDBs should be researched for an upgrade by applicability to new types of data. Similar research was also done on integration of XML files with the DWH [25,40]. Since XML format bears resemblance with document stores (Section 3), these approaches should also be considered for an implementation in NoSQL and JSON environment, targeted for the BigDWH integration.…”

Section: Multidimensional Design Of Bigdwhmentioning

confidence: 99%

“…Later research also focused on integration of newly emerging data types (e.g. XML [40], linked data [41]), as well as overall (semi-)automatization of the design process [14,15,21,42,43]. The following list addresses the most common features in MDC discovery found in the past research of either (Big)DWH design attempts, or semantic-based DWH design, which we believe to have potential in warehousing of big data:…”

Section: Outlining Mdcsmentioning

confidence: 99%

The potential of semantic paradigm in warehousing of big data

2019

Self Cite

View full text Add to dashboard Cite

Big data have analytical potential that was hard to realize with available technologies. After new storage paradigms intended for big data such as NoSQL databases emerged, traditional systems got pushed out of the focus. The current research is focused on their reconciliation on different levels or paradigm replacement. Similarly, the emergence of NoSQL databases has started to push traditional (relational) data warehouses out of the research and even practical focus. Data warehousing is known for the strict modelling process, capturing the essence of the business processes. For that reason, a mere integration to bridge the NoSQL gap is not enough. It is necessary to deal with this issue on a higher abstraction level during the modelling phase. NoSQL databases generally lack clear, unambiguous schema, making the comprehension of their contents difficult and their integration and analysis harder. This motivated involving semantic web technologies to enrich NoSQL database contents by additional meaning and context. This paper reviews the application of semantics in data integration and data warehousing and analyses its potential in integrating NoSQL data and traditional data warehouses with some focus on document stores. Also, it gives a proposal of the future pursuit directions for the big data warehouse modelling phases.

show abstract

“…(Golfarelli et al, 2001 ;Pokorný, 2001) proposent d'intégrer des données XML à partir de leur DTD. (Vrdoljak et al, 2003 ;Vrdoljak et al, 2006) proposent de créer un schéma multidimensionnel à partir de la définition XSchema des documents XML. (Niemi et al, 2002) assemble à la volée des cubes de données XML à partir de requêtes utilisateur.…”

Section: éTat De L'artunclassified

Analyse multidimensionnelle de documents via des dimensions OLAP

Ravat¹,

Teste²,

Tournier³

2007

Document numérique

View full text Add to dashboard Cite

Avec l'émergence de formats de données semi-structurés (tels que XML), le stockage de documents dans un entrepôt centralisé est apparu de façon naturelle comme une adaptation des entrepôts de données. De nos jours, les systèmes OLAP (On-Line Analytical Processing) font face à une part grandissante de données non numériques. Cet article présente un environnement pour l'analyse multidimensionnelle de données textuelles dans un environnement OLAP. La structure, les métadonnées et le contenu des documents orientés texte sont transposés en sujets d'analyse (faits) et en axes d'analyse (dimensions) au sein d'un schéma en étoile modifié. Ceci permet de plus amples possibilités d'analyses multidimensionnelles. Cet environnement permet à un utilisateur d'avoir une vision détaillée au sein d'une collection de documents. ABSTRACT. With the emergence of semi-structured data format (such as XML), the storage of documents in centralized facilities has slowly appeared as a natural adaptation of data warehousing technology. Nowadays, OLAP (On-Line Analytical Processing) systems face growing non-numeric data. This paper presents a framework for the multidimensional analysis of textual data in an OLAP sense. Document structure, document meta-data and document contents are converted into subjects of analysis (facts) and analysis axes (dimensions) within an adapted star schema. This allows greater multidimensional analysis possibilities. This framework allows a user to gain insight within a collection of documents.

show abstract

Integrating XML Sources into a Data Warehouse

Cited by 8 publications

References 9 publications

Finding an application-appropriate model for XML data warehouses

Finding an application-appropriate model for XML data warehouses

The potential of semantic paradigm in warehousing of big data

Analyse multidimensionnelle de documents via des dimensions OLAP

Contact Info

Product

Resources

About