RAPID Administration Guide

Installation Notes

Here are some notes about the virtual machine (VM) image.

  1. The VM image is in Microsoft Hyper-V vhd format, but can be converted into other formats. It has been successfully started on Microsoft Windows, VMware, and VirtualBox hosts.
  2. The VM image contains a stock installation of Windows Server 2012 R2 and SQL Server 2012 SP1 that is current with the latest security patches (as of February 2014). In future release, the developers intend to be synchronized with the latest releases of both products.
  3. The software is licensed under GNU Affero General Public License Version 3 <https://www.gnu.org/licenses/agpl-3.0.html>. You cannot sell this software and must make freely available any modifications you make to the software.
  4. We strongly recommend that you immediately begin to implement your local institutional security and authentication protocols with the assistance of your IT and sysadmins. As a minimum, you should change the administrator password and run the VM behind your firewall as it will contain PHI.
  5. There is no mechanism or account for the developers to access your VM installation for support purposes. If you determine it is necessary for the  developers to access your VM, you would need to arrange a remote desktop session to the server and give us access.
  6. The system utilizes two different data sets, which you will load directly into the database that calls an SSIS ETL script. This is a manual process because UNOS and SRTR do not have an authenticated web services API that we can utilize to automatically download the data.
  7. The VM is large! It currently is compressed to approximately 13 gigabytes (you can thank Microsoft Windows and SQL Server), so expect a long download. After extracting the file, it is around 30 gigabytes.

Hardware Requirements

The minimum hardware requirements for RAPID are the same as SQL Server 2012. http://msdn.microsoft.com/en-us/library/ms143506.aspx.

Our testing has shown that a minimum of two CPU cores and 8 gigabytes of RAM is recommended. One of our internal test machine is 4 cores and 16 gigabytes of RAM, and the other is 8 cores and 32 gigabytes of RAM. There doesn’t seem to be much difference in performance between the two, although we have not extensively benchmarked.

You cannot use SQL Server Express because you need SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).

Disk storage requirements are low. The UNOS dataset is less than 100 megabytes even for the largest center, and each SRTR PSR is 1-2 megabytes. Each PSR is stored permanently, but the UNOS data set is stored once. Therefore, even with several years worth of data, the storage requirements would be at most a few hundred megabytes.


RAPID Architecture