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 |
| _version_ | 1818947255137206272 |
|---|---|
| author | Р. Белоус Є. Крилов В. Анікін |
| author_facet | Р. Белоус Є. Крилов В. Анікін |
| author_sort | Р. Белоус |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-12-20T08:28:00Z |
| format | Article |
| id | doaj.art-c8a15a3d7af846e09760825b821a0da1 |
| institution | Directory Open Access Journal |
| issn | 1560-8956 2522-9575 |
| language | English |
| last_indexed | 2024-12-20T08:28:00Z |
| publishDate | 2021-12-01 |
| publisher | Igor Sikorsky Kyiv Polytechnic Institute |
| record_format | Article |
| series | Adaptivni Sistemi Avtomatičnogo Upravlinnâ |
| spelling | doaj.art-c8a15a3d7af846e09760825b821a0da12022-12-21T19:46:47ZengIgor Sikorsky Kyiv Polytechnic InstituteAdaptivni Sistemi Avtomatičnogo Upravlinnâ1560-89562522-95752021-12-0123910.20535/1560-8956.39.2021.247364Methods for optimizing queries of distributed databasesР. Белоус0Є. Крилов1В. Анікін2Igor Sikorsky Kyiv Polytechnic InstituteIgor Sikorsky Kyiv Polytechnic InstituteIgor Sikorsky Kyiv Polytechnic InstituteThe 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.http://asac.kpi.ua/article/view/247364distributed databasesoptimization methodsDBMSDB – DBMS connection |
| spellingShingle | Р. Белоус Є. Крилов В. Анікін Methods for optimizing queries of distributed databases Adaptivni Sistemi Avtomatičnogo Upravlinnâ distributed databases optimization methods DBMS DB – DBMS connection |
| title | Methods for optimizing queries of distributed databases |
| title_full | Methods for optimizing queries of distributed databases |
| title_fullStr | Methods for optimizing queries of distributed databases |
| title_full_unstemmed | Methods for optimizing queries of distributed databases |
| title_short | Methods for optimizing queries of distributed databases |
| title_sort | methods for optimizing queries of distributed databases |
| topic | distributed databases optimization methods DBMS DB – DBMS connection |
| url | http://asac.kpi.ua/article/view/247364 |
| work_keys_str_mv | AT rbelous methodsforoptimizingqueriesofdistributeddatabases AT êkrilov methodsforoptimizingqueriesofdistributeddatabases AT vaníkín methodsforoptimizingqueriesofdistributeddatabases |