|
|
|
Introduction to JBase - Now Available |
 JBase is a database program designed to be used with TIFF and MODI documents. File attributes and text are extracted from the document images and inserted into a Microsoft SQL Compact Edition 3.5 database. There, documents can be grouped and organized and additional identifying fields can be filled-in as needed. Documents can then be searched by Windows file attributes, user assigned attributes or for text located within the document. The actual files can be located anywhere on the local machine or even on the network. JScan 2.0 , an OCR tool for TIFF and MODI files, is fully integrated within JBase, providing a comprehensive solution for dealing with document images. |
|
Firstly, and unfortunately, optical character recognition (OCR) is not foolproof. Although we are moving closer all the time to paperless offices, errors in text recognition still persist. A good example, which I see all the time, are the letters O and Q and the number 0. However, by taking that which is recognized, putting it into text format, then allowing that text to be editable (correctable), we can fill in one of the gaps which currently exist. This is most important when searching for terms that have been "mis-recognized", which can result in relevant documents being "not found". Secondly, there is a dramatic increase in search speed. Anyone familiar with databases has heard of SQL, shorthand for Sequential Query Language, often pronounced "Sequel" or just by its letters - "S-Q-L". SQL is the closest thing to a standard query language that currently exists. Its commercial introduction was made by the Oracle Corporation in 1979, and in 1989 Microsoft introduced its first version for OS/2. The reasons for its longevity and current ubiquitousness is many, and speed is certainly one of them. JBase uses Microsoft SQL Server Compact Edition (CE) - the "compact" referring to disk space and memory usage, it is not descriptive of its performance. As with its big brother, Microsoft SQL Server, you will find searches blazingly fast. |
|
Microsoft SQL Server Compact Edition databases are limited to 4 GB in size. This limit is before any "shrinking" of the database is done. Microsoft SQL Server Compact 3.5 (MSSCE) database files are divided into logical 4 KB units referred to as pages. As a database continues to be modified, some pages might contain unused space, and some pages are unused. These unused pages are reclaimed by the shrinking utility (found in JBase under Database on the menu bar), minimizing the amount of wasted space. Thus, the effective size of a database can be much larger than the 4 GB limit. There are no limits on the number of databases that can be created with MSSCE. |
|
|