A database for superconducting cavities for the TESLA test facility

Abstract We look back on 10 years experience using a database for superconducting cavities for the TESLA Test Facility (TTF). The database was developed to collect data of every preparation step and measurement in order to optimize cavity production and preparation techniques to meet the ambitious goal of high accelerating gradients at high quality factors. Data from 110 superconducting 9-cell cavities, 50 single cell cavities, several 2- to 7-cell cavities and about 60 RF couplers were collected in the database. In addition, company measurements on sub-assemblies and parts forming the next 30 9-cell cavities were stored, thus establishing the database as part of a quality management system. This database is dynamically accessible via an extensive graphical web-interface based on ORACLE products, which enables the users to select and analyse the collected data easily from anywhere.