在軟體工程中，資料模型是一個抽象的模型，用來表達資料組織以及關聯資料之間彼此的關係，也用來表達真實世界中事物及事物相關的屬性，其展示出所有資料的結構及其可做的存取。由於資料組成本身是個抽象的概念，資料模型能用來支援實作出程式資料結構。我們研究團隊的研究中，基於模型驅動架構的設計方法，設計出資料模型的轉換方法。其可讓程式設計師運用高階的資料模型描述，提供資料結構的轉換決策，以轉換成實體的資料模型，再根據實作的程式語言產生真實編碼。程師設計師另可以透過一種模式語言撰寫高階資料存取描述，此方法將會對應資料模型的轉換結果，進行資料存取模型的實體轉換，產生資料存取的實體模型與真實編碼。本論文研究此方法的軟體實作並進行實驗，測試給定不同的資料結構轉換決策時，產生其實體資料結構與資料存取操作程式碼，以驗證本論文研究的軟體實作的正確性。

In software engineering, data model is an abstract modeltoexpress data organization andassociate the relationship among data. It is also used to express the attributes of things and relationships in the real world.It shows the structure and access of all data. Since data composition itself is an abstract concept, data models can be used to support realization into program data structure.Our research team designed a data model transformation method based on model-driven architecture.Programmers canwrite high-level data model description and give data structure transformation decisions.They can beconverted to physical data model, and then be generated into real codesof selected program language.Programmers can also use a pattern language towrite high-level data access description.The method can be used to transform the data access model into physical model and real code according the transformed result. In this research, the design method was implemented in software. We also carried out experiments, given various decision of data structure transformation. It can generate correct codes of physical data structure and data access to verify the correctness of the implemented software of this thesis research.

致謝 I
摘要 II
Abstract III
目錄 IV
圖次 VI
第一章導論 1
1.1 研究動機 1
1.2 研究背景 1
1.3 研究目標 4
1.4 論文大綱 4
第二章資料模型與轉換的設計 5
2.1系統架構 5
2.2資料模型轉換 6
2.2.1資料模型 7
2.2.2資料模型轉換方法 11
2.3資料存取模型轉換 15
2.3.1資料存取模型 15
2.3.2資料存取模型轉換 16
第三章系統實作設計 17
3.1 系統實作架構 17
3.1.1系統設計介紹 17
3.1.2 系統實作工具 18
3.2資料模型轉換的軟體設計 19
3.2.1來源實體關係圖實作設計 19
3.2.2資料結構特殊化層實作設計 21
3.2.3邏輯觀點層實作設計 25
3.2.4資料模型程式語言化實作設計 25
3.3資料存取模型轉換的軟體設計 26
3.3.1高階層資料存取模型 26
3.3.2 高階層到特殊化層轉換 27
3.3.3特殊化層到程式庫層轉換 28
3.3.4 程式庫層到語言層轉換 29
第四章實驗 30
4.1 實驗規劃 30
4.2 資料模型與轉換實驗 32
4.3 資料存取模型與轉換實驗 39
第五章結論 46
參考文獻 47

1. E. F. Codd, “A relational model of data for large shared data banks,” Communications of theACM, Vol. 13, No. 6, pp. 377-387, June 1970.

2. P.P.Chen, “The entity-relationship model-toward a unified view of data,” ACM Trans. on Database Systems,Vol. 1, No. 1, pp.9-36, 1976.

3. J. R.Abrial,“Data Semantics,”Proc. of IFIP Working Conf. DatabaseManagement, Jan 1974.

4. Soley, et al., MDA (Model-Driven Architecture), White Paper, Draft 3.2, OMG Staff Strategy Group, November 27-th 2000

5. G. Booch, I. Jacobson, J. Rumbaugh, The Unified Modeling Language User Guide,Addison-Wesley, 1999.

6. C. Batini and M. Lenzerini “A Methodology for Data Schema Integration in the Entity Relationship Model,” Journal of IEEE Trans. on Software Engineering, Vol. SE-10, No. 6, Nov. 1984

7. 羅治民、溫志鴻、陳伯援, “基於模型轉換方法之關聯式資料庫自動開發,”第十三屆電子化企業經營管理理論暨實務研討會論文集, 2012.

8. C. Alexander, A Pattern Language: Towns, Building, Constructions, Oxford University Press, 1970.

9. E. Gamma, R. Helms, R. Johnson, and J. Vlissides, Design Patterns: Elements of Reusable Object-Oriented Software, Addison-Wesley, 1995.

10. Tsung Lee, Transformation Design of Data Model and Data Access Model, Technical Report, Computing System Lab., Dept. of Electrical Eng., Nat’l Sun Yat-Sen Univ., June 2013.

11. 陳郁穎,一種資料模型設計的軟體實作,中山大學電機工程學系碩士論文, 2014.

12. Tsung Lee,Transformational Design of Data Model and Data Access Model, Technical Report, Computing System Lab., Dept. of Electrical Eng., Nat’l Sun Yat-Sen Univ., June 2018.

13. Stanley B. Lippman, et al., C++ Primer, 4th Ed., Addison Wesley, Jan 2008.

14. Tsung Lee and Yao-Yi Huang, A Unified Data Structure Design, Internal Research Memo, Computing System Lab., Dept. of Electrical Eng., Nat’l Sun Yat-Sen Univ., June 2012.

15. Tsung Lee and Yao-Yi Huang, A Design Pattern Transformation Tool, Internal Research Memo, Computing System Lab., Dept. of Electrical Eng., Nat’l Sun Yat-Sen Univ., June 2018.

16. Tsung Lee and Yao-Yi Huang, A Generalized Parser Design, Internal Research Memo, Computing System Lab., Dept. of Electrical Eng., Nat’l Sun Yat-Sen Univ., Feb 2012.

17. 侯捷, STL原碼剖析, 碁峯, 2002.