-
公开(公告)号：CA2322603C
公开(公告)日：2005-04-12
申请号：CA2322603
申请日：2000-10-06
Applicant: IBM CANADA
Inventor： HURAS MATTHEW A , WINER MICHAEL J , GORALWALLA IQBAL A , SHARPE DAVID C
Abstract: An optimization for updatable scrollable cursors in database systems. To ensure that a temporary copy of a data record matches the data record maintained in the database, th e temporary copy is associated with a timestamp included on each page storing the data records o f the database. The timestamp on a page in the database is updated whenever any record stored on the page is updated. The optimization compares the timestamp stored with the temporary record wit h the current timestamp associated with the page on which the data record is stored in the database. If the two timestamps are matching then the temporary record is identical to the databa se table record and there is no need to carry out a comparison of the attribute values of the temporar y record with the record in the database table.
-
公开(公告)号：CA2307155A1
公开(公告)日：2001-10-28
申请号：CA2307155
申请日：2000-04-28
Applicant: IBM CANADA
Inventor： MCKNIGHT KATHY A , HUFFMAN PAUL C , ZILIO DANIEL C , SHARPE DAVID C
Abstract: A query processing system has a query processor and a data manager. The quer y processor calls the data manager to carry out data access for a query including a filtering operation, The date manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Whe re the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.
-
Patent Agency Ranking
公开(公告)号：CA2306946C
公开(公告)日：2005-09-20
申请号：CA2306946
申请日：2000-04-28
Applicant: IBM CANADA
Inventor： FINLAY IAN R , LOHMAN GUY M , SHARPE DAVID C , LINDSAY BRUCE G , ZILIO DANIEL C
IPC: G06F17/30
Abstract: A query processing system having a data manager, and a query manager also includes a buffer. The query manager calls the data manager to access data based on a query. Where there is no predicate check or consumption operation on the record accessed, the data manager will notionally return the record to the query manager. However, the data manager accomplishes the retu rn by writing the relevant portions of the record to a buffer. The data manager maintains stabilization of the page containing the record while the buffer is being written to. The data manager continues to access records on the stabilized page and to write such records to the buffer where appropriate. The query manager retrieves the records from the buffer after the data manager has completed its operation resulting from the query manager call.
-
公开(公告)号：CA2390849A1
公开(公告)日：2003-12-18
申请号：CA2390849
申请日：2002-06-18
Applicant: IBM CANADA
Inventor： SHARPE DAVID C , FLASZA MIROSLAW A
Abstract: A method for comparing data, and in particular character data, is disclosed. Two pieces of data are compared to determine if they are within an equivalence class based on using a dictionary sort order table with a non-unique collating sequence. If so, the pieces of data are compared using a dictionary sort order table with a uniqu e collating sequence. The comparison method may be implemented within a sorting module that receives an input data set and then uses the comparison to compare two piece s of data in the input data set at a time. The sorting module uses the result of the comparison method to sort the input data set into equivalence classes. The results of a second comparison provides data sorted within equivalence classes. The sorting modu le may provide sorting services to a database management system or to a calling program.
-
公开(公告)号：CA2306946A1
公开(公告)日：2001-10-28
申请号：CA2306946
申请日：2000-04-28
Applicant: IBM CANADA
Inventor： ZILIO DANIEL C , FINLAY IAN R , LOHMAN GUY M , SHARPE DAVID C , LINDSAY BRUCE G
IPC: G06F17/30
Abstract: A query processing system having a data manager, and a query manager also includes a buffer. The query manager calls the data manager to access data based on a query. Where there is no predicate check or consumption operation on the record accessed, the data manager will notionally return the record to the query manager. However, the data manager accomplishes the retu rn by writing the relevant portions of the record to a buffer. The data manager maintains stabilization of the page containing the record while the buffer is being written to. The data manager continues to access records on the stabilized page and to write such records to the buffer where appropriate. The query manager retrieves the records from the buffer after the data manager has completed its operation resulting from the query manager call.
-
公开(公告)号：CA2359277A1
公开(公告)日：2003-04-18
申请号：CA2359277
申请日：2001-10-18
Applicant: IBM CANADA
Inventor： IGORALWALLA IQBAL A , SHARPE DAVID C , O'CONNELL WILLIAM T
IPC: G06F17/30
Abstract: The present invention provides a system and a method for materializing recor ds in a result set in response to a query. The computer system comprises a server and a client. The server has a database and a database management system for providing access to the database. The client is operatively coupled to the database management system. The client is adapted to provide a query to the database management system and the database management system is adapted to materialize a number of records in a result set in response to the query. The number of materialized records is selected to reduce inefficient materialization of records from the database in response to the query.
-
公开(公告)号：CA2322603A1
公开(公告)日：2002-04-06
申请号：CA2322603
申请日：2000-10-06
Applicant: IBM CANADA
Inventor： GORALWALLA IQBAL A , WINER MICHAEL J , SHARPE DAVID C , HURAS MATTHEW A
Abstract: An optimization for updatable scrollable cursors in database systems. To ensure that a temporary copy of a data record matches the data record maintained in the database, th e temporary copy is associated with a timestamp included on each page storing the data records o f the database. The timestamp on a page in the database is updated whenever any record stored on the page is updated. The optimization compares the timestamp stored with the temporary record wit h the current timestamp associated with the page on which the data record is stored in the database. If the two timestamps are matching then the temporary record is identical to the databa se table record and there is no need to carry out a comparison of the attribute values of the temporar y record with the record in the database table.
-
-
-
-
-
-
Search Results
7
records
(took 0.02 seconds)
