A KOREAN SEARCH PATTERN IN THE LIKE OPERATION

Sung Chul Park, Eun Hyang Lo, Jong Chul Park, Young Chul Park

Abstract

The string pattern search operator LIKE of SQL has been developed based on English such that each search pattern of English of the operator works for each character in the alphabet of English. For finding Korean, search patterns of the operator can be expressed by both the alphabet and syllables of Korean. As a phonetic symbol, each syllable of Korean is composed either of a leading sound and a medial sound or of a leading sound, a medial sound, and a trailing sound. By utilizing that characteristic of Korean syllables, in addition to the traditional complete-syllable based search pattern of Korean, this paper proposes an incomplete-syllable based search pattern of Korean, as a pattern of the operator LIKE, to find Korean syllables having specific leading sounds, specific medial sounds, or both specific leading sounds and medial sounds. Formulating predicates that are equivalent with the incomplete-syllable based search pattern of Korean by way of existing SQL expressions is cumbersome and might cause the portability problem of applications depending on the underlying character set of the DBMS.

References

  1. American National Standards Institute, 1992. The Database Language SQL, Standard No. X3.135-1992, New York.
  2. Kaplan, M., 2001. International Features in Microsoft SQL Server 2000, viewed 1 August 2006, <http://msdn.microsoft.com/library/default.asp?url=/li brary/enus/dnsql2k/html/intlfeaturesinsqlserver2000.asp>.
  3. Korean Standards Information Center, 2002. Code for information interchange (Hangul and Hanja), Standard No. KS X 1001.
  4. Korean Standards Information Center, 1982. Keyboard layout for information processing, Standard No. KS X 5002.
  5. Melton, J., Simon, A. R., 1993. Understanding the new SQL: A complete guide, Morgan Kaufmann Publishers, Inc., San Mateo, California.
  6. Microsoft, 2006. LIKE (Transact-SQL), viewed 20 October 2006, <http://msdn2.microsoft.com/enus/library/ms179859.aspx>.
  7. ORACLE, 2005. Globalization Support Oracle Unicode database support, viewed 24 July 2006, < http://www.oracle.com/technology/tech/globalization/ pdf/TWP_AppDev_Unicode_10gR2.pdf>.
  8. ORACLE, 2005. Oracle 10g Downloads, viewed 20 October 2006, < http://www.oracle.com/technology/software/products/ database/oracle10g/index.html>.
  9. Poon, S., Sud, M., Chong, R., 2005. Understanding DB2 Universal Database character conversion, viewed 1 August 2006, <http://www128.ibm.com/developerworks/db2/library/techarticle/d m-0506chong/>.
  10. Unicode, Inc., 2005. Conformance, viewed 11 July 2006, <http://www.unicode.org/versions/Unicode4.0.0/ch03. pdf>.
  11. Unicode, Inc., 2005. East Asian Scripts, viewed 11 July 2006, <http://www.unicode.org/versions/Unicode4.0.0/ch11. pdf>.
  12. Unicode, Inc., 2005. Hangul Compatibility Jamo, viewed 11 July 2006, <http://www.unicode.org/charts/P DF/U3130.pdf>.
  13. Unicode, Inc., 2005. Hangul Jamo, viewed 11 July 2006, <http://www.unicode.org/charts/PDF/U1100.pdf>.
  14. Unicode, Inc., 2005. Hangul Syllables, viewed 11 July 2006, <http://www.unicode.org/charts/PDF/UAC00.pdf>.
  15. Unicode, Inc., 2006. Unicode Home Page, viewed 5 July 2006, <http://www.unicode.org>.
Download


Paper Citation


in Harvard Style

Chul Park S., Hyang Lo E., Chul Park J. and Chul Park Y. (2007). A KOREAN SEARCH PATTERN IN THE LIKE OPERATION . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 457-464. DOI: 10.5220/0002376304570464


in Bibtex Style

@conference{iceis07,
author={Sung Chul Park and Eun Hyang Lo and Jong Chul Park and Young Chul Park},
title={A KOREAN SEARCH PATTERN IN THE LIKE OPERATION},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={457-464},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002376304570464},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - A KOREAN SEARCH PATTERN IN THE LIKE OPERATION
SN - 978-972-8865-88-7
AU - Chul Park S.
AU - Hyang Lo E.
AU - Chul Park J.
AU - Chul Park Y.
PY - 2007
SP - 457
EP - 464
DO - 10.5220/0002376304570464