Conceptual modeling of database object-oriented applied to soil studies – DATASOLOS_SC

Authors

DOI:

https://doi.org/10.5965/223811712342024732

Keywords:

database, object orientation, soils

Abstract

Information systems are able to store important data so as that these can be consulted and analyzed for the most varied uses and applications.  The way how the data is stored in a database makes it easy the organization, query and update of information. The conceptual modeling has been successfully applied in the building of databases enabling represent in an abstract way, formal and unambiguous, the reality of application. The objective of this study was to design a structure of a database by means of conceptual modeling for applications in the field of soil science through of OMT model, aimed the organizing, systematizing, and managing of the information available about this natural resource, through a relational object database management system. The DATASOLOS_SC gathers general, physical, chemical and morphological data of soil profiles from Santa Catarina State – Brazil, besides a soil samples library (physical bank). The initial version of the soil database will be available for access at the electronic address https://datasolos-sc.sistemas.udesc.br/.

Downloads

Download data is not yet available.

References

ASSAD ED & SANO EE. 1998. Sistema de informações geográficas: aplicações na agricultura. Brasília: Embrapa.

BAUMGARDNER MF. 1999. Soil databases. In: SUMNER ME. (Ed.). Handbook of soil science. Boca Raton: CRC Press. p.H1-H4.

BOOCH G et al. 1998. The unified modeling language user guide. Massachusetts: Addison Wesley Longman.

CHAGAS CS et al. 2004. Estrutura e organização do sistema de informações georreferenciadas de solos do Brasil (SIGSOLOS – VERSÃO 1.0). Revista Brasileira de Ciência do Solo 28: 865-876.

CEN. 1996. Geographic information – data description – conceptual schema language. Brussels: EUROPEAN COMMITTEE FOR STANDARDIZATION. (Relatório).

COOPER M et al. 2005. A national soil profile database for Brazil available to international scientists. Soil Science Society of America Journal 69: 649-652.

ELMASRI R & NAVATHE SB. 2017. Fundamentals of Database Systems. 7.ed. Harlow: Pearson.

BHERING SB et al. 1998. Base de informações georreferenciada de solos: metodologia e guia básico do aplicativo SigSolos, versão 1.0. Rio de Janeiro: EMBRAPA – CNPS. 112p. (Boletim de pesquisa 11).

EMBRAPA. 1998. Base de informações georreferenciada de solos: metodologia e guia básico do aplicativo SigSolos, versão 1.0. Rio de Janeiro: CNPS. (CD-ROM - Boletim de pesquisa 11).

FAO. 1996. The digitized soil map of the world including derived soil properties. Rome: FAO. (CD-Rom).

FURLAN JD. 1998. Modelagem de Objetos através da UML. Análise e Desenho Orientados a Objeto. The Unified Modeling Language. São Paulo: Makron Books.

LISBOA FILHO J. 2000. Projeto conceitual de banco de dados geográficos através da reutilização de esquemas, utilizando padrões de análise e um framework conceitual. Tese (Doutorado em Ciência da Computação) Porto Alegre: UFRGS. 212p.

LISBOA FILHO J et al. 2000. Modelagem conceitual de banco de dados geográficos: o estudo de caso do projeto PADCT/CIAMB. In: Carvão e Meio Ambiente. Porto Alegre: UFRGS. p.440-458.

MACDONALD KB & KLOOSTERMAN B. 1984. The canadian soil information system -CANSIS: general users manual. Ottawa Land Resource Research Institute, Research Branch, Agriculture Canada. 56p. (Manual Técnico).

NETO SLR. 2000. Um modelo conceitual de sistema de apoio à decisão espacial para gestão de desastres por inundações. Tese (Doutorado em Engenharia de Transportes). São Paulo: USP. 208p.

NETO SLR et al. 2006. Modelagem conceitual de geodados com técnica orientada a objetos para gestão de recursos hídricos. Revista Brasileira de Recursos Hídricos 11: 235-244.

RUMBAUGH J et al. 1991. Object-oriented modeling and design. New Jersey: Prentice-Hall.

SOIL SURVEY STAFF. 1991. National soil information system (NASIS): soil interpretation and information dissemination sub-system. Draft requirements statement. Lincoln: USDA, Natural Resources Conservation Service, National Soil Survey Center. 67p.

VAN ENGELEN VWP & WEN TT. 1995. Global and national soils and terrain digital databases (SOTER): procedures manual. Wageningen: UNEP-ISSS-ISRIC-FAO. 129p. (Manual Técnico).

Published

2024-12-18

How to Cite

SANTOS, Pablo Grahl dos; ALMEIDA, Jaime Antonio de. Conceptual modeling of database object-oriented applied to soil studies – DATASOLOS_SC . Revista de Ciências Agroveterinárias, Lages, v. 23, n. 4, p. 732–738, 2024. DOI: 10.5965/223811712342024732. Disponível em: https://periodicos.udesc.br/index.php/agroveterinaria/article/view/24960. Acesso em: 21 dec. 2024.

Issue

Section

Research Article - Science of Soil and Environment

Most read articles by the same author(s)