Browse > Article

A New Korean Search Pattern of the Operator LIKE  

Park, Sung-Chul (경북대학교 전자전기컴퓨터)
Roh, Eun-Hyang (한국신발피혁연구소 생산시스템연구팀)
Park, Young-Chul (경북대학교 전자전기컴퓨터)
Park, Jong-Cheol ((주)퓨전소프트 R&D3그룹)
Publication Information
Journal of KIISE:Databases / v.34, no.3, 2007 , pp. 244-260 More about this Journal
Abstract
The operator LIKE of the database language SQL is a string pattern search operator. By providing the string pattern, the operator can identify column values that match with the string pattern. As a phonetic symbol, each Korean syllable is composed either of a leading sound and a medial sound or of a leading sound, a medial sound, and a trailing sound. As a search pattern of Korean syllables of the operator LIKE, in addition to the traditional Korean search pattern, this paper proposes a new search pattern that is based on leading sounds and medial sounds of Korean. With the new Korean search pattern, Korean syllables having specific leading sounds, specific medial sounds, or both specific leading sounds and medial sounds can be found. Formulating predicates equivalent with the new Korean search pattern by way of existing SQL operators is cumbersome and might cause the portability problem of applications depending on the underlying character set of the DBMS. This paper presents algorithms for the execution of the operator LIKE considering the new Korean search pattern based on the characters that are represented in KS X 1001, which is a Korean standard code for information interchange of Korean and Chinese.
Keywords
SQL; LIKE; string pattern; KS X 1001; Korean;
Citations & Related Records
연도 인용수 순위
  • Reference
1 S. Poon, M. Sud, R. Chong, Understanding DB2 Universal Database character conversion, http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0506chong/, IBM, 2005
2 S. Law, Globalization Support Oracle Unicode database support. An Oracle White Paper, Oracle Corporation, 2001
3 M. Kaplan, International Features in Microsoft SQL Server 2000, http://msdn.microsoft.com/library/default.asp?url=/library/en- us/dnsql2k/html/intlfeaturesinsqlserver2000.asp, 2001
4 The Unicode Consortium, Unicode 4.0 Special Areas and Format Characters, http://www.unicode.org/versions/Unicode4.0.0/ch15.pdf
5 The Unicode Consortium, Unicode 4.0 Conformance, http://www.unicode.org/versions/Unicode4.0.0/ch03.pdf
6 http://www.celldb.co.kr
7 S. C. Park, E. H. Lo, J. C. Park, Y. C. Park, 'A Korean Search Pattern in the LIKE Operation,' Proc. of the 9th International Conference on Enterprise Information Systems, June 2007(to be appeared)
8 Microsoft, LIKE (Transact-SQL), http://msdn2.microsoft.com/en-us/library/ms179859.aspx, 2006
9 Y. C. Park, J. H. Cho, G. J. Cha, and P. Scheuermann, 'Efficient Schemes of Executing Star Operators in XPath Query Expressions,' Proc. of the 11th International Conference on DASFAA, pp. 264-278, April 2006   DOI   ScienceOn
10 박준현, 박영철, 이진수, 'B+-트리에서 키와 구분자의 저장과 탐색', 한국정보과학회 논문지(C), 제3권 제6호, pp. 568-580, 1997
11 S. H. Kim, M. S. Jung, J. H. Park, and Y. C. Park, 'A Design and Implementation of Savepoints and Partial Rollbacks considering Transaction Isolation Levels of SQL2,' Proc. of the 6th International Conference on DASFAA, pp. 303-312, April 1999   DOI
12 Y. C. Park, M. H. Cha, and J. H. Park, 'An Efficient Scheme of Deleting All Records in a Table,' Proc. of the 7th World Multiconference on Systemics, Cybernetics and Informatics, pp 203-208, 2003
13 노은향, LIKE 연산에서 한글 탐색 양식[석사학위 논문], 경북대학교, 2006
14 J. Melton, A. R. Simon, Understanding the new SQL: A complete guide, Morgan Kaufmann Publishers, Inc., San Mateo, California, 1993
15 Korean Standards Information Center, Code for information interchange (Hangul and Hanja), Standard No. KS X 1001, 2002
16 The Unicode, http://www.unicode.org
17 김경석, 컴퓨터 속의 한글 이야기 ？ 둘째 보따리 ？ , 부산대학교 출판부, 1999
18 Korean Standards Information Center, Keyboard layout for information processing, Standard No. KS X 5002, 1982
19 조관현, 한글 두음 문자열 검색 방법 및 장치 (METHOD AND APPARATUS FOR SEARCHING THE INITIAL SOUND STRING KOREAN CHARACTER), 대한민국 특허 등록 번호 10-02850119, 등록일자 2000년 12월 29일
20 ORACLE, Oracle 10g Downloads, http://www.oracle.com/technology/software/products/database/oracle10g/index.html, 2005
21 American National Standards Institute, The Database Language SQL, Standard No. X3.135-1992, New York, 1992