IM-SQL Database Notes

Image-Master and SQL: a Backend Connection

The SQL Server data access mechanism for Image-Master is an integrated feature enhancement to the core software. Full backwards compatibility with existing DBF based tables is provided by default which provides flexibility in deploying the SQL server features to selected workstation groups. This allows for certification testing of the new features in a production system while providing data isolation for non-participating workstations.

IM-SQL Benefits

Blazingly fast query times in the Viewing Module (literally 10 to 20 fold performance improvement with large document sets)

Removal of the 2G maximum document limit inherent in the databases

Ability to implement index field data security by user

Ability to query and aggregate Image-Master index data with other SQL data easily

Ability to store a larger number of index fields without impacting the maximum document quantity

Ability to tailor user licenses to match usage patterns and spread costs throughout the year

Improved data integrity protection by virtue of SQL transaction services and backup services

One future benefit may be the ability to encapsulate the image data within the SQL security model.

DB Naming Convention

If a database is SQL enabled, then "(SQL)" will appear at the end of the database name in the Select Image-Master Database screen. Some Image-Master databases can migrate to SQL while others can remain as DBF tables even after the Machine ID group has been enabled for SQL access.

Connection Verifications

In the Viewing or Scanning Module, "Using SQL Enabled Database:" will appear in the upper-left corner if the connection to SQL was successful.

Search Results Timer

In any search results screen, "SQL Server" will appear in the upper-left corner along with the estimated time it took to return the search results.