CSA Group Information Technology - Database Languages - SQL Multimedia and Application Packages - Part 2: Full-Text (Adopted ISO/IEC 13249-2:2003, second edition, 2003-11-01)

Scope This part of ISO/IEC 13249: a) introduces the Full-Text part of ISO/IEC 13249 (all parts); b) gives the references necessary for this part of ISO/IEC 13249; c) defines notations and conventions specific to this part of ISO/IEC 13249; d) defines concepts specific to this part of ISO/IEC 13249; e) defines the full-text user-defined types and their associated routines. The full-text user-defined types defined in this part of ISO/IEC 13249 adhere to the following. A full-text user-defined type is generic to text handling. It addresses the need to search and retrieve information based on aspects of full-text data using patterns such as words, phrases, proximity expansion, fuzzy expansion, and thesaurus based expansions. It also addresses the need to construct such search patterns for text identification facilities and text ranking facilities. A full-text user-defined type does not redefine the database language SQL directly or in combination with another full-text data type. An implementation of this part of ISO/IEC 13249 may exist in environments that also support information and content management, decision support, data mining, and data warehousing systems. Application areas addressed by implementations of this part of ISO/IEC 13249 include, but are not restricted to, library, newspaper, multimedia, and scientific research applications.