User Generated SQL Queries Inform Evaluation of NSSP ESSENCE

Description: 

As system users develop queries within ESSENCE, they step through the user-interface to select data sources and parameters needed for their query. Then they select from the available output options (e.g., time series, table builder, data details). These activities execute a SQL query on the database, the majority of which are saved in a log so that system developers can troubleshoot problems. Secondarily, these data can be used as a form of web analytics to describe user query choices, query volume, query execution time, and develop an understanding of ESSENCE query patterns.

Objective:

The objective of this work is to describe the use and performance of the NSSP ESSENCE system by analyzing the structured query language (SQL) logs generated by users of the National Syndromic Surveillance Program'¬ôs (NSSP) Electronic Surveillance System for the Early Notification of Community-based Epidemics (ESSENCE).

Primary Topic Areas: 
Original Publication Year: 
2018
Event/Publication Date: 
January, 2018

January 25, 2018

Contact Us

INTERNATIONAL SOCIETY FOR
DISEASE SURVEILLANCE

288 Grove Street, Box 203
Braintree, MA 02184
(617) 779 0880
Email:syndromic@syndromic.org

This Knowledge Repository is made possible through the activities of the Centers for Disease Control and Prevention Cooperative Agreement/Grant #1 NU500E000098-01, National Surveillance Program Community of Practice (NSSP-CoP): Strengthening Health Surveillance Capabilities Nationwide, which is in the interest of public health.

Site created by Fusani Applications