DATABASE OPERATION USING ODBC/JDBC IN THE KEK 8GeV LINAC

The KEK 8GeV Linac (linear accelerator) has been using an operation database consisting of PCs (personal computers) and MS-SQL (1) on a Windows NT server. An automatic database logging system for Linac operation and attendant problems has been completed. The Linac has both static and dynamic databases, which store accelerator data, a troubleshooting log and operator's notes (2,3) . The console is composed of an MS- Access integrated, and GUI (graphical user interface) and applications written in VB (visual basic) linked to the database using ODBC (open database connectivity). Recently, the need for web-based applications linked to a database has grown (4) , and JDBC (Java database connectivity) has enabled this. This treatise compares ODBC and JDBC, both of which are used in the Linac PC system, and reports the issue of their application.