Question ID : 7
Created on 2009-08-28 at 12:32 PM
Author : Veryant Support [support@veryant.com]
Online URL : http://support.veryant.com/support/phpkb/question.php?ID=7
Question:
What are the basic differences between JISAM and c-treeRTG? What are the guidelines for choosing between them?
Answer:
Here are the benefits of each:
Veryant JISAM
isCOBOL Evolve supplies a high capacity, client/server, indexed ISAM file system called Veryant JISAM.
JISAM is written entirely in Java so it runs anywhere, even on a mobile phone.
Utility provided for basic file management
Utility provided for one-step migration of data files from other COBOL vendor's indexed files.
ODBC Driver for Windows
Maximum file size: 9+ exabytes (EB) (over 9 million terabytes)
Maximum number of keys: no limit
Maximum number of records: no limit
Maximum key length: 255 bytes
Maximum number of segments per key: 16
Maximum record length: 2 GB
Currently JISAM has the following limitations:
transactions and compression are not supported
variable length records is not supported, the maximum record size is always used.
Veryant's c-treeRTG
A Client/Server product, it includes its own server (instead of using isCOBOL's application server)
Full Transaction Support
ODBC Driver for Windows
Supports Live Backup
Memory file support
Includes several feature-rich management utilities including Graphical tool for SQL access of your indexed data
Utility provided for one-step migration of data files from Vision.
Maximum file size: 16,000,000 terabytes (16 Exabytes)
Maximum number of keys: no limit
Maximum number of records: no limit
Maximum key length: no limit
Maximum number of segments per key: no limit
Maximum fixed record length: 65,535 bytes
Maximum variable record length: 2 GB
Compression: supported
The basic guideline is to use JISAM for smaller numbers of users (100 or fewer), or light data access, and use c-treeRTG for larger numbers of users or if you want to take advantage of the extra features of c-treeRTG