Invention Grant
- Patent Title: Encoding data to be sorted
-
Application No.: US12506126Application Date: 2009-07-20
-
Publication No.: US08825674B2Publication Date: 2014-09-02
- Inventor: Mark D. Callaghan , Dmitry M. Potapov
- Applicant: Mark D. Callaghan , Dmitry M. Potapov
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong Becker Bingham Wong LLP
- Agent Adam C. Stone
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
Key conditioning involves the construction of a byte orderable array from values for a possibly multi-field key concatenated key, for comparison by a sort routine. Byte-orderable sort keys are conditioned prior to execution of a sort routine, to facilitate an accurate and/or efficient sort procedure. Key conditioning may be applied to values in one or more columns of a database table, where the column(s) are used as keys for sorting rows of the table. Six factors are considered in encoding the byte array, such as whether nulls compare high or low; whether a field is fixed width or variable width; whether a field is guaranteed to be not null; whether a field is ordered ascending or descending; whether a field is the last field of a multi-field sort key or the only field of a sort key; and whether a field is likely to contain a significant number of zero values.
Public/Granted literature
- US20090282040A1 ENCODING DATA TO BE SORTED Public/Granted day:2009-11-12
Information query