Authors
Yusupova N.
|
Degree
|
Dr of Technique, Professor, Dean, Ufa State Aviation Technical University |
|---|---|
|
E-mail
|
yussupova@ugatu.ac.ru |
|
Location
|
Ufa |
|
Articles
|
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 microservicesThe 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 approachThe 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... |
