com.netrics.likeit

Class NetricsTable

java.lang.Object

com.netrics.likeit.NetricsTable

Direct Known Subclasses:

NetricsDb

public class NetricsTable
extends java.lang.Object

This class represents a Netrics table.

Its purpose is to allow the user to construct and configure a table object to be loaded into a Netrics server.

See Also:

NetricsServerInterface.tblload(com.netrics.likeit.NetricsTable), NetricsServerInterface.tbldump(java.lang.String, com.netrics.likeit.NetricsLock)

Field Summary

Fields

Modifier and Type	Field and Description
static int	FLDTYP_ATTRS Name/Value attributes value field.
static int	FLDTYP_DATE Date value field.
static int	FLDTYP_DATETIME Date and time value field.
static int	FLDTYP_FLOAT Floating point value field.
static int	FLDTYP_INT Integer value field.
static int	FLDTYP_SRCHTEXT Searchable text field.
static int	FLDTYP_TEXT Non-searchable text field.

Constructor Summary

Constructors

Constructor and Description
NetricsTable(java.lang.String name, java.lang.String[] fieldNames, NetricsRecSrc src)

Method Summary

Methods

Modifier and Type	Method and Description
void	addPIndex(java.lang.String field_name, boolean primary, java.lang.String[] partition_separators, boolean normalized) Add a partition index to this table.
java.lang.String	compare(NetricsTable tbl) For internal use only.
java.lang.String[]	getFieldNames() Can be used to get the field names from a NetricsTable returned by a tbldump.
java.lang.String	getInfo() Can be used to get the table info from a NetricsTable returned by a tbldump.
java.lang.String	getName() Return the name of this table.
NetricsRecSrc	getRecSrc() Retrieve the NetricsRecSrc for a NetricsTable returned by a tbldump.
java.lang.String	getString() An unformatted string representation of the table.
void	setCharmaps(java.lang.String[] charmaps) Specifies the character map to use for each field.
void	setEstNumRecords(int est_num) Set the estimated number of records.
void	setFieldTypes(int[] ftypes) Specify the field types for this table.
void	setGipFiltered(boolean enabled) Enable gip filtering for this table.
void	setGipGramLen(int glen) This method sets the gram length for the enterprise filter.
void	setInfo(java.lang.String info) Set the table info string.
void	setPhonetic(boolean enabled) Enable phonetic searches for this table.
void	setPsiEncodings(java.lang.String[][] encodings, int[][] backwards_fields, int[] suffixed_fields, int[][] min_match_sizes) Use this function to specify encodings for the PSI prefilter.
void	setSortEncodings(java.lang.String[][] encodings, int[][] backwards_fields) Use this function to specify encodings for the SORT prefilter.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

FLDTYP_TEXT

public static final int FLDTYP_TEXT

Non-searchable text field. Use this for text fields that you will not be performing inexact matching on.

See Also:

Constant Field Values

FLDTYP_SRCHTEXT

public static final int FLDTYP_SRCHTEXT

Searchable text field. This is the default field type and the only type inexact matching can be performed on.

See Also:

Constant Field Values

FLDTYP_INT

public static final int FLDTYP_INT

Integer value field.

See Also:

Constant Field Values

FLDTYP_FLOAT

public static final int FLDTYP_FLOAT

Floating point value field. This is the same as a "C" double value.

See Also:

Constant Field Values

FLDTYP_DATE

public static final int FLDTYP_DATE

Date value field.

See Also:

Constant Field Values

FLDTYP_DATETIME

public static final int FLDTYP_DATETIME

Date and time value field.

See Also:

Constant Field Values

FLDTYP_ATTRS

public static final int FLDTYP_ATTRS

Name/Value attributes value field.

See Also:

Constant Field Values

Constructor Detail

NetricsTable

public NetricsTable(java.lang.String name,
            java.lang.String[] fieldNames,
            NetricsRecSrc src)

Parameters:

name - The name of the table. Must be unique. In other commands, the table will be referred to by this name

fieldNames - User specified names for the fields of the table. In other commands, fields will be referred to by these names

src - The NetricsRecSrc object which holds the records for this table (can be null to load an empty table)

Method Detail

getString

public java.lang.String getString()

An unformatted string representation of the table.

getRecSrc

public NetricsRecSrc getRecSrc()

Retrieve the NetricsRecSrc for a NetricsTable returned by a tbldump.

The returned NetricsRecSrc object can be used to retrieve all of the records of the table.

See Also:

NetricsServerInterface.tbldump(java.lang.String, com.netrics.likeit.NetricsLock)

getName

public java.lang.String getName()

Return the name of this table.

setEstNumRecords

public void setEstNumRecords(int est_num)

Set the estimated number of records. This method is used to set the estimated number of records in the record source for this table. The server may use this to optimize loading of the records.

setGipGramLen

public void setGipGramLen(int glen)

This method sets the gram length for the enterprise filter. Only change this at the request of your TIBCO representative.

setInfo

public void setInfo(java.lang.String info)

Set the table info string. This string can be used to associate information with the table as a whole (e.g. title, url). It can then be accessed by calling the list command of the NetricsServerInterface class.

See Also:

NetricsServerInterface.list(java.lang.String[])

getInfo

public java.lang.String getInfo()

Can be used to get the table info from a NetricsTable returned by a tbldump.

See Also:

NetricsServerInterface.tbldump(java.lang.String, com.netrics.likeit.NetricsLock)

setFieldTypes

public void setFieldTypes(int[] ftypes)

Specify the field types for this table. Use the public constants in this class to set each type.

Field Type	Description
NetricsTable.FLDTYP_TEXT	Non-searchable text
NetricsTable.FLDTYP_SRCHTEXT	Searchable text
NetricsTable.FLDTYP_INT	Integer type field
NetricsTable.FLDTYP_FLOAT	Float type field
NetricsTable.FLDTYP_DATE	Date type field (default format: yyyy/mm/dd)
NetricsTable.FLDTYP_DATETIME	Date type field, with time (default format: yyyy/mm/dd HH:MM:SS)
NetricsTable.FLDTYP_ATTRS	Name/Value attributes type field

setGipFiltered

public void setGipFiltered(boolean enabled)

Enable gip filtering for this table. This may only be set to true if GIP filtering is enabled in the server. GIP filtering will greatly speed up the performance of the server for large datasets. Gip filtering must be enabled at load time to use it to search a table.

If GIP filtering is enabled in the server the default value for all tables created is true, thus it is only necessary to call this method if you wish to turn GIP filtering off (false).

setSortEncodings

public void setSortEncodings(java.lang.String[][] encodings,
                    int[][] backwards_fields)
                      throws NetricsException

Use this function to specify encodings for the SORT prefilter. It is recommended that you contact your TIBCO representative for advice on which sort encodings to use for your specific application.

Parameters:

encodings - Each string array is a list of field names which will be used for a given sort encoding. The first field name will be the primary sort key, the second field will be secondary, and so on. In general, you should have as many encodings as the number of fields in the table and use all important fields as the primary sort key in at least one encoding.

backwards_fields - Fields can also be sorted backwards (from the last characters in the field to the first). Important fields can and should be used as primary sort keys in both their forward and reverse directions. The backwards_fields array should be the same length as the encodings array and the subarray at each position in the two primary arrays should also be the same length. In this way, there is an integer in the backwards_fields arrays for each of the fields in the encodings arrays. The integer is set to 1 if the field is to be sorted in the backwards direction and zero for the forward direction.

Throws:

NetricsException

setPsiEncodings

public void setPsiEncodings(java.lang.String[][] encodings,
                   int[][] backwards_fields,
                   int[] suffixed_fields,
                   int[][] min_match_sizes)
                     throws NetricsException

Use this function to specify encodings for the PSI prefilter. It is recommended that you contact your Netrics representative for advice on which PSI encodings to use for your specific application.

Parameters:

encodings - Each string array is a list of field names which will be used for a given PSI encoding. The first field name will be the primary PSI key, the second field will be secondary, and so on. In general, you should have as many encodings as the number of fields in the table and use all important fields as the primary PSI key in at least one encoding.

backwards_fields - Fields can also be sorted backwards (from the last characters in the field to the first). Important fields can and should be used as primary PSI keys in both their forward and reverse directions. The backwards_fields array should be the same length as the encodings array and the subarray at each position in the two primary arrays should also be the same length. In this way, there is an integer in the backwards_fields arrays for each of the fields in the encodings arrays. The integer is set to 1 if the field is to be sorted in the backwards direction and one for the forward direction.

suffixed_fields - Indicates the number of fields in each encoding to which suffixing is applied. Currently PSI only supports suffixing the first field, so the entries of this array must be 0 or 1.

min_match_sizes - Indicates the minimum match size for each field of each encoding. Match sizes are in characters for text fields, and in bytes for non-text fields. A candidate record is rejected if none of the minima are met. Like backwards_fields this array must have the same dimensions as encodings.

Throws:

NetricsException

addPIndex

public void addPIndex(java.lang.String field_name,
             boolean primary,
             java.lang.String[] partition_separators,
             boolean normalized)

Add a partition index to this table. This method is used to add a partition index to the table. These indexes can be used to speed the processing of Filtering Predicates. A partition index groups records in the table into a set of partitions based on the value of the named field. The number of partitions and range of values that are placed in each partition must be defined when the index is created. These are defined by the partition_separators parameter. There is a limit on the number of partitions in an index, currently set to 1026. As there are two predefined partitions for empty and invalid values and a final partition for values greater than the last separator this limits the total number of separators to 1023.

Partition indexes may be defined as either Primary or Secondary. Primary indexes give a much better performance improvement, especially on large tables and with highly selective predicates, but at a cost of significantly larger memory requirements and slightly slower load times. The additional memory overhead for a primary index is much larger if more than one primary index is defined for a table.

If you are using filtering predicates properly defined partitioned indexes in conjunction with a properly formulated predicate expression can dramatically improve performance on large tables. It is recommened that you consult with your Netrics representative to determine the optimal use of partition indexes for your particular situation.

Parameters:

field_name - The name of the field that is to be indexed.

primary - If true this is a primary index, otherwise it is a secondary index.

partition_separators - This is an array that defines the upper bound of each partition. The values MUST be in sorted order (as per the type of the named field) least to greatest. The size of the array defines the number of partitions.

normalized - If true and the field is a string value the normalized values are indexed. Thus this index will work with the case insensitive comparison operators and not work with the standard operators.

See Also:

NetricsPredicate, NetricsSearchCfg.SetSearchPredicate(com.netrics.likeit.NetricsPredicate)

setPhonetic

public void setPhonetic(boolean enabled)

Enable phonetic searches for this table. Phonetics is not currently supported, so this may only be set to false.

getFieldNames

public java.lang.String[] getFieldNames()

Can be used to get the field names from a NetricsTable returned by a tbldump.

See Also:

NetricsServerInterface.tbldump(java.lang.String, com.netrics.likeit.NetricsLock)

setCharmaps

public void setCharmaps(java.lang.String[] charmaps)
                 throws NetricsException

Specifies the character map to use for each field.

The length of this array must be the same as the number of fields in the table. This is a list of the names of character maps assigned to each field. Entries that do not correspond to fields of type FLDTYP_SRCHTEXT are ignored.

There are two predefined character maps:

NetricsCharmap.Standard - the default character map.
NetricsCharmap.Punctuation - a punctuation sensitive map.

DEFAULT: if not specified all searchable fields use the predefined character map: NetricsCharmap.Standard

Parameters:

charmaps - A string name of the character map to use for each field in the table.

Throws:

NetricsException

See Also:

NetricsCharmap, NetricsServerInterface.cmapcreate(com.netrics.likeit.NetricsCharmap)

compare

public java.lang.String compare(NetricsTable tbl)

For internal use only. WARNING: This modifies the record source of tbl.