Intelligent search in Big Data

© Published under licence by IOP Publishing Ltd. An approach to data integration, aimed on the ontology-based intelligent search in Big Data, is considered in the case when information objects are represented in the form of relational databases (RDB), structurally marked by their schemes. The source of information for constructing an ontology and, later on, the organization of the search are texts in natural language, treated as semi-structured data. For the RDBs, these are comments on the names of tables and their attributes. Formal definition of RDBs integration model in terms of ontologies is given. Within framework of the model universal RDB representation ontology, oil production subject domain ontology and linguistic thesaurus of subject domain language are built. Technique of automatic SQL queries generation for subject domain specialists is proposed. On the base of it, information system for TATNEFT oil-producing company RDBs was implemented. Exploitation of the system showed good relevance with majority of queries

On Semantic Search Algorithm Optimization

© 2019, Springer Nature Switzerland AG. In the article we consider, on the example of development of a relational database (RDB) information system for Tatneft oil and gas company, an approach to organization of effective search in large arrays of heterogeneous data, satisfying the following essential requirements. On the one hand, the data is integrated at the semantic level, i.e. the system supports the presentation of data, describing its semantic properties within an unified subject domain ontology. Accordingly, end user’s request are formulated exclusively in the subject domain terminology. On the other hand, the system generates unregulated SQL-queries, i.e. the full text of possible SQL-queries, not just values of particular parameters, predefined by the system developers. Considered approach includes both the possibilities of increasing the reactivity of the universal SQL queries generation scheme as well as more specific optimization possibilities, arising from the particular system usage context

On Semantic Search Algorithm Optimization

© 2019, Springer Nature Switzerland AG. In the article we consider, on the example of development of a relational database (RDB) information system for Tatneft oil and gas company, an approach to organization of effective search in large arrays of heterogeneous data, satisfying the following essential requirements. On the one hand, the data is integrated at the semantic level, i.e. the system supports the presentation of data, describing its semantic properties within an unified subject domain ontology. Accordingly, end user’s request are formulated exclusively in the subject domain terminology. On the other hand, the system generates unregulated SQL-queries, i.e. the full text of possible SQL-queries, not just values of particular parameters, predefined by the system developers. Considered approach includes both the possibilities of increasing the reactivity of the universal SQL queries generation scheme as well as more specific optimization possibilities, arising from the particular system usage context

On ontology based data integration: Problems and solutions

© Published under licence by IOP Publishing Ltd. In the article essential problems of integrating heterogeneous data, arising in development of corporate databases intellectual access systems, are considered. In addition to the common structural problems, caused by variety of data organization, special attention is paid to the less obvious linguistic problems, caused by differences in data notation. A unified approach to overcoming such problems by sequential application of explicit definition of semantics, is described. This approach was tested in development of an intelligent search system for the TATNEFT oil-producing corporation; the system implementation showed high relevance of search results together with an adequate reactivity

Building subject domain ontology for a corporate web application

Copyright © 2020 for this paper by its authors. The technology of automated construction of the subject domain ontology, based on information extracted from the comments of the TATNEFT oil company relational databases, is considered. The technology is based on building a converter (compiler) translating the logical data model of Epicenter Petrotechnical Open Software Corporation (POSC), presented in the form of ER diagrams and a set of the EXPRESS object-oriented language descriptions, into the OWL ontology description language, recommended by the W3C consortium. The basic syntactic and semantic aspects of the transformation are described

Intelligent search in Big Data

© Published under licence by IOP Publishing Ltd. An approach to data integration, aimed on the ontology-based intelligent search in Big Data, is considered in the case when information objects are represented in the form of relational databases (RDB), structurally marked by their schemes. The source of information for constructing an ontology and, later on, the organization of the search are texts in natural language, treated as semi-structured data. For the RDBs, these are comments on the names of tables and their attributes. Formal definition of RDBs integration model in terms of ontologies is given. Within framework of the model universal RDB representation ontology, oil production subject domain ontology and linguistic thesaurus of subject domain language are built. Technique of automatic SQL queries generation for subject domain specialists is proposed. On the base of it, information system for TATNEFT oil-producing company RDBs was implemented. Exploitation of the system showed good relevance with majority of queries

Revisiting the “West-Baltic” Type Hydronymy in Central Russia

Рукопись поступила в редакцию 06.10.2020.Received on 6 October 2020.В статье рассмотрена субстратная гидронимия Поочья и Поднепровья (с финалями -ва, -да и др.), обычно относимая к западнобалтийскому топонимическому слою и связываемая с языком носителей мощинской археологической культуры и близких к ней групп памятников. Автором проведен анализ ее пространственного распределения на Восточно-Европейской равнине. Исследование показало, что: 1) гидронимия на -ва соотносится с ареалом субстратной балтийской гидронимии в целом и регионами распространения памятников днепро-двинской, юхновской, позднедьяковской культур раннего железного века; 2) ареалы гидронимов с меной ж/з и гидронимов, различающихся только этими звуками, соотносятся с ареалами древностей кривичей и радимичей, областями неразличения свистящих и шипящих и шепелявого произношения свистящих в русских диалектах; 3) балтийская гидронимия с финальным компонентом -да отсутствует на территории мощинской культуры и связанных с ней групп памятников; 4) из достоверных названий с корнем ape-/upe- в мощинском ареале отмечены лишь содержащие восточнобалтийский вариант; 5) восточнобалтийское объяснение названий с корнем stab- не уступает западно-балтийскому; 6) отсутствуют достаточные основания для возведения названий некоторых рек к прусским словам pannean и suge: бóльшая часть этих гидронимов носит поздний характер, а для меньшей более вероятны иные объяснения; 7) гипотеза о принадлежности некоторых гидронимов к числу субстратных (Зерна, Опочинка, Поня, Сежиковка и др.) не подтверждается. Исходя из вышеперечисленных наблюдений оспорена гипотеза о наличии западнобалтийского слоя гидронимии в Поочье и вытекающее из нее предположение о западнобалтийской идентичности носителей мощинской культуры.The article examines the substrate hydronymy of the middle Oka and the Dnieper regions (ending in -va, -da, etc.) that is typically attributed to the West-Baltic toponymic stratum and associated with the language of the Moschinskaya archaeological culture and the related archaeological sites. The author analyzed its spatial distribution in the East European Plain. The study has found that: 1) the spread of names of waterbodies ending in -va correlates with the distribution scheme of substrate Baltic hydronymy in general and the monuments of the Dnieper-Dvina, Yukhnovskaya, and Late Dyakovo cultures of the Early Iron Age; 2) the spread of hydronyms with zh/z sound variation (including as a distinctive feature) correlates with the Krivich and Radimich culture areas, and the range of Russian dialects with lisping pronunciation which makes no diff erence between sibilants and hushing sounds; 3) Baltic hydronymy ending in -da is not attested in the area of the Moschinskaya culture and related archaeological sites; 4) among the names with the root ape-/upe- found in the same cultural milieu, only those containing Eastern Baltic variant are verifi able; 5) the hypothesis for East Baltic origination of the names with the root stab- is not inferior to the West Baltic; 6) there are no suffi cient grounds for tracing some river names to the Prussian words pannean and sug since most of these hydronyms refer to a later period while the others have more plausible explanations; 7) for some hydronyms (Zerna, Opochinka, Ponya, Sezhikovka, etc.) the substrate origin is not confi rmed. Based on the above observations, the hypothesis for the presence of a West-Baltic layer of hydronymy in the middle Oka region and the consequent assumption of the West-Baltic origin of the Moshinskaya culture were disputed

On ontology based data integration: Problems and solutions

© Published under licence by IOP Publishing Ltd. In the article essential problems of integrating heterogeneous data, arising in development of corporate databases intellectual access systems, are considered. In addition to the common structural problems, caused by variety of data organization, special attention is paid to the less obvious linguistic problems, caused by differences in data notation. A unified approach to overcoming such problems by sequential application of explicit definition of semantics, is described. This approach was tested in development of an intelligent search system for the TATNEFT oil-producing corporation; the system implementation showed high relevance of search results together with an adequate reactivity