Situation-Oriented Databases: Processing Office Documents

This article discusses the application of a situation-oriented approach to the problem of extracting semantic information from office documents. Office documents created by vector graphics editors and word processors are reviewed. The ability to extract semantic information is due to the fact that such documents are based on open XML formats that can be processed by external programs. Processing of documents based on a situational database where word documents are programmatically loaded as XML files extracted from zip-archives is considered. In the situation-oriented database, it is possible to present an office document as a virtual document that is mapped both on XML files and the ZIP archive with XML files. This applies not only to text documents, but also to graphic documents that have an internal XML representation. This enables processing of documents in Office Open XML and Open Document Format. The article discusses various aspects of identifying and finding the necessary information during document processing by means of special standard definitions as bookmarks, key phrases and text labels. Models and algorithms for extracting the required information are examined. Examples of the practical use of this approach in the field of distance learning of students at the university are given. In addition, an example of extracting metadata of scientific publications in the Open Journal Systems publishing system is regarded.

1. Hou X., Li N., Yang H., Liang Q. Comparison of Wordprocessing Document Format in OOXML and ODF. In: 2010 Sixth International Conference on Semantics, Knowledge and Grids. 2010:297–300. DOI:10.1109/SKG.2010.44

2. Schubert S. The Next Millennium Document Format. In DocEng’19: Proceedings of the ACM Symposium on Document Engineering 2019. New York, NY, USA: Association for Computing Machinery. 2019:1–4. DOI:10.1145/3342558.3345419

3. Roig J., Ribera M. Implementation of the OOXML standard since its approval until today. In DSAI’2020: 9th International Conference on Software Development and Technologies for Enhancing Accessibility and Fighting Info-exclusion. New York, NY, USA: Association for Computing Machinery. 2020:129–134. DOI:10.1145/3439231.3440607

4. Mironov V.V., Gusarenko A.S., Yusupova N.I. Structuring virtual multi-documents in situationally-oriented databases by means of entry-elements. SPIIRAS Proceedings. 2017;4(53):225–242. DOI:10.15622/sp.53.11 (In Russ.)

5. Mironov V.V., Gusarenko A.S., Yusupova N.I. Situation-oriented databases: polyglot persistence based on REST microservices. Applied Informatics. 2019;5(83):87–97. DOI:10.24411/1993-8314-2019-10038 (In Russ.)

6. Mironov V.V., Gusarenko A.S., Yusupova N.I., Smetanin Y.G. JSON documents processing using situation-oriented databases. Acta Polytechnica Hungarica. 2020;17(8):29–40. DOI:10.12700/APH.17.8.2020.8.3

7. Mironov V.V., Gusarenko A.S., Tuguzbaev G.A. Graphic Documents Parametric Personalization for Information Support of Educational Design Using Situation-Oriented Databases. In ITIDS’2020: 8th Scientific Conference on Information Technologies for Intelligent Decision Making Support. Atlantis Press. 2020:260–267. DOI:10.2991/assehr.k.201029.050

8. Mironov V.V., Gusarenko A.S., Tuguzbaev G.A. Extracting semantic information from graphic schemes. Informatics and Automation. 2021;20(4):940–970. DOI:10.15622/IA.20.4.7 (In Russ.)

9. Mironov V.V., Gusarenko A.S., Yusupova N.I. Building of Virtual Multidocuments Mapping to Real Sources of Data in Situation-Oriented Databases. Communications in Computer and Information Science. 1204 CCIS. 2021:167–178. DOI:10.1007/978-3-030-78273-3_17

10. Mironov V.V., Gusarenko A.S., Yusupova N.I. Monitoring YouTube Video Views in the Educational Environment Based on Situation-Oriented Database and RESTful Web Services. SIIT. 2021;3(1(5)):39–49.

11. Kulkarni A., Shivananda A. Extracting the Data – Natural Language Processing Recipes. Springer; 2019.

12. Bolotova LS, Danchul AN, Novikov AP, Surkhaev MA, Nikishina AA. Initial identification in technology of informational search (part 1). Prikladnaya Informatika = Journal of Applied Informatics. 2015;4(58):128–142.

13. Bolotova L.S., Danchul A.N., Novikov A.P., Surkhaev M.A., Nikishina A.A. Initial identification in technology of informational search (part 2). Prikladnaya Informatika = Journal of Applied Informatics. 2015;6(60):128–143.

14. Joun J., Chung H., Park J., Lee S. Relevance analysis using revision identifier in MS word. Journal of Forensic Sciences. 2021;66(1):323–335.

15. Jarzabek S., Dan D. Documentation Reuse: Managing Similar Documents. In: 2017 IEEE International Conference on Information Reuse and Integration (IRI). 2017:372–375. DOI:10.1109/IRI.2017.52

16. Bešić D. Microservice for text extraction from word and pdf documents. In: Proceeding of the Faculty of technical Sciences, Novi Sad. 2021;36(07):1252–1256. DOI:10.24867/13BE26Besic

17. Duretec K., Rauber A., Becker C. A Text Extraction Software Benchmark Based on a Synthesized Dataset. In: 2017 ACM/IEEE Joint Conference on Digital Libraries (JCDL). 2017:1–10. DOI:10.1109/JCDL.2017.7991565

18. Karcioğlu A.A., Yaşa A.C. Automatic Summary Extraction in Texts Using Genetic Algorithms. In: 2020 28th Signal Processing and Communications Applications Conference (SIU). 2020:1–4. DOI:10.1109/SIU49456.2020.9302205

19. Harmata S., Hofer-Schmitz K., Nguyen P.H., Quix C., Bakiu B. Layout-Aware Semi-automatic Information Extraction for Pharmaceutical Documents. In: Da Silveira M, Pruski C, Schneider R, editors. Data Integration in the Life Sciences. Cham: Springer International Publishing. 2017:71–85. (Lecture Notes in Computer Science). DOI:10.1007/978-3-319-69751-2_8

20. Zhang J., Xie Y., Shen J., Wang L., Lin H. Text Information Hiding Method Using the Custom Components. In: Sun X, Pan Z, Bertino E, editors. Cloud Computing and Security. Cham: Springer International Publishing. 2018:473–84. (Lecture Notes in Computer Science). DOI:10.1007/978-3-030-00015-8_41

21. Lubenets Y.V., Miroshnikov A.I. Software Supports for Remote Examination on Mathematical Disciplines in Higher Education. In TBLE: 2021 1st International Conference on Technology Enhanced Learning in Higher Education. 2021:274–277. DOI:10.1109/TELE52840.2021.9482472

22. Abramova I.A., Syrkin V.V., Stepanov A.P. Extensions of the standard functionality and interface of MS Office applications based on the development of custom add-ins. Nauka i Voennaya Bezopasnost'. 2020;2(21):192–199.

23. Miroshnikova E.P., Levonevskiy D.K., Motienko A.I. Modules for import, export and data analytics in the electronic journal management system of the ‘Spiiras Proceedings’ journal for automated interaction with global indices and aggregators. Problemy iskusstvennogo intellekta = Problems of Artificial Intelligence. 2019;3(14):58–75.

24. Reznichenko O.S., Sivakov S.I., Reznichenko T.A. Method of automated generation of information about university’s scientific publications for reporting in the research management system of the russian ministry of science and higher education. Universitetskoe Upravlenie: Praktika i Analiz = University Management: Practice and Analysis. 2020;24(2):44–58. DOI: 10.15826/umpa.2020.02.013

25. Pinto J., Rathod D., and Quadros A. Text summarizer for URL and .DOCX files. International Journal of Advanced Research in Computer Science. 2020;11(4):18–21. DOI: 10.26483/ijarcs.v11i4.6639

26. Baynova M.S., Sokolov A.M. Tools for automated collection and analysis of sociological information on the territorial identity of city residents. Prikladnaya Informatika = Journal of Applied Informatics. 2021;2(92):92–102.

27. Novikov A., Keyno P. Heterogenius data collecting in scientific communities using portfolio management system in ConfID service. Prikladnaya Informatika = Journal of Applied Informatics. 2020; 2(86):28–36.

28. Izmailov V.V., Novoselova M.V. Automated system for generating task options based on MS Word document. Software Journal: Theory and Applications. 2017;1:1–5. DOI:10.15827/2311-6749.17.1.1

29. Yu Z., Xiong Z. Comparative analyses for the performance of Rational Rose and Visio in software engineering teaching. In: J. Physics: Conf. Series, IOP Publishing. 2018;1087(6):062–041. DOI:10.1088/1742-6596/1087/6/062041

30. Parker D.J. Mastering Data Visualization with Microsoft Visio Professional 2016. Packt Publishing Ltd; 2016.

31. He L., Lian J. Instructional design of practice course of logistics system planning and design based on Visio. In ITME’2018: Proc. 9th Int. Conf. on Information Technology in Medicine and Education. 2018:526–530. DOI:10.1109/ITME.2018.00122

32. Ruiz Ledesma E.F. et al. Educational tool for generation and analysis of multidimensional modeling on data warehouse. Int. J. Advanced Computer Science and Applications. 2020;11(9):261–267. DOI:10.14569/IJACSA.2020.0110930

33. Shafiee S. et al. Evaluating the benefits of a computer-aided software engineering tool to develop and document product configuration systems. Computers in Industry. 2021;128. DOI:10.1016/j.compind.2021.103432

34. Medoh C., Telukdarie A. Business process modelling tool selection: a review. In IEEM’2017: Proc. IEEE Int. Conf. on Industrial Engineering and Engineering Management. IEEE;2017;524–528. DOI:10.1109/IEEM.2017.8289946

35. Afanasyev A., Voit N., Gaynullin R. The analysis of diagrammatic of workflows in design of the automated systems. In: Uncertainty Modelling in Knowledge Engineering and Decision Making. 2016:509–514. DOI:10.1142/9789813146976_0082

36. Voit N., Bochkov S., Kirillov S. Temporal automaton RVTI-grammar for the diagrammatic design workflow models analysis. In AICT’2020: IEEE 14th Int. Conf. on Application of Information and Communication Technologies, Tashkent, Uzbekistan. 2020:1–6. DOI:10.1109/AICT50176.2020.9368810

37. Afanasyev A., Voit N., Ukhanova M., Ionova I. Development of the approach to check the correctness of workflows. In: Data Science and Knowledge Engineering for Sensing Decision Support. P. 1392–1399. DOI:10.1142/9789813273238_0173

38. Shah R., Kesan J. Interoperability challenges for open standards: ODF and OOXML as examples. In dg.o’09: Proceedings of the 10th Annual International Conference on Digital Government Research: Social Networks: Making Connections between Citizens, Data and Government. Puebla: Digital Government Society of North America. 2009:56–62.

39. Doncevic J., Fertalj K. Database integration systems. In MIPRO’2020: Proc. 43rd Int. Convention on Information, Communication and Electronic Technology. 2020:1617–1622. DOI:10.23919/MIPRO48935.2020.9245245

40. Kolonko M., Mullenbach S. Polyglot Persistence in conceptual modeling for information analysis. In ACIT’2020: Proc. 10th Int. Conf. on Advanced Computer Information Technologies. 2020:590–594. DOI:10.1109/ACIT49673.2020.9208928

41. Kosmerl I., Rabuzin K., Sestak M. Multi-model databases – introducing polyglot persistence in the big data world. In MIPRO’2020: Proc. 43rd Int. Convention on Information, Communication and Electronic Technology. 2020:1724–1729. DOI:10.23919/MIPRO48935.2020.9245178

42. Montgomery C., Isah H., Zulkernine F. Towards a natural language query processing system. In IBDAP’2020: Proc. 1st Int. Conf. on Big Data Analytics and Practices. 2020. DOI:10.1109/IBDAP50342.2020.9245462