Detection and prevention of writing conflicts within nested...

Details Detection and prevention of writing conflicts within nested... Detection and prevention of writing conflicts within nested...

2008-05-06

2008-05-06

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10413637

ABSTRACT:
Conflict checking for writing operations in an SQL database system is carried out for nested statements invoked by a parent statement. Each statement has an associated table access data structure defined at compile-time indicating the tables in the database that the statement accesses and the mode of access. At execution-time the table access data structure for each nested statement is accessed and the information is compared with a list of tables maintained for the parent statement to determine if there is a read/write or write/write conflict possible if the nested statement is executed. Where there is no conflict detected, the information from the table access data structure is copied to the list of tables.

REFERENCES:
patent: 5857182 (1999-01-01), DeMichiel et al.
patent: 5873075 (1999-02-01), Cochrane et al.
patent: 6003026 (1999-12-01), Bonzi
patent: 6055539 (2000-04-01), Singh et al.
patent: 6067542 (2000-05-01), Carino, Jr.
patent: 6081801 (2000-06-01), Cochrane et al.
patent: 6092062 (2000-07-01), Lohman et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6219660 (2001-04-01), Haderle et al.
patent: 6304873 (2001-10-01), Klein et al.
patent: 6304876 (2001-10-01), Isip, Jr.
patent: 6321235 (2001-11-01), Bird
patent: 2001/0016844 (2001-08-01), Isip, Jr.
patent: 2002/0023069 (2002-02-01), Blank et al.
Baru, C. K., Fecteau, G. and Malkemus, T. R. “On-Line Data Redistribution in a Shared-Nothing Parallel Database System,”IBM Technical Disclosure Bulletin, vol. 40, No. 1,Jan. 1997.
Bonneau, S. and Hameurlain, A. “Hybrid Simultaneous Scheduling and Mapping in SQL Multi-Query Parallelization,” Database and Expert Systems Applications, 10 Intl. Conf., DEXA '99,Lecture Notes in Computer Science, vol. 1677, pp. 88-99., Abstract only.
Lee, Seung-Hoon, Jang, Gi-Hwa, Lee, Su-Hyun, Jung, Sung-Hwan. A Content-Based Image Retrieval System Using Extended SQL in RDBMS,Proceedings of ICICS, Intl. Conf. on Information, Communications and Signal Processing, vol. 2, pp. 1069-1072, Abstract only.
Hameurlain, A. and Morvan, F. Scheduling and Mapping for Parallel Execution of Extended SQL Queries,Proceedings of the 1995 ACM CIKM Int. Conf. on Information and Knowledge Management, pp. 197-204, Abstract only.

Affiliated with

Also associated with

Rating

Detection and prevention of writing conflicts within nested... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Detection and prevention of writing conflicts within nested..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Detection and prevention of writing conflicts within nested... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3950254