Architecture and Functions of Database Management System
for Tracking and Management of Tools
Zornitsa Zaharieva1 , Roman Zahariev2
1 Sofia University "St. Kliment Ohridski", Faculty of Mathematics and Informatics, Bulgaria
2 Central Laboratory of Mechatronics & Instrumentation, 1113 Sofia
Abstract: This work addresses the Manufacturing and Test Folder (MTF) System and in particular its extension the Tools Folder, which will not only manage basic technical characteristics about the tools, but will also handle more advanced information like calibrations and inspection results and track changes of these over time. It will also be able to log all operations performed on the tools. The MTF and especially its web-based interface was first created to facilitate the production follow-up and capturing of test data for equipment to be installed in the Large Hadron Collider (LHC) at CERN (The European Organization for Nuclear Research). Now the functionality of MTF is being extended to also include the handling of important tools used at CERN . This new functionality of the MTF is implemented in the Tools Folder, and will become essential for the correct and optimal usage of complex and valuable tools throughout their life cycles at CERN.
Keywords: Management and Tracking of Equipment, Tools Folder, Engineering Data Management System at CERN, MTF, Web Interface, Oracle Databases,
PL/SQL.