HFSQL

DATA AND INDEXES DATA TYPES HFSQL supports all data types: • Text, character • Numeric (integer, real, decimal with 38 significant digits), Currency • Date, time, duration, timestamp • Boolean • Array type column • Blob (“memo”, binary format: image, video,...) Powerful features are available: • Unicode is supported, with support of linguistic sorts • The sort order for differ- ent character sets is taken into account • Default value • Calculated items • Man- agement of NULL • Timestamp... UNICODE Data in Chinese HFSQL supports Unicode type text and blob columns. Indexes can be sorted by the alphabetical order corresponding to each language: Russian from Russia or Ukraine, Chinese from Singapore, Taiwan, Hong Kong, Macao, ... INDEX AND KEYS HFSQL manages keys and indexes for any type of column. In order to ensure optimum performance, the server uses an optimization mechanism based on the data distribution, that gets automatically activated during idle times. The following types of indexes can be cre- ated: • Simple index • Composite index • Partial index • Full text index. HFSQL ensures data integrity by managing: • Unique constraints • Cardinality constraints • Automatic Identifier • Primary and foreign keys. FULL TEXT INDEX The “full text” search allows for very fast string (words or expressions) searches in- side your data. It allows you for instance to find a word among one million rows in less than 2 ms (average for found occurrence). This enables you to index, without pro- gramming, the texts found in a HFSQL database. Results are offered according to a rele- vance order (“ranking”). To perform searches on words stored in RTF or HTML documents, HFSQL ignores tags during indexing for these formats. Texts can be contained inside text or blob type controls. A full text index can index one or more columns, therefore a single search can be done on several columns at the same time. The stop words and synonyms are sup- ported. CAPACITY (VOLUMES) HFSQL Client/Server offers large storage capacity, in line with current and future storage models, as well as the ever increas- ing needs of enterprises. During a recent roadshow, in front of more than 10,000 professional developers, PC SOFT demonstrated the use of a HFSQL database containing more than 20 billion rows: data searches started instantly! 329,000,000,000,000,000 329 millions of billions... This is the num- ber of rows (records) that can be found in a HFSQL table: you’re safe!