Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-11-28
2006-11-28
Corrielus, Jean M. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07143108
ABSTRACT:
An apparatus and method for deleting objects from an object-relational system in a customizable and database independent manner. The apparatus and method provide a customizable and database independent mechanism for the deletion of object data from a relational database. The method implemented by the apparatus determines the dependency structure of a relational database using database metadata. The dependency structure is then utilized to determine the type of deletion to be performed on data representations of the object and its related objects, i.e., parent or child objects. The deletion actions include cascade deletion and nullify columns deletion. Appropriate SQL statements are then automatically generated at run-time to perform the deletion of the object data from the relational database.
REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4947320 (1990-08-01), Crus et al.
patent: 5185885 (1993-02-01), Dysart et al.
patent: 5226158 (1993-07-01), Horn et al.
patent: 5291583 (1994-03-01), Bapat
patent: 5412774 (1995-05-01), Agrawal et al.
patent: 5706506 (1998-01-01), Jensen et al.
patent: 5717924 (1998-02-01), Kawai
patent: 5832268 (1998-11-01), Anderson et al.
patent: 5832498 (1998-11-01), Exertier
patent: 5878411 (1999-03-01), Burroughs et al.
patent: 5930795 (1999-07-01), Chen et al.
patent: 6047284 (2000-04-01), Owens et al.
patent: 6061692 (2000-05-01), Thomas et al.
patent: 6163776 (2000-12-01), Periwal
patent: 6199195 (2001-03-01), Goodwin et al.
patent: 6327628 (2001-12-01), Anuff et al.
patent: 6374252 (2002-04-01), Althoff et al.
patent: 6374256 (2002-04-01), Ng et al.
patent: 6385618 (2002-05-01), Ng et al.
patent: 6418448 (2002-07-01), Sarkar
patent: 6456995 (2002-09-01), Salo et al.
patent: 2003/0009431 (2003-01-01), Souder et al.
patent: 2003/0204514 (2003-10-01), Owens et al.
patent: 2004/0098406 (2004-05-01), Roddy
patent: 2005/0076094 (2005-04-01), Sasaki et al.
“Fundamentals of Database Systems—Third Edition” Elmasri and Navathe, copyright 1997 (pp. 209-211 and pp. 734-739).
Text Book: Funamentals of Database System (Third Edition) of Ramez Elmasri and Shamkant B. Navathe from Addition-Wisley.
Generic Dynamic SQL Application Programming Interface Set; Hidalgo; International Business Machines Technical Disclosure Bulletin; V. 36, No. 8, pp. 573-578.
Core Java 2 vol. II—Advanced Features; Horstmann et al., pp. 203-253; 2000.
Corrielus Jean M.
LaBow Jeffrey S.
Lammes Francis
Ly Anh
Yee Duke W.
LandOfFree
Apparatus and method for deletion of objects from an... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Apparatus and method for deletion of objects from an..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for deletion of objects from an... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3652776