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 110
- Downloads 0
RECORDING AND PROCESSING OF PRIMARY ACOUSTIC MATERIAL FOR THE TASK OF VOICE ANALYSISAND VOICE CHARACTERISTICS EXTRACTION
The features of using different types of microphones for acoustic recording of the human voice are considered. The possibility of using studio, headset, lapel and stubborn microphones is analyzed. The main characteristic...
PARAMETRIC PRESENTATION OF PELTIER ELEMENT CHARACTERISTICS
A technique for calculating the characteristics of the Peltier element based on three parame-ters and the SPICE model is described. Mathematical model of the Peltier element is proposed and considered. The proposed metho...
IMPLEMENTATION AND MODELLING OF FAST MEDIAN FILTERING
In this article has been proposed the use of a modified median filter that uses partitioning vector data, which is processed in blocks.Has been proposed a hardware-software and hardware implementation of the modified med...
APPLICATION OF MACHINE LEARNING METHODS IN DRILLING AUTOMATION TASKS
Most modern drilling machines are not able to drill composite materials (CM) automatically with preservation a drill against breakages. The proposed effective learning algorithm is able to manage com-plex hardware device...
THE STUDENT’S KNOWLEDGE AUTOMATED CONTROL SYSTEM ON PRACTICE OF THEORETICAL DISCIPLINES
The application system intended for the students knowledge automated control at realization of practical trainings on theoretical disciplines is described. Processes of control tasks preparation by the teacher and realiz...