SQL language extensions for modifying collection-valued and...

Details SQL language extensions for modifying collection-valued and... SQL language extensions for modifying collection-valued and...

2003-10-24

2008-10-07

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07433886

ABSTRACT:
A system and method for updating collection-valued and other complex structured columns in a nested table using a nested extension of an UPDATE statement that is analogous to the syntax and semantics of the UPDATE statement that is used to modify scalar-valued columns of the table (called the outer UPDATE). Using the same syntactic and semantic constructs as the table at the outer level allows an existing implementation that processes modifications to relational tables to reuse its implementation techniques for processing outer updates to modify collection-valued columns as well. The UPDATE extensions enable the specification of updates to nested collections embedded at arbitrary levels of depth in the object model. The new syntax is embedded inside the outer UPDATE statement in a way that parallels the structure of the data itself and thus maps more directly to the user's conceptual model of the data.

REFERENCES:
patent: 5412804 (1995-05-01), Krishna
patent: 6016497 (2000-01-01), Suver
patent: 6122644 (2000-09-01), Graefe et al.
patent: 6460043 (2002-10-01), Tabbara et al.
patent: 6484179 (2002-11-01), Roccaforte
patent: 6493708 (2002-12-01), Ziauddin et al.
patent: 6564203 (2003-05-01), Krishnaprasad et al.
patent: 6636870 (2003-10-01), Roccaforte
patent: 6892204 (2005-05-01), Haas et al.
patent: 2004/0073565 (2004-04-01), Kaufman et al.

Affiliated with

Also associated with

Rating

SQL language extensions for modifying collection-valued and... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with SQL language extensions for modifying collection-valued and..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and SQL language extensions for modifying collection-valued and... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3988007