Journal of Applied Informatics

Editorial Board

Journal archive

For authors

For advertisers

Useful links

Contacts

Authors

< Back to the list of authors

Gusarenko A.

Degree	PhD in Computer Science, Ufa State Aviation Technical University (UGATU)
E-mail	gusarenko@ugatu.su
Location	Ufa
Articles	Model for creating documents in OFFICE OPEN XML format based on situationally-oriented databases Article uses XML-processing documents in situationally-oriented databases based on dynamic DOM-objects for the task of generating personalized documents. The paper proposes a dynamic model SOBD providing specifications and new elements to create a finished electronic documents based on the Office Open XML blanks prepared by means of word processors. In the states of the dynamic model blanks are generated using information from XML documents SOBD server web application. The model in this paper allows the specification of routine operations to generate documents at a higher level of abstraction, using the syntax model SOBD. The article shows the graphical equivalents, and text tools introduced in the dynamic model and interpreted using the interpreter embedded dynamic models for solving the problem of generation of documents. Interpreter embedded dynamic models works with documents Office Open XML, using the technology of dynamic DOM-objects, while the resulting documents have ways of representing docx and vdx. The work looks at ways to specification of sources and processing XML-based data dynamic DOM-objects bound to the states of the dynamic model. Proposed to implement the model on the platform PHP using blanks docx and vdx. Read more... Integration of virtual multidocument mappings into real data sources in situational-oriented databases This article solves the heterogenous data mapping problem on real data sources in Situation-Oriented Databases. In accordance with Polyglot Persistence SODB uses various type of documents. It is necessary to use external data sources like relational and JSON/XML documents. To manage this diversity of sources proposed special provision for hierarchical situation model of SODB named as virtual multidocuments. There are three type of data sources discussed — XML/JSON, Zip-archives, MySQLidocuments from relational database MySQL. Introduced inversional methods for mapping virtual multi-documents on real data sources by means of doc-elements. For each functional element three special modules are recommended to implement with known structures. Implementation technique is shown on SQLite example and based on three functions SQLite3_doc, SQLite3_load, SQLite3_save. First SQLite3_doc module defines how to connect to source within model and send a query. Second SQLite3_load module specifies how to return document is selected from table of relational database and loaded in virtual multi-document for handling and subsequent saving. In this function interpreter of SODB creates special DPO-object (DPO — Data Processing Object) within that all handling operations are performed. DPO-object can concern of several virtual multi-documents. For late stages must be implemented third function SQLite3_save that performs saving ending result in serverless SQLite3 database. All proposed functions implemented on PHP example in web-application of SODB. Read more... Situation-oriented databases: polyglot persistence based on REST microservices The article discusses the new features provided in situational-oriented databases (SODB) for the implementation of microservice architecture. SODB - a project integrator of heterogeneous data within the approach polyglot persistence on the base of the information processor, built-managed situational model. Access to heterogeneous data is organized in the SODB based on the concept of virtual documents that are displayed on heterogeneous physical data. The article discusses the microservice architecture based on SODB, a modern approach that provides better scalability and modifiability of web applications based on HTTP requests. The task is set to process HTTP requests by the microservice within the framework of the general concept of virtual documents. To solve the problem, a new type of virtual document has been introduced, which is displayed on an HTTP request, which facilitates the microservice, on the one hand, access to the request properties and the data attached to it, and on the other, the formation of an HTTP response. The article discusses how to process an HTTP request using an example of a typical situational model of a microservice that maintains a relational database table based on a data source - an external web service. The structure of the situational model that processes and forms the response depending on the type of request and the situations encountered is examined in detail. An example of the practical implementation of a complex of microservices based on SODB for monitoring student views of educational videos on YouTube is given. Read more... Soft extract data from word-based documents situationally-oriented approach The article discusses the use of situation-oriented approach to software processing word-documents. The documents under consideration are prepared by the user in the environment of the Microsoft Word processor or its analogs and are used in the future as data sources. The openness of the Office Open XML and Open Document Format made it possible to apply the concept of virtual documents mapped to ZIP archives for programmatic access to XML components of word documents in a situational environment. The importance of developing preliminary agreements regarding the placement of information in the document for subsequent search and retrieval, for example, using pre-prepared templates, is substantiated. For the DOCX and ODT formats, the article discusses the use of key phrases, bookmarks, content controls, custom XML components to organize the extraction of entered data. For each option, tree-like models of access to the extracted data, as well as the corresponding XPath expressions, are built. It is noted that the use of one or another option depends on the functionality and limitations of the word processor and is characterized by varying complexity of developing a blank template, entering data by the user and programming data extraction. The applied solution is based on entering metadata into the article using content controls placed in a stub template and bound to elements of a custom XML component. The developed hierarchical situational model of HSM provides extraction of an XML component, loading it into a DOM object and XSLT transformations to obtain the resulting data: an error report and JavaScript code for subsequent use of the extracted metadata. Read more...