Advertisement

Transformation of Fuzzy Spatiotemporal Data Between Relational Databases and XML

  • Zongmin MaEmail author
  • Luyi Bai
  • Li Yan
Chapter
  • 10 Downloads
Part of the Studies in Computational Intelligence book series (SCI, volume 894)

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.

References

  1. 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.MathSciNetCrossRefGoogle Scholar
  2. 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.CrossRefGoogle Scholar
  3. 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.CrossRefGoogle Scholar
  4. Bai, L., Yan, L., & Ma, Z. M. (2014). Querying fuzzy spatiotemporal data using XQuery. Integrated Computer-Aided Engineering, 21(2), 147–162.CrossRefGoogle Scholar
  5. Balmin, A., & Papakonstantinou, Y. (2005). Storing and querying XML data using denormalized relational databases. The VLDB Journal, 14(1), 30–49.CrossRefGoogle Scholar
  6. 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.Google Scholar
  7. 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.Google Scholar
  8. 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.Google Scholar
  9. 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.Google Scholar
  10. Liu, J., Ma, Z. M., & Feng, X. (2013). Storing and querying fuzzy XML data in relational databases. Applied Intelligence, 39(2), 386–396.CrossRefGoogle Scholar
  11. Liu, C., Vincent, M. W., & Liu, J. (2006). Constraint preserving transformation from relational schema to XML schema. World Wide Web, 9(1), 93–110.CrossRefGoogle Scholar
  12. Lo, A., Alhajj, R., & Barker, K. (2006). VIREX: visual relational to XML conversion tool. Journal of Visual languages & Computing, 17(1), 25–45.CrossRefGoogle Scholar
  13. Ma, Z. M., & Yan, L. (2007). Fuzzy XML data modeling with the UML and relational data models. Data & Knowledge Engineering, 63(3), 972–996.CrossRefGoogle Scholar
  14. Malaika, S. (1999). Using XML in relational database applications. In Proceedings of the 15th International Conference on Data Engineering (pp. 167). Sydney, Australia: IEEE.Google Scholar
  15. 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.Google Scholar
  16. 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.Google Scholar
  17. 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.CrossRefGoogle Scholar
  18. 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.Google Scholar
  19. 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.Google Scholar
  20. 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.CrossRefGoogle Scholar
  21. 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.Google Scholar
  22. Wu, X., Zhang, C., & Zhang, S. (2005). Database classification for multi-database mining. Information Systems, 30(1), 71–88.CrossRefGoogle Scholar
  23. Zadeh, L. A. (1965). Fuzzy sets. Information and Control, 8(3), 338–353.MathSciNetCrossRefGoogle Scholar
  24. Zadeh, L. A. (1978). Fuzzy sets as a basis for a theory of possibility. Fuzzy Sets and Systems, 1(1), 3–28.MathSciNetCrossRefGoogle Scholar

Copyright information

© Springer Nature Switzerland AG 2020

Authors and Affiliations

  1. 1.College of Computer Science and TechnologyNanjing University of Aeronautics and AstronauticsNanjingChina
  2. 2.College of Information Science and EngineeringNortheastern University (Qinhuangdao)QinhuangdaoChina
  3. 3.College of Computer Science and TechnologyNanjing University of Aeronautics and AstronauticsNanjingChina

Personalised recommendations