The SAP Sybase IQ Unstructured Data Analytic (UDA) option
extent the capabilities of SAP Sybase IQ to do text analysis (data mining). This
option allow the creation of Character Large Objects (CLOB) and Binary Large
Objects columns that are used to store and manipulate binary documents (like MS
Excel, MS word, etc) and long text columns (filtered content of the binary
objects).
To obtain insight from those CLOB, we need to index those
columns and use string functions to retrieve, compare and extract
information.
A case sensitive databases can:
There are several options that can be use to minimize the
impact of case sensitivity during data mining, let see some of them:
Select * from MyUser.Mytable
Where lcase(mycolum) like ‘%term%’
This work well for string columns that are not CLOB; the LCASE, UCASE, LOWER and UPPER function are not supported
on CLOB data type columns.
If the SAP Sybase IQ database will be primary used for data mining
and the case can be ignored, it is recommended to create the database with CASE
IGNORE property; by default all SAP Sybase IQ database are created with CASE
RESPECT property.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
53 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |