Abstract
Since XML could benefit greatly from database support and more specifically from relational database systems, we study the methodology of modeling fuzzy spatiotemporal data in XML and relational database, respectively. Furthermore, the approaches of transforming fuzzy spatiotemporal data between XML and relational databases have been proposed as well. To accomplish this, fuzzy spatiotemporal data models are devised in XML and in relational database to capture the semantics of fuzzy spatiotemporal features, respectively. To allow for better and platform independent sharing of fuzzy spatiotemporal data stored in a relational format, a temporal edge approach is proposed to accomplish the transformation of fuzzy spatiotemporal data between XML and relational databases. The unique feature of our approach is that no schema information is required for transformation of fuzzy spatiotemporal data. Moreover, temporal, spatial, and fuzzy features of fuzzy spatiotemporal data in XML documents are taken into consideration. Such approach of transformation could provide a significant consolidation of the interoperability of fuzzy spatiotemporal data between XML and relational databases.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Arenas, M., & Libkin, L. (2005). An information-theoretic approach to normal forms for relational and XML data. Journal of the ACM, 52(2), 246–283.
Atay, M., Chebotko, A., Liu, D., Lu, S., & Fotouhi, F. (2007). Efficient schema-based XML-to-relational data mapping. Information Systems, 32(3), 458–476.
Bai, L., Yan, L., & Ma, Z. M. (2013). Determining topological relationship of fuzzy spatiotemporal data integrated with XML twig pattern. Applied Intelligence, 39(1), 75–100.
Bai, L., Yan, L., & Ma, Z. M. (2014). Querying fuzzy spatiotemporal data using XQuery. Integrated Computer-Aided Engineering, 21(2), 147–162.
Balmin, A., & Papakonstantinou, Y. (2005). Storing and querying XML data using denormalized relational databases. The VLDB Journal, 14(1), 30–49.
Du, F., Amer-Yahia, S., & Freire, J. (2004). ShreX: Managing XML documents in relational databases. In Proceedings of the Thirtieth International Conference on Very Large Data Bases (pp. 1297–1300). Toronto, Canada: VLDB Endowment.
Guesgen, H. W. (2013, June). A fuzzy set approach to representing spatio-temporal and environmental context: Preliminary considerations. In Workshops at the Twenty-Seventh AAAI Conference on Artificial Intelligence (pp. 13–16). Bellevue, WA: AAAI Press.
He, J. S. K. T. G., & Naughton, C. Z. D. D. J. (2008). Relational databases for querying XML documents: limitations and opportunities. In Proceedings of VLDB (pp. 302–314). Edinburgh, Scotland: VLDB Endowment.
Krishnamurthy, R., Chakaravarthy, V. T., Kaushik, R., & Naughton, J. F. (2004). Recursive XML schemas, recursive XML queries, and relational storage: XML-to-SQL query translation. In Proceedings of the 20th International Conference on Data Engineering (pp. 42–53). Boston, MA: IEEE.
Liu, J., Ma, Z. M., & Feng, X. (2013). Storing and querying fuzzy XML data in relational databases. Applied Intelligence, 39(2), 386–396.
Liu, C., Vincent, M. W., & Liu, J. (2006). Constraint preserving transformation from relational schema to XML schema. World Wide Web, 9(1), 93–110.
Lo, A., Alhajj, R., & Barker, K. (2006). VIREX: visual relational to XML conversion tool. Journal of Visual languages & Computing, 17(1), 25–45.
Ma, Z. M., & Yan, L. (2007). Fuzzy XML data modeling with the UML and relational data models. Data & Knowledge Engineering, 63(3), 972–996.
Malaika, S. (1999). Using XML in relational database applications. In Proceedings of the 15th International Conference on Data Engineering (pp. 167). Sydney, Australia: IEEE.
Moro, M. M., Lim, L., & Chang, Y. C. (2007). Schema advisor for hybrid relational-XML DBMS. In Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data (pp. 959–970). Beijing, China: ACM.
Pal, S., Cseri, I., Seeliger, O., Schaller, G., Giakoumakis, L., & Zolotov, V. (2004). Indexing XML data stored in a relational database. In Proceedings of the Thirtieth International Conference on Very Large Data Bases (pp. 1146–1157). Toronto, Canada: VLDB Endowment.
Ribaric, S., & Hrkac, T. (2012). A model of fuzzy spatio-temporal knowledge representation and reasoning based on high-level Petri nets. Information Systems, 37(3), 238–256.
Saito, T. L., & Morishita, S. (2008). Relational-style XML query. In Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data (pp. 303–314). Vancouver, Canada: ACM.
Shanmugasundaram, J., Kiernan, J., Shekita, E. J., Fan, C., & Funderburk, J. (2001, September). Querying XML views of relational data. In Proceedings of VLDB (Vol. 1, pp. 261–270). Roma, Italy: VLDB Endowment.
Sözer, A., Yazıcı, A., Oğuztüzün, H., & Taş, O. (2008). Modeling and querying fuzzy spatiotemporal databases. Information Sciences, 178(19), 3665–3682.
Tatarinov, I., Viglas, S. D., Beyer, K., Shanmugasundaram, J., Shekita, E., & Zhang, C. (2002). Storing and querying ordered XML using a relational database system. In Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data (pp. 204–215). Madison, Wisconsin: ACM.
Wu, X., Zhang, C., & Zhang, S. (2005). Database classification for multi-database mining. Information Systems, 30(1), 71–88.
Zadeh, L. A. (1965). Fuzzy sets. Information and Control, 8(3), 338–353.
Zadeh, L. A. (1978). Fuzzy sets as a basis for a theory of possibility. Fuzzy Sets and Systems, 1(1), 3–28.
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this chapter
Cite this chapter
Ma, Z., Bai, L., Yan, L. (2020). Transformation of Fuzzy Spatiotemporal Data Between Relational Databases and XML. In: Modeling Fuzzy Spatiotemporal Data with XML. Studies in Computational Intelligence, vol 894. Springer, Cham. https://doi.org/10.1007/978-3-030-41999-8_6
Download citation
DOI: https://doi.org/10.1007/978-3-030-41999-8_6
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-41998-1
Online ISBN: 978-3-030-41999-8
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)