Automated query optimization method using both global and parall

Details Automated query optimization method using both global and parall Automated query optimization method using both global and parall

1985-02-28

1988-09-06

Williams, Jr., Archie E.

Boots, shoes, and leggings

364200, G06F 1516, G06F 1540

Patent

active

047697725

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

REFERENCES:
patent: 4430699 (1984-02-01), Segarra et al.
patent: 4432057 (1984-02-01), Daniell et al.
patent: 4464650 (1984-08-01), Eastman
patent: 4479196 (1984-10-01), Ferrer et al.
patent: 4497039 (1985-01-01), Kitakami et al.
patent: 4499553 (1985-02-01), Dickinson et al.
patent: 4500960 (1985-02-01), Babecki et al.
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4513390 (1985-04-01), Walter et al.
patent: 4531186 (1985-07-01), Knapman
patent: 4543630 (1985-09-01), Neches
patent: 4553222 (1985-11-01), Kurland etal.
patent: 4604686 (1986-08-01), Reiter et al.
patent: 4606002 (1986-08-01), Waisman et al.
patent: 4631673 (1986-12-01), Haas et al.
patent: 4635189 (1987-01-01), Kendall
patent: 4644471 (1987-02-01), Kojima et al.
patent: 4648036 (1987-03-01), Gallant

Affiliated with

Also associated with

Rating

Automated query optimization method using both global and parall does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Automated query optimization method using both global and parall, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Automated query optimization method using both global and parall will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1610773