Methods for optimizing queries of distributed databases
The object of research is distributed databases. The article emphasizes the great variety of existing databases and gives a brief description of them. The advantages, disadvantages and necessary requirements to the distributed database are analyzed. The most effective ways to optimize the structure...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Igor Sikorsky Kyiv Polytechnic Institute
2021-12-01
|
| Series: | Adaptivni Sistemi Avtomatičnogo Upravlinnâ |
| Subjects: | |
| Online Access: | http://asac.kpi.ua/article/view/247364 |
| Summary: | The object of research is distributed databases. The article emphasizes the great variety of existing databases and gives a brief description of them. The advantages, disadvantages and necessary requirements to the distributed database are analyzed. The most effective ways to optimize the structure of distributed databases are listed separately. The purpose of the research is to analyze the approaches to assessing the effectiveness of distributed databases (productivity, scalability (extensibility), reliability, data protection, availability, ease of application development, the level of interaction with the user). The fragment of grammar of T – SQL language is given and the basic generalizing recommendations on writing of inquiries, which are convenient for the optimizer and effective at execution, are resulted.
Ref. 4. |
|---|---|
| ISSN: | 1560-8956 2522-9575 |