 |
|
|
|
|
|
 Title: |
US5734885:
System and method for tightly coupling application programs with relational databases
[ Derwent Title ]
|
| Country: |
US United States of America
|
| |
| Inventor: |
Agrawal, Rakesh; San Jose, CA
Shim, Kyuseok; San Jose, CA
|
| Assignee: |
International Business Machines Corporation, Armonk, NY
other patents from INTERNATIONAL BUSINESS MACHINES CORPORATION (280070) (approx. 44,393)
News, Profiles, Stocks and More about this company
|
| Published / Filed: |
1998-03-31
/ 1995-08-24
|
| Application Number: |
US1995000518875
|
| IPC Code: |
Advanced:
G06F 17/30;
Core:
more...
IPC-7:
G06F 17/30;
|
| ECLA Code: |
G06F17/30S4F9E; G06F17/30S4P4P;
|
| U.S. Class: |
Current:
707/003;
717/106;
Original:
395/603;
395/704;
395/705;
|
| Field of Search: |
395/600,603,704,705
|
| Priority Number: |
| 1995-08-24 |
US1995000518875 |
|
| 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.
|
| Attorney, Agent or Firm: |
Baker, Maxham, Jester & Meador ;
|
| Primary / Asst. Examiners: |
Black, Thomas G.; Corrielus, Jean M.
|
| INPADOC Legal Status: |
Show legal status actions
|
| Family: |
None
|
First Claim:
Show all 15 claims |
We claim:
1. A digital processing apparatus, comprising:
- a database management system having a database address space;
- a relational database accessible by the database management system;
- first computer readable code means for generating a user defined function (udf) embodying operational steps of an application program;
- second computer readable code means for tightly coupling the database management system with the application program by:
- causing the database management system to execute the udf and thereby generate a results set without transmitting the results set to the application program;
- storing the results set in the database address space; and
- third computer readable code means for transmitting the results set to the application program.
|
| Background / Summary: |
Show background / summary
|
| Drawing Descriptions: |
Show drawing descriptions
|
| Description: |
Show description
|
| Forward References: |
Show 3 U.S. patent(s) that reference this one
|
|
|
|
|
|
|
| Foreign References: |
None
|
| Other Abstract Info: |
DERABS G98-230172
DERG98-230172
|
| Other References: |
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.).
(7 pages)
Cited by 4 patents
M.A. Roytberg, "A Search For Common Patterns in Many Sequences", Computer Applications in the Biosciences, 8(i):57-64, 1992.
(8 pages)
Cited by 6 patents
[ISI abstract]
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.
(12 pages)
Cited by 35 patents
[ISI abstract]
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.
|
|
 Nominate this for the Gallery...
|
|
