Accusoft.PrizmViewer10.AnnotationServer
Other Annotation Storage
| Concepts > Other Annotation Storage |
Prizm® Annotation Server samples are written and tested using files (file system) and MS Access database for annotation data storage. However, other storage mechanisms are possible. The Prizm Annotation Server code is written using classes, where a new storage class could be created and the code modified to incorporate the custom class into the source code.
If you are interested in customizing the Prizm Annotation Server source code, please see the Prizm Annotation Server Source Code Overview topic.
The Annotation Server samples come with a Microsoft® Access 2002 compatible database (.MDB) that works with the sample code. To deploy your annotation server using a higher performing database engine, such as Microsoft or Oracle SQL Servers, simply modify your ODBC connection parameters in the Annotation Configuration file and create the appropriate tables in your database.
Prizm Annotation Server has not been tested using other database engines, so there is no assurance that other database engines are supported without modifying the Annotation Server source code.
Due to limitations in the size of searchable fields in Access databases, the database schema used in the Annotations2002.mdb database included with this sample uses two separate fields to store the image path (URL) that the annotations apply to. The limit on a text field is 255 characters in Access, so the total combined maximum length of a URL that the Access database supports is 255 + 255 = 520 characters.
When using a high-performance SQL server, you are able to combine the two pieces into a single searchable field. There are a few changes that need to be made to the DatabaseStore class when using a single field for the URL. The changes needed include storing the complete path instead of separate paths in the constructor and modifying the query in the DatabaseStore class GetAnnotData method to query from a single field using the value of the full URL saved in the constructor instead of multiple fields.