Search:
Thunderstone
Texis Manual
Vortex Manual
Texis FAQ
Webinator Manual
Support Forum
The Web
Advanced Search
Home
Products
Company
News
Tech Support
Demos
Contact Us
Texis Manual
Top
Up: List of Tables
Next: PREFACE
Back: List of Tables
PDF
USING TEXIS
PREFACE
Acknowledgment
Documentation Caveat
Documentation Structure
THE NICKEL TOUR - OR - I BOUGHT IT, NOW WHAT?
Executables
Sample Database
Using the API
Starting the Network Server Daemon
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
Search Condition Using IN
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
File functions
fromfile, fromfiletext
totext
toind
String Functions
abstract
text2mm
keywords
length
lower
upper
initcap
sandr
Math functions
Date functions
Bit manipulation functions
Internet/IP address functions
Geographical coordinate functions
azimuth2compass
azimuthgeocode
azimuthlatlon
dms2dec, dec2dms
distgeocode
distlatlon
latlon2geocode
geocode2lat, geocode2lon
Other Functions
exec
mminfo
convert
seq
random
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 EXIST
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: Normal vs. Inverted vs. Counter
Metamorph Index Capabilities and Limitations
Using LIKE3 for Index Only Search (No Post-Search)
Creating an Inverted Index
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
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: Wed Aug 6 10:57:07 EDT 2008
Home
::
Products
::
Company
::
News
::
Tech Support
::
Demos
::
Contact Us
Copyright © 2008 Thunderstone Software LLC. All rights reserved.