No. ISO 22400 does not require a separate KPI database, and AS9100 does not inherently force one either.
What you do need is a controlled way to define, calculate, trace, review, and change KPI logic across the systems you already have. In practice, that can be implemented in several ways:
- inside an MES or manufacturing data platform
- in a historian or analytics layer
- in a data warehouse or KPI repository
- across existing systems with governed calculations and documented mappings
The right answer depends on your data landscape, validation burden, reporting latency needs, and how much inconsistency already exists across plants or programs.
What matters more than a separate database
In a regulated aerospace environment, the key question is not whether the KPI data sits in a separate database. The key question is whether you can show that:
- each KPI has a controlled definition
- source data is identifiable and traceable
- calculation logic is versioned and change-controlled
- time stamps, units, context, and production states are interpreted consistently
- users can distinguish operational dashboards from quality records or formal evidence
- data corrections, exclusions, and overrides are documented
If those controls are weak, a separate KPI database will not solve the real problem. It may only move it.
When a separate KPI database can make sense
A dedicated KPI repository or analytics store can be useful when your current environment is fragmented or performance reporting is contested. Common reasons include:
- multiple MES, ERP, QMS, and machine data sources use different event models
- plants calculate the same KPI differently
- the historian is not structured for business-level metric governance
- you need a stable semantic layer for enterprise reporting
- production systems should not carry heavy analytical query loads
- you need to preserve KPI calculation versions over time
In those cases, a separate layer can improve standardization and reporting performance. But it only helps if integration mapping, master data alignment, and change governance are mature enough to support it.
When it is the wrong move
It is often the wrong move if the real issues are poor source data quality, missing event context, inconsistent equipment states, or weak process discipline. A separate KPI database can introduce additional failure modes:
- duplicate data pipelines that drift from source systems
- reconciliation disputes between shop floor, quality, and finance views
- extra validation effort for calculations and interfaces
- unclear ownership of KPI definitions
- more change-control overhead every time routings, reason codes, or data models change
In brownfield environments, this is common. Plants already have layered MES, ERP, PLM, QMS, historians, spreadsheets, and local reporting tools. Adding one more database without resolving system-of-record boundaries usually increases integration debt.
AS9100-specific considerations
AS9100 is concerned with effective process control, objective evidence, traceability, and disciplined management of changes. It does not prescribe a KPI database architecture.
However, if KPI outputs are used to support management review, corrective action, process performance evaluation, or audit evidence, you should expect scrutiny of:
- where the data came from
- how calculations are performed
- who can change definitions or thresholds
- how revisions are approved and communicated
- whether historical KPI values remain interpretable after process or system changes
That means governance matters as much as storage location. If a KPI layer is separate, its interfaces and logic may need the same discipline as other regulated manufacturing systems, especially when metrics influence quality or release-related decisions.
Practical recommendation
Start with a KPI architecture decision, not a database decision.
For most aerospace and other regulated brownfield operations, a pragmatic approach is:
- define a controlled KPI catalog aligned to ISO 22400 concepts and your operating model
- identify source systems and system-of-record boundaries for each input
- standardize event meanings, reason codes, units, calendars, and master data
- decide whether calculations belong in MES, historian, analytics, or a dedicated repository based on latency, traceability, and maintenance burden
- apply change control to formulas, mappings, and exclusions
- validate that reported values can be reproduced from source data
If your current stack can do that reliably, you may not need a separate KPI database. If it cannot, a dedicated KPI layer may be justified, but only as part of a governed integration design.
Full replacement is usually not the practical answer in AS9100 environments. Replacing MES, ERP, QMS, or historians just to simplify KPI reporting often fails because of qualification burden, validation cost, downtime risk, legacy equipment integration, and long asset lifecycles. Coexistence is usually the safer path, but it requires clear ownership and disciplined data governance.