1 / 5

General Requirements for Database Management System on Straw Manufacturing

This document outlines the general requirements for a database management system overseeing straw manufacturing, focusing on automatic internet access, weekly backups, mandatory parameter inputs for each straw, and robust sorting capabilities based on specified parameters. It details the need for automatic histogram filling for reporting, restrictions on installation involving defective straws, and user editing capabilities for restored straws. The database server (MySQL) and web server (Apache) setup is specified, along with access privileges. The system is designed for compatibility with common browsers for user access.

thy
Télécharger la présentation

General Requirements for Database Management System on Straw Manufacturing

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. DB Current Status 07.09.2010 Polenkevich Irina

  2. 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.

  3. 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

  4. 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

  5. Future develope On this week: full transferring of database statistics on new global server na62-jinr.ru; debugging and testing of its working capacity.

More Related