DOI 10.17586/0021-3454-2016-59-5-355-363
UDC 004.91
IMPROVEMENT OF SITUATION-ORIENTED DATABASE MODEL FOR INTERACTION WITH MySQL
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:
References:
-
Strauch C., Kriha W. NoSQL databases, http://www.christof-strauch.de/nosqldbs. pdf.
-
Fowler M., Sadalage P.J. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison–Wesley, 2013, 164 р.
-
Bogatyrev V. A. Information Technologies (Informacionnye Tehnologii), 2006, no. 9. рр. 25–30. (in Russ.)
-
Bogatyrev V.A., Bogatyrev S.V., Bogatyrev A.V. Telekommunikatsii (Telecommunications), 2013, no. 2, pp. 42–48. (in Russ.)
-
Tatarnikova T., Kolbanev M. IEEE EUROCON-2009, St. Petersburg, 2009, рр. 1883–1887.
-
Pukha G.P. Sovremennoe vysokourovnevoe i ob"ektno-orientirovannoe programmirovanie (Modern High-Level and Object-Oriented Programming), St. Petersburg, 2013. (in Russ.)
-
Mironov V. V., Shakirova G. R. Vestnik UGATU, 2006, no. 5(8), pp. 58–63. (in Russ.)
-
Mironov V. V., Shakirova G. R. Vestnik UGATU, 2007, no. 2(9), pp. 88–97. (in Russ.)
-
Mironov V. V., Shakirova G. R. Vestnik UGATU, 2007, no. 5(9), pp. 54–63. (in Russ.)
-
Mironov V. V., Yusupova N. I., Shakirova G. R. Vestnik UGATU, 2010, no. 2(14), pp. 233–244. (in Russ.)
-
Mironov V.V., Gusarenko A.S. Vestnik UGATU, 2012, no. 3(16), pp. 159–172. (in Russ.)
-
Mironov V.V., Gusarenko A.S. Vestnik UGATU, 2012, no. 6(16), pp. 167–176. (in Russ.)
-
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.)
-
Zobolotskiy V. P., Ovodenko A. A., Stepanov A. G. Matematicheskie modeli v upravlenii (Mathematical Models in Management , St. Petersburg, 2001, 196 р. (in Russ.)
-
Valeev S.S., Nikitin A.P. Vestnik UGATU, 2008, no. 1(11), pp. 215–219. (in Russ.)
-
Valeev S.S., Urazbakhtin R.N., Khristoforov S.V. Vestnik UGATU, 2012, no. 6(16), pp. 234–251. (in Russ.)
-
Valeev S.S., Karimov R.R., Karpenko O.Yu., Kondratyeva N.V. Vestnik UGATU, 2013, no. 6(17), pp. 57–60. (in Russ.)
-
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.
-
Kanashin V.V., Mironov V.V. Vestnik UGATU, 2013, no. 2(17), pp. 138–149. (in Russ.)
-
Kanashin V.V., Mironov V.V. Vestnik UGATU, 2013, no. 5(17), pp. 166–176. (in Russ.)
-
Kanashin V.V., Mironov V.V. Vestnik UGATU, 2014, no. 1(18), pp. 204–213. (in Russ.)
-
Kanashin V.V., Mironov V.V. Vestnik UGATU, 2014, no. 2(18), pp. 185–196. (in Russ.)
-
Makarova E.S., Mironov V.V. Vestnik UGATU, 2012, no. 6(16), pp. 177–188. (in Russ.)
-
Makarova E.S., Mironov V.V. Vestnik UGATU, 2013, no. 5(17), pp. 150–165. (in Russ.)
-
Gusarenko A.S., Mironov V.V. Vestnik UGATU, 2014, no. 3(18), pp. 242–252. (in Russ.)
-
Gusarenko A.S., Mironov V.V. Vestnik UGATU, 2015, no. 1(19), pp. 204–211. (in Russ.)
-
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.)
-
Mironov V.V., Gusarenko A.S., Dimetriev R.R., Sarvarov M.R. Vestnik UGATU, 2014, no. 4(18), pp. 191–197. (in Russ.)
-
Mironov V.V., Yusupova N.I., Gusarenko A.S. Vestnik UGATU, 2015, no. 2(19), pp. 188–199. (in Russ.)
-
Гусаренко А. С. Journal of Applied Informatics, 2015, no. 3(10), pp. 62–75. (in Russ.)
-
He W., Zhai J. Proc. of Intern. Conf. on Computational and Information Sciences (ICCIS’ 2013), 2013, no. 1, pp. 411–413.
-
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.
-
Sladic G., Milosavljevic B., Konjovic Z., Vidakovic M. Computer Science and Information Systems, 2011, no. 3(8), pp. 591–609.
-
Sudarsan R., Gray J. J. of Research and Practice in Information Technology, 2006, no. 4(38), pp. 337–351.
-
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.
-
Dekeyser S., Hidders J., Paredaens J. World Wide Web-Internet and Web Information Systems, 2004, no. 1(7), pp. 29–57.
-
Jea K. F., Chang T. P., Chen S. Y. J. of Information Science and Engineering, 2009, no. 5(25), pp. 1617–1639.
-
Kudrass T., Conrad M. XML-Based Data Management and Multimedia Engineering, 2002, no. 2490, pp. 210–227.
-
Nassis V., Dillon T. S., Rajagopalapillai R., Rahayu W. Proc. of Database Systems for Advanced Applications, 2006, no. 3882, pp. 513–529.
-
Batory D. IBM Systems Journal, 2006, no. 3(45), pp. 527–539.
-
Dejanovic I., Milosavljevic G., Perisic B., Tumbas M.A. Computer Science and Information Systems, 2010, no. 3(7), pp. 409–440.
- Su-Cheng H., Lee C.S. IETE Techn. Rev., 2009, no. 1(26), pp. 28–40.