A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Quock, D. E.R.

Paper Title Page
RPPB34 Global Search Tool for the Advanced Photon Source Integrated Relational Model of Installed Systems (IRMIS) Database 683
 
  • M. B. Cianciarulo
    Purdue University, West Lafayette, Indiana
  • D. E.R. Quock
    ANL, Argonne, Illinois
 
  The Integrated Relational Model of Installed Systems (IRMIS) is a relational database tool that has been implemented at the Advanced Photon Source to maintain an updated account of approximately 600 control system software applications, 400,000 process variables, and 30,000 control system hardware components. To effectively display this large amount of control system information to operators and engineers, IRMIS was initially built with nine Web-based viewers: Applications Organizing Index, IOC, PLC, Component Type, Installed Components, Network, Controls Spares, Process Variables, and Cables. However, since each viewer is designed to provide details from only one major category of the control system, the necessity for a one-stop global search tool for the entire database became apparent. The user requirements for extremely fast database search time and ease of navigation through search results led to the choice of Asynchronous JavaScript and XML (AJAX) technology in the implementation of the IRMIS global search tool. Unique features of the global search tool include a two-tier level of displayed search results, and a database data integrity validation and reporting mechanism.  
RPPB35 Administration of Control Systems at the Advanced Photon Source Using Applications Organizing Index 686
 
  • N. D. Arnold, D. E.R. Quock
    ANL, Argonne, Illinois
 
  Applications Organizing Index (AOI) is a relational database tool that has been implemented at the Advanced Photon Source (APS) to aid in the management of more than 600 unique control system applications. AOI provides control system developers an intuitive view of and navigation links to the components that make up a single control system such as source code files, operator displays, process variables, work history notes, programmable components, validation procedures, drawings, and more. The foundation for the Applications Organizing Index tool is the collaborative effort between several Experimental Physics and Industrial Control System (EPICS) sites to build the common relational database schema for documenting large and complex particle accelerator control systems, Integrated Relational Model of Installed Systems (IRMIS). This paper describes the evolution of AOI as it became populated with APS control systems component data and as users’ requests for new features of AOI became apparent.