Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge

Shane Catolico Briones; Salvador Villar Briones II

doi:doi:10.11648/j.ajsea.20241201.13

Research Article |

| Peer-Reviewed

Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge

Shane Catolico Briones^*

, Salvador Villar Briones II

Published in American Journal of Software Engineering and Applications (Volume 12, Issue 1)

Received: 17 April 2024 Accepted: 7 May 2024 Published: 24 May 2024

Views: Downloads:

Download PDF

Share This Article

Twitter
Linked In
Facebook

Abstract

Developing a relational database management system offers benefits such as organized data storage, efficient querying, data integrity, scalability, security, and enhanced collaboration. These advantages can collectively contribute to a comprehensive and reliable resource for Kurakding (Schizophyllum Commune) related information, catering to the needs of farmers, researchers, educators, enthusiasts, and other stakeholders. Kurakding, as known by the locals, is an edible and medicinally important mushroom, particularly popular in the Bicol Region of the Philippines, Southeast Asia. Rapid urbanization and growing populations threaten the mushroom’s natural habitat, leading to its scarcity and increased market value. Recognizing the potential benefits of Information Technology (IT) for agricultural development, a digital repository for Kurakding regional knowledge was implemented. The study employs a developmental and experimental research design, creating a DBMS from scratch and comparing its effectiveness against existing systems. The database development life cycle, which comprises five phases: requirements analysis, initial design, prototyping, data entry management, and full-pledged development, was strictly adopted during the design and development of the digital repository. Secondary data, research outputs, and interviews with stakeholders contributed to data gathering. Results include a conceptual framework and logical design for a KIS Repository, represented through Entity-Relationship Diagram (ERD). The ERD depicts entities such as User, Content, research, and statistics, facilitating user interaction, data management, and forum engagement. Database tables are designed to store user information, Kurakding statistics, research data, content, and forum interactions. Improving the database framework for integrating scientific data enhances its usefulness for diverse stakeholders in the Kurakding industry. This study emphasizes the importance of a digital repository in broadening knowledge about Kurakding and fostering stakeholder involvement. Ultimately, this study created a comprehensive and user-friendly resource for Kurakding-related information, facilitating its sustainable cultivation and utilization.

Published in	American Journal of Software Engineering and Applications (Volume 12, Issue 1)
DOI	10.11648/j.ajsea.20241201.13
Page(s)	14-22
Creative Commons	This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.
Copyright	Copyright © The Author(s), 2024. Published by Science Publishing Group

Keywords

Relational Database Management System, Digital Repository, Kurakding, Schizophyllum Commune, Database

References

[1]	Ediriweera, S., Rlc, W., Nanayakkara, C., and Ovdsj, W.. (2015). Comparative study of growth and yield of edible mushrooms, Schizophyllum commune Fr., Auricularia polytricha (Mont.) Sacc. and Lentinus squarrosulus Mont. on lignocellulosic substrates. Available: https://doi.org/10.5943/mycosphere/6/6/10
[2]	Bramantara, A. H., et. al. (2020). IoT-Based Mushroom Cultivation Monitoring Information System. Solid State Technology. Available: http://solidstatetechnology.us/index.php/JSST/article/view/4348
[3]	Demiryurek, K., et. al (2008). Agricultural information systems and communication networks: the case of dairy farmers in the Samsun province of Turkey. Information Research, Vol. 13, No. 2. Available: http://www.informationr.net/ir/13-2/paper343.html
[4]	USAID, ICT to Enhance Farm Extension Service in Africa, Briefing Paper, November, 2010.
[5]	Bilan, Y., Oliinyk, O., Mishchuk, H., and Skare, M. (2023). Impact of information and communications technology on the development and use of knowledge. Technological Forecasting and Social Change, Volume 191, June 2023, 122519. https://doi.org/10.1016/j.techfore.2023.122519
[6]	Silberschatz, A., Korth, H., and Sudarshan, S. (2019). Database System Concepts Seventh Edition. McGraw Hill Education.
[7]	Hannes Mühleisen, Danica Porobic, and Manuel Rigger. Ensuring the Reliability and Robustness of Database Management Systems (Dagstuhl Seminar 23441). In Dagstuhl Reports, Volume 13, Issue 10, pp. 139-181, Schloss Dagstuhl – Leibniz-Zentrum für Informatik (2024).
[8]	Booth, J. D. (2022). Database Design Succinctly. Syncfusion, Inc.
[9]	Antoniuk, L., & Taskaiev, D. (2023). Concept, types and importance of databases. Prospects for their development. Scientific Collection «InterConf», (148), 474–480. Retrieved from https://archive.interconf.center/index.php/conference-proceeding/article/view/2866
[10]	Fileve, V. A. (2023). Construction and application of database architecture for integrated business software process. Available at https://epluse.ceec.bg/wp-content/uploads/2023/09/20230200-01.pdf
[11]	Arshad, M., Brohi, M.N., Soomro, T.R., Ghazal, T.M., Alzoubi, H.M., Alshurideh, M. (2023). NoSQL: Future of BigData Analytics Characteristics and Comparison with RDBMS. In: Alshurideh, M., Al Kurdi, B.H., Masa’deh, R., Alzoubi, H.M., Salloum, S. (eds) The Effect of Information Technology on Business and Marketing Intelligence Systems. Studies in Computational Intelligence, vol 1056. Springer, Cham. https://doi.org/10.1007/978-3-031-12382-5_106
[12]	Veda C. Storey, Roman Lukyanenko, and Arturo Castellanos (2023). Conceptual Modeling: Topics, Themes, and Technology Trends. ACM Comput. Surv. 55, 14s, Article 317 (December 2023), 38 pages. https://doi.org/10.1145/3589338
[13]	Amini, Mahyar and Rahmani, Ali, Agricultural Databases Evaluation with Machine Learning Procedure (January 1, 2023). Australian Journal of Engineering and Applied Science 8.6 (2023): 39-50, Available at SSRN: https://ssrn.com/abstract=4331902

Cite This Article

Plain Text BibTeX RIS

APA Style

Briones, S. C., II, S. V. B. (2024). Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge. American Journal of Software Engineering and Applications, 12(1), 14-22. https://doi.org/10.11648/j.ajsea.20241201.13

Copy | Download

ACS Style

Briones, S. C.; II, S. V. B. Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge. Am. J. Softw. Eng. Appl. 2024, 12(1), 14-22. doi: 10.11648/j.ajsea.20241201.13

Copy | Download

AMA Style

Briones SC, II SVB. Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge. Am J Softw Eng Appl. 2024;12(1):14-22. doi: 10.11648/j.ajsea.20241201.13

Copy | Download

@article{10.11648/j.ajsea.20241201.13,
  author = {Shane Catolico Briones and Salvador Villar Briones II},
  title = {Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge
},
  journal = {American Journal of Software Engineering and Applications},
  volume = {12},
  number = {1},
  pages = {14-22},
  doi = {10.11648/j.ajsea.20241201.13},
  url = {https://doi.org/10.11648/j.ajsea.20241201.13},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ajsea.20241201.13},
  abstract = {Developing a relational database management system offers benefits such as organized data storage, efficient querying, data integrity, scalability, security, and enhanced collaboration. These advantages can collectively contribute to a comprehensive and reliable resource for Kurakding (Schizophyllum Commune) related information, catering to the needs of farmers, researchers, educators, enthusiasts, and other stakeholders. Kurakding, as known by the locals, is an edible and medicinally important mushroom, particularly popular in the Bicol Region of the Philippines, Southeast Asia. Rapid urbanization and growing populations threaten the mushroom’s natural habitat, leading to its scarcity and increased market value. Recognizing the potential benefits of Information Technology (IT) for agricultural development, a digital repository for Kurakding regional knowledge was implemented. The study employs a developmental and experimental research design, creating a DBMS from scratch and comparing its effectiveness against existing systems. The database development life cycle, which comprises five phases: requirements analysis, initial design, prototyping, data entry management, and full-pledged development, was strictly adopted during the design and development of the digital repository. Secondary data, research outputs, and interviews with stakeholders contributed to data gathering. Results include a conceptual framework and logical design for a KIS Repository, represented through Entity-Relationship Diagram (ERD). The ERD depicts entities such as User, Content, research, and statistics, facilitating user interaction, data management, and forum engagement. Database tables are designed to store user information, Kurakding statistics, research data, content, and forum interactions. Improving the database framework for integrating scientific data enhances its usefulness for diverse stakeholders in the Kurakding industry. This study emphasizes the importance of a digital repository in broadening knowledge about Kurakding and fostering stakeholder involvement. Ultimately, this study created a comprehensive and user-friendly resource for Kurakding-related information, facilitating its sustainable cultivation and utilization.
},
 year = {2024}
}

Copy | Download

TY  - JOUR
T1  - Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge

AU  - Shane Catolico Briones
AU  - Salvador Villar Briones II
Y1  - 2024/05/24
PY  - 2024
N1  - https://doi.org/10.11648/j.ajsea.20241201.13
DO  - 10.11648/j.ajsea.20241201.13
T2  - American Journal of Software Engineering and Applications
JF  - American Journal of Software Engineering and Applications
JO  - American Journal of Software Engineering and Applications
SP  - 14
EP  - 22
PB  - Science Publishing Group
SN  - 2327-249X
UR  - https://doi.org/10.11648/j.ajsea.20241201.13
AB  - Developing a relational database management system offers benefits such as organized data storage, efficient querying, data integrity, scalability, security, and enhanced collaboration. These advantages can collectively contribute to a comprehensive and reliable resource for Kurakding (Schizophyllum Commune) related information, catering to the needs of farmers, researchers, educators, enthusiasts, and other stakeholders. Kurakding, as known by the locals, is an edible and medicinally important mushroom, particularly popular in the Bicol Region of the Philippines, Southeast Asia. Rapid urbanization and growing populations threaten the mushroom’s natural habitat, leading to its scarcity and increased market value. Recognizing the potential benefits of Information Technology (IT) for agricultural development, a digital repository for Kurakding regional knowledge was implemented. The study employs a developmental and experimental research design, creating a DBMS from scratch and comparing its effectiveness against existing systems. The database development life cycle, which comprises five phases: requirements analysis, initial design, prototyping, data entry management, and full-pledged development, was strictly adopted during the design and development of the digital repository. Secondary data, research outputs, and interviews with stakeholders contributed to data gathering. Results include a conceptual framework and logical design for a KIS Repository, represented through Entity-Relationship Diagram (ERD). The ERD depicts entities such as User, Content, research, and statistics, facilitating user interaction, data management, and forum engagement. Database tables are designed to store user information, Kurakding statistics, research data, content, and forum interactions. Improving the database framework for integrating scientific data enhances its usefulness for diverse stakeholders in the Kurakding industry. This study emphasizes the importance of a digital repository in broadening knowledge about Kurakding and fostering stakeholder involvement. Ultimately, this study created a comprehensive and user-friendly resource for Kurakding-related information, facilitating its sustainable cultivation and utilization.

VL  - 12
IS  - 1
ER  -

Copy | Download

Author Information

Shane Catolico Briones

College of Education, Partido State University, Goa, Camarines Sur, Philippines

Contact Email

http://orcid.org/0000-0003-3489-4594
Salvador Villar Briones II

College of Education, Partido State University, Goa, Camarines Sur, Philippines

Contact Email

http://orcid.org/0000-0003-1524-0683

Download PDF

Sections

Plain Text BibTeX RIS

APA Style

Briones, S. C., II, S. V. B. (2024). Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge. American Journal of Software Engineering and Applications, 12(1), 14-22. https://doi.org/10.11648/j.ajsea.20241201.13

Copy | Download

ACS Style

Briones, S. C.; II, S. V. B. Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge. Am. J. Softw. Eng. Appl. 2024, 12(1), 14-22. doi: 10.11648/j.ajsea.20241201.13

Copy | Download

AMA Style

Briones SC, II SVB. Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge. Am J Softw Eng Appl. 2024;12(1):14-22. doi: 10.11648/j.ajsea.20241201.13

Copy | Download

@article{10.11648/j.ajsea.20241201.13,
  author = {Shane Catolico Briones and Salvador Villar Briones II},
  title = {Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge
},
  journal = {American Journal of Software Engineering and Applications},
  volume = {12},
  number = {1},
  pages = {14-22},
  doi = {10.11648/j.ajsea.20241201.13},
  url = {https://doi.org/10.11648/j.ajsea.20241201.13},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ajsea.20241201.13},
  abstract = {Developing a relational database management system offers benefits such as organized data storage, efficient querying, data integrity, scalability, security, and enhanced collaboration. These advantages can collectively contribute to a comprehensive and reliable resource for Kurakding (Schizophyllum Commune) related information, catering to the needs of farmers, researchers, educators, enthusiasts, and other stakeholders. Kurakding, as known by the locals, is an edible and medicinally important mushroom, particularly popular in the Bicol Region of the Philippines, Southeast Asia. Rapid urbanization and growing populations threaten the mushroom’s natural habitat, leading to its scarcity and increased market value. Recognizing the potential benefits of Information Technology (IT) for agricultural development, a digital repository for Kurakding regional knowledge was implemented. The study employs a developmental and experimental research design, creating a DBMS from scratch and comparing its effectiveness against existing systems. The database development life cycle, which comprises five phases: requirements analysis, initial design, prototyping, data entry management, and full-pledged development, was strictly adopted during the design and development of the digital repository. Secondary data, research outputs, and interviews with stakeholders contributed to data gathering. Results include a conceptual framework and logical design for a KIS Repository, represented through Entity-Relationship Diagram (ERD). The ERD depicts entities such as User, Content, research, and statistics, facilitating user interaction, data management, and forum engagement. Database tables are designed to store user information, Kurakding statistics, research data, content, and forum interactions. Improving the database framework for integrating scientific data enhances its usefulness for diverse stakeholders in the Kurakding industry. This study emphasizes the importance of a digital repository in broadening knowledge about Kurakding and fostering stakeholder involvement. Ultimately, this study created a comprehensive and user-friendly resource for Kurakding-related information, facilitating its sustainable cultivation and utilization.
},
 year = {2024}
}

Copy | Download

TY  - JOUR
T1  - Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge

AU  - Shane Catolico Briones
AU  - Salvador Villar Briones II
Y1  - 2024/05/24
PY  - 2024
N1  - https://doi.org/10.11648/j.ajsea.20241201.13
DO  - 10.11648/j.ajsea.20241201.13
T2  - American Journal of Software Engineering and Applications
JF  - American Journal of Software Engineering and Applications
JO  - American Journal of Software Engineering and Applications
SP  - 14
EP  - 22
PB  - Science Publishing Group
SN  - 2327-249X
UR  - https://doi.org/10.11648/j.ajsea.20241201.13
AB  - Developing a relational database management system offers benefits such as organized data storage, efficient querying, data integrity, scalability, security, and enhanced collaboration. These advantages can collectively contribute to a comprehensive and reliable resource for Kurakding (Schizophyllum Commune) related information, catering to the needs of farmers, researchers, educators, enthusiasts, and other stakeholders. Kurakding, as known by the locals, is an edible and medicinally important mushroom, particularly popular in the Bicol Region of the Philippines, Southeast Asia. Rapid urbanization and growing populations threaten the mushroom’s natural habitat, leading to its scarcity and increased market value. Recognizing the potential benefits of Information Technology (IT) for agricultural development, a digital repository for Kurakding regional knowledge was implemented. The study employs a developmental and experimental research design, creating a DBMS from scratch and comparing its effectiveness against existing systems. The database development life cycle, which comprises five phases: requirements analysis, initial design, prototyping, data entry management, and full-pledged development, was strictly adopted during the design and development of the digital repository. Secondary data, research outputs, and interviews with stakeholders contributed to data gathering. Results include a conceptual framework and logical design for a KIS Repository, represented through Entity-Relationship Diagram (ERD). The ERD depicts entities such as User, Content, research, and statistics, facilitating user interaction, data management, and forum engagement. Database tables are designed to store user information, Kurakding statistics, research data, content, and forum interactions. Improving the database framework for integrating scientific data enhances its usefulness for diverse stakeholders in the Kurakding industry. This study emphasizes the importance of a digital repository in broadening knowledge about Kurakding and fostering stakeholder involvement. Ultimately, this study created a comprehensive and user-friendly resource for Kurakding-related information, facilitating its sustainable cultivation and utilization.

VL  - 12
IS  - 1
ER  -

Copy | Download