Establishment of the Database and Database Management System of the Forest Dynamics Plot - An Example of a Forest Dynamics Plot of an Evergreen Broad-leaved Forest in the Upstream Region of Nantzuhsien Creek

• Main Authors: Jen-Fang Chen, 陳仁芳
• Other Authors: Kuoh-Cheng Yang
• Format: Others
• Language: zh-TW
• Published: 2007
• Online Access: http://ndltd.ncl.edu.tw/handle/77268945845978932943

碩士 === 靜宜大學 === 生態學研究所 === 95 === The concept of forest dynamics plot (FDP) was advanced by Stephen P. Hubbell in 1970. As yet, there are over 10 sites that the site covers an area of over 1 ha. in Taiwan. In order to process the data of investigation, this research was based on the correlative data of a forest dynamics plot of an evergreen broad-leaved forest in the upstream region of Nantzuhsien creek. According to the items and characteristic of investigation, this research developed a set of database management system which can help to input and manage data, correction and detect mistakes, and do basic calculation and analysis, making correlative tables and charts. And then each site can use the same processing model of computer as this database management system which can be a medium that it solves the problems of integration and communion of data among each site. This research had four kinds of materials, including: 1. the table of measurement of theodolite; 2. the table of plant investigation; 3. 3,702 records of woody plant were investigated by the work team in the upstream region of Nantzuhsien creek during summer vocation in 2005; 4. the graph paper of plant investigation 10*10 m². After understanding the operation of correlative data, producing 12 tables, 6 queries, 29 forms and 2 reports by processing 15 steps and adopting the concept of relational database model. Then, the researcher arranged each database objects and established a database management system. The database management system were separated into 6 parts: 1. data management; 2. data query; 3. data analysis; 4. the distribution of plants; 5. the list of plants in site; 6. data exportation. Using this database management system can reduce the time and avoid the mistakes when users input data, and search data easily, and calculate the species numbers of families in site, the numbers of stems, the basal area (BA), the important value (IV) and the structures of diameter classes, and producing of tables and charts as above, and the distribution charts of individuals, and the list of plants in site. Besides, it can provide the function of data exportation.