Computer automated system and method for optimizing the processi

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

364DIG1, 3642834, G06F 15403

Patent

active

053676750

ABSTRACT:
An automated method is provided for optimizing a query for retrieving data from a relational database in a computer relational database management system. The method uses rules for identifying queries for which duplicates are a factor in retrieving the proper data from the database. The method then merges queries with table expressions, views and subqueries when possible without causing duplicates to be unnecessarily retrieved.

REFERENCES:
patent: 4769772 (1989-09-01), Dwyer
patent: 4829427 (1989-05-01), Green
patent: 5091852 (1992-02-01), Tsuchida et al.
patent: 5239663 (1993-08-01), Faudemay
M. Astrahan et al., "System R", System R: Relational Approach to Database Management, ACM Transactions on Database Systems, Jun. 1986, pp. 97-137.
P. Selinger, et al., "Access Path Selection in a Relational Database Management System," Jun. 1979, Proc. ACM SIGMOD.
R. Ganski, et al., "Optimization of Nested SQL Queries Revisited," 1987 Proc. of ACM SIGMOD Conference.
W. Kim, "On Optimizing an SQL-like Nested Query," Sep. 1982, vol. 7:3, ACM Transactions on Database Systems.
O. Anfindsen, "A Study of Access Path Selection in DB2" Norwegian Telecommunications Administration and University of Oslo, Norway.
L. Haas, et al., "Extensible Query Processing in Starburst," 1989 ACM 0-89791-317-/5/89/0005/0377.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Computer automated system and method for optimizing the processi does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Computer automated system and method for optimizing the processi, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computer automated system and method for optimizing the processi will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-1998003

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.