Author: F. Michael Hemmer
Institution: Brookhaven National Laboratory
Two Tier Client/Server Database Development For Alignment Data At The Relativistic Heavy Ion Collider And Alternating Gradient Synchrotron
This paper describes the development of the two tier client/server database program, "SurvBase", implemented for accelerator alignment data management at the Alternating Gradient Synchrotron and the Relativistic Heavy Ion Collider at Brookhaven National Laboratory. Integration of Windows NT, Visual Basic 5.0 and Sybase ODBC program development environment components is explained. Logic and algorithms for data flow and integrity are given along with SQL and VB code examples. Program expansion capacity and back end Relational Database Server switching are discussed.