The Use of NoSQL in Product Traceability System Construction

Product traceability system is one significant part of the modern production system, and it supports the product quality assurance by providing traceable life-cycle information about one product. By using entity-relationship model and relational database to construct a product traceability system, some problems arise when facing complex products. Three problems include entity/table explosion, query disaster and sorting problem are analyzed, then NoSQL is adopted to overcome these disadvantages. Finally, a case study about a product traceability system for pleurotus eryngii cultivation is introduced. The result demonstrates that the document type NoSQL can fix the entity/table explosion, query disaster and sorting problem easily. This solution can be used as references to those products that have plenty of unstructured production components, stages and process.