Abstract
Information imprecision and uncertainty exist in many real-world applications and for this reason fuzzy data management has been extensively investigated in various database management systems. Currently, introducing native support for XML data in relational database management systems (RDBMs) has attracted considerable interest with a view to leveraging the powerful and reliable data management services provided by RDBMs. Although there is a rich literature on XML-to-relational storage, none of the existing solutions satisfactorily addresses the problem of storing fuzzy XML data in RDBMs. In this paper, we study the methodology of storing and querying fuzzy XML data in relational databases. In particular, we present an edge-based approach to shred fuzzy XML data into relational data. The unique feature of our approach is that no schema information is required for our data storage. On this basis, we present a generic approach to translate path expression queries into SQL for processing XML queries.
Similar content being viewed by others
Explore related subjects
Discover the latest articles, news and stories from top researchers in related subjects.References
Abiteboul S, Senellart P (2006) Querying and updating probabilistic information in XML. In: Proceedings of EDBT, pp 1059–1068
Abiteboul S, Kimelfeld B, Sagiv B, Senellart Y (2009) On the expressiveness of probabilistic XML models. VLDB J 18(5):1041–1064
Amer-Yahia S, Du F, Freire J (2004) A comprehensive solution to the XML-to-relational mapping problem. In: Proceedings of WIDM, pp 31–38
Amer-Yahia S, Srivastava D (2002) A mapping schema and interface for XML stores. In: Proceedings of WIDM, pp 23–30
Atay M, Chebotko A, Liu D et al (2007) Efficient schema-based XML-to-relational data mapping. Inf Syst 32:458–476
Campi A, Damiani E, Guinea S et al (2009) A fuzzy extension of the XPath query language. J Intell Inf Syst 33(3):285–305
Codd EF (1970) A relational model of data for large shared data bases. Commun ACM 13(6):377–387
Florescu D, Kossmann D (1999) Storing and querying XML data using an RDMBS. IEEE Data Eng Bull 22:27–34
Galindo J, Medina J, Pons O, Cubero J (1998) A server for fuzzy SQL queries. In: Proceedings of the 3rd international conference on flexible query answering systems, pp 164–175
Gaurav A, Alhajj R (2006) Incorporating fuzziness in XML and mapping fuzzy relational data into fuzzy XML. In: Proceedings of the 2006 ACM symposium on applied computing, pp 456–460
Hollander ES, van Keulen M (2010) Storing and querying probabilistic XML using a probabilistic relational DBMS. In: Proceedings of the 4th international workshop on management of uncertain data (MUD 2010), pp 35–49
Hung E, Getoor L, Subrahmanian VS (2003) PXML: a probabilistic semistructured data model and algebra. In: Proceedings of ICDE, pp 467–478
Jiang H, Lu H, Wang W, Yu JX (2001) Path materialization revisited: an efficient storage model for XML data. In: Proceedings of the 2nd Australian institute of computer ethics conference, pp 85–94
Krishnamurthy R, Chakaravarthy V, Kaushik R, Naughton J (2004) Recursive XML schemas, recursive XML queries, and relational storage: XML-to-SQL query translation. In: Proceedings of ICDE, pp 42–53
Liu J, Ma ZM, Feng X (2012) Formal approach for reengineering fuzzy xml in fuzzy object-oriented databases. Appl Intell. doi:10.1007/s10489-012-0386-4
Liu J, Ma ZM, Yan L (2009) Efficient processing of twig pattern matching in fuzzy XML. In: Proceedings of CIKM, pp 193–204
Ma ZM, Liu J, Yan L (2010) Fuzzy data modeling and algebraic operations in XML. Int J Intell Syst 25(9):925–947
Ma ZM, Yan L (2007) Fuzzy XML data modeling with the UML and relational data models. Data Knowl Eng 63:972–996
Nierrman A, Jagadish HV (2002) ProTDB: probabilistic data in XML. In: Proceedings of VLDB, pp 646–657
Pal S, Cseri I, Seeliger O et al (2004) Indexing XML data stored in a relational database. In: Proceedings of VLDB, pp 1146–1157
Peng F, Chawathe SS (2005) XSQ: a streaming XPath engine. ACM Trans Database Syst 30(2):577–623
Senellart P, Abiteboul S (2007) On the complexity of managing probabilistic XML data. In: Proceedings of PODS, pp 283–292
Tatarinov I, Viglas SD, Beyer K et al (2002) Storing and querying ordered XML using a relational database system. In: Proceedings of SIGMOD, pp 204–215
Turowski K, Weng U (2002) Representing and processing fuzzy information an XML-based approach. J Knowl-Based Syst 15:67–75
Valova I, Milano G, Bowen K, Gueorguieva N (2011) Bridging the fuzzy, neural and evolutionary paradigms for automatic target recognition. Appl Intell 35(2):211–225
Weigel F, Schulz KU, Meuss H (2005) Exploiting native XML indexing techniques for XML retrieval in relational database systems. In: Proceedings of WIDM, pp 23–30
W3C (1999) XML path language (XPath) version 1.0. http://www.w3.org/TR/xpath
Yoshikawa M, Amagasa T (2001) XRel: a path-based approach to storage and retrieval of XML documents using relational databases. ACM Trans Internet Technol 1(1):110–141
Zadeh LA (1965) Fuzzy sets. Inf Control 8(3):338–353
Zajaczkowski J, Verma B (2012) Selection and impact of different topologies in multi-layered hierarchical fuzzy systems. Appl Intell 36(3):564–584
Acknowledgements
The authors thank the anonymous referees for their valuable comments and suggestions, which improved the technical content and the presentation of the paper. The work is supported by the National Natural Science Foundation of China (60873010) and the Fundamental Research Funds for the Central Universities (N090504005 and N100604017).
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Liu, J., Ma, Z.M. & Feng, X. Storing and querying fuzzy XML data in relational databases. Appl Intell 39, 386–396 (2013). https://doi.org/10.1007/s10489-012-0419-z
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10489-012-0419-z