System and method for tightly coupling application programs with

Details System and method for tightly coupling application programs with System and method for tightly coupling application programs with

1995-08-24

1998-03-31

Black, Thomas G.

395704, 395705, G06F 1730

Patent

active

057348855

ABSTRACT:
An application program is tightly coupled to a relational database without changing the software of the database management system. A first user defined function (udf) allocates a work area in the address space of the database management system. Then, a second udf embodying the computational steps of the application program undertakes the computational steps within the dbms work area and saves the results in the work area. Importantly, the second udf does not return an answer to the application program during the processing of records, thereby eliminating copying costs and context switch costs. When processing is complete, the results are transmitted to the application program and the work area is released.

REFERENCES:
patent: 4805134 (1989-02-01), Calo et al.
patent: 4891785 (1990-01-01), Donohoo
patent: 5210870 (1993-05-01), Baum et al.
patent: 5317742 (1994-05-01), Bapat
patent: 5430644 (1995-07-01), Deaton et al.
patent: 5430871 (1995-07-01), Janoussi et al.
patent: 5434963 (1995-07-01), Kuwamoto et al.
patent: 5504886 (1996-04-01), Chang et al.
Martin Vingron and Patrick Argos, "A Fast and Sensitive Multiple Sequence Alignment Algorithm", Computer Applications in the Biosciences, 5:115-122, 1989. (W1.C0528.BML 1st & 2nd Fl.).
M.A. Roytberg, "A Search For Common Patterns in Many Sequences", Computer Applications in the Biosciences, 8(i):57-64, 1992.
S. Gatziu and K.R. Dittrich, "Detecting Composite Events in Active Databases Using Petri Nets", Proceedings of the 4th International Workshop on Research Issues in Data engineering: Active Database Systems, pp. 2-9, Feb. 1994. (QA76.9D3.1593 1993).
IBM Database 2 Application Programming Guide for Common Servers, Verson 2, pp. 275-304 (1995).
Montage User's Guide, pp. 8-1 through 8-5 (Mar. 1994).
V. Linneman, et al., "Design and Implementation of an Extensible Database Management System Supporting User Defined Data Types and Functions", Proceedings of the International Conference on Very Large Data Bases, Amsterdam, The Netherlands, 1988, pp. 294-305.
R. Agrawal, et al., "Mining Association Rules Between Sets of Items in Large Databases", Proceedings of the ACM SIGMOD Conference on Management of Data, pp. 207-216, Washington, D.C., May 1993.
Rakesh Agrawal, et al., "Database Mining: A Performance Perspective", IEEE Transactions on Knowledge and Data Engineering, 5(6):914-925, Dec. 1993.
R. Agrawal, et al., "Fast Algorithms for Mining Association Rules", Proceedings of VLDM Comference, Santiago, Chile, Sep. 1994, pp. 487-499. (IBM Research Report RJ9839, Jun. 1994).
W. Hasan, et al., "Papyrus GIS Demonstration", Proceedings of the ACM-SIGMOD International Conference on the Management of Data, Washington, D.C., pp. 554-555, Jun. 1993.
M. Stonebraker, et al., "The Design of Postgres", Proceedings of the ACM-SIGMOD International Conference on the Management of Data, Washington, D.C., pp. 340-355, May 1986.
M. Stonebraker, et al., "The DBMS Research at Crossroads: The Vienna Update", Proceedings of the VLDB Conference, pp. 688-692, Dublin, Aug.1993.
M.M. Morsi, et al., "An Extensible Object-Oriented Database Testbed", Proceedings of the International Conference on Data Engineering, pp. 150-157, 1992. (QA 76.9 1594).
G. M. Lohman, et al., "Extensions to Starburst: Objects, Types, Functions, and Rules", Communications of the ACM, pp. 95-106, vol. 34, No. 10, Oct. 1991.

Affiliated with

Also associated with

Rating

System and method for tightly coupling application programs with 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 tightly coupling application programs with, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for tightly coupling application programs with will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-62812