水稻光譜資料庫管理系統之建置

Abstract

精準農業計畫之有效執行，仰賴不同資料之整合。資料庫管理系統是一個兼具管理、分析之工具。本文旨在介紹近地面水稻光譜資料庫系統之建置。本系統的架構規劃是以web為環境，以。client-server 為架構，適用於2-Tier 或3-Tier 的架構。研究步驟包括：1 需求分析、2 資料庫設計、3 程式設計、4 介面設計、5 測試及安裝。本應用系統以HTML+ASP plus為設計的工具，後端資料庫以SQL 2000為資料庫管理系統系統架構。系統功能包括：1.系統管理、2.資料新增／刪除、3.資料查詢。嘗試藉由建立此基礎光譜資料庫，以利後續相關水稻生長、逆境（病蟲害、雜草、旱害等）及產量之監測與估測技術研究。 Success of the precision agriculture project depends on the integration of different data. Database management information system is a tool combined with the management and analysis. The setup of database management system of spectral reflectance for near-surface rice paddy is introduced in this paper. The system structure is based on client-sewer of 2-Tier or 3-Tier, which can be run with web environment. The steps of system development include: 1. demand analysis, 2. database design, 3. programming, 4. interface design, 5. test and setup. HTML and ASP plus are used to develop the system and MS SQL 2000 is used to develop the backend database. The functions of the system include: 1. system management, 2. data insert/delete, 3. data query. By the development of such spectral reflectance database system, related researches of rice growth, resistance and production will be improved.