The Risk Map: Architecting an Obsolescence-Immune Data Foundation
1. The Flat Table Trap (Excel is Dead) Managing an industrial Bill of Materials (BOM) through spreadsheets is a structural deficiency. Excel provides a two-dimensional environment for a three-dimensional problem. Hardware engineering and manufacturing dependencies operate under a graph logic. When the procurement department receives an End of Life (EOL) alert for a component, calculating the volumetric impact by searching text across multiple static documents introduces operational latency. The UNE-EN IEC 62402:2019 standard, in its Clause 8.10 (Data Acquisition), establishes the requirement to maintain “a list of configuration sub items within an item” alongside “the identification of the items and sub items details: manufacturer, part number and specification”. Achieving the level of parametric traceability demanded by the standard requires the design of a relational data model. ...