Data Allocation in Distributed Database Systems在分布式数据库系统中的数据分配.ppt

Data allocation in DDS Data Allocation in Distributed Database Systems Samira Tasharofi Reza Basseda Introduction Primary concern in DDS Designing the fragmentation and allocation of the underlying database Data allocation goal: To fix the sites where the fragments are located so as to minimize the total data transfer cost, under the storage constraints (i.e., the maximum number of fragments that can be allocated at a site) at each of the sites Introduction (Cont.) The data allocation problem is NP-complete in general and requires heuristics that are fast and are capable of generating high-quality solutions The optimal allocation of database objects highly depends on the query execution strategy employed by a distributed database system The given query execution strategy usually assumes an allocation of the fragments Outline Static Algorithms Dynamic Allocation Algorithms Transparent Data Relocation Conclusion References Static Algorithms Genetic Algorithm: begins by generating an initial population, P (t = 0), and evaluating each of its members with the objective function While the terminator condition is not satisfied, a portion of the population is selected, somehow altered, evaluated, and placed back into the population Static Algorithms (Cont.) The Simulated Evolution Algorithm: The principal difference between a genetic algorithm and an evolutionary strategy is that the former relies on crossover, a mechanism of probabilistic and useful exchange of information among solutions to locate better solutions, while the latter uses mutation as the primary search mechanism In the proposed scheme the chromosomal representation is based on problem data, and solution is generated by applying a fast decoding heuristic (mapping heuristic) in order to map from problem domain to solution domain. Static Algorithms (Cont.) The Mean Field Annealing (MFA) Algorithm Combines the collective computation property of the famous Hopfield Neural Network (HNN) with simulated a