1 / 1

SNS Daily News

Related Story: SNS DBA collapses at “Yes, we have a database” brown-bag. Overwork could be cause. SNS Daily News. Weather Sunny and Warm (It’s always sunny in Oak Ridge). On The Web: WWW.SNS.GOV. Wednesday, October 25, 2006.

geneva
Download Presentation

SNS Daily News

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Related Story: SNS DBA collapses at “Yes, we have a database” brown-bag. Overwork could be cause. SNS Daily News Weather Sunny and Warm (It’s always sunny in Oak Ridge) On The Web: WWW.SNS.GOV Wednesday, October 25, 2006 D. Purcell, W. Blokland, A. Liyu, J. Patton, T. Pelaia, S. Zhukov Trumpets Sound OverSNS IOCs Use of Relational Database to Supply Configuration Files By David Purcell The process saves time. Rollbacks are easy. Files manipulated with database tools and file editors. Other data from relational database available for use. Versions secured and controlled. Purcell toots horn at celebration party. Engineer Sees Wife for First Time Since Being Hired. Inside By Jeff Patton How They Did It By Andrei Liyu and Sasha Zhukov RDB HTTP Socket Library TCP/IP Web server – RDB connectivity: PHP, JSP, ASP The SNS RDB is Oracle based. Its schema is extensive and includes many different types of data related to the SNS control system. Page 1 By Tom Pelaia and Wim Blokland With the use of web-based tools, java applications, and simple SQL, SNS engineers can now easily update their deployed IOCs and then Controls System Object Database Server Web Server Controls System Object leave work, often before dinner. The engineers Software IOCs are modified to use new client library. LabView VI uses internal socket library while VxWorks implements the library via code changes to st.cmd file. Page 3 The control system object initiates a request to the web server. The web server determines the number of files required for the specific IOC, and then through a second request downloads the files from the RDB. The IOC then receives the files from the web server. Page 4 Concerns Given Pink Slip can also use the data stored within the database to keep track of the actual deployed configuration, the changes that have been made to their IOCs. They also have the ability to easily roll back if needed. Page 2 • Gone are: • Multiple IOC Logins • Concern over Type of OS • Need for Special RDB Drivers • Concern over Type of RDB Traditionalists Worried Although all seems to work with this system, some feel the potential is too great. They claim it won’t stop with configuration files. Calibration data, manufacturer’s data, analytical results, and documentation all may be next. Page 5 Users of Windows and VxWorks Agree Although there is some discrepancy over who can do it faster, users of both platforms agree it is simple to implement. Also, EPICS users the world over are rejoicing at the SNS development. The client library, HttpClientLibrary.c, is based on an EPICS Socket library from the EPICS COM library. It is reported to work on any EPICS supported OS and has been tested at SNS on both Windows and VxWorks. Page 3 ORNL/SNS is managed by UT-Battelle, LLC, for the U.S. Department of Energy under contract DE-AC05-00OR22725.

More Related