relation database
Recently Published Documents


TOTAL DOCUMENTS

35
(FIVE YEARS 6)

H-INDEX

3
(FIVE YEARS 1)

Author(s):  
Sergei Pavlovich Karpov ◽  
Vladimir Aleksandrovich Ilyashenko

The article discusses the process of database creation that covers notarial documents telling us about the history of an Italian trading post Tana (Azov). The material for the database has been collected over several years as part of a research addressing a set of documents about the history of medieval Italy. In the course of the research a considerable body of material has been collected. Its analysis was a hard task since data were arranged in a peculiar way. To achieve the goal a relational database consisting of sixteen tables which in turn contained several dozen fields has been created on the basis of DBMS Access. The article also describes the main goals and difficulties the database creation is accompanied by as well as those emerging when analysis by means of inquires is made. These are identification of names mentioned in the sources as well as identification and removal of multiple references to the same personalities. This database covers multilateral information about commercial transactions made in Tana in the 13th-15th centuries including places, dates and details of these transactions, detailed information about people involved as well as links to sources of this information.


Author(s):  
Jintao Gao ◽  
Wenjie Liu ◽  
Zhanhuai Li

Read separating from write is a strategy that NewSQL adopts to incorporate the advantages of traditional relation database and NoSQL database. Under this architecture, baseline data is split into multiple partitions stored at distributed physical nodes, while delta data is stored at single transaction node. For reducing the pressure of transaction node and improving the query performance, delta data needs to be synchronized into storage nodes. The current strategies trigger the procedure of data synchronization per partition, meaning that unchanged partitions will also participate in data synchronization, which consumes extra network cost, local IO and space resources. For improving the efficiency of data synchronization meanwhile mitigating space utilization, the fine-grained data synchronization strategy is proposed, whose main idea includes that fine-grained logical partitions upon original coarse-grained partitions is established, providing more correct synchronized unit; the delta data sensing strategy is introduced, which records the mapping between changed partitions and its delta data; instead of partition driven, the data synchronization through the delta-broadcasting mechanism is driven, constraining that only changed partitions can participate in data synchronization. The fine-grained data synchronization strategy on Oceanbase is implemented, which is a distributed database with read separating from write, and the results show that our strategy is better than other strategies in efficiency of data synchronizing and space utilization.


The purpose of this article is to consider the methodological features of the nature reserve fund of Ukraine (NRFU) mapping as instruments of thematic interactive map creation of the specified objects in Poltava region. It is defined as a modern mapping service. That is the result of work and an innovative and effective application tool, in particular for environmental monitoring and land management of the region. Main material. Based on modern scientific methods, types of objects of the nature reserve fund on the map are applied. The possibility to obtain additional meta-information about them through pop-up dialogues and hyperlinks are substantiated. It is proved this holistic cartographic work and at the same time dynamic information-cartographic system must match modern practice requirements. Different groups of users in the framework of environmental monitoring, regional land management etc. must be informed to perform a number of important strategic and tactical tasks. The authors formulate approaches to determining the overall effectiveness of the developed thematic interactive map through the purpose, the results of the intended use and the creation cost, maintenance at the current level. The authors applied the methodological principles of geoinformation mapping for this (heredity, system compliance, continuity, consistency, representativeness, scale, cost-effectiveness), assessing the effectiveness of the system approach, obtaining not only a general indicator but also partial estimates, flexibility of methods to change conditions use map. The algorithm of regional geoinformation mapping of the nature reserve fund of Ukraine has been developed. This is generally characterized by consistent implementation of tasks at three levels: theoretical, informational-logical and practical. The list of information mapping layers of the interactive map, which make up its contents are obtained. This is based on using various types of data from the created object-relation database, which contains 376 NRFU objects in Poltava region (98.2% filling). Conclusions. As a result of the research on the creation of a thematic interactive map of NREU in Poltava region, using effective methodological tools, the provisions of modern regional geoinformation mapping in the form of an established algorithm are formulated.


For representing and manipulating uncertain information like fuzzy, incomplete, inconsistent or imprecise, Neutrosophic relation database model is a more general platform, in the human decision-making process. Neutrosophic sets can easily handle real world problems. A new correlation method is introduced in this paper to construct similarity measure, by which decision making problem that exist in real world situation can be easily handled in regard of multiple existing criteria’s or incomplete or inconsistent information. The selection of the best option of alternative can be done by ranking all the other options as per similarity measure depending on concept of similarity. Later in this paper, an explanatory example is given of the proposed method and the comparison results are also presented to show the effective output.. The application in certain domains of medical diagnosis problems having multiple criteria’s in decision making are also discussed in the end of the proposed method.


2019 ◽  
Vol 12 (3) ◽  
pp. 159
Author(s):  
Pisase Senawongse ◽  
Apisit Eiumnoh

A decision support system (DSS) module for sustainable land development for Thailand: A case of Chonburi province was developed for decision makers based on available geographic information databases and overlaying techniques available on an internet network. Chonburi province in the Southeast Coast of Thailand was assigned as a special economic development zone or Eastern Economic Corridor (EEC) is a fast growing area for industrial and infrastructure developments causing land use conflicts between privates and governments that were observed elsewhere. Databases including administrative boundary, land resources, land uses, national policies and legislation aspects were integrated for land suitability, condition and limitation for land developments. The system employed ArcGIS Geo-processing service module available on the Central Relation Database that can be accessed via Web Services and RSS. The decision makers could access from the Web Browser and make decision under three conditions, by screening areas for specific land use types, analyzing land use limitations and conditions or for maximum land use benefits. The developed DSS module on land resources spatial analysis and legislation limitations would be a simple technological tool to preliminary and fast selection of proper land managements in the future and would be able to apply in other parts of the country.


2018 ◽  
Vol 14 (2) ◽  
pp. 124-146
Author(s):  
Kento Goto ◽  
Misato Kotani ◽  
Motomichi Toyama

Purpose Currently, the results of database acquisition are variously expressed, but it seems that users’ understanding degree will be improved by expressing some search results such as images of products of shopping sites in three dimensions rather than two dimensions. Therefore, this paper aims to propose a system for automatically generating 3D virtual museum that arranges 3D objects with various layouts from the acquisition result of relation database by SuperSQL query. Design/methodology/approach The study extended the SuperSQL to generate 3D virtual reality museum using declarative queries on relational data stored in a database. Findings This system made it possible to generate various three-dimensional virtual spaces with different layouts through simple queries. Originality/value It can be said that this system is useful in that a complicated three-dimensional virtual space can be generated by describing a simple query and a different three-dimensional virtual space can be generated by slightly changing the query or database content. When creating a virtual museum, if there are too many exhibitions or when changing the layout, the burden on the user will be high. But in this system, it is possible to automatically generate various virtual museums easily and reduce the burden on users.


2018 ◽  
Vol 2 (2) ◽  
pp. 51
Author(s):  
M. Sandeep Kumar ◽  
Prabhu .J

A Huge amount of data is manipulated by using the web application, Facebook, Twitter, social sites etc. Most of the data are unstructured data. It is not desirable for storing, performing and analyzing data in the relational database for huge data. It affords way towards performing NoSQL database and uses fully for handling the big data. In this paper, we present the performance in store and query operation in NoSQL database, estimating the performance of both reads and write operation using simple and complex queries. Result represents that comparing Cassandra with relation database, Cassandra outperforms the relation database. Most of the organization used only Hbase and Cassandra for benefit of cost. Comparison Various NoSQL Database, issues while performing NoSQL database. 


2014 ◽  
Vol 1030-1032 ◽  
pp. 1900-1904 ◽  
Author(s):  
Hai Yan Chen

Big Data provides a possibility of handling mass data, which acts as a subversive technique. By the way, traditional relation database is no more effective of mass data that causes distributed database NoSQL to appear and evolve. In this article, we will design and realize a new distributed big data management system (DBDMS), which is based on Hadoop and NoSQL techniques, and it provides big data real-time collection, search and permanent storage. Proved by some experiment, DBDMS can enhance the processing capacity of mass data, very suitable for mass log backup and retrieval, mass network packet grab and analyze, and etc. other applied areas.


Sign in / Sign up

Export Citation Format

Share Document