BS ISO/IEC 13249-2:2003

Foreword
Introduction
1 Scope
2 Normative references
3 Terms and definitions, notations and conventions
   3.1 Terms and definitions
   3.2 Notations
   3.3 Conventions
4 Concepts
   4.1 Concepts taken from ISO/IEC 9075 (all parts)
   4.2 Text model
   4.3 Text identification facilities
   4.4 Text Scoring facilities
   4.5 Language aspects
   4.6 Word normalization
   4.7 Types and routines provided by this part of
        ISO/IEC 13249
   4.8 The Full-Text Information Schema
5 Full-Text Types
   5.1 FullText Type and Routines
   5.2 FT_TokenPosition Type and Routines
   5.3 FT_Pattern Type and Routines
6 Structured Search Pattern Types
   6.1 FT_Any Type and Routines
   6.2 FT_Primary Type and Routines
   6.3 FT_WordOrPhrase Type and Routines
   6.4 FT_TextLiteral Type and Routines
   6.5 FT_StemmedWord Type and Routines
   6.6 FT_Phrase Type and Routines
   6.7 FT_StemmedPhase Type and Routines
   6.8 FT_Proxi Type and Routines
   6.9 FT_Soundex Type and Routines
   6.10 FT_Fuzzy Type and Routines
   6.11 FT_BroaderTerm Type and Routines
   6.12 FT_NarrowerTerm Type and Routines
   6.13 FT_Synonym Type and Routines
   6.14 FT_PreferredTerm Type and Routines
   6.15 FT_RelatedTerm Type and Routines
   6.16 FT_TopTerm Type and Routines
   6.17 FT_IsAbout Type and Routines
   6.18 FT_Context Type and Routines
   6.19 FT_ParExpr Type and Routines
   6.20 FT_Term Type and Routines
   6.21 FT_Expr Type and Routines
   6.22 FT_PhraseList Type and Routines
7 FullText_Token Type and Routines
   7.1 FullText_Token Type
8 SQL/MM Full-Text Thesaurus Schema
   8.1 Introduction
   8.2 FT_THESAURAS Schema
   8.3 TERM_DICTIONARY base table
   8.4 TERM_HIERARCHY base table
   8.5 TERM_SYNONYM base table
   8.6 TERM_RELATED base table
9 SQL/MM FULL-TEXT INFORMATION SCHEMA
   9.1 Introduction
   9.2 FT_FEATURES view
   9.3 FT_Schemata view
10 SQL/MM Full-Text Definition Schema
   10.1 Introduction
   10.2 FT_FEATURES base table
   10.3 FT_SCHEMATA base table
11 STATUS CODES
12 CONFORMANCE
   12.1 Requirements for conformance
   12.2 Features of ISO/IEC 9075 required in this
        part of ISO/IEC 13249
   12.3 Claims of conformance
Annex A
      A.1 Implementation-defined Meta-variables
Annex B
      B.1 Implementation-dependent Meta-variables
INDEX
Tables

This document: - introduces the Full-Text part of ISO/IEC 13249 (all parts); - gives the references necessary for ISO/IEC 13249:2003; - defines notations and conventions specific to ISO/IEC 13249:2003; - defines concepts specific to ISO/IEC 13249:2003; - defines the full-text user-defined types and their associated routines.

This part of ISO/IEC13249: introduces the Full-Text part of ISO/IEC13249 (all parts); gives the references necessary for this part of ISO/IEC13249; defines notations and conventions specific to this part of ISO/IEC13249; defines concepts specific to this part of ISO/IEC13249; defines the full-text user-defined types and their associated routines. The full-text user-defined types defined in this part of ISO/IEC13249 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/IEC13249 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/IEC13249 include, but are not restricted to, library, newspaper, multimedia, and scientific research applications.