Package resolution mechanism for database systems

Details Package resolution mechanism for database systems Package resolution mechanism for database systems

2011-03-01

2011-03-01

Morrison, Jay A (Department: 2168)

Data processing: database and file management or data structures

Data integrity

Triggers, stored procedures, user defined function

C707S758000, C707S769000

Reexamination Certificate

active

07899797

ABSTRACT:
A method and system for providing package resolution in a database system is disclosed. The method and system comprise providing a statement within a server which allows an application to identify a list of package collections. The method and system further includes executing the statement to obtain the appropriate package. A system and method in accordance with the present invention provides a new current package path value, which is set via a statement referred to as Set Current Package Path. The SET CURRENT PACKAGE PATH statement allows the application to supply a precedence list of qualified package collections during execution time, therefore the scheme for resolving packages can be changed at any point during execution. The SET CURRENT PACKAGE PATH statement improves application development by making the package resolution mechanism less error prone and less tedious for the application developer, while providing an optimal-performance solution in the client-server environment.

REFERENCES:
patent: 6317880 (2001-11-01), Chamberlain et al.
patent: 6321235 (2001-11-01), Bird
patent: 6353833 (2002-03-01), Bird et al.
patent: 6510439 (2003-01-01), Rangarajan et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 2001/0049682 (2001-12-01), Vincent et al.
patent: 2002/0123978 (2002-09-01), Bird et al.
patent: 2003/0055820 (2003-03-01), Aigen
patent: 2003/0060913 (2003-03-01), Turner et al.
patent: 2003/0074360 (2003-04-01), Chen et al.
IBM TDB/RD: Article 456145, “Conservative binding semantics for SQL objects and static DMI statements in packages handling for the newly introduced execute privilege of a routine”, (Apr. 2002); 2 pp.
Link, J. et al., “DB2-805 SQL Analysis and Resolution”, (Nov. 1, 1999); pp. 1-22.

Affiliated with

Also associated with

Rating

Package resolution mechanism for database systems does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Package resolution mechanism for database systems, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Package resolution mechanism for database systems will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2737606