Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-02-15
2005-02-15
Le, Uyen (Department: 2171)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06856996
ABSTRACT:
Provided is a method, system, and program for accessing rows of data from a base table satisfying a search criteria. An initial request to access rows in the base table is received, including the search criteria specifying predicates for one or more columns in the base table. A data structure is generated to include information on qualifying base table rows that satisfy the search criteria. Notification is provided that the qualifying base table rows are accessible before information on all the qualifying base table rows is included in the data structure. A request is then received for one qualifying base table row. A determination is made as to whether the data structure includes information on the requested qualifying base table row. If so, the information in the data structure is used to provide access to the requested qualifying base table row.
REFERENCES:
patent: 4190835 (1980-02-01), Buynak
patent: 4221003 (1980-09-01), Chang et al.
patent: 4434475 (1984-02-01), McCaskill et al.
patent: 5097408 (1992-03-01), Huber
patent: 5241648 (1993-08-01), Cheng et al.
patent: 5276870 (1994-01-01), Shan et al.
patent: 5396623 (1995-03-01), McCall et al.
patent: 5410693 (1995-04-01), Yu et al.
patent: 5412805 (1995-05-01), Jordan, II et al.
patent: 5446858 (1995-08-01), Copeland et al.
patent: 5450581 (1995-09-01), Bergen et al.
patent: 5546576 (1996-08-01), Cochrane et al.
patent: 5579515 (1996-11-01), Hintz et al.
patent: 5581275 (1996-12-01), Glei et al.
patent: 5590319 (1996-12-01), Cohen et al.
patent: 5724575 (1998-03-01), Hoover et al.
patent: 5739817 (1998-04-01), Glei et al.
patent: 5742806 (1998-04-01), Reiner et al.
patent: 5758357 (1998-05-01), Barry et al.
patent: 5819268 (1998-10-01), Hackett
patent: 5887274 (1999-03-01), Barry et al.
patent: 5930795 (1999-07-01), Chen et al.
patent: 5963936 (1999-10-01), Cochrane et al.
patent: 5974407 (1999-10-01), Sacks
patent: 5987472 (1999-11-01), Serafin
patent: 6092062 (2000-07-01), Lohman et al.
patent: 6212514 (2001-04-01), Eberhard et al.
patent: 6223420 (2001-05-01), Lee et al.
patent: 6523040 (2003-02-01), Lo et al.
patent: 6665678 (2003-12-01), Ching Chen et al.
patent: 20020026524 (2002-02-01), Dharap
patent: 20020029212 (2002-03-01), Chen et al.
patent: 63071741 (1988-04-01), None
patent: 1009546 (1989-01-01), None
patent: 5225250 (1993-09-01), None
patent: WO 9857279 (1998-12-01), None
patent: WO 9927679 (1999-06-01), None
Terry et al, “Continuous queries over append-only databases”, ACM 1992, pp. 321-330.*
U.S. patent application Ser. No. 09/656,558, filed on Sep. 7, 2000, entitled, “Method, System And Program For Implementing Scrollable Cursors In A Database”, invented by MA Bernal, et al.
Preliminary Amendment submitted in application Ser. No. 09/915,869, filed on Jul. 26, 2001.
Preliminary Amendment submitted in application Ser. No. 09/915,866, filed on Jul. 26, 2001.
Preliminary Amendment submitted in application Ser. No. 09/915,868, filed on Jul. 26, 2001.
Preliminary Amendment submitted in application Ser. No. 09/915,783, filed on Jul. 26, 2001.
Preliminary Amendment submitted in application Ser. No. 09/915,867, filed on Jul. 26, 2001.
U.S. patent application Ser. No. 09/365,953, filed on Aug. 8, 1999, entitled, “Automatic Pruning For Log-Based Replication”, invented by IT Ieong and PL Shimer.
U.S. patent application Ser. No. 09/325,661, filed on Jun. 2, 1999, Prov filed Oct. 8, 1998, entitled, “Database Extender For Storing, Querying, and Retrieving Structured Documents”, invented by DT Chang; JH Chow; J Xu; and JM Cheng.
U.S. patent application Ser. No. 09/324,499, filed on Jun. 2, 1999, Prov filed Oct. 8, 1998, entitled, “Method and Apparatus For Indexing Structured Documents With Rich Data Types”, invented by YC Fuh; JH Chow; J Xu; and JM Cheng.
U.S. patent application Ser. No. 09/324,827, filed on Jun. 2, 1999, Prov filed Oct. 8, 1998, entitled, “Method and Apparatus For Querying Structured Documents Using A Database Extender”, invented by JH Chow; J Xu; and JM Cheng.
U.S. patent application Ser. No. 09/466,862, filed on Dec. 17, 1999, entitled, “Support For Summary Tables In A Heterogeneous Database Environment”, invented by RJ Cochrane; JC Kleewein; TY Leung; MH Pirahesh; N. Subramanian; and S. Venkataraman.
IBM, Corp., “New Options for FETCH in SQL”, Technical Disclosure Bulletin, vol. 36, No. 06A, Jun. 1993, pp. 559-560.
IBM, Corp., “Dynamic Ordering of Joined Rows using Fields from MultipleTables”, Technical Disclosure Bulletin, vol. 36, No. 11, Nov. 1993, pp. 363-366.
IBM, Corp., “Orderable, Updatable, Scrollabel Structured Query Language Cursors”, Technical Disclosure Bulletin, vol. 38, No. 07, Jul. 1995, pp. 393-394.
IBM, Corp., “Updateable Scrollable Cursors”, Technical Disclosure Bulletin, vol. 36, No. 04, Apr. 1993, pp. 263-268.
IBM, Corp., “Technique to Allow DB2 Utilities and Commands to Run While SQL Applications have a Table Space Locked”, Technical Disclosure Bulletin, vol. 36, No. 09A, Sep. 1993, pp. 499-502.
IBM, Corp., “Administration Guide: Performance” Version 6 from IBM DB2 Universal Database, Reference SC09-2840-00, 1999, pp. 219-226.
Microsoft Corp., “Forward-only Cursors” [online], 2000, pp. 1. [Retrieved on Jun. 24, 2000]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/psdk/sq1/8_con_07_10.htm>.
Microsoft Corp., “Types of Cursors” [online], 2000, pp. 1-3. [Retrieved on Jun. 24, 2000]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/partbook/vb6/typesofcursors.htm.>.
Microsoft Corp., “Controlling Cursor Behavior” [online], 2000, pp. 1. [Retrieved on Jun. 24, 2000]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/psdk/sq1/8_con_07_8.htm.>.
Microsoft Corp., “MDAC 2.5 SDK-ODBC Programmer's Reference Chapter 3: ODBC Architecture” [online], 2000, pp. 1-2. [Retrieved on Jun. 24, 2000] Retrieved from the Internet at <URL:http://msdn.microsoft.com/library/psdk/dasdk/odch6gh1.htm.>.
Microsoft Corp., “MDAC 2.5 SDK-ODBC Programmer's Reference Chapter 17: Programming Considerations” [online], 2000, pp. 1-6. [Retrieved on Jun. 24, 2000] Retrieved from the Internet at <URL:http://msdn.microsoft.com/library/psdk/dasdk/odch8goj.htm.>.
Microsoft Corp., “Dynamic Cursors” [online], 2000, pp. 1. [Retrieved on Jun. 24, 2000]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/psdk/sq1/8_con_07_14.htm>.
Microsoft Corp., “Static Cursors” [online], 2000, pp. 1. [Retrieved on Jun. 24, 2000]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/psdk/sq1/8 con 07 12.htm>.
Microsoft Corp., “Cursor Types” [online], 2000, pp. 1. [Retrieved on Jun. 24, 2000]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/psdk/sq1/8_con_07_0.htm>.
Microsoft Corp., “What the Heck is a Cursor, Anyway?” [online], 2000, pp. 1-3. [Retrieved on Jun. 24, 2000]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/partbook/vb6/whatheckiscursoranyway.htm.>.
Microsoft Corp., “Fetching and Scrolling” [online], 2000, pp. 1-2. [Retrieved on Jun. 24, 2000]. Retrieved on the Internet at <URL: http://msdn.microsoft.com/library/psdk/sq1/8_con_07_7.htm>.
Microsoft Corp., “Changing Rows with Positioned Operations” [online], 2000, pp. 1-2. [Retrieved Jun. 24, 2000]. Retrieved from the Internet at <URL: http://msdn.microsoft.com/library/psdk/sq1/8_con_07_22.htm>.
Microsoft Corp., “Cursors” [online], 2000, pp. 1. [Retrieved on Jun. 24, 2000]. Retrieved on the Internet at <URL: http://msdn.microsoft.com/library/psdk/sq1/8_con_07.htm>.
Microsoft Corp., “Cursor Locking” [online], 2000, pp. 1. [Retrieved on Jun. 24, 2000]. Retrieved on
Chow Jyh-Herng
Leung Ting Yu
Pham Thanh Tan
Konrad Raynes & Victor LLP
Le Uyen
Victor David W.
LandOfFree
Method, system, and program for accessing rows in one or... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method, system, and program for accessing rows in one or..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and program for accessing rows in one or... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3477215