To download the FDA POCA software, click on the following link. Save the installation zip file to your computer and follow the instructions in the POCA Installation Guide that is part of the zip file.
POCA System Overview
The Phonetic and Orthographic Computer Analysis (POCA) program is a software tool that uses an advanced algorithm to determine the orthographic and phonetic similarity between two drug names. The program can compare a drug name against multiple drug names found in several different “data sources” contained in the software. The two data sources provided through this download are Drugs@FDA and RxNorm.
This zip file contains both a compiled version of the POCA application and the source code. The compiled version has been tested and installed on a number of computers.
POCA is a web-based application that was originally developed for the Microsoft .Net Framework 1.1 and the Oracle 9i Database. It has now been upgraded to include the following:
- Microsoft .Net Framework 4.0 and the Oracle 12c Database.
- Revised orthographic algorithm (for more information on the revised algorithm, see Medication Errors Related to Drugs
Prior to installing the POCA database and application, it will be necessary to ensure that the Microsoft .Net Framework 4.0 and Internet Information Services (IIS) are installed on the computer hosting the web application, and that Oracle 12c Database software is installed on the computer hosting the database (these may be on the same computer). Following the instructions in the supplied “POCA Installation Guide”, download and create POCA database. The POCA web application files are downloaded to the computer’s hard drive, which will configure the web server.
Once the application is up and running, instructions for using the application can be found in the POCA User Guide file that can be downloaded from the link above. This file is also available from the “Help” link in the application.
Files and Folders in the zip file
- POCA_DB_Install Folder
This contains two scripts and an ORACLE backup .dmp file that will be used to create an Oracle database and import data and PL/SQL routines into the database.
POCA_Datasources Folder (inside the POCA_DB_Install folder)
This contains a single ascii file in a specific format. Files in this format can be used as data sources for POCA. A description of this format is supplied as a spreadsheet called data_source_template.xls. Please note that POCA data sources must be in the ascii specific pipe delimited format. POCA does not directly accept spreadsheet data
- POCA Installation Guide.doc
This document is the instructions for installing the POCA database and application.
- Poca_Published_Files Folder
This folder contains the compiled version of the POCA application ready to run on a Windows system.
- Poca_Source_Code Folder
This folder contains the source code for the POCA application for those who want to investigate the algorithms and/or change them.
- Technical Information Folder
Contains the following files:
- POCA ER diagram.pdf
This ER diagram is provided as a reference so users can understand how the tables relate to each other and to get a general feel for the size of the system.
- FDA POCA TECHNICAL USERS GUIDE
Some of this refers to how POCA is set up at FDA and is not relevant to installing POCA. This might be useful to a programmer who wanted to modify the POCA system.
- ODAC folder
This folder contains different versions of the Oracle.DataAccess.dll file that you may need to use during installation (see the installation guide).
- Monthly Drugs@FDA and RxNorm Downloads
Please find listed below the monthly downloads of Drugs@FDA and RxNorm to be copied to folder per installation guide.
For more information on the POCA 4.0 update, see the POCA 4.0 Update Webpage
For more information on medication errors related to drugs, see the Medication Errors Related to Drugs Webpage