The REDACLE Work-Flow Management System

A MySQL-based system handles the data management, quality control and bookkeeping for building a new scientific instrument with 500,000 parts. Here's how you can adapt it for your manufacturing process.

Giovanni Organtini (G.Organtini@roma1.infn.it) teaches Computing and Programming for Physicists at the University of Rome. He has been a Linux user both for research and teaching for nine years, and he has been married to Federica for ten. He is involved in the design and realization of particle detectors and advanced computing for high-energy Physics.

Luciano M. Barone (Luciano.Barone@roma1.infn.it) is Associate Professor of Physics at Rome University La Sapienza. Born to physics as a high-energy experimentalist, he quickly turned to computing applications in the same field. He likes to tackle large problems and tame them to the finest detail.

______________________

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: The REDACLE Work-Flow Management System

Anonymous's picture

Is there a missing Parts table example in the article? Tables 1 and 2 are mentioned in the 2nd paragraph of the REDACLE:the Database Design section. The table 2 example seems to pertain to text found later in the article.

I would like to see the schema for the partDefinition table.

Webinar
One Click, Universal Protection: Implementing Centralized Security Policies on Linux Systems

As Linux continues to play an ever increasing role in corporate data centers and institutions, ensuring the integrity and protection of these systems must be a priority. With 60% of the world's websites and an increasing share of organization's mission-critical workloads running on Linux, failing to stop malware and other advanced threats on Linux can increasingly impact an organization's reputation and bottom line.

Learn More

Sponsored by Bit9

Webinar
Linux Backup and Recovery Webinar

Most companies incorporate backup procedures for critical data, which can be restored quickly if a loss occurs. However, fewer companies are prepared for catastrophic system failures, in which they lose all data, the entire operating system, applications, settings, patches and more, reducing their system(s) to “bare metal.” After all, before data can be restored to a system, there must be a system to restore it to.

In this one hour webinar, learn how to enhance your existing backup strategies for better disaster recovery preparedness using Storix System Backup Administrator (SBAdmin), a highly flexible bare-metal recovery solution for UNIX and Linux systems.

Learn More

Sponsored by Storix