Source: http://jitcs.ru/index.php?option=com_content&view=article&id=559
Timestamp: 2019-04-18 11:10:12+00:00

Document:
Situation-oriented database (SODB) represents the information processor for processing the XML-documents as part of a Web application that is running by means of built-in situational models. Considered SOBD architecture with a virtual document repository, which contains the XML-data and virtual documents processed by the data processing objects DPO. The document repository can store heterogeneous data as files, web services, the zip-archives and DBMS. Considered SODB integration with relational environment MySQL as a source of XML-Data - XML-documents are physically stored in a MySQL database, how to handle the process of loading data in DOM-objects created by the interpreter situational model. Proposed linguistic tools for specifying in the situational model for displaying XMLdata in a MySQL table. In SODB there are several types of virtual documents dom-element, src-element, rcv-element, doc-element. These types of elements are used to display documents from the file system in a DBMS table. Discussed the practical implementation of the approach using PHP platform and the mysqli extension, and its application in web applications.
situation-oriented database; web-application; model-driven approach; hierarchical situation model; virtual document; relational data; data integration; HSM; NoSQL; XML; DOM; MySQL; PHP; mysqli.
1. Agustin J.L.H., Del Barco P.C. A model-driven approach to develop high performance web applications. In: J. of Systems and Software. Vol. 86, no. 12, pp. 3013–3023 (2013).
2. Pinheiro P.V. P., Endo A.T., Simao A. Model-Based Testing of RESTful Web Services Using UML Protocol State Machines. In: Brazilian Workshop on Systematic and Automated Software Testing (2013).
4. Aguilar J.A. et al. An Analysis of Techniques and Tools for Requirements Elicitation in Model-Driven Web Engineering Methods In: Computational Science and Its Applications ICCSA 2015, pp. 518–527. Springer International Publishing (2015).
5. Delgado A., Marotta A., Gonzalez L. Towards the construction of quality-aware Web Warehouses with BPMN 2.0 Business Processes. In: IEEE Eighth International Conference on Research Challenges in Information Science (RCIS’2014), pp. 1–6. IEEE (2014).
6. Delgado A., Marotta A. Automating the process of building flexible Web Warehouses with BPM Systems. In: Computing Conference (CLEI), 2015 Latin American, pp. 1–11. IEEE Press (2015).
7. Pokorny J. NoSQL databases: a step to database scalability in web environment. In: Int. J. of Web Information Systems. Vol. 9, no. 1, pp. 69–82 (2013).
8. Bugiotti, F., Cabibbo, L., Atzeni, P., Torlone, R. Database design for NoSQL systems. In: Conceptual Modeling, pp. 223–231. Springer International Publishing (2014).
9. Zhang S. Application of document-oriented NoSQL database technology in web-based software project documents management system. In: IEEE International Conference on Information Science and Technology (ICIST), pp. 504–507 (2013).
13. Mironov V. V., Gusarenko A. S. Dinamicheskie DOM-objekty v situ-acionno-orientirovannyh bazah dannyh: lingvisticheskoe i algoritmicheskoe obespechenie istochnikov dannyh // Vestnik UGATU. 2012. V. 16, no. 6 (51). pp. 167–176.
14. Gusarenko A.S., Mironov V. V. Smarty-objekty: variant ispol'zovanija geterogennyh istochnikov v situacionnoorientirovannyh bazah dannyh // Vestnik UGATU. 2014. V. 18, no. 3 (63). pp. 242–252. (Smarty-objects: using of heterogeneous sources in a situation-oriented databases. In: Vestnik UGATU. 2014. V. 18, no. 3 (63). pp. 242-252).
18. Arlazarov V.L., Emel'janov N. E. Dokumentooborot kak informacionnaja baza nakoplenija znanij // Trudy Instituta sistemnogo analiza Rossijskoj akademii nauk. 2007. T. 29. S. 6–48.
19. Dolgorukov A.Ju., Erohin V. I. Jazyk zaprosov hranilishha dokumentov, postroennogo na NIKA-tehnologii // Trudy Instituta sistemnogo analiza Rossijskoj akademii nauk. 2010. T. 58. S. 48–60.
20. Emel'janov N.E., Tishhenko V. A. Metodologija postroenija mnogourovnevogo indeksa kljuchevogo massiva po leksikograficheskomu priznaku na osnove metoda regressionnogo analiza na primere SUBD NIKA // Trudy Instituta sistemnogo analiza Rossijskoj akademii nauk. 2010. T. 58. S. 6–17.
22. Ilya Taranov, Ivan Shcheklein, Alexander Kalinin, et al. Sedna: native XML database management system (internals overview) // SIGMOD '10: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data. New York, NY, USA: ACM, 2010. Pages 1037–1046.
24. Gusarenko A. S. Usovershenstvovanie modeli situacionno-orientirovannoj bazy dannyh dlja vzaimodejstvija s MySQL // Izvestija vysshih uchebnyh zavedenij. Priborostroenie. 2016. Т. 59. № 5. С. 355–363.
25. Gusarenko A.S., Mironov V.V. Geterogennye istochniki dokumentov v situacionno-orientirovannyh bazah dannyh // Vestnik UGATU. 2015. V. 19. № 4. P. 124–131.
26. Kanashin V.V., Mironov V.V. Ierarhicheskie vidzhety: organizacija interfejsa pol'zovatelja v veb-prilozhenijah na osnove situacionno-orientirovannyh baz dannyh // Vestnik UGATU. 2013. V. 17, № 2 (55). P. 138–149.
27. Kanashin V.V., Mironov V.V. Ierarhicheskie vidzhety: vvod i kontrol' dannyh pol'zovatelja v veb-prilozhenijah na osnove situacionno-orientirovannyh baz dannyh // Vestnik UGATU. 2013. Т. 17, № 5 (58). С. 166–176.
28. Kanashin V.V., Mironov V.V. Ierarhicheskie vidzhety: algoritmy kontrolja dannyh pol'zovatelja v veb-prilozhenijah na osnove situacionno-orientirovannyh baz dannyh // Vestnik UGATU. 2014. Т. 18, № 1 (62). С. 204–213.
29. Kanashin V.V., Mironov V.V. Ierarhicheskie vidzhety: opyt primenenija v veb-prilozhenii na osnove si-tuacionnoorientirovannoj bazy dannyh // Vestnik UGATU. 2014. Т. 18, № 2 (63). С. 185–196.
30. Makarova E.S., Mironov V.V. Proektirovanie konceptual'noj modeli dannyh dlja zadach Web-OLAP na osnove situacionnoorientirovannoj bazy dannyh // Vestnik UGATU. 2012. Т. 16, № 6 (51). С. 177–188.
31. Makarova E.S., Mironov V.V. Funkcii analitiki v veb-prilozhenijah na osnove situacionno-orientirovannyh baz dannyh // Vestnik UGATU. 2013. V. 17, № 5 (58). P. 150–165.
32. Dejanovic I., Milosavljevic G., Perisic B., Tumbas M. A. Domain-specific language for defining static structure of database applications. In Computer Science and Information Systems, Vol. 7, No. 3, P. 409–440, 2010.
33. Djukic V. et. al. Model Execution: An Approach based on extending Domain-Specific Modeling with Action Reports // Computer Science and Infor-mation Systems. 2013. Т. 10. № 4. С. 1585–1620.

References: V. 
 V. 
 V. 
 V. 
 V. 
 V. 
 V. 
 V. 
 V. 
 V. 
 V.