Method and system for nested SQL functions for net.data on...

Details Method and system for nested SQL functions for net.data on... Method and system for nested SQL functions for net.data on...

2005-07-05

2005-07-05

Ali, Mohammad (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

06915293

ABSTRACT:
The present invention provides a system and method for providing nesting Structured Query Language (SQL) functions. The method includes: calling a first SQL function; processing a first result table for the first SQL function; determining that the first result able comprises a second SQL function; calling the second SQL function; processing a second result table of the second SQL function; returning a result for the second SQL function; resuming processing of the first result table; and returning a result for the first SQL function. The method and system allows a Net.Data™ system to call SQL functions from within a result table of another SQL function. The level of nesting is maintained for an array of SQL statement handles to ensure that the proper handles are used. In this manner, auxiliary tables are not required, simplifying the programming of Net.Data™ queries and decreasing memory overhead.

REFERENCES:
patent: 5724570 (1998-03-01), Zeller et al.
patent: 5822750 (1998-10-01), Jou et al.
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 6304873 (2001-10-01), Klein et al.
Ganski et al., “Optimization of Nested SQL Queries Revisited” 1987, PP 23-33m ACM Press, New York, NY.
Chiueh et al., “Cache memory design for Internet processors”, State Unive. of New York, Stony Brook, NY, USA, Jan.-Feb., 200 pp. 28-33, vol. 20, Issue: 1.
Kim, Won, “An Optimizing an SQL-like Nested Query,” ACM Transactions on Database Systems, vol. 7, No. 3, Sep. 1982, pp. 443-469.
Koymen, Kemal et al., “SQL*: A Recursive SQL,” Information Systems, vol. 18, 1993, No. 2, pp. 121-128.

Affiliated with

Also associated with

Rating

Method and system for nested SQL functions for net.data on... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for nested SQL functions for net.data on..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for nested SQL functions for net.data on... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3419294