Architecture of shared-nothing cluster to fast accessing and ensure the availability of data in distributed database environment
Main Article Content
Abstract
Database systems have been essential for all forms of data processing for a long time. In recent years, the amount of processed data
has been growing dramatically, even in small projects. At the other hand, database management systems tend to be static in terms of size and
performance, which makes scaling a difficult and expensive task. Enterprises may have multiple database systems spread across the
organization for redundancy or for serving different applications. In such systems, query workloads can be distributed across different servers
for better performance. In this paper, we focus on complex queries whose evaluation tends to be time-consuming and design the secured share
nothing clustering architecture to improve the performance of application and also assure to the user to availability of the data. The proposed
architecture is very helpful towards a two phase query optimizer. In the first phase, the synchroniz and decomposes a query into subqueries and
tranfer them to appropriate cluster nodes. In the second phase, each cluster node optimizes and evaluates its subquery locally.
Â
Key word: cluster technology, database technology, shared-nothing cluster, query processing, query optimization.
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.