Author(s)

Kevin Beland, Kirk Larson, Thaine Rowley, Matt Mueller, Christopher Smith, Al Rizzo, Daniel Valandra, Marc Rendell

Creighton University and the Rose Salter Medical Research Foundation, Omaha, NE, USA.

In prior work we described techniques used to capture, store, and retrieve narrative data forms from a database using widely available off the shelf software. This concept makes use of the security and versioning features of database architecture together with those of image-supported electronic document information capture. We present herein the security and audit trail features of our construct. Unique usernames and passwords are used at the operating system level to enforce client validation and control access to the database system via an electronic signature using a Boolean logic algorithm. We used the database domain to capture original data and any changes to the data, developing an audit trail displaying identification information. Version controlled and change tracked electronic documents can be retrieved through the client side web interface to enable direct search operations, thus uncoupling the client from database query languages.

InfoPath, Electronic Form, Data Storage

Beland, K. , Larson, K. , Rowley, T. , Mueller, M. , Smith, C. , Rizzo, A. , Valandra, D. and Rendell, M. (2014) Security and Audit Trail Capabilities of a Facilitated Interface Used to Populate a Database System with Text and Graphical Data Using Widely Available Software. Journal of Software Engineering and Applications, 7, 713-719. doi: 10.4236/jsea.2014.78066.