Object-relational Database Management System Research Articles

Інформаційна технологія оцінювання теплоізоляції багатошарових стін

In today's conditions, the problem of insulation of surfaces is very relevant for wide circles of the population of Ukraine. Everyone knows that surface insulation allows to reduce heat transfer due to the use of materials with low thermal conductivity. In the absence of permanent heating, the issue of thermal insulation of cylindrical pipes is very relevant. The issue of insulation selection and structural design requires a complex and professional approach. To calculate the problem of thermal insulation, a specialist needs to have a toolkit for calculating the temperature field and saving the obtained results for further analysis. The work presents the developed information technology that allows a specialist to calculate the temperature field for multilayer cylindrical pipes. The object-oriented programming language C# and the Microsoft Visual Studio integrated development environment were used to build the IT toolkit. It should be noted that when making calculations, there is no need to specify the characteristics of pipe and insulation materials, since all data is stored in the IT database. The object-relational database management system - PostgreSQL was used to build the data module. After the calculations, all the built calculation models and the received numerical models of the results are also stored in the database. This allows you not to recalculate if necessary, but to use the data that is already available. To analyze the results, the developed toolkit allows you to plot temperature changes of a multilayer wall. At the same time, the user selects the necessary calculation models independently from IT database data. The DirectX three-dimensional graphics development tool package is used for visual representation of numerical model calculations. The authors developed an algorithm for constructing a color temperature field according to the calculations. Red is chosen for the highest field temperature, and blue for the lowest temperature. A feature of the proposed information technology is that its functionality allows three users with different levels of access to work with the toolkit: a database administrator, a mathematical model construction engineer, and a numerical model analysis specialist.

Особливості інтеграції геопросторових даних автомобільних доріг із застосуванням операції з’єднання (JOIN)

The purpose of the article is to research the integration of attributes of the set of geospatial data “Roads”, which was created on the basis of the topographic database of the Main State Topographic Map, and the geoinformation system of roads of the State Agency of Roads of Ukraine (hereinafter – Ukravtodor) for the creation and maintenance of core reference data of roads of the national spatial data infrastructure (hereinafter – NSDI) using an operation Theta-JOIN in object-relational database management systems (hereinafter referred to as DBMS). Method. The basis of the research is the analysis of the possibilities of applying the theory of spatial databases and knowledge bases, international and national harmonized standards in the field of Geographic Information/Geomatics to solve the issue of integration of spatial data using the Theta-JOIN operation in object-relational database management systems. The results. The article analyzes the geo-information model of the road, based on the data of which it is possible to make management decisions during planning, design, operation, management, organization of road safety, etc. The requirements for the presentation of this model are defined in the GDF 5.1 standard, which is used for modeling road infrastructure in a geographic information environment using the Unified Modeling Language (UML) and Model Management Architecture (MDA) technologies. This allows for data interoperability at different levels, for example, national and pan-European. The geoinformation model of a public road of state importance in the topographic database is a continuous feature that is an aggregation of the features of the road and transport network through which this model passes. Also, on the basis of regulatory and technical support, the geographic identifier of the highway was established – the road index, the structure and principles of which are defined in the draft of the national standard DSTU xxx:20xx “Geoinformation system of public highways. Part 1. Composition, content and requirements for the database”. Two sets of spatial data TDB of the Main state topographic map and GIS roads of Ukravtodor were combined using the theta-JOIN operation in the PostgreSQL/PostGIS. The scientific novelty and practical significance is in the fact that the integration of sets of core reference and thematic spatial data of roads was investigated using the theta-join operation of relational algebra, which is implemented in modern GIS and DBMS for the development of the national spatial data infrastructure. This will make it possible to expand the attributes of road features contained in TDB, due to the official data of Ukravtodor, joining these sets with a geographic identifier, road index.

Development of a geodatabase for retrieval of geochemical data from oil wells: A case study from the Gachsaran oilfield; SW Iran

Managing geochemical data is crucial in the petroleum industry, as the exploration and development of oilfields typically require a large volume of data from geochemical analyses. Specifically, geochemical data relevant to oil wells, source rocks, and reservoir rocks are often related to location dimensions. Therefore, the geodatabase can be a powerful tool in collecting, storing, retrieving, processing, and analysis of these data. In this study, a novel geodatabase approach was utilized to store, display, and present geochemical data of petroleum samples from oil wells. The geodatabase scheme comprised two types of data layers: spatial data (e.g., oil well, oilfield boundary, formations including source rocks/reservoir rocks and sector) and non-spatial data (e.g., oil samples and geochemical information). The PostgreSQL/PostGIS object-relational database management system was used to design and implement the geodatabase, while QGIS was employed to connect to the database and visualize the geometrical data of the Gachsaran oilfield. The QGIS Data Plotly plugin was then used to interpret geochemical data. According to the findings of this study, the PostgreSQL/PostGIS open-source database is a suitable method for spatial data management of oil well geometrical data. In addition, the geochemical evaluation of possible source rocks and determination of geochemical characteristics of reservoir oil were analyzed using this geodatabase. Moreover, integrating oil geochemical data into a geodatabase prevents the scattering of geochemical data and facilitates data interpretation.

ГЕОДЕЗІЯ, КАРТОГРАФІЯ І АЕРОФОТОЗНІМАННЯ

The purpose of this work is to study the integration of sets of core reference and thematic geospatial data based on the JOIN operation of relational algebra and its interaction with geocoding of geospatial features, which is implemented in modern geographic information systems (GIS) and database management systems (hereinafter – DBMS) for the development of the national spatial data infrastructure (hereinafter – NSDI). Method. The research is based on the analysis of the possibilities of applying the theory of geospatial databases and knowledge bases, international and national harmonized standards in the field of Geographic Information/ Geomatics to solve the problem of integration of geospatial data using the operation JOIN relational algebra in object-relational database management systems (OR DBMS). Results. The paper examines the models of the Join operation of relational algebra, which underlie the geocoding of features and the creation of electronic gazetteers, and proves its effectiveness: the Join operation integrates of core reference and thematic geospatial datasets. There is a need to define the required geographic identifiers, which must be present among the attributes of the core reference and thematic geospatial datasets to perform the join. The variety of uses of the Join operation covers all possible cases that arise in their practical application. Thus, the use of the Join operation involves identifying these required geographic identifiers at the geospatial database design stage. In particular, it is expedient to determine mandatory geographical identifiers (codes) of features according to the official national systems of features classification (codification) in the relevant sectoral thematic registers, which are responsible for certain holders of thematic data in accordance with Annex 2 of the Decree of Cabinet of Ministers “The order for the functioning of the national spatial data infrastructure” of May 26, 2021, № 532. Scientific novelty and practical significance. The integration of core reference data and thematic geospatial datasets based on JOIN operation models of relational algebra and their interaction with geocoding of geospatial features is researched, which is implemented in modern GIS and DBMS for the development of national spatial data infrastructure. The research was performed on a set of core reference spatial data, namely: information on administrative-territorial units of the Cherkasy region, including their borders; the data from the statistical bulletin of the socio-economic situation of the Cherkasy region for January 2021 of the Main Department of Statistics in Cherkasy region of the State Statistics Service of Ukraine were selected as thematic data. It has been shown that relational algebra join (JOIN) operations can be used to integrate other thematic geospatial data with core reference data using geographic identifiers that contain these datasets.

Database Private Security Jurisprudence: A Case Study using Oracle

Oracle is one of the largest vendors and the best DBMS solution of Object Relational DBMS in the IT world. Oracle Database is one of the three market-leading database technologies, along with Microsoft SQL Server's Database and IBM's DB2. Hence in this paper, we have tried to answer the million-dollar question “What is user’s responsibility to harden the oracle database for its security?” This paper gives practical guidelines for hardening the oracle database, so that attacker will be prevented to get access into the database. The practical lookout for protecting TNS, Accessing Remote Server and Prevention, Accessing Files on Remote Server, Fetching Environment Variables, Privileges and Authorizations, Access Control, writing security policy, Database Encryption, Oracle Data Mask, Standard built in Auditing and Fine Grained Auditing (FGA) is illustrated with SQL syntax and executed with suitable real life examples and its output is tested and verified. This structured method acts as Data Invictus wall for the attacker and protect user’s database.

ГЕОДЕЗІЯ, КАРТОГРАФІЯ І АЕРОФОТОЗНІМАННЯ

Purpose. The aim of the research is to develop fuzzy impact models of the natural and anthropogenic influence, which allows to integrate different physical factors, which makes it possible to bring them to a single environmental assessment system and comparison of different assessed areas. Methodology. The basis of the proposed modeling is a traditional approach on the development of such models, which includes conceptual, logical and physical modeling levels. The Unified Modeling Language (UML) is used for conceptual modeling level, which is recommended as the main modeling tool in the set of international standards in geographic information / geomatics and software that supports the interactive mode of UML diagrams creation Visio. The geospatial database and SQL-functions are implemented and the extension of the standard SQL-99 language with a new data type geometry and built-in functions which provides storage, processing and analysis of geospatial data in database management systems is used. The proposed models are realized in the environment of object-relational DBMS PostgreSQl / Postgis and geographic information system QGIS. Results. A review of the experience of using fuzzy logic to assess the state of the environment is done. Technological models for computation of indicators of administrative unit provision by social infrastructure objects, influence of greenery, industrial territories and transport on the environment are offered and realized. An example of approbation of the proposed approach based on OpenStreetMaps open data for the Popasnianskyi distinct of Luhansk region territory is given. Scientific novelty. Theoretical generalizations are made and practical results are received of resolving applied problem of the development of the fuzzy impact assessment model of various factors influence on the environment with use of GIS. Such assessment can be used at the stage of community spatial development strategies preparation to determine the most acceptable development version, as well as to unify the means of strategies implementation monitoring, organically linking local, national and global tasks. Practical significance. The application of the proposed approach of GRID modeling and fuzzy impact assessment use in assessing the quality of the environment allows to integrate different indicators, compare them, by bringing them into a single evaluation system.

Shared Parameter Database of War Gaming Software: Case Study on Commercial Simulation Databases

Background: The current research brings up the perspective of security-critical information systems in shared parameter databases in the context of processing sensitive data at Finnish Naval Warfare Centre. It refers to the environment of isolated military war gaming simulation and modeling systems. The research problem is: How to make an optimal solution for data distribution in different military war gaming simulation and modeling software? Objectives: The objective is to create a single shared database usable with different detail level software, e.g. high-level scenario simulation, technical system-of-system simulations, and system-level physical simulations. Methods: The methods are modeling, simulation and operation analysis. The approach is inductive, the strategy is a qualitative case study and the data collection was implemented by exploring database models and their combinations. The integration was implemented in an object-relational database management system (ORDBMS), PostgreSQL. Results: The shared database led to efficient access to simulation parameters, more straightforward system integration and improved scalability. Conclusions: The results of modeling and simulation indicated that the integration is possible to implement.

Геоинформационное обеспечение изучения размещения зарубежных ТНК в глобальных городах

The article discusses the experience of assessing the location of foreign TNCs in global cities as a significant factor in the field of environmental, economic and social aspects of sustainable development of urban areas. A number of initial theoretical models are proposed from the standpoint of the center-peripheral approach and a conceptual scheme of geoinformation and cartographic support of the study is presented, the main stages of its implementation are revealed. The databases of the European Commission’s Joint Research Center (GHS Urban Center Database, GHS-UCDB) and (GHS Functional Urban Areas, GHS-FUA) were used to get an idea of the real models of the intracity location of large business in the delimitation of the boundaries of agglomerations and their separate zones. To determine the composition of TNC divisions, Forbes 2000 data for 2020 and information from corporate websites on the branch network with geographic reference from the Craft.co reference service were used. In total, 55 global cities of the alpha group and more than 12 thousand foreign branches of TNCs were involved in the analysis. The processing and systematization of the obtained data was carried out using the object-relational database management system (RDBMS) PostgreSQL and the PostGIS extension. The visualization of the research results based on the consolidation of tabular data and spatial relationships using QGIS. Comparative analysis showed the effectiveness of the developed technique. As a result of its application, the overall scale of the presence of big business in the global cities of the alpha group and a significant gap between leaders and outsiders were determined. The absence of a universal model for the zonal distribution of TNCs in the urban space was revealed, the basic invariants of which were visualized using the example of a number of centers. The presented developments can contribute to the development of the direction of microgeographic research in geo-urban studies. In practice, the methodology can be useful for modernizing the assessment of the quality of the urban environment and the conditions for its formation as part of the implementation in the Russian Federation of the national project “Housing and Urban Environment”.

Development of computer-based methodology for remote advanced training of medical doctors

Aim. To formulate the methodology for developing the interactive virtual computer simulations with a rating assessment of trainees’ decisions and the capability of remote access.Material and Methods. The methods of knowledge engineering were used to extract and formalize expert knowledge about the structure, significance, and relevance of clinical diagnostic information. The materials for creating virtual computer simulations were based on texts from the archival medical records, laboratory data, and multimedia results of instrumental methods of study. A three-tier network architecture was applied to provide the capabilities of remote access. It was organizationally represented by three components: a client layer, a business logic layer, and a data layer. Data transfer was provided by the Web protocols while microservices represented the infrastructure.Results. The information was formalized and structured after expert analysis and identification of significant diagnostic and prognostic data. The process included defining the domain model, identifying the aggregates and connections between them, and designing software and user interfaces. Possible solutions for trainees are now presented in the form of interactive reference lists. The artifacts of the user’s work are saved in the storage represented by the module for working with the server file system and the object-relational database management system. Each task module contains static and interactive blocks of information. The purpose of static blocks is to provide trainees with the necessary information for making clinical and diagnostic decisions. The interactive blocks allow selecting one or more solutions from the list. The content and sequence of further information presentation are determined by the trainees’ answers to the questions of an interactive block. Trainees’ decision-making competencies are evaluated using the rating system. The final personal rating is calculated as a multiplication of all coefficients related to the trainees’ decisions. This approach integrates a rating system with the trajectory chosen by the trainee for task completion.Conclusions. The distance learning technologies, developed for clinical disciplines in this study, are quite new and innovative. The repository of virtual computer simulations is under development to improve the methodological support of remote clinical training.

A Generic and Extensible Core and Prototype of Consistent, Distributed, and Resilient LIS

The majority of the existing land information systems (LIS) are centralized, transaction processing systems based on object-relational database management systems for data storage, management, and retrieval. These traditional database management systems are dominantly based on a share-everything or share disk architecture and face challenges in meeting the performance and scalability requirements of distributed, data-intensive systems, including LIS. They support vertical, rather than horizontal scalability, which is of particular importance in distributed systems. In some cases, due to legal, administrative, or infrastructure constraints, LIS need to be distributed rather than centralized systems. Distributed computing systems and share-nothing architecture have become very popular, including new data processing platforms and frameworks with horizontal scalability and fault tolerance capabilities. In this paper, we present cdrLIS—a generic and extensible core of LIS based on relevant international standards and the NewSQL database management system (DBMS) that enables the implementation of consistent, distributed, highly-available, and resilient LIS. A generic core is implemented in the Go programming language and can be easily extended and adopted towards the implementation of a specific country profile. cdrLIS can be deployed either on a computer cluster or on cloud computing platforms and thus support the design and building of a new generation of distributed and resilient data-intensive applications and information systems in the land administration domain.

A new online database on genome-related information of Indian plants

In this paper, we present a new online comprehensive database developed for genome-related information of Indian plants (dGRIP). In strict sense, dGRIP database displays for each species and genus, its chromosome number(s) with comprehensive cytogenetic data, genome size, ploidy, systematics and molecular genetics related to Indian angiosperms, gymnosperms, pteridophytes and bryophytes. The data are described in the form of datasheets encompassing 29 parameters available for users to consolidate the knowledge with respect to comprehensive cytogenetical details. The chromosome database is developed based on object-relational database management system (Sequence Query Language) and includes references from which the information was sourced. The online database is currently available at http://sbtju.in/Dgrip/index.html consists of a main page, project information, collaborators and search tools for each group, namely angiosperms, gymnosperms pteridophytes and bryophytes. Currently, the information is available for about 1500 species (Release 1.0); however, the dGRIP continues to expand with goal to include data of more than 17,000 plant species from India.

CONCEPTUAL MODELING AND PRINCIPLES OF IMPLEMENTATION OF THE SPATIAL DATABASES OF THE CADASTRE OF NATURAL HEALING RESOURCES

Data in the system of conducting the State inventory of natural healing resources are preserved mainly in unstructured form. Accumulated information is not used efficiently. Data that has a structured form prefers fast updates, high speed updates, processing, and visualization. The use of GIS technologies together with object-relational database management systems provide an opportunity for high-quality and efficient storage, processing, analysis and visualization of geospatial information. In accordance with the modern methodology of geospatial data organization at the stage of database design, a conceptual modeling of data with cataloging of research objects is carried out. The result of this phase is the conceptual schema of the geodata database and the directory of the geodata database objects. The purpose of the article is to describe the conceptual schema of the database, the description of the structure and the Catalog of classes of objects of the base of the geodata of natural healing resources. Conceptual model allows you to outline the boundaries of the subject area, identify its main essence, the relationship between them.Each type of natural healing resources (mineral waters, mud, limestone and lakes, bishofite, ozokerite, seacoast, landscapes) is a separate class of objects. Non-spatial object classes are attributive data on qualitative, quantitative indicators, information on the subject of business, licensing. The relationship between classes is modeled in the form of associations that use the key fields of the corresponding attributes. All attribute fields have status: basic, non-core, and service. The catalog of objects classes contains a set of data in accordance with the list of data included in the State inventory of natural healing resources. Provides additional data that can complement the description of objects in the geodatabase. The catalog is presented in the form of an information table with the characteristics of each class, a list of attributes, data types, units of measure, domains and associations. Data types can have text, numeric, logical formats. For attributes that have a list of defined definitions, domains of admissible values are provided. Each geospatial object stores an abstract Geometry data type that provides information about the geographic location of an object.The maintenance of the State inventory of natural healing resources in the system of the Infrastructure of geospatial data of Ukraine is based on application of GIS technologies and object-relational DBMS. A conceptual scheme and a catalog of classes of objects of the geospatial data set of the State Cadastre of natural healing resources will be based on physical modeling in the environment of an object-relational database management system.

Accelerating Drug Discovery by Early Protein Drug Target Prediction Based on a Multi-Fingerprint Similarity Search †

In this continuing work, we have updated our recently proposed Multi-fingerprint Similarity Search algorithm (MuSSel) by enabling the generation of dominant ionized species at a physiological pH and the exploration of a larger data domain, which included more than half a million high-quality small molecules extracted from the latest release of ChEMBL (version 24.1, at the time of writing). Provided with a high biological assay confidence score, these selected compounds explored up to 2822 protein drug targets. To improve the data accuracy, samples marked as prodrugs or with equivocal biological annotations were not considered. Notably, MuSSel performances were overall improved by using an object-relational database management system based on PostgreSQL. In order to challenge the real effectiveness of MuSSel in predicting relevant therapeutic drug targets, we analyzed a pool of 36 external bioactive compounds published in the Journal of Medicinal Chemistry from October to December 2018. This study demonstrates that the use of highly curated chemical and biological experimental data on one side, and a powerful multi-fingerprint search algorithm on the other, can be of the utmost importance in addressing the fate of newly conceived small molecules, by strongly reducing the attrition of early phases of drug discovery programs.

Efficient Iris Recognition Management in Object-Related Databases

Biometric applications have grown significantly in recent years, particularly iris-based systems. In the present work, an extension of an Object Relational Database Management System for the integral management of a biometric system based on the human iris was presented. Although at present, there are many database extensions for different domains, in no case for biometric applications. The proposed extension includes both the extension of the type system and the definition of domain indexes for performance improvement. The aim of this work is to provide a tool that facilitates the development of biometric applications based on the iris feature. Its development is based on a reference architecture that includes both the management of images of the iris trait, its associated metadata and the necessary methods for both manipulation and queries. An implementation of the extension is performed for PostgreSQL DBMS, and SP-GiST framework is used in the implementation of a domain index. Experiments were carried out to evaluate the performance of the proposed index, which shows improvements in query execution times.

Master plan geospatial profile data set model analysis

The specifics of modern data organization models in geoinformation systems are considered and compared. The advantages of using the object-relational model for the development and maintenance settlement master plan geospatial profile data sets are substantiated. The basic principles of forming settlement master plan geospatial profile data sets in object-relational database management system are defined

Implementasi JSON untuk Minimasi Penggunaan Jumlah Kolom Suatu Tabel Pada Database PostgreSQL

On the development of the database currently has become a very important thing, each will plan something, consider any thing we will need and use existing data in a database, The development of the database currently has become a very important thing, when we want to plan something and consider everything, we will need and use existing data in a database, PostgreSQL is one Object Relational Database Management Systems (DBMS) open source with a lot of features that are not less sophisticated to commercial databases. On daily use, it sometimes occurs a case that requires a dynamic column, therefore we should make the new columns to meet those needs. However, if each row of the table column requires different column and potentially need another ones, then it is going to be useless. On the research of utilizing the technology of JavaScript Object Notation (JSON),Json_encode PHP programming language can simplify the use of the column so that a new column is no longer needed when we want to create a new column on the table, we only need a new column that stores an array that has been converted into a JSON string forms the result of json_encode that represents the column name and the content of the columns of a table.

Respiratory cancer database: An open access database of respiratory cancer gene and miRNA.

Respiratory cancer database (RespCanDB) is a genomic and proteomic database of cancer of respiratory organ. It also includes the information of medicinal plants used for the treatment of various respiratory cancers with structure of its active constituents as well as pharmacological and chemical information of drug associated with various respiratory cancers. Data in RespCanDB has been manually collected from published research article and from other databases. Data has been integrated using MySQL an object-relational database management system. MySQL manages all data in the back-end and provides commands to retrieve and store the data into the database. The web interface of database has been built in ASP. RespCanDB is expected to contribute to the understanding of scientific community regarding respiratory cancer biology as well as developments of new way of diagnosing and treating respiratory cancer. Currently, the database consist the oncogenomic information of lung cancer, laryngeal cancer, and nasopharyngeal cancer. Data for other cancers, such as oral and tracheal cancers, will be added in the near future. The URL of RespCanDB is http://ridb.subdic-bioinformatics-nitrr.in/.

JSON Implementation to Minimize the Use of the Number of Columns of a Table in a PostgreSQL Database

On the development of the database currently has become a very important thing, each will plan something, consider any thing we will need and use existing data in a database, The development of the database currently has become a very important thing, when we want to plan something and consider everything, we will need and use existing data in a database, PostgreSQL is one Object Relational Database Management Systems (DBMS) open source with a lot of features that are not less sophisticated to commercial databases. On daily use, it sometimes occurs a case that requires a dynamic column, therefore we should make the new columns to meet those needs. However, if each row of the table column requires different column and potentially need another ones, then it is going to be useless. On the research of utilizing the technology of JavaScript Object Notation (JSON),Json_encode PHP programming language can simplify the use of the column so that a new column is no longer needed when we want to create a new column on the table, we only need a new column that stores an array that has been converted into a JSON string forms the result of json_encode that represents the column name and the content of the columns of a table.

Development of geoinformation zoning model of urban territories for use in urban cadaster systems

The structure and composition of zoning spatial resources is explored. Geoinformation mode of geospatial zoning data on the basis of object-relational database management system is developed. Developed zoning model is tested in the environment of open-source database management system PostgreSQL. Applied SQL-function for automatic creation of build conditions and restrictions of land development is implemented

Bio-optical data integration based on a 4 D database system approach

Abstract. Bio-optical characterization of water bodies requires spatio-temporal data about Inherent Optical Properties and Apparent Optical Properties which allow the comprehension of underwater light field aiming at the development of models for monitoring water quality. Measurements are taken to represent optical properties along a column of water, and then the spectral data must be related to depth. However, the spatial positions of measurement may differ since collecting instruments vary. In addition, the records should not refer to the same wavelengths. Additional difficulty is that distinct instruments store data in different formats. A data integration approach is needed to make these large and multi source data sets suitable for analysis. Thus, it becomes possible, even automatically, semi-empirical models evaluation, preceded by preliminary tasks of quality control. In this work it is presented a solution, in the stated scenario, based on spatial – geographic – database approach with the adoption of an object relational Database Management System – DBMS – due to the possibilities to represent all data collected in the field, in conjunction with data obtained by laboratory analysis and Remote Sensing images that have been taken at the time of field data collection. This data integration approach leads to a 4D representation since that its coordinate system includes 3D spatial coordinates – planimetric and depth – and the time when each data was taken. It was adopted PostgreSQL DBMS extended by PostGIS module to provide abilities to manage spatial/geospatial data. It was developed a prototype which has the mainly tools an analyst needs to prepare the data sets for analysis.