A Landscape of XML Data from Analytics Perspective

Abstract

Abstract The journey of the database started with a relational database followed by transactional, eXtensible Markup Language (XML)[10,11], Not only SQL (NoSQL), and Hybrid Transactional/Analytical Processing (HTAP) database[2]. Analytic functions in SQL are used to process analytical databases, XQuery is used to process XML databases and NewSQL queries are used to process Hybrid Transactional and Analytical Processing (HTAP) databases. In the current scenario, the research related to the XML database and analytics on the XML database is an important area of concern. Numerous enterprises use XML as a data exchange format. Considering all the benefits of XML and its use in the field of web applications, various works elaborate to adopt it as a data storage technology. In this work, an attempt has been made to perform analytical functions using XQuery on an XML data and compare its performance with Analytical SQL queries in terms of execution time. A sample set of queries has been performed on a sample dataset. According to the results, it is concluded that Analytic SQL is dominating XQuery to perform analytical functions. In experimentation, we explained the persistence of XML data (electronic health records dataset) in eXist-DB and BaseX and executing queries on that data. The finding is that the performance of XML data in a health care environment is better if we use BaseX instead of eXist-DB.