ISSN 0021-3454 (print version)
ISSN 2500-0381 (online version)
Menu

11
Issue
vol 67 / November, 2024
Article

DOI 10.17586/0021-3454-2016-59-5-355-363

UDC 004.91

IMPROVEMENT OF SITUATION-ORIENTED DATABASE MODEL FOR INTERACTION WITH MySQL

A. S. Gusarenko
Ufa State Aviation Technical University, Department of Automated Control Systems;; Assistant Lecturer


Read the full article 

Abstract. Completing of situation-oriented database model with specialized means for interaction with database management system MySQL is considered. An improved model of situation-oriented database (SODB) is proposed; the model extends the capabilities of the use of XML-data stored in a relational database MySQL. As a result, the proposed model is provided with tools for the database connection and management of its facilities. The interaction consists in creation of databases, tables, entering sample data and updating data; the functions are realized on the platform of SODB dynamic model interpreter developed with the use of PHP technologies. The model has an XML-based representation and equivalent representation in the form of diagrams.
Keywords: web-application, situation-oriented database, dynamic model, NoSQL, XML, DOM, РНР

References:
  1. Strauch C., Kriha W. NoSQL databases, http://www.christof-strauch.de/nosqldbs. pdf.
  2. Fowler M., Sadalage P.J. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison–Wesley, 2013, 164 р.
  3. Bogatyrev V. A. Information Technologies (Informacionnye Tehnologii), 2006, no. 9. рр. 25–30. (in Russ.)
  4. Bogatyrev V.A., Bogatyrev S.V., Bogatyrev A.V. Telekommunikatsii (Telecommunications), 2013, no. 2, pp. 42–48. (in Russ.)
  5. Tatarnikova T., Kolbanev M. IEEE EUROCON-2009, St. Petersburg, 2009, рр. 1883–1887.
  6. Pukha G.P. Sovremennoe vysokourovnevoe i ob"ektno-orientirovannoe programmirovanie (Modern High-Level and Object-Oriented Programming), St. Petersburg, 2013. (in Russ.)
  7. Mironov V. V., Shakirova G. R. Vestnik UGATU, 2006, no. 5(8), pp. 58–63. (in Russ.)
  8. Mironov V. V., Shakirova G. R. Vestnik UGATU, 2007, no. 2(9), pp. 88–97. (in Russ.)
  9. Mironov V. V., Shakirova G. R. Vestnik UGATU, 2007, no. 5(9), pp. 54–63. (in Russ.)
  10. Mironov V. V., Yusupova N. I., Shakirova G. R. Vestnik UGATU, 2010, no. 2(14), pp. 233–244. (in Russ.)
  11. Mironov V.V., Gusarenko A.S. Vestnik UGATU, 2012, no. 3(16), pp. 159–172. (in Russ.)  
  12. Mironov V.V., Gusarenko A.S. Vestnik UGATU, 2012, no. 6(16), pp. 167–176. (in Russ.)
  13. Gusarenko A.S. Obrabotka XML-dokumentov v situatsionno-orientirovannykh bazakh dannykh na osnove dinamicheskikh DOM-ob"ektov (Processing XML Documents in Situationally-Oriented Databases Based on Dynamic DOM-objects), Extended abstract of candidate’s thesis, Ufa, 2013. 16 р. (in Russ.)
  14. Zobolotskiy V. P., Ovodenko A. A., Stepanov A. G. Matematicheskie modeli v upravlenii (Mathematical Models in Management , St. Petersburg, 2001, 196 р. (in Russ.)
  15. Valeev S.S., Nikitin A.P. Vestnik UGATU, 2008, no. 1(11), pp. 215–219. (in Russ.)
  16. Valeev S.S., Urazbakhtin R.N., Khristoforov S.V. Vestnik UGATU, 2012, no. 6(16), pp. 234–251. (in Russ.)
  17. Valeev S.S., Karimov R.R., Karpenko O.Yu., Kondratyeva N.V. Vestnik UGATU, 2013, no. 6(17), pp. 57–60. (in Russ.)
  18. Valeev S.S. Proc. of the 2nd Intern. Conf. “Information Technologies for Intelligent Decision Making Support” and the Intended Intern. Workshop “Robots and Robotic Systems”, Ufa, USATU, 2014, рp. 150–152.
  19. Kanashin V.V., Mironov V.V. Vestnik UGATU, 2013, no. 2(17), pp. 138–149. (in Russ.)
  20. Kanashin V.V., Mironov V.V. Vestnik UGATU, 2013, no. 5(17), pp. 166–176. (in Russ.)
  21. Kanashin V.V., Mironov V.V. Vestnik UGATU, 2014, no. 1(18), pp. 204–213. (in Russ.)
  22. Kanashin V.V., Mironov V.V. Vestnik UGATU, 2014, no. 2(18), pp. 185–196. (in Russ.)
  23. Makarova E.S., Mironov V.V. Vestnik UGATU, 2012, no. 6(16), pp. 177–188. (in Russ.)
  24. Makarova E.S., Mironov V.V. Vestnik UGATU, 2013, no. 5(17), pp. 150–165. (in Russ.)
  25. Gusarenko A.S., Mironov V.V. Vestnik UGATU, 2014, no. 3(18), pp. 242–252. (in Russ.)
  26. Gusarenko A.S., Mironov V.V. Vestnik UGATU, 2015, no. 1(19), pp. 204–211. (in Russ.)
  27. Mironov V.V., Yusupova N.I., Shakirova G.R. Ierarkhicheskie modeli dannykh: kontseptsii i realizatsiya na osnove XML (Hierarchical Data Model: Concepts and Implementation Based on XML), Moscow, 2011, 453 р. (in Russ.)
  28. Mironov V.V., Gusarenko A.S., Dimetriev R.R., Sarvarov M.R. Vestnik UGATU, 2014, no. 4(18), pp. 191–197. (in Russ.)  
  29. Mironov V.V., Yusupova N.I., Gusarenko A.S. Vestnik UGATU, 2015, no. 2(19), pp. 188–199. (in Russ.)
  30. Гусаренко А. С. Journal of Applied Informatics, 2015, no. 3(10), pp. 62–75. (in Russ.)
  31. He W., Zhai J. Proc. of Intern. Conf. on Computational and Information Sciences (ICCIS’ 2013), 2013, no. 1, pp. 411–413.
  32. Benzaken V. et al. Proc. of the 40th Annual ACM SIGPLAN-SIGACT Symp. on Principles of Programming Languages (POPL’ 2013), Rome, Italy, 2013, рp. 101–113.
  33. Sladic G., Milosavljevic B., Konjovic Z., Vidakovic M. Computer Science and Information Systems, 2011, no. 3(8), pp. 591–609.
  34. Sudarsan R., Gray J. J. of Research and Practice in Information Technology, 2006, no. 4(38), pp. 337–351.
  35. Tang N., Yu J.X., Wong K.F., Li J.X. J. of Research and Practice in Information Technology, 2008, no. 1(40), pp. 33–53.
  36. Dekeyser S., Hidders J., Paredaens J. World Wide Web-Internet and Web Information Systems, 2004, no. 1(7), pp. 29–57.
  37. Jea K. F., Chang T. P., Chen S. Y. J. of Information Science and Engineering, 2009, no. 5(25), pp. 1617–1639.
  38. Kudrass T., Conrad M. XML-Based Data Management and Multimedia Engineering, 2002, no. 2490, pp. 210–227.
  39. Nassis V., Dillon T. S., Rajagopalapillai R., Rahayu W. Proc. of Database Systems for Advanced Applications, 2006, no. 3882, pp. 513–529.
  40. Batory D. IBM Systems Journal, 2006, no. 3(45), pp. 527–539.
  41. Dejanovic I., Milosavljevic G., Perisic B., Tumbas M.A. Computer Science and Information Systems, 2010, no. 3(7), pp. 409–440.
  42. Su-Cheng H., Lee C.S. IETE Techn. Rev., 2009, no. 1(26), pp. 28–40.