Skip to main content

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).

Submitted by elamb on