Jesse Clark
2012
When the mission evaluation manager decides it is safe
based on input from each team
(propulsion, avionics, life support, etc)
based on reports from technicians that have been analyzed by engineers and closed as acceptably safe.
“We don't fly with open paper.”
With a paper-based system, searching or summarizing all outstanding reports can take hours, in which time conditions can change.
We don't fly with open paper.
SELECT
COUNT(*)
FROM
problem_reports
WHERE
status = "OPEN";
Which components should we re-check in cold weather?
SELECT
component, COUNT(*), MAX(severity)
FROM
problem_reports
WHERE
description LIKE "%cold weather%"
GROUP BY
component
ORDER BY
MAX(severity) DESC;
Have any parts from Manufacturer X
had problems in the last 3 years?
(A problem can link to a part.)
SELECT
part_id
FROM
problem_reports
LEFT JOIN parts ON parts.id = problem_reports.part_id
WHERE
parts.manufacturer = "X"
AND
problem_reports.date > DATE_SUB(NOW(), INTERVAL 3 YEAR);
Automatically generate complex queries
Have any parts from Manufacturer X
had problems in the last 3 years?
(A problem can link to multiple parts.)
SELECT
problem_reports.id, title, severity, likelihood, status
FROM
problem_reports
LEFT JOIN problem_parts
ON problem_parts.problem_id = problem_reports.id
LEFT JOIN parts
ON problem_parts.part_id = parts.id
WHERE
parts.manufacturer = "X"
AND
parts.maintenance_date > DATE_SUB(NOW(), INTERVAL 3 YEAR);
GROUP BY
problem_reports.id
Jesse Clark