Dynamic and scalable parallel processing of sequence operations

Details Dynamic and scalable parallel processing of sequence operations Dynamic and scalable parallel processing of sequence operations

2006-08-08

2006-08-08

Bataille, Pierre (Department: 2186)

Electrical computers and digital processing systems: memory

Storage accessing and control

Specific memory composition

Reexamination Certificate

active

07089356

ABSTRACT:
A method is described for parallel processing of sequence operations, in which contention for the sequence operation is reduced among multiple parallel processes. Contention is reduced by caching sequence values locally for each parallel process. Each process accesses the sequence operation, or an instance level cache of sequence values, in a batched manner, thereby returning a block of unique sequence values instead of a single sequence value. The block of sequence values, or at least information that indicates a range of sequence values that define the block, is then cached locally in association with a given process of the multiple processes. Hence, future requests for sequence values from the given process are serviced from the local cache, rather than having to access the sequence operation and risk contention for the operation with other processes.

REFERENCES:
patent: 5742806 (1998-04-01), Reiner et al.
patent: 5802563 (1998-09-01), Hagersten et al.
patent: 5943685 (1999-08-01), Arimilli et al.
patent: 6301258 (2001-10-01), Katseff et al.
Jim Grey, et al., Quicky Generating Billion-Record Synthetic Databases, ACM SIGMOD May 1994, pp. 243-252.
Oracle, “Oracle9iSQL Reference, Release 2 (9.2), Part No. A96540-01, SQL Statements: Create Library to Create SPFILE, 15 of 16,” 2002, 5 pages.
Oracle, “Oracle9iSQL Reference, Release 2 (9.2), Part No. A96540-01, Basic Elements of Oracle SQL, 6 of 10,” 2002, 7 pages.
Oracle, “Oracle7 Parallel Server Concepts and Administrator's Guide, Oracle Database Architecture for the Parallel Server,” 1996, 9 pages.
Oracle, “Oracle7 Parallel Server Concepts and Administrator's Guide, Overview of Locking Mechanisms,” 1996, 11 pages.

Affiliated with

Also associated with

Rating

Dynamic and scalable parallel processing of sequence operations does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Dynamic and scalable parallel processing of sequence operations, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic and scalable parallel processing of sequence operations will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3714723