Designing and implementation of a conceptual model of database for harvesting data of Northern forest of Iran

Document Type : Scientific article

Author

Associate professor, Department of Forest Sciences, Faculty of Agriculture, University of Ilam, I. R. Iran

Abstract

Looking at the different stages of wood logging operations in north forest of Iran we will see that a huge amount of data is collected and in various traditional and digital methods are stored. Todays, despite the emergence of new database and databank systems, unfortunately, most of the General Natural Resource offices of Iran even in the northern provinces, do not have any comprehensive and smart information system and database so that massive amount of information from various stages of harvesting operations could be collected and stored efficiently. To facilitate in storage, processing and delivery of harvesting information of north forest, a harvesting database system using Entity – relationship data model was designed. Access software version.2016 was used to implement the entity- relationship data model or physical design of database system. The designed system includes several components or subsystems (marking of trees, cutting, re-measuring, grading, wood extraction from the forest field and depot, districts certification, forestry plans, forestry plans executives, and out of forestry plans cutting licenses). Using the designed system, the information and data requirements for further investigation and processing from forest harvesting data for forest management decision making can be provided.

Entity – relationship data model was designed. Access software version.2016 was used to implement the entity- relationship data model or physical design of database system. The designed system includes several components or subsystems (marking of trees, cutting, re-measuring, grading, wood extraction from the forest field and depot, districts certification, forestry plans, forestry plans executives and out of forestry plans cutting licenses). Using the designed system, the information and data requirements for further investigation and processing from forest harvesting data for forest management decision making can be provided.

Keywords

References

- Chen, P. P., 1976. The Entity-Relationship Model: Toward a Unified View of Data, ACM Transaction on Database Systems, 1(1): 9-36.
- Connolly, T. M. & C. E. Begg, 2001. Database Systems (A practical Approach to Design, Implementation and management, Third edition. Addison Wesley Press, 1100 p.
- Feghhi, J., 1997. Informations- und Metainformationsbedarf für die forstliche Planung im Hinblick auf ein Wald-Informations-system. PhD thesis. ETH Zurich university.
- Goushegir, S. Z. & J. Feghhi, 2009. An entity – relationship model for forest management unit, Case study: Kheiroud forest, Journal of Applied Sciences, 9(3): 578-582.
- IUFRO., 2005. Development of a Global forest information service (GFIS)- Creating a common vision. IUFRO occasional,12: 34 p.
- Koehl, M., 2006. Forest information systems. In: Shao, G. & K. M. Reynolds (Eds.), Computer Applications in Sustainable Forest Management. Managing Forest Ecosystems, Springer, pp: 67-82.
- Mahdavi, A., 2012. Application of Entity-relationship data model for physical design of database of North forest inventories, Journal of Conservation and Utilization of Natural Resources, 1(2): 85-104. (In Persian)
- Mahdavi, A., D. Pelz & G. Ehrlenshpiel, 2009. IFMIS, a Forest Management Information System (Case study in Noo - shahr), Iranian Journal of Forest and Poplar Research, 16(4): 609-625. (in Persian)
- Mathey, A. H., E. Krcmar, S. Dragicevic & I. Vertinsky, 2008. An object-oriented cellular automata model for forest planning problems, Ecological Modeling, 212(3-4): 359-371.
- Schuck, A., T. Green, G. Andricnko, N. Fedorec, A. Requardt, T. Rihards, R. Mills, E. Mikkola, R. Paeivinen & M. Koehl, 2007. Towards a European forest information system. European Forest Institute Research Report, 20, 129 p.
- Wu, S. l., Q. S. Lou, Z. J. Quan & X. J. Li, 2003. Study of setting up the forest resources management information system based on WEBGIS, Chinese Geographical Science, 13(1): 56-61.
- Tiefenbacher, J., 2012. Approaches to managing disaster- Assessing hazards, emergencies and disaster impacts. InTech publisher, 174 p.
- Tokola, T., A. Turkia, J. Sarkeala & J. Soimasuo, 1997. An entity – relationship model for forest inventory, Canadian Journal of Forest Research, 27(10): 1586-1594.
- Wang, J., Sh. Grushecky & J. Brooks, 2004. An integrated computer – based cruising system for central Appalachin hardwoods, Computers and Electronics in agriculture, 45(1-3): 133-138.
- Zhang, Y. & P. K. Barten, 2009. Watershed Forest Management Information System (WFMIS), Environmental Modelling & Software, 24(4): 569-575.
Forest Research and Development
Volume 4, Issue 4
March 2019
Pages 515-532

Files

Share

How to cite

Statistics