A Paged Prefetching Model for Join Operations of Cross-Databases
As the applications of big data are increasing, the NoSQL (Not only Structured Query Language) database management systems have been developed rapidly. How to integrate NoSQL database and relational database effectively has become one of the research hotspots. In the existing research results, the p...
| Format: | Article |
|---|---|
| Language: | zho |
| Published: |
EDP Sciences
2020-12-01
|
| Series: | Xibei Gongye Daxue Xuebao |
| Subjects: | |
| Online Access: | https://www.jnwpu.org/articles/jnwpu/full_html/2020/06/jnwpu2020386p1225/jnwpu2020386p1225.html |
| _version_ | 1797427564774424576 |
|---|---|
| collection | DOAJ |
| description | As the applications of big data are increasing, the NoSQL (Not only Structured Query Language) database management systems have been developed rapidly. How to integrate NoSQL database and relational database effectively has become one of the research hotspots. In the existing research results, the paged query method used for join operations of these heterogeneous multi-databases can produce a large delay. In view of this deficiency, this paper presents a paged prefetching model, and focuses on its basic composition, prefetching mode and operation mechanism. A prototype system is designed and developed. The effect of this model is verified, and the expected targets are achieved. Compared with the non-prefetched paging query method, the outstanding contribution of this research result is that it can reduce the delay of paging query and thus improve the efficiency of the join operations of cross-databases. |
| first_indexed | 2024-03-09T08:45:43Z |
| format | Article |
| id | doaj.art-474ec098887146bbb3c458d68d5ea0cf |
| institution | Directory Open Access Journal |
| issn | 1000-2758 2609-7125 |
| language | zho |
| last_indexed | 2024-03-09T08:45:43Z |
| publishDate | 2020-12-01 |
| publisher | EDP Sciences |
| record_format | Article |
| series | Xibei Gongye Daxue Xuebao |
| spelling | doaj.art-474ec098887146bbb3c458d68d5ea0cf2023-12-02T15:16:41ZzhoEDP SciencesXibei Gongye Daxue Xuebao1000-27582609-71252020-12-013861225123410.1051/jnwpu/20203861225jnwpu2020386p1225A Paged Prefetching Model for Join Operations of Cross-Databases01School of Computer Science and Engineering, Northwestern Polytechnical UniversitySchool of Computer Science and Engineering, Northwestern Polytechnical UniversityAs the applications of big data are increasing, the NoSQL (Not only Structured Query Language) database management systems have been developed rapidly. How to integrate NoSQL database and relational database effectively has become one of the research hotspots. In the existing research results, the paged query method used for join operations of these heterogeneous multi-databases can produce a large delay. In view of this deficiency, this paper presents a paged prefetching model, and focuses on its basic composition, prefetching mode and operation mechanism. A prototype system is designed and developed. The effect of this model is verified, and the expected targets are achieved. Compared with the non-prefetched paging query method, the outstanding contribution of this research result is that it can reduce the delay of paging query and thus improve the efficiency of the join operations of cross-databases.https://www.jnwpu.org/articles/jnwpu/full_html/2020/06/jnwpu2020386p1225/jnwpu2020386p1225.htmlbig datanosqlsqldatabase integrationcross-databases joinpaged prefetching modeltime delaypaging query |
| spellingShingle | A Paged Prefetching Model for Join Operations of Cross-Databases Xibei Gongye Daxue Xuebao big data nosql sql database integration cross-databases join paged prefetching model time delay paging query |
| title | A Paged Prefetching Model for Join Operations of Cross-Databases |
| title_full | A Paged Prefetching Model for Join Operations of Cross-Databases |
| title_fullStr | A Paged Prefetching Model for Join Operations of Cross-Databases |
| title_full_unstemmed | A Paged Prefetching Model for Join Operations of Cross-Databases |
| title_short | A Paged Prefetching Model for Join Operations of Cross-Databases |
| title_sort | paged prefetching model for join operations of cross databases |
| topic | big data nosql sql database integration cross-databases join paged prefetching model time delay paging query |
| url | https://www.jnwpu.org/articles/jnwpu/full_html/2020/06/jnwpu2020386p1225/jnwpu2020386p1225.html |