Distributed databases principles and systems
Distributed databases principles and systems
Data allocation in distributed database systems
ACM Transactions on Database Systems (TODS)
Allocating data files over a wide area network: goal setting and compromise design
Information and Management
Principles of distributed database systems (2nd ed.)
Principles of distributed database systems (2nd ed.)
Five Steps to Construct a Model of Data Allocation for Distributed Database Systems
Journal of Intelligent Information Systems
Distributed Object Based Design: Vertical Fragmentation of Classes
Distributed and Parallel Databases
On Data Allocation with the Minimum Overall Communication Costs in Distributed Database Design
ICCI '93 Proceedings of the Fifth International Conference on Computing and Information
Availability and Reliability Issues in Distributed Databases Using Optimal Horizontal Fragmentation
DEXA '99 Proceedings of the 10th International Conference on Database and Expert Systems Applications
Incremental data allocation and reallocation in distributed database systems
Data warehousing and web engineering
Vertical fragmentation in distributed object database systems with complex attributes and methods
DEXA '96 Proceedings of the 7th International Workshop on Database and Expert Systems Applications
An Adaptive Object Allocation and Replication Algorithm in Distributed Databases
ICDCSW '03 Proceedings of the 23rd International Conference on Distributed Computing Systems
Integrating vertical and horizontal partitioning into automated physical database design
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Enhancing XML data warehouse query performance by fragmentation
Proceedings of the 2009 ACM symposium on Applied Computing
DYFRAM: dynamic fragmentation and replica management in distributed database systems
Distributed and Parallel Databases
An Efficient Approach for Data Placement in Distributed Systems
MUE '11 Proceedings of the 2011 Fifth FTRA International Conference on Multimedia and Ubiquitous Engineering
Secure dynamic fragment and replica allocation in large-scale distributed file systems
IEEE Transactions on Parallel and Distributed Systems
Hi-index | 0.00 |
One of the important features of database fragmentation and allocation techniques is the fact that they depend not only on the entries of a database relation, but also on their empirical frequencies of use. Distributed processing is an effective way to improve performance of database systems. However, for a Distributed Database System (DDBS) to function efficiently, fragments of the database need to be allocated carefully at various sites across the relevant communications network. Therefore, fragmentation and proper allocation of fragments across network sites is considered as a key research area in distributed database environment. However, fragments allocation to the most appropriate sites is not an easy task to perform. This paper proposes a synchronized horizontal fragmentation, replication and allocation model that adopts a new approach to horizontally fragment a database relation based on attribute retrieval and update frequency to find an optimal solution for the allocation problem. A heuristic technique to satisfy horizontal fragmentation and allocation using a cost model to minimize the total cost of distribution is developed. Experimental results are consistent with the hypothesis and confirm that the proposed model can efficiently solve dynamic fragmentation and allocation problem in a distributed relational database environment.