跳到主要內容

簡易檢索 / 詳目顯示

研究生: 黃琬淇
Wan-Chi Huang
論文名稱: 環境資料系統化整合資料模式之發展
Development of a systematic data model for systematic integration of environmental data
指導教授: 廖述良
Shu-Liang Liaw
口試委員:
學位類別: 博士
Doctor
系所名稱: 工學院 - 環境工程研究所
Graduate Institute of Environmental Engineering
畢業學年度: 98
語文別: 中文
論文頁數: 120
中文關鍵詞: 環境資料系統思維系統化資料整合系統化物件事件方法資料模式
外文關鍵詞: Environmental data, Data model, Systematic data
相關次數: 點閱:7下載:0
分享至:
查詢本校圖書館目錄 查詢臺灣博碩士論文知識加值系統 勘誤回報
  • 在永續發展的原則下,環境管理的對象日益多元化,致使環境管理決策的重要性與影響力俱增。為求提升環境管理決策及執行之效益與效率,以解決複雜的環境管理與永續發展問題,如何掌握正確且完整的環境資料與資訊,遂成為當前應首先發展的重要工作之一。在資訊科技的發展下,環境資料的搜集、儲存與管理等問題已由資料庫系統的發展所解決;然而,在資料與資訊整合方法的部分,卻仍無太大的突破與進展。其原因主要是在於傳統的關連式資料庫與地理資訊系統,並無法有效描述、代表及重建真實世界動態變化的事物與景象,亦無法在物件化與分散式的網際網路中有效交換與整合環境資料與資訊;而近幾年所發展的物件導向資料模式、物件導向關連式資料模式等雖已使資料儲存結構更貼近真實世界的運作模式,卻仍無法確切有效滿足永續環境管理所需環境資料之有彈性與系統化整合需求。透過以污水處理廠運作管理及固定污染源整合污染管制為例的分析與探討,本研究所發展之基於系統思維之考量原則、結合物件與事件演變觀念的系統化物件事件資料模式,不但可系統化地配置真實世界存在事物的四維時空變化之紀錄外,亦能夠滿足視需求、有彈性地透過網際網路運作機制整合分散式組織分工架構下建置與維護的各類既有資料庫,根本解決資料交換及整合問題。


    Environmental problems are complex systemic problems, which can only be solved effectively with systems thinking. This means that, in the process of problem solving, information of the involving human-natural system’s structure, attributes, behaviors, relations and their dynamic changes are required for systematical analysis and problem solving. The current data models, such as relational data model, object-oriented data model, object-relational data model and object-event data model, can be used to organize certain data and are generally used by enterprise database system. However, they are not efficient and effective enough for collecting and integrating environmental data to generate the information mentioned above. In this study, a systematic object-event data model based on object-oriented thinking and systems thinking has been developed, which is more able to systematically collect and integrate environmental data. Comparing with a developed relational database through two case studies for industrial wastewater treatment plant management and integrated point source pollution management, it is shown that the SOE database is more comprehensible and flexible for data access and integration at different levels with its embedded systematic logics. Data distributed in diverse SOE databases are more capable to be significantly integrated to provide adequate information for better utilization in emergent environmental modeling or knowledge mining tools, such as declarative modeling, semantic modeling, and agent-based software or information systems.

    第一章 前言 1 1.1 研究緣起……………………………………………………… 1 1.2 研究目的……………………………………………………… 2 1.3 研究內容……………………………………………………… 3 第二章 文獻回顧 5 2.1 系統性問題與系統思維……………………………………… 5 2.2 物件導向思維………………………………………………… 11 2.3 環境資料整合………………………………………………… 16 2.4 資料模式與資料應用………………………………………… 22 第三章 研究流程與方法 29 3.1 研究流程……………………………………………………… 29 3.2 名詞界定……………………………………………………… 30 3.3 系統化物件事件資料模式之發展…………………………… 35 3.4 系統化物件事件資料模式之應用…………………………… 36 3.5 研究結果與討論……………………………………………… 37 第四章 系統化物件事件模式之發展 39 4.1 系統思維原則與系統方法…………………………………… 39 4.2 系統化物件事件方法論……………………………………… 45 4.3 真實事物的物件化、事件化、系統化描述………………… 49 4.4 系統化物件資料模式之結構………………………………… 51 4.5 系統化物件資料模式之實作………………………………… 60 4.6 資料模式之比較……………………………………………… 63 4.7 小結…………………………………………………………… 65 第五章 系統化物件事件資料模式之應用案例一:污水廠運作管理 69 5.1 工業區污水處理廠運作管理之系統界定…………………… 69 5.2 工業區污水處理廠運作管理對象之物件化與系統化……… 71 5.3 工業區污水處理廠運作管理活動之事件化………………… 73 5.4 工業區污水處理廠運作管理資料表設計與實作…………… 75 5.5 小結…………………………………………………………… 81 第六章 系統化物件事件資料模式之應用案例二:污染源整合管理 87 6.1 固定污染源整合管理背景說明……………………………… 87 6.2 污染源污染管制對象之物件化與系統化…………………… 92 6.3 污染源污染管制活動之事件化……………………………… 94 6.4 污染源污染管制物件事件資料表設計……………………… 99 6.5 小結…………………………………………………………… 108 第七章 結論與建議 109 7.1 結論…………………………………………………………… 109 7.2 建議…………………………………………………………… 111 參考文獻 113

    一、 英文部分(依字母順序排列)
    1.American National Standards Institute, ANSI (1975), “Interim Report of ANSI/X3/SPARC Group on Database Management Systems.”
    2.Athanasiadis, I. N. and P. A. Mitkas (2009), A methodology for developing environmental information systems with software agents, Whitestein Series in Software Agent Technologies and Autonomic Computing: Advanced Agent-Based Environmental Management Systems, Springer-Verlag, pp.119-137.
    3.Athanasiadis, I. N., F. Villa and A. E. Rizzoli (2007), “Enabling knowledge-based software engineering through semantic-objectrelational mappings,” Proc. of the Third International Workshop on Semantic Web Enabled Software Engineering, Fourth European Semantic Web Conference, Innsbruck, Austria, pp.16-30.
    4.Batra, D., Hoffer, J. A. and Bostrom, R. P. (1990), “Comparing Representations with Relational and EER Models,” Communications of the ACM, 33(2), pp.126-139.
    5.Bertalanffy, K. L. (1950a), “An outline of General Systems Theory,” British Journal for the Philosophy of Science, 1, pp.139-164.
    6.Bertalanffy, K. L. (1950b), “The theory of open systems in physics and biology,” Science, 111, pp.23-29.
    7.Bertalanffy, L. (1969), “General system theory,” New York: George Braziller.
    8.Brazhnik, O. (2007), “Databases and the Geometry of Knowledge,” Data & Knowledge Engineering, 61, pp.207-227.
    9.Castano, S., De Antonellis, V., Fugini, M. G., And Pernici, B. (1998), “Conceptual Schema Analysis: Techniques and Applications,” ACM Transactions on Database Systems, 23(3), pp.286-333.
    10.Chen, P. (1976), “The entity-relationship model: Toward a unified view of data,” ACM Transactions on Database Systems, 1(1), pp.9-36.
    11.Chen, Z., A. Gangopadhyay, G. Karabatis, M. McGuire and C. Welty (2007), “Semantic Integration and Knowledge Discovery for Environmental Research. Journal of Database Management,” 18(1), pp.43-67.
    12.Connolly, T. and C. Begg(1999), Database Solutions: A Step by Step Guide to Building Databases, Addison-Wesley, pp.13.
    13.Deato, M. L. and J. J. Winebrake (2000), Dynamic Modeling of Environmental Systems, Springer Press, New York, pp.12-15.
    14.Elmasri, R. and Navathe, S. B. (2004), Fundamentals of Database Systems, 4th Edition, Addison-Welsley, pp.435-438.
    15.Forrester, J. W. (1994), “Learning through system dynamics as preparation for the 21st century,” Creat. Learn. Exch., 3(3), pp.1-8.
    16.Forrester, J. W. (1994), “Learning Through System Dynamics as Preparation for 21st Century,” MIT System Dynamics in Education Project (SDEP), Online document, http://sysdyn.clexchange.org/sdep/papers/
    D-4434-3.pdf (accessed: 2009).
    17.Galbraith, P.L. (1999), “Systems thinking: a missing component in higher educational planning?” Higher Education Policy, 12, pp.141-157.
    18.Grant, W. E. (1998), “Ecology and natural resources management: reflections from a systems perspective,” Ecological Modeling, 108, pp.67-76.
    19.Halls, M. L. W., (1999), “Systems Thinking and human values: Towards understanding Performance in Organizations,” Online document, http://www.sysval.org/chapter3.html (accessed: 2009).
    20.Heylighen, F. (1998), “Basic Concepts of the Systems Approach. Principia Cybernetic,” Online document, http://pespmc1. vub.ac.be/SYSAPPR.html (accessed: Nov. 2009).
    21.Hines, M.L. (1998), “Conceptual object-oriented database: a theoretical model, Information Sciences,” 105, pp.31-68.
    22.Ison, R. L., P. T. Maiteny and S. Carr (1997), “Systems Methodologies for Sustainable Natural Resources Research and Development,” Agricultural Systems, 55(2), pp.257-272.
    23.Jolma, A. (1995), “Design and Implementation of Environmental Decision Support Systems with Object-orientation and spreadsheet. International Congress on Modelling and simulation (MODSIM 95),” Newcastle, NSW, Australia, pp.376-381.
    24.Kim, Y. G. and S. T. March (1995), “Comparing Data Modeling Formalisms,” Communications of the ACM, 38(6), pp.103-115.
    25.Kleinholz, A. (1999), “Systems ReThinking: An Inquiring Systems Approach to Art and Practice of Learning, Organizational Foundations of Information Systems,” Online Document, http://www.cba.uh.edu/~
    parks/fis/inqre2al.htm (accessed: 2009).
    26.Laycock, H. (2006), Words without Objects, Oxford: Oxford University Press.
    27.Martinez, E. C. (2000), “Systems thinking and functional modeling of batch process management using projects,” Computer and Chemical Engineering, 24, pp.1657-1663.
    28.Maier, R. (1999), Evaluation of Data Modeling, Eder et al. (Eds.): ADBIS´99, LNCS 1691, Springer-Verlag Berlin Heidelberg, pp.232 -246.
    29.Moore, S. B. and Ausley, L. W. (2004), “Systems thinking and green chemistry in the textile industry: concepts, technologies and benefits,” Journal of Cleaner Production, 12, pp.585-601.
    30.Nagarur, N. N. and J. Kaewplang (1998), “An Object-oriented decision support system for maintenance management,” Journal of Quality in Maintenance Engineering, 5(3), pp. 248-257.
    31.O’Connor, J. and I. McDermott (1997), The art of systems thinking, Hammersmith, London: HarperCollins.
    32.Ossimitz, G. (1997), “The Development of Systems Thinking Skills Using System Dynamics Modeling Tools,” Online document, http://wwwu.uniklu.ac.at/gossimit/sdyn/gdm_eng.htm (accessed: 2009).
    33.Ottmann, B., M. West and S. Fyfe (1992), “Reviewing and improving data models,” Shell International. IC91-077 T3
    34.Ozel, F. and N. Kohler (2004), Data modeling issues in simulating the dynamic processes in life cycle analysis of buildings. Automat. Constr., 13(2), pp.167-174.
    35.Peckham, J. and F. Maryanski (1988), “Semantic Data Models,” ACM Computing Surveys, 20(3), pp.153-189.
    36.Pokorny J (2006), “Database architectures: current trends and their relationships to environmental data management,” Journal of Environmental Modelling and Software, 21, pp.1579-1586.
    37.Richmond, B. (1993), “Systems thinking: critical thinking skills for the 1990s and beyond,” System Dynamics Review, 9(2), pp.113-133.
    38.Rizzoli, A. E., M. Donatelli, I. N. Athanasiadis, F. Villa and D. Huber (2008), “Semantic links in integrated modelling frameworks,” Mathematics and Computers in Simulation, 78(2-3), pp.412-423.
    39.Rubenstein-Montano, B., J. Liebowitz, J. Buchwalter, D. McCaw, B. Newman and K. Rebeck (2001), “The knowledge management methodology team: A systems thinking framework for knowledge management,” Decision Support System, 31(1), pp.5-16.
    40.Schlange, L. E. (1995), “Linking futures research methodologies: an application of systems thinking and metagame analysis to nuclear energy policy issues,” Futures, 27, pp. 823-838.
    41.Senge, P.M. (1990), The Fifth Discipline, Doubleday, New York.
    42.Senge, P. M. (1994), The Fifth Discipline: The art and science of the learning organization: 1994 edition, New York: Currency Doubleday.
    43.Shannon, C.E. (1948), "A Mathematical Theory of Communication,” The Bell System Technical Journal, 27, pp.379-423 & 623-656.
    44.Suh, S. (2009), Handbook of Input-Output Economics in Industrial Ecology: Eco-Efficiency in Industry and Science, 23, Springer Netherlands.
    45.Tolchinsky, P., M. Aulinas, U. Cortés and M. Poch (2009), Deliberation about the Safety of Industrial Wastewater Discharges into Wastewater Treatment Plants. Whitestein Series in Software Agent Technologies and Autonomic Computing: Advanced Agent-Based Environmental Management Systems, Springer-Verlag, pp.37-60.
    46.United Nations Conference on Environment and Development, UNCED (1992), “Agenda 21,” Online document: http://www.un.org/esa/dsd/
    agenda21/ (accessed: 2009).
    47.Villa, F., I. N. Athanasiadis and A. E. Rizzoli (2009), “Modelling with knowledge: a review of emerging semantic approaches to environmental modeling,” Environmental Modelling and Software, 24, pp.577-587.
    48.West, M. and J. Fowler (1996), “Developing High Quality Data Models,” EPISTLE (the European Process Industries STEP Technical Liaison Executive), Online document: http://www.matthew-west.org.uk/
    Documents/princ03.pdf (accessed: 2009)
    49.Wiener, N. (1948), Cybernetics: or, Control and Communication in the Animal and the Machine, Hermann et Cie, Paris, The MIT Press, Cambridge (Mass.), Wiley and Sons, New York.
    50.WIKIPEDIA, “Data model,” online document: http://en.wikipedia.org/wiki/Data_model (accessed: 2009)
    51.Whitehorn, M. (2006), “On Data Models, Data Types and Dangerous Liaisons,” Online document: http://www.regdeveloper.co.uk/2006/07/22/
    data_models/ (accessed: 2009).
    二、中文部分(依年份順序排列)
    1.經濟部工業局(2008),「工業區污水處理廠營運管理要點 - 97年第二次修正版」,線上資料:http://www.moeaidb.gov.tw/external/ctlr?PRO= filepath.DownloadFile&f= documentAttach&t=f&id=522 (accessed: 2009)
    2.曾守正(2007),資料庫系統之理論與實務(二版),華泰總經銷。
    3.毒性化學物質管理法(2007),第三章第十三條,中華民國法律。
    4.水污染防治法(2007),第三章第十四條,中華民國法律。
    5.空氣污染防治法(2006),第三章第二十四條,中華民國法律。
    6.廢棄物清理法(2006),第三章第二十八條,中華民國法律。
    7.廖述良、高正忠、鄒倫、余瑞芳(2005),環境資料庫標準系統推動、跨部會資料庫整合及環保知識庫規劃暨教育宣導計畫,行政院環保署專案計畫報告。
    8.鄒倫(2005),環境資料庫標準系統推動、跨部會資料庫整合及環保知識庫規劃暨教育宣導計畫,行政院環保署專案計畫報告。
    9.黃琬淇、廖述良 (2005),「以系統方法發展國家環境管理指標系統架構」,工業污染防治,第93期,第101-120頁。
    10.鄭婉儀、蕭慧娟、鄒倫(2004),「環保署環境資料之整合及供應」,九十三年度環境資料庫建置研討會,台北。
    11.廖述良、黃琬淇、黃崇益(2003),「以物件導向思維建置具系統思維之環境資料庫體系」,2003國土資訊系統成果展示研討會論文集,台北。
    12.於幼華、廖述良 (2003),「環境資料庫標準規範及示範系統規劃暨教育宣導計畫」,行政院環保署研究計畫報告,中央大學,中壢。
    13.環境基本法(2002),第二章第十五條,中華民國法律。
    14.宋淳伍、廖述良、蔣本基(2002),「工業區廢水管理資訊系統之發展與建立」,工業污染防治,第81期。
    15.宋淳伍、廖述良、蔣本基(2002),「工業區廢水管理資訊系統之發展與建立」,地方環境資料庫及環境資料品質系統建置研討會,台北。
    16.宋淳伍(2002),「工業區廢水管理資訊系統之發展與建立」,中央大學環工程研究所碩士論文。
    17.江岷欽、劉坤億(1999),「企業型政府:理念、實務、省思」,智勝文化,台北。
    18.林財庫(1997),「科學認識論及方法論之機械化約觀與有機系統觀的比較」,科學教育學刊,第5卷第1期,第111-136頁。

    QR CODE
    :::