Grouping database queries and/or transactions

Details Grouping database queries and/or transactions Grouping database queries and/or transactions

2003-10-27

2010-10-12

Stace, Brent (Department: 2161)

Data processing: database and file management or data structures

Data integrity

Transactional processing

C707S687000, C707S713000

Reexamination Certificate

active

07814080

ABSTRACT:
A method and apparatus identifies SQL statements in a first transaction that specify modification operations that are commutative and associative. The SQL statements are combined into one SQL statement, and the one SQL statement is submitted to a database system. Optionally, or alternatively, multiple transactions can be grouped together into one transaction.

REFERENCES:
patent: 5367675 (1994-11-01), Cheng et al.
patent: 6714938 (2004-03-01), Avadhanam et al.
patent: 6745180 (2004-06-01), Yamanoue
patent: 6829600 (2004-12-01), Gu et al.
Walter, Bernd, Nested Transactions with Muliple Commit Points: An Approach to the Structuring of Advanced Database Applications, Aug. 1984, Tenth Intl. Conf. VLDB.
Glosser, Cisele, Lesson on Order of Operations With Exponents, Aug. 2000, MathGoodies.
Motyka, Mark, Introduction to Algebra, Mar. 2001, MathLeague.
Dayal, Umeshwar, of Nests and Trees: A Unified Approach to Processing Queries that Contain Nested Subqueries, Aggregates, and Quantifiers, 1987, 13thIntl. Conf. VLDB.
A. Reuter, “Concurrency on High-Traffic Data Elements,” ACM 0-89791-070-2/82/003/0083, pp. 83-92 (1982).
H.F. Korth, “Locking Primitives in a Database System,” Journal of the Association for Computing Machinery, vol. 30, No. 1, pp. 55-79 (Jan. 1983).
D. Gawlick, “Prcessing Hot Spots in High Performance Systems,” IEEE, pp. 249-251 (1985).
P. O'Neil, “The Escrow Transactional Method,” ACM Transactions on Database Systems, vol. 11, No. 4, pp. 405-430 (Dec. 1986).
C. Mohan et al., “Solutions to Hot Spot Problems in a Shared Disks Transaction Environment,” Computer Science, pp. 1-21 (1991).
U.S. Appl. No. 10/121,191, filed Apr. 12, 2002.

Affiliated with

Also associated with

Rating

Grouping database queries and/or transactions does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Grouping database queries and/or transactions, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Grouping database queries and/or transactions will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4160021