发明名称 METHOD AND SYSTEM FOR CONDUCTING REVERSE INDEX SCANS
摘要 A method executed by a data processor for scanning a reverse range. The scan is conducted in an index for a table having an upper end and a lower end. The reverse ran ge has a start key value for defining the reverse range, and the index has a set of keys representing a set of records and record attributes in the table. Each key in the set of keys has a RID designating a record in the table and a key value corresponding to an attribute of the record in the table. The method includes the steps of searching the index for a start key, selecting an upper bound of the reverse range, and, if the upper bound is the first key in the index, indicating that the index does not contain any key value within the reverse range, or, if the upper bound is not the first key in the index, then fetching each key below the upper bound in the index.
申请公布号 CA2279092(A1) 申请公布日期 2001.01.29
申请号 CA19992279092 申请日期 1999.07.29
申请人 IBM CANADA LIMITED-IBM CANADA LIMITEE 发明人 MCARTHUR, CATHERINE S.;CRANSTON, LESLIE A.;HURAS, MATTHEW
分类号 G06F17/30;(IPC1-7):G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项
地址