Supporting ad-hoc queries in an integrated clinical database

Whether caring for patients or conducting research, medical decision-makers need access to clinical data. To fulfill that need, commercial software developers have produced a wide range of database query tools that differ greatly in functionality and cost. Generally, tools that have a greater ability to conceal database complexity from the user also require more effort for administrative setup. We describe a cost-effective, commercially-available query tool that requires no special setup to perform most simple queries, yet can be customized to satisfy users' more complex querying requirements.