A relational data harmonization approach to XML

Niemi, Timo; Näppilä, Turkka; Järvelin, Kalervo

doi:10.1177/0165551509104231

Cited by 17 publications

(31 citation statements)

References 31 publications

(77 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In particular they propose SLCA [41] and MLCA [25] whose general intuition is that the LCA must be minimal. However, in [28,32] they showed that these approaches still produced undesired combinations between data items in some cases (e.g. when a data item needs to be combined with a data item at a lower level of the document hierarchy).…”

Section: Related Workmentioning

confidence: 99%

Building data warehouses with semantic web data

NebotVictoria

BerlangaRafael

2012

Decision Support Systems

View full text Add to dashboard Cite

The Semantic Web (SW) deployment is now a realization and the amount of semantic annotations is ever increasing thanks to several initiatives that promote a change in the current Web towards the Web of Data, where the semantics of data become explicit through data representation formats and standards such as RDF/(S) and OWL. However, such initiatives have not yet been accompanied by efficient intelligent applications that can exploit the implicit semantics and thus, provide more insightful analysis. In this paper, we provide the means for efficiently analyzing and exploring large amounts of semantic data by combining the inference power from the annotation semantics with the analysis capabilities provided by OLAP-style aggregations, navigation, and reporting. We formally present how semantic data should be organized in a well-defined conceptual MD schema, so that sophisticated queries can be expressed and evaluated. Our proposal has been evaluated over a real biomedical scenario, which demonstrates the scalability and applicability of the proposed approach.

show abstract

Section: Related Workmentioning

confidence: 99%

Building data warehouses with semantic web data

NebotVictoria

BerlangaRafael

2012

Decision Support Systems

View full text Add to dashboard Cite

show abstract

“…In other words, we can assume that the most of the existing data sources can be represented based on XML, which can, in turn, be represented unambiguously as XML relations. This affords us the possibility to utilize the data harmonization approach introduced in Niemi et al (2009).…”

Section: Related Work 21 Xml and Relational Databasesmentioning

confidence: 99%

“…As discussed in our previous work (Niemi et al, 2009), in many advanced applications, such as online analytical processing (OLAP), this kind of query language is necessary to satisfy the ad hoc information needs of the user. In that context, we also demonstrated formally that the XML relation representation and the related constructor algebra can be used to resolve all kinds of data conflict types in data harmonization.…”

Section: Ijwis 71mentioning

confidence: 99%

“…Lee et al (1995) have classified the possible data conflict types in the context of relational model. In Niemi et al (2009), we modified and extended their classification to cover also semi-structured XML data. The purpose of data harmonization is to remove all forms of heterogeneity from the data, that is, the similar information is represented in one uniform way.…”

Section: Harmonization Of Xml Datamentioning

confidence: 99%

“…For example, the data extraction expression products-mod1.xml [name AS product-name,category AS category-name] corresponds to the SPC function spc(products-mod1.xml, [name, category]) (Niemi et al, 2009). Based on both the above data extraction expression and the XML relation representation of the document products-mod1.xml (Appendix A), the result after…”

Section: Syntax Of Rxqlmentioning

confidence: 99%

See 2 more Smart Citations

A query language for selecting, harmonizing, and aggregating heterogeneous XML data

Näppilä

Moilanen

Niemi

2011

International Journal of Web Information Systems

Self Cite

View full text Add to dashboard Cite

Purpose -The purpose of this paper is to introduce an expressive query language, called relational XML query language (RXQL), capable of dealing with heterogeneous Extensible Markup Language (XML) documents in data-centric applications. In RXQL, data harmonization (i.e. the removal of heterogeneous factors from XML data) is integrated with typical data-centric features (e.g. grouping, ordering, and aggregation). Design/methodology/approach -RXQL is based on the XML relation representation, developed in the authors' previous work. This is a novel approach to unambiguously represent semistructured data relationally, which makes it possible in RXQL to manipulate XML data in a tuple-oriented way, while XML data are typically manipulated in a path-oriented way. Findings -The user is able to describe the result of an RXQL query straightforwardly based on non-XML syntax. The analysis of this description, through the mechanism developed in this paper, affords the automatic construction of the query result. This feature increases significantly the declarativeness of RXQL compared to the path-oriented XML languages where the user needs to control the construction of the result extensively. Practical implications -The authors' formal specification of the construction of the query result can be considered as an abstract implementation of RXQL. Originality/value -RXQL is a declarative query language capable of integrating data harmonization seamlessly with other data-centric features in the manipulation of heterogeneous XML data. So far, these kinds of XML query languages have been missing. Obviously, the expressive power of RXQL can be achieved by computationally complete XML languages, such as XQuery. However, these are not actual query languages, and the query formulation in them usually presupposes programming skills that are beyond the ordinary end-user.

show abstract

Barriers to task‐based information access in molecular medicine

Kumpulainen

Järvelin

2011

J. Am. Soc. Inf. Sci.

Self Cite

View full text Add to dashboard Cite

We analyze barriers to task-based information access in molecular medicine, focusing on research tasks, which provide task performance sessions of varying complexity. Molecular medicine is a relevant domain because it offers thousands of digital resources as the information environment. Data were collected through shadowing of real work tasks. Thirty work task sessions were analyzed and barriers in these identified. The barriers were classified by their character (conceptual, syntactic, and technological) and by their context of appearance (work task, system integration, or system). Also, work task sessions were grouped into three complexity classes and the frequency of barriers of varying types across task complexity levels were analyzed. Our findings indicate that although most of the barriers are on system level, there is a quantum of barriers in integration and work task contexts. These barriers might be overcome through attention to the integrated use of multiple systems at least for the most frequent uses. This can be done by means of standardization and harmonization of the data and by taking the requirements of the work tasks into account in system design and development, because information access is seldom an end itself, but rather serves to reach the goals of work tasks.

show abstract

A relational data harmonization approach to XML

Cited by 17 publications

References 31 publications

Building data warehouses with semantic web data

Building data warehouses with semantic web data

A query language for selecting, harmonizing, and aggregating heterogeneous XML data

Barriers to task‐based information access in molecular medicine

Contact Info

Product

Resources

About