{'fraction_non_alphanumeric': 0.009420289855072464, 'fraction_numerical': 0.0, 'mean_word_length': 5.165178571428571, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
An Integrated Data-Warehouse-Concept for Clinical and Biological Information

The development of medical research networks within the framework of translational research has fostered interest in the integration of clinical and biological research data in a common database. The building of one single database integrating clinical data and biological research data requires a concept which enables scientists to retrieve information and to connect known facts to new findings. Clinical parameters are collected by a Patient Data Management System and viewed in a database which also includes genomic data. This database is designed as an Entity Attribute Value model, which implicates the development of a data warehouse concept. For the realization of this project, various requirements have to be taken into account which has to be fulfilled sufficiently in order to align with international standards. Data security and protection of data privacy are most important parts of the data warehouse concept. It has to be clear how patient pseudonymization has to be carried out in order to be within the scope of data security law. To be able to evaluate the data stored in a database consisting of clinical data collected by a Patient Data Management System and genomic research data easily, a data warehouse concept based on an Entity Attribute Value datamodel has been developed.