A query language for selecting, harmonizing, and aggregating heterogeneous XML data
Author:
Näppilä Turkka,Moilanen Katja,Niemi Timo
Abstract
PurposeThe 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/approachRXQL 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.FindingsThe 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 implicationsThe authors' formal specification of the construction of the query result can be considered as an abstract implementation of RXQL.Originality/valueRXQL 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.
Subject
Computer Networks and Communications,Information Systems
Reference35 articles.
1. Aho, A.V., Hopcroft, J.E. and Ullman, J.D. (1973), “On finding lowest common ancestors in trees”, Proceedings of the 5th Annual ACM Symposium on Theory of Computing, Austin, TX, USA, April 30‐May 2, ACM Press, New York, NY, pp. 253‐65. 2. Arenas, M. and Libkin, L. (2005), “XML data exchange: consistency and query answering”, in Li, C. (Ed.), Proceedings of the 24th ACM SIGACT‐SIGMOD‐SIGART Symposium on Principles of Database Systems, Baltimore, MD, USA, June 3‐15, Vol. 2005, ACM Press, New York, NY, pp. 13‐24. 3. Beyer, K., Chamberlin, D., Colby, L.S., Özcan, F., Pirahesh, H. and Xu, Y. (2005), “Extended XQuery for analytics”, in Li, C. (Ed.), Proceedings of the 24th ACM SIGACT‐SIGMOD‐SIGART Symposium on Principles of Database Systems, Baltimore, MD, USA, June 13‐15, ACM Press, New York, NY, pp. 503‐14. 4. Boag, S., Chamberlin, D., Fernández, M.F., Florescu, D., Robie, J., Siméon, J. and Watson, T.J. (2007), “XQuery 1.0: an XML query language”, W3C recommendation, available at: www.w3.org/TR/2007/REC‐xquery‐20070123/ (accessed 19 February 2010). 5. Brabrand, C., Møller, A. and Schwartzbach, M.I. (2008), “Dual syntax for XML languages”, Information Systems, Vol. 33 Nos 4/5, pp. 385‐406.
Cited by
5 articles.
订阅此论文施引文献
订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献
1. Data Harmonization for Heterogeneous Datasets in Big Data - A Conceptual Model;Software Engineering Perspectives in Intelligent Systems;2020 2. A visual XML dataspace approach for satisfying ad hoc information needs;Journal of the Association for Information Science and Technology;2015-03-27 3. XPath fragments on XML in columns;International Journal of Web Information Systems;2013-11-18 4. XML data exchange with target constraints;Information Processing & Management;2013-03 5. An approach for developing a schemaless XML dataspace profiling system;Journal of Information Science;2012-04-18
|
|