Automated query optimization method using both global and parallel local optimizations for materialization access planning for distributed databases

摘要: In a Distributed Database System (DDS), database management and transaction are extended to distributed environment among plurality of local sites which each have server, file data storage facilities. The Materialization Access Planning (MAP) method query, update, or is an important part the processing transaction. access planning results in strategy for system (DSDBMS). consists selecting copies used process This step necessary since may be stored at more than one site (i.e., computer) on network. planing choosing execution order operations actual operation. Three methods used: General (Response), (Total) Initial Feasible Solution (IFS). For (Response) decrease communication cost increase costs as compared IFS.