Efficient collation element structure for handling large numbers of characters

Inactive Publication Date: 2005-04-05
ORACLE INT CORP
View PDF6 Cites 170 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

One embodiment of the present invention provides a system for facilitating use of a collation element that supports a large number of characters. The system operates by receiving the collation element and reading a primary weight value from a primary weight field within the collation element. If the primary weight value falls within a reserved set of values, the system reads

Problems solved by technology

One challenge in developing a database system is to support sorting for different languages.
Unfortunately, there can be thousands of different characters in a multilingual sort, and this causes the data structures involved in performing the multilingual sort to consume a lot of memory.
Moreover, it can be hard to compact these data structures without degrading performance.
However, increa

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Efficient collation element structure for handling large numbers of characters
  • Efficient collation element structure for handling large numbers of characters
  • Efficient collation element structure for handling large numbers of characters

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

The following description is presented to enable any person skilled in the art to make and use the invention, and is provided in the context of a particular application and its requirements. Various modifications to the disclosed embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be applied to other embodiments and applications without departing from the spirit and scope of the present invention. Thus, the present invention is not intended to be limited to the embodiments shown, but is to be accorded the widest scope consistent with the principles and features disclosed herein.

The data structures and code described in this detailed description are typically stored on a computer readable storage medium, which may be any device or medium that can store code and / or data for use by a computer system. This includes, but is not limited to, magnetic and optical storage devices such as disk drives, magnetic tape, CDs (compact disc...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

One embodiment of the present invention provides a system for facilitating use of a collation element that supports a large number of characters. The system operates by receiving the collation element and reading a primary weight value from a primary weight field within the collation element. If the primary weight value falls within a reserved set of values, the system reads an additional portion of the primary weight value from both a secondary weight field and a tertiary weight field within the collation element. On the other hand, if the primary weight value is not within the reserved set of values, the system reads a secondary weight value from the secondary weight field, and also reads a tertiary weight value from the tertiary weight field.

Description

BACKGROUND1. Field of the InventionThe present invention relates to the process of indexing and sorting data within a database system. More specifically, the present invention relates to a method and an apparatus for providing an efficient collation element structure for encoding sorting weights for a large number of characters.2. Related ArtOne challenge in developing a database system is to support sorting for different languages. For example, some databases allow Japanese customers to specify the sorting method as “Japanese”, while French customers specify the sorting method as “French”. However, with the worldwide deployment of Internet technologies, it is becoming increasingly important for companies to provide multi-lingual capabilities in their software in order to expand their businesses globally.As the data that is stored in databases becomes increasingly more multilingual, database users are increasingly more interested in using a single sort whose order is good for most l...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/22G06F17/30G06F7/00G06F7/24G06F7/22G06F7/02
CPCG06F7/02G06F7/24Y10S707/99937Y10S707/99934G06F2207/025
Inventor HO, CHING-LANYANG, JIANPING
Owner ORACLE INT CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap