跳到主要內容

臺灣博碩士論文加值系統

(107.21.85.250) 您好!臺灣時間:2022/01/18 09:01
字體大小: 字級放大   字級縮小   預設字形  
回查詢結果 :::

詳目顯示

: 
twitterline
研究生:廖正國
研究生(外文):Cheng Kuo Liao
論文名稱:一個關連式資料庫的物件界面元件產生器
論文名稱(外文):A Relational-to-Object Interfaces Component Generator
指導教授:楊千楊千引用關係
指導教授(外文):Chyan Yang
學位類別:碩士
校院名稱:國立交通大學
系所名稱:資訊管理所
學門:電算機學門
學類:電算機一般學類
論文種類:學術論文
論文出版年:2002
畢業學年度:90
語文別:英文
論文頁數:52
中文關鍵詞:關連式到物件軟體元件COM程式碼產生器SQL-DMO應用程式架構由資料庫到全球資訊網
外文關鍵詞:relational-to-objectcomponent-basedcomponent object model (COM)code generatorSQL-DMOapplication frameworkdatabase-to-www
相關次數:
  • 被引用被引用:0
  • 點閱點閱:348
  • 評分評分:
  • 下載下載:71
  • 收藏至我的研究室書目清單書目收藏:0
關連式資料庫管理系統乃當今商業資訊系統之主要資料儲存與管理系統。另一方面,物件導向技術則已成為大型軟體開發之主流方法。為關連式資料庫提供一組物件界面,可以為資料庫應用程式的開發帶來一些物件科技的優點。然而為關連式資料庫提供物件界面,一向被認為是一件耗費時間且又容易出錯的工作。在本篇論文裡,我們提出一個稱為「資料庫存取元件產生器(DACG)」的架構,可以用來消除建立資料庫物件界面所需的程式工作。DACG有兩個主要優點:一、它是一個「免寫程式」的架構,DACG的使用者可以不需要寫一行程式便可產生資料庫的物件界面。二、DACG產生的元件有很好的可重複使用性,它們可以被多種程式語言的發展環境裡所使用。DACG的核心是一個以應用架構(Application Framework)為基礎的程式碼產生器。DACG採用「元件導向軟體工程」的方法來縮短發展的時程,其下層的元件模型則是微軟的Component Object Model (COM),因此它可以用任何支援COM的物件語言來實作。本篇論文同時也呈現一個DACG的實作系統,我們選擇的程式語言是Visual Basic,後端的資料庫系統則是Microsoft SQL Server。此外,本篇論文最後也以一Web應用程式-「線上徵才系統」為例,展示了DACG Component的實際應用。

The Relational Database Management Systems (RDBMS) is the dominant data management technology of today’s business information system. Meanwhile, object-oriented methodology has become the mainstream approach of building large-scale software applications. Providing an object-based abstraction of database access can bring the advantages of object technology to the database-intensive applications. However, it is known that providing object interfaces of RDBs is very time-consuming and error-prone, and usually the object interfaces cannot be reused. In this paper, we propose an architecture called “Data Access Component Generator (DACG)” to eliminate the programming efforts of the data object interfacing task. DACG has two major advantages. First, it is a code-free architecture; the user of DACG can build data interfaces without writing any source code. Second, the data interfaces have great reusability; they can be reused in several programming languages. The kernel of DACG is a framework-based code generator. DACG adopt the Component-Based Software Engineering (CBSE) to shorten its development cycle. The underlying component model of DACG uses the Microsoft’s Component Object Model (COM). Therefore it can be implemented in any COM-complied language. A DACG implementation with Microsoft SQL Server as the backend DBMS is also presented. Visual Basic Application version (VBA) was chosen as the programming language to implement our system. Moreover, this research has demonstrates the usage of DACG components by applying it to achieve the database-to-www bridging in real world web applications.

Contents
1. Introduction 1
1.1. Motivation 1
1.2. Research Purposes 2
1.3. Research Process 3
2. Literature Review 4
2.1. Object-Relational Approach 4
2.2. Software Component Technology 5
2.2.1. Component-based software engineering─the emerging methodology 5
2.2.2. Definitions 5
Software Element and Software Component 6
Component Model and Component Model Implementation 6
Interaction and Interface 6
Composition 7
Software Component Infrastructure 7
2.2.3. Components and Objects 7
2.2.4. Component Models 8
Interfaces 9
Naming 11
Meta Data 11
Interoperability 12
Customization 13
Composition 13
Evolution Support 14
Packaging and Deployment 14
Component Model Implementation and Services 15
2.3. COM 15
2.3.1. The Component Model for Microsoft Windows Family 15
Corresponding element in COM 16
COM Components and Objects 17
Interfaces 17
Naming 18
Meta Data 18
Interoperability 19
Customization 19
Composition 21
Evolution Support 21
Packaging and Deployment 22
2.4. Universal Data Access 22
2.5. SQL-DMO 24
3. Data Access Component Generator (DACG) 26
3.1. System Design 26
3.1.1. System Architecture 26
3.1.2. DACG Template Project 28
Database Connection Unit 29
Data object Class Template 29
Data Object Collection Class Template 29
Error Handling Unit 29
Project Control Template File 29
3.1.3. Schema Extractor 30
3.1.4. Code Generator 30
Data connection unit 30
Data Object Class 31
Data Object Collection Class 31
Error Handling 31
Project Control File 31
DACG project element 32
3.1.5. DACG Coordinator 32
3.2. Implementation 34
3.2.1. Template Project 35
Database Connection Unit 35
Data Object Class Template 36
Data Object Collection Class Template 38
Error Handling Unit 39
Project Control Template File 40
3.2.2. Schema Extractor 42
3.2.3. Code Generator 42
3.2.4. DACG Coordinator 43
4. Accessing Databases from WWW by using DACG components 45
5. Conclusions and Future Works 49
6. References 51
1. M. Stonebraker, D. Moore(1996), Object-Relational DBMSs: the Next Great Wave, San Francisco: Morgan Kaufmann, pp1-216.
2. I. M. Kwon, C. O. Kim, J. Jun, and S. S. Kim, “Building Generic Data Interface through a Data Object Generalization Pattern”, Journal of Object-Orient Programming, 13(6), pp6-10.
3. G.T. Heineman and W.T. Councill(2001), Component-Based Software Engineering: Putting The Pieces Together, New York: Addison-Wesley, pp1.500.
4. Thuan L. Thai(1998), Learning DCOM, Cambridge: O’Reilly, pp12-16.
5. J. W. Rahayu, E. Chang, T. S. Dillon, and D. Taniar, “Performance evaluation of the object-relational transformation methodology,” Data & Knowledge Engineering, 38(2001), pp265-300
6. S. Bergamaschi, A. Garuti, C. Sartori, and A. Venuta(1997), “Object Wrapper: an Object-Oriented Interface for Relational Databases,” Proceedings of the 23rd EUROMICRO Conference, Budapest, pp41-46.
7. A. M. Keller, R. Jensen, and S. Agarwal, “Persistence Software: Bridging Object-Oriented Programming and Relational Databases,” ACM SIGMOD Re-cord, 22(2), pp523-528.
8. Clemens Szyperski(1997), Component Software: Beyond Object-Oriented Programming, New York: Addison-Wesley, pp1-343.
9. Don Box (1998), Essential COM, New York: Addison Wesley Longman. pp1-440.
10. R.R. Ling, D.C. Yen, and D.C. Chou(2000), "From Database to Web Browser: The Solutions to Data Access," Journal of Computer Information System, Winter 2000-2001, pp58-63.
11. Microsoft(2000), SQL-DMO Objects and SQL Server Administration, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con01_2yi7.asp.
12. Mohamed E. Fayad(2000), “Object-Oriented Application Frameworks,” ACM Computing Surveys, 32(1), pp1-9.
13. C. S. Peng, S. K. Chen, J. Y. Chung, A. R. Chowdhury, and V. Srinivasan (1998), “Accessing existing business data from the World Wide Web”, IBM System Journal, 37(1), pp115-132.
14. T. Barsalou, Niki Siambela, A. M. Keller, G. Wiederhold(1991), Updating Relational Databases through Object-Based Views, ACM SIGMOD Record, 20(2), pp258-257
15. E. Petroutsos(1999), Mastering Database Programming with Visual Basic 6, San Francisco: Sybex, pp1-859.
16. S. Powers(2001), Developing ASP Components, 2ed, Sebastopol: O’Reilly, pp180-295.

QRCODE
 
 
 
 
 
                                                                                                                                                                                                                                                                                                                                                                                                               
第一頁 上一頁 下一頁 最後一頁 top