Toggle navigation
+1 216-820-2200
+1 216-820-2200
Toggle navigation
Products
Solutions
How to Buy
Support
Contact Us
News
About
Using Texis
Preface
Acknowledgment
Documentation Caveat
Documentation Structure
Introduction
Texis: Thunderstone's Text Information Server
What is it?
Why is that different?
What can we do with it?
Features Unique to Texis
Zero Latency Insert
Variable Sized Records
Indirect Fields
Variable Length Index Keys
Why all the variable stuff?
Specifications
Texis as a Relational Database Management System
Relational Database Background
Support of SQL
Case Example: Acme Industrial Online Corporate Library
Table Definition
Creating the Resume Table
Inserting Data into the Resume Table
Defining a Table
Command Discussion
Removing a Table
A First Look at Queries
Command Discussion
Retrieving From the Entire Table
Retrieving All the Columns
Retrieving a Subset of Rows: Simple Conditions
Retrieving a Subset of Rows: Compound Conditions
Retrieval Using the
AND
Operator
Retrieval Using the
OR
Operator
Retrieval Using Both
AND
and
OR
Operators
Retrieval Using Parentheses
Logical Operator
NOT
Additional Comparison Operators
Range and Geographical Searches Using
BETWEEN
Geographical Searches with
BETWEEN
Set-like Searches Using
IN
,
SUBSET
and
INTERSECT
Searches Using
IN
Searches Using
SUBSET
Searches Using
INTERSECT
IN
,
SUBSET
,
INTERSECT
Commonality
Search Condition Using
LIKE
Command Discussion
Relevance Ranking Using
LIKER
and
LIKEP
Command Discussion
Query searching using
LIKEIN
Search Condition Using
MATCHES
Sorting Your Results
Queries Involving Calculated Values
Arithmetic Calculations
Manipulating Information By Date
Summarizing Values:
GROUP BY
Clause and Aggregate Functions
Groups With Conditions:
HAVING
Clause
Server functions
File functions
fromfile, fromfiletext
totext
toind
canonpath
pathcmp
basename
dirname
fileext
joinpath
joinpathabsolute
String Functions
abstract
text2mm
keywords
length
lower
upper
initcap
sandr
separator
stringcompare
stringformat
Math functions
Date functions
Bit manipulation functions
Cryptographic functions
Internet/IP address functions
urlcanonicalize
Geographical coordinate functions
azimuth2compass
azimuthgeocode
azimuthlatlon
dms2dec, dec2dms
distgeocode
distlatlon
latlon2geocode, latlon2geocodearea
geocode2lat, geocode2lon
parselatitude, parselongitude
JSON functions
JSON Path Syntax
JSON Field Syntax
isjson
json_format
json_type
json_value
json_query
json_modify
json_merge_patch
json_merge_preserve
Other Functions
exec
mminfo
convert
seq
random
generate_uuid
bintohex
hextobin
identifylanguage
lookup
lookupCanonicalizeRanges
lookupParseRange
hasFeature
ifNull
isNull
xmlTreeQuickXPath
Advanced Queries
Retrieving Data From Multiple Tables
Command Discussion
Nesting Queries
Command Discussion
Forming Complex Queries
Joining a Table to Itself
Correlated Subqueries
Subquery Using EXISTS
Virtual Fields
Column Aliasing
Intelligent Text Search Queries
Types of Text Query
Definition of Metamorph Terms
Adjusting Linguistic Controls
Constructing a Metamorph Query
Keyword Search
Refining a Query
Adjusting Proximity Range by Specifying Delimiters
Delimiter Syntax Summary
Rules of Delimiter Syntax
Using Set Logic to Weight Search Items
Set Logic and Intersections Defined
Maximum Intersections Possible ("AND")
Specifying Fewer Intersections
Specifying No Intersections ("OR")
Weighting Items for Precedence (+)
Marking Items for Exclusion ("NOT") (-)
Combinatorial Logic
Combinatorial Logic and
LIKER
Metamorph Logic Rules Summary
Other Metamorph Features
Indexing for Increased Performance
When and How to Index
Creating An Index
Command Discussion
Creating a Unique Index
Command Discussion
Creating a Metamorph Index
Metamorph Index Types: Inverted vs. Compact vs. Counter
Inverted
Compact
Counter
Metamorph Index Capabilities and Limitations
Using
LIKE3
for Index Only Search (No Post-Search)
Creating an Inverted Index
Index Options
Available Options
Dropping an Index
Keeping the Database Current
Adding New Records
Inserting One Row at a Time
Command Discussion
Inserting Text
Inserting Multiple Rows at a Time
Command Discussion
Updating Records
Command Discussion
Making a Texis Owned File
Deleting Records
Command Discussion
Security
Creating Users and Logging In
Granting Privileges
Command Discussion
Removing Privileges
Command Discussion
Administration of the Database
System Catalog
Optimization
Table Compaction
Index Maintenance
Manual Index Optimization via
CREATE METAMORPH INDEX
Manual Index Optimization via
ALTER INDEX
Automatic Index Optimization via
chkind
Choosing Manual vs. Automatic Index Optimization
Reserved Words
Server Properties
Search and optimization parameters
Metamorph parameters
Rank knobs
Other ranking properties
Indexing properties
Locking properties
Miscellaneous Properties
Copyright © Thunderstone Software
Last updated: Apr 15 2024
Texis Manual
Top
Up: List of Tables
Next: Preface
Back: List of Tables
PDF
Contact
Submit Request
Copyright © 2024 Thunderstone Software LLC. All rights reserved.