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 112
- Downloads 0
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...
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...
SHIPBOARD FIBER OPTIC HYDROPHONE
To build traffic safety navigation systems and submarine vessels and apparatus necessary to implement reliable control of hydroacoustic fields. Existing controls are not fully in its metro-logical and technical character...
P-POLARIZED NONLINEAR SURFACE POLARITONS IN A LAYER WITH INTENSITY-DEPENDENT DIELECTRIC FUNCTION
Properties of p-polarized nonlinear surface polaritons (NLSP) have been investigated theoretically in a number of papers. But several simplifications which essentially reduce the generality of the results and limit the p...
FIBER-OPTICAL SENSOR OF METHANE
For the construction of the system of safety in surrounding environment it is necessary to carry out reliable control of methane. Existent controls not in a complete measure after the metrology and technical by descripti...