DISTRIBUTED DATABASE STRUCTURE DESIGN BASED ON SQL-QUERY PARSING
Journal Title: Наукові праці. Серія "Комп’ютерні технології" - Year 2016, Vol 287, Issue 275
Abstract
In measures of research, the specificity of operational records associated with the transition from local to distributed database was discussed. This trend is motivated by the presence of different accounting types, by existence of workstations that are geographically remoted and, of course, by the need of consolidating data analysis. In view of distributed database structure usage necessarily is actual question of best data storage strategy for different parts of data in distributed database. In addition, it is important to choose right way and technique of its future synchronizing in case of its changing or may be for making consolidated analysis by on-line analytical processing subsystems. Research aims to improve execution speed of local SQL-queries with keeping value of data relevance in acceptable measures by optimizing the database structure of remote workstation place. It makes possible by users SQL-queries parsing with future clustering and classification of central DB relations set. The first stage is creation of user queries accounting with the possibility of its future classification depending on what workstation place it belongs, where is it placed (geographical location), what user role it belongs, and other criteria’s. According to the parameter, classification is been doing automatically as well as manually. Particularly attention is payed to separate stage of queries text parsing which is aided to determine relations and attributes list. SQL-query code parsing task is suggested to solve by using open source project ANTLR. Final analysis that is made based on previously received data allows achieving databases and relations list. This list have to be available on-line and can be ranged by different criteria’s. Some relations need of special attention during making a decision of its placing in remote database. In this case relation projections that are used in different queries need to be considered as well as horizontal division based on range of keys
Authors and Affiliations
M. Dvoretskiy, S. Borovlyova, E. Davydenko
Keywords
Related Articles
- EP ID EP225175
- DOI -
- Views 126
- Downloads 0
RESEARCH OF METHODS FOR INCREASING THE EFFICIENCY OF PATTERN RECOGNITION IN SYSTEMS FOR COLLECTING AND SORTING PLASTIC BOTTLES
Nowadays the whole world is thinking about preserving the environment. One of the most important factors is the processing of waste, most of which is occupied by plastic bottles. The rapid development of plastic packagin...
RESEARCH OF COMPUTER CONTROL SYSTEM PLATFORM FOR MOBILE OBJECT
In today’s world, a lot of attention paid to the various systems of stabilization. It can be a stabilizer for cameras ‒ steadicam or suspension stabilization system for sports cars. It is used in various areas of technol...
SYSTEM OF MONITORING OF THE ROUT TAXI
The article deals with the hardware and software complex of monitoring of public transport movement (in the priority of monitoring the route taxi) on the basis of the theory of mass service systems. The prototype of a mo...
THE ESTABLISHMENT OF A REGISTRATION SYSTEM THE EFFECT OF DEFLECTION OF THE FLUID FLOW
In result of the conducted researches it is proposed the creation of a system monitoring the occurrence of the Coanda effect to reduce accidents and improve the system dynamic positioning semi-submersible drilling rigs....
ANALYSIS DORASDADDY OPERATIONS OF CRYPTOGRAPHIC ENCODING ACCORDING TO THE CRITERION OF THE STRICT AVALANCHE EFFECT
The article identifies many double operations cryptographic encoding which meet the criteria of strict avalanche effect, and the peculiarities of their use in cryptographic algorithms. The possibility of achieving the st...