Systematic embodiment of supply chain network through designing the optimal database structure

In the past, many researchers suggested a variety of supply chain network models which encompass both the upstream and downstream sides. However, most of the supply chain models were conceptual network map and focused on individual firm or industry level. In this paper, we analyzed and embodied more substantive supply chain network model based on the optimal database comprised of US patent data, STN International patent data and Harmonized System (HS) code data. We designed 4 relational database sets. First set consists of the list of traded commodities and their HS code. The second is about matching relation between traded products and their raw or intermediate materials. The third is composed of diverse usage databases of raw or intermediate materials compiled by using patent data, and the fourth is about the patent data of individual substances. Then, we implement visualizing the supply chain network from raw materials to traded products by linking 4 database sets. We demonstrate the supply chain network of a medical patch as an application of our technique.