Chapter 9. Querying

Table of Contents

Using TMCore Public Views And Functions
Executing Queries
Other Options For Working With Results Sets
Querying Efficiently
Limiting Data Read In A Results Row
Performing Query Analysis
Use The ApplicationOntology Cache Object

TMCore is built on relational database technology and exposes a complete relational data model for the topic maps managed by the system. The model consists of a set of views and pre-defined SQL functions which can be used to construct arbitrary queries across all topic map data using any of the SQL constructs supported by the underlying database - this includes statistical functions; data conversion fucntions; full-text query extensions and so on. Unlike the indexes covered in the section called “The Core Indexes”, the relational model also allows multiple topic maps to be queried simultaneously.