The development of a grinder BOM relational data by the use of quality function deployment concept

關聯式資料庫在建立資料間關係上，資料模型化能力弱，無法記錄一個複雜的資料結構，若要描述物件與物件之間的複雜關係，必須另外建立一個表格處理，當資料量越來越多時，必須額外新建更多的表格才足以應付需求，並且在描述物件間的關係上，欠缺系統性的方法，通常依資料庫設計者的經驗、方法及知識水準不同而有所差別。 為了改善關聯式資料庫欠缺系統性建立資料間關聯的問題，本研究提出利用品質機能展開的觀念於建立資料的關聯性。利用品質機能展開的部署策略及其一系列具有邏輯性的展開系統，幫助資料庫系統中階層關係的建立，同時產生資料間的關聯性，並透過關聯式資料庫建立資料關聯的完整性。最後以建構磨床材料清單資料庫為例，說明如何利用本研究所提出的方法，建立磨床材料清單資料庫，表達材料清單各層級零件的組成關係、材料的資訊以及材料間的關係。 本研究的結果有三項：第一，利用品質機能展開具有邏輯性的展開特性，有系統地建立資料庫系統中的階層關係，利於處理眾多關係複雜的物件，幫助資料庫設計者能夠有系統地產生物件關聯。第二， 利用品質機能展開的關念於建構關聯式資料庫之初步規劃後，透過關聯式資料模式與正規化步驟，建立資料間其它可能的關聯，並且消除資料庫中各種可能的異常現象，以建立資料關聯的完整性。第三，利用本研究所提出的方法，建立磨床材料清單資料庫，有效率地建構材料清單樹狀結構中各層級零件的組成關係，並且整合材料的相關資訊以及材料間的關係。When establishing data relationships in a relational database, the database is limited in its data modeling capability and it is also incapable of recording complicated data structures. In order to describe complicated relationships between objects, the database requires another table to accomplish the task. As the data volume increases, the number of table entries increases as well in order to meet this demand. Furthermore, the database lacks a systematic method for describing the relationship between objects. Often times, the results would vary depending on the database designer’s level of experience, expertise, and the method of data entry. In order to address the lack of a systematic method in relational databases for establishing data relationships, this study applied quality function deployment concept to establish data relationships. The logical expanding strategy system from quality function deployment was applied to help the database to establish relationships in the middle levels, and also to make connections between the data. Furthermore, the relational database was used for the completeness of the database. Finally, the grinder bill of material was used as an example to illustrate how to apply the method developed in this study to establish its database. This expressed the component relationships in each level, the information about the materials, and the relationships between materials. There are three results in this study: the first is the application of quality function deployment, which has the characteristic of logical expanding, and which was used to systematically develop the relationships for the middle levels in the database. It is especially useful when applied to complicated objects which have many processes. It also helps the database designer to systematically create relationships for the objects. Second, after applying quality function deployment concept to the construction of a relational database, the process of normal form of relational database is implemented in order to develop possible relationships between the data and it also helps to eliminate any possibility of unusual phenomena in the database, which facilitates the development of a complete database. Third, the method was applied in this study to construct a database for grinder bill of material. It efficiently formed the relationships for the components in each middle level of the tree structure of the bill of material, and also integrated the information about the materials and the relationships between materials