System and method for mutation of selected assignment operations

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

364DIG1, 3642821, 3642834, 39520002, G06F 1730

Patent

active

055663290

ABSTRACT:
A relational data base management system that stores and retrieves large data objects (LOBs) from data base storage to evaluate assignment statements includes a data manager that mutates selected string operations into equivalent functions on a LOB operand that can be left in the data base, thereby eliminating the associated storage access operations. When the data manager receives an assignment statement containing one or more LOBs, the data manager first checks to determine if the statement can be mutated. If the statement can be mutated, then the mutation is performed. The mutated statement is then processed according to a conventional deleted evaluation scheme. If the assignment statement cannot be mutated, then the statement is evaluated according to a conventional deleted evaluation scheme. In this way, the data base management system does not require the LOB to be read from the data base into intermediate storage, but instead provides an equivalent result by operating on the LOB in place in the data base storage. This permits processing selected LOB assignment statements with much fewer storage access operations than an immediate evaluation scheme, thereby increasing efficiency and execution speed.

REFERENCES:
T. J. Lehman et al., "The Starburst Long Field Manager", Proceedings of the 15th Int'l Con'f on Very Large Databases, IEEE, 1989, pp. 375-383.
R. L. Haskin et al., "On Extending the Function of a Relational Database System," Proc. 1982 ACM-SIGMOD Conference on Management of Data, Jun. 1982, pp. 207-213.
M. J. Carey et al., "Object and File Management in the Exodus Extensible Database System," Proceedings of the 12th Int'l Conference on Very Large Data Bases, 1986, pp. 91-100.
A. Biliris, "An Efficient Database Storage Structure for Large Dynamic Objects," 1992 8th Int'l Conference on Data Engineering, pp. 301-308.
B. Hwang et al., "Efficient Storage Management for Large Objects," 1994 20th Conference on System Architecture and Design (Euromicro '94), pp. 37-44.
Michael Stonebraker, "Large Object Support in Postgres," 9th Int'l Conference on Data Engineering, 1993 IEEE, pp. 355-362.
J. R. Barnett et al., "A Uniform Mechanism to Support Long Fields and Nested Relations in Database Management Systems," 1989 Annual Hawaii Int'l Conference on System Sciences (vol. II), pp. 569-576.

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

System and method for mutation of selected assignment operations does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for mutation of selected assignment operations, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for mutation of selected assignment operations will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-1254455

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