50 likes | 165 Views
DB Current Status. 07.09.2010 Polenkevich Irina. The general requirements on DB. Access through the Internet; DB backup to do automatically (once per week); Obligatory filling of all specified parameters for each straw;
E N D
DB Current Status 07.09.2010 Polenkevich Irina
The general requirements onDB • Access through the Internet; • DB backup to do automatically (once per week); • Obligatory filling of all specified parameters for each straw; • Sorting of straws by the set of parameters and parameter range: example " width of a seam " = (0.4-0.8) mm, "diameter" D = (9.75-9.77) mm … • Automatic filling of specified histograms for the reporting (manufacturing straw: tested, good, bad, stored, ready for installation, installed, etc.); • Impossibility of installation to the detector bad straws and straws without label; • Editing (in manual mode) information for restored straws and approve theirs for installation in the detector; • Access - mode of privileges and passwords. PHP+MySQL All these requirements is satisfied MYSQL data base server and web-server (Apache) with interface written on PHP by Ira Polenkevich. For the user side it is necessary only the ordinary software: Internet Explorer, Netscape Navigator or any another Explorer.
Software • On server na62.jinr.ru was installed: • database server Mysql (version 5.5.4); • http server Apache (version 2.2.16); • Php (version 5.3.3). Straw data transfer
General view http://na62.jinr.ru/straw • Pages for working with • “Tape parameter” • “Straw parameter” • “Straw tests” • “Frame parameter” • “Straw manufacturing”: • insert, edit, delete, search, analyze etc, depending from your priority Page for short description and latest news
Future develope On this week: full transferring of database statistics on new global server na62-jinr.ru; debugging and testing of its working capacity.