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
    • 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
      • canonpath
    • String Functions
      • abstract
      • text2mm
      • keywords
      • length
      • lower
      • upper
      • initcap
      • sandr
      • separator
    • 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
      • 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 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