{'fraction_non_alphanumeric': 0.02148148148148148, 'fraction_numerical': 0.0007407407407407407, 'mean_word_length': 5.622549019607843, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 1, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 1, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Relational database of treatment planning system information

The purpose of the present work was to develop a relational database and associated applications to facilitate retrospective review of data present in radiation treatment plans. The data source was a commercial radiation treatment planning system (Pinnacle3, Philips Medical Systems, Milpitas CA), which is specifically characterized by an open data storage format and internal scripting capability. The database is an open-source, relational database (PostgreSQL, PostgreSQL Global Development Group, http://www.postgresql.org). The data is presented through a web interface in addition to being fully query-accessible using standard tools. A database schema was created to organize the large collection of parameters used to generate treatment plans as well as the parameters that characterized these plans. The system was implemented through a combination of the treatment planning systems internal scripting language and externally executed code. Data is exported in a way that is transparent to the user, through integration into an existing and routinely-used process. The system has been transparently incorporated into our radiation treatment planning workflow. The website-based database interface has allowed users with minimal training to extract information from the database.