Pipelining operations involving DML and query

Details Pipelining operations involving DML and query Pipelining operations involving DML and query

2011-08-02

2011-08-02

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S803000, C707S809000

Reexamination Certificate

active

07991794

ABSTRACT:
Techniques are described herein for supporting pipelining operations involving DML (Data manipulation Language) and query. In an embodiment, a DML operation is performed for the purpose of changing data in a database system from a first state to a second state. Before the data in the database system is changed by the DML operation, the DML operation has an in-memory representation of such data. In an embodiment, a subsequent query operation that logically depends on the data in the database system in the second state is granted access to the in-memory representation of such data in the second state before the data in the database system is changed by the DML operation to the second state. As a result, operations may be executed in a pipelined fashion with minimum blocking.

REFERENCES:
patent: 5619713 (1997-04-01), Baum et al.
patent: 5832475 (1998-11-01), Agrawal et al.
patent: 5832498 (1998-11-01), Exertier
patent: 5903887 (1999-05-01), Kleewein et al.
patent: 6092082 (2000-07-01), Maruyama
patent: 6167405 (2000-12-01), Rosensteel et al.
patent: 6169794 (2001-01-01), Oshimi et al.
patent: 6282533 (2001-08-01), Ramaswamy et al.
patent: 6341281 (2002-01-01), MacNicol et al.
patent: 6356891 (2002-03-01), Agrawal et al.
patent: 6493727 (2002-12-01), Huang et al.
patent: 6684215 (2004-01-01), Saracco
patent: 6721742 (2004-04-01), Uceda-Sosa et al.
patent: 6772165 (2004-08-01), O'Carroll
patent: 6879984 (2005-04-01), Duddleson et al.
patent: 6895471 (2005-05-01), Tse et al.
patent: 6917933 (2005-07-01), Craig et al.
patent: 7062481 (2006-06-01), Pham et al.
patent: 7469256 (2008-12-01), Manolov et al.
patent: 2002/0059299 (2002-05-01), Spaey
patent: 2003/0061244 (2003-03-01), Hirohata
patent: 2003/0065477 (2003-04-01), Opdyke
patent: 2004/0148308 (2004-07-01), Rajan et al.
patent: 2004/0199535 (2004-10-01), Zuk
patent: 2004/0249870 (2004-12-01), Jeevanjee et al.
patent: 2005/0076046 (2005-04-01), Goldsack
patent: 2005/0154696 (2005-07-01), Gutsche
Barclay et al., “Loading Databases Using Dataflow Parallelism”, 1994, 16 pages.
Lehner et al., “Fast Refresh Using Mass Query Optimization”, 2001 IEEE, IBM, 8 pages.
Wilkinson et al., “Parallel Programming”, Prentice Hall, 1999, 20 pages.

Affiliated with

Also associated with

Rating

Pipelining operations involving DML and query does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Pipelining operations involving DML and query, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Pipelining operations involving DML and query will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2774774