BioCycle-DB: Data-Tier Enforcement of Spatio-Temporal Logistics and Compliance Auditing in Poultry Waste Recovery

Modern circular agricultural supply chains require high-integrity digital platforms to coordinate the recovery and disposal of highly perishable organic waste. While the web-based application tier is always used to perform transaction processing and implement business logic and auditing processes, implementing all of this through the application tier often results in system performance issues, code duplication, and significant security threats due to the risks involved in accessing the database directly. The paper proposes the design of high-integrity database architecture which uses the Database Life Cycle Model and runs on Microsoft SQL Server Express 2022 platform.
A key database-tier design pattern utilized is 1:1 Extension/Association (One-to-One Delegation). The central USER table submits a role request (ROLE_REQUEST) when an external stakeholder registers. Upon administrative approval, the system enforces a strict 1:1 extension by creating a record in either the Slaughterhouse or Processor entity, each with its own independent primary key and a foreign key referencing the corresponding ROLE_REQUEST. To facilitate logistics management based on spatio-temporal parameters independent of application tier, we have designed and implemented: (1) an automated volume-based biohazard disposal routing engine using a database cursor inside a stored procedure (sp_ProcessExpiredReports) which automatically runs a 24-hour storage expiry routine and disposes of the waste either for Incineration, Effluent Treatment (ETP), or Anaerobic Digestion; (2) a filtered unique index constraint (idx_one_pending_per_processor_report) that eliminates transaction conflicts mathematically and duplicate active states; and (3) a non-repudiable audit-trail mechanism through DML triggers (trg_ProcessBatch_Audit) that captures global SESSION_CONTEXT variables and logs all field level changes. Overall, this architecture provides complete and tamper-evident traceability of waste from its creation to disposal/recovery and fulfils the strict reporting requirements for compliance under the Environmental Quality Act (EQA) 1974.

Database Life Cycle (DBLC), Microsoft SQL Server, Filtered Unique Indexes

1. Hakim, L. I., Isa, N. M. M., & Tahir, S. M. (2020). Effect of halal and non-halal slaughtering methods on bacterial contamination of poultry meat. Sains Malaysiana, 49(8), 1947-1950. [Google Scholar] [Crossref]

2. Kiepper, B. H., Merka, W. C., & Fletcher, D. L. (2008). Proximate composition of poultry processing wastewater particulate matter from broiler slaughter plants. Poultry science, 87(8), 1633-1636. [Google Scholar] [Crossref]

3. Liang XiaoNa, L. X., Ye Qing, Y. Q., Wu Shang, W. S., Wu ShangYi, W. S., Kang ShiMo, K. S., Guan BoYuan, G. B., ... & Yue XiQing, Y. X. (2018). Fertilizer efficiency of a new type of chicken blood liquid fertilizer. [Google Scholar] [Crossref]

4. Currim, F., & Ram, S. (2012). Modeling spatial and temporal set-based constraints during conceptual database design. Information Systems Research, 23(1), 109-128. [Google Scholar] [Crossref]

5. Gupta, A. K., Fadzlillah, N. A., Sukri, S. J. M., Adediran, O. A., Rather, M. A., Naik, B., & Rustagi, S. (2024). Slaughterhouse blood: A state-of-the-art review on transforming by-products into valuable nutritional resources and the role of circular economy. Food Bioscience, 61, 104644. [Google Scholar] [Crossref]

6. Kamble, S. S., Gunasekaran, A., & Gawankar, S. A. (2020). Achieving sustainable performance in a data-driven agriculture supply chain: A review for research and applications. International journal of production economics, 219, 179-194. [Google Scholar] [Crossref]

7. Rejeb, A., Keogh, J. G., Zailani, S., Treiblmaier, H., & Rejeb, K. (2020). Blockchain technology in the food industry: A review of potentials, challenges and future research directions. Logistics, 4(4), 27. [Google Scholar] [Crossref]

8. Laws of Malaysia, Environmental Quality Act 1974 (Act 127). Kuala Lumpur: Percetakan Nasional Malaysia Berhad, 2006. [Google Scholar] [Crossref]

9. Astill, J., Dara, R. A., Campbell, M., Farber, J. M., Fraser, E. D., Sharif, S., & Yada, R. Y. (2019). Transparency in food supply chains: A review of enabling technology solutions. Trends in Food Science & Technology, 91, 240-247. [Google Scholar] [Crossref]

10. Bustillo-Lecompte, C. F., & Mehrvar, M. (2015). Slaughterhouse wastewater characteristics, treatment, and management in the meat processing industry: A review on trends and advances. Journal of environmental management, 161, 287-302. [Google Scholar] [Crossref]

11. Mozhiarasi, V., & Natarajan, T. S. (2025). Slaughterhouse and poultry wastes: management practices, feedstocks for renewable energy production, and recovery of value added products. Biomass conversion and biorefinery, 15(2), 1705-1728. [Google Scholar] [Crossref]

12. Bułkowska, K., & Zielińska, M. (2024). Recovery of biogas and other valuable bioproducts from livestock blood waste: a review. Energies, 17(23), 5873. [Google Scholar] [Crossref]

13. Coronel, C., Morris, S., & Rob, P. (2019). Database systems: design, implementation, and management. Cengage Learning. [Google Scholar] [Crossref]

14. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2002). Database system concepts (Vol. 5). New York: McGraw-Hill. [Google Scholar] [Crossref]

15. Hoffer, J. A., Ramesh, V., Topi, H., & Hilol, B. (2016). Modern database management (Vol. 4, No. 1). London, UK: Pearson. [Google Scholar] [Crossref]

16. Connolly, T. M., Begg, C. E., & Strachan, A. D. (2005). Database systems: a practical approach to design, implementation, and management (Vol. 3). Harlow: Addison-Wesley. [Google Scholar] [Crossref]

17. Flores, D. A., & Jhumka, A. (2017, August). Implementing chain of custody requirements in database audit records for forensic purposes. In 2017 IEEE Trustcom/BigDataSE/ICESS (pp. 675-682). IEEE. [Google Scholar] [Crossref]

18. Wei, Z., Leck, U., & Link, S. (2019). Discovery and ranking of embedded uniqueness constraints. Proceedings of the VLDB Endowment, 12(13), 2339-2352. [Google Scholar] [Crossref]

19. Edström, M., Nordberg, Å., & Thyselius, L. (2003). Anaerobic treatment of animal byproducts from slaughterhouses at laboratory and pilot scale. Applied Biochemistry and Biotechnology, 109(1), 127-138. [Google Scholar] [Crossref]

• The Indirect Effect of Liquidity and Activity on Company Value with Profitability as an Intervening Variable
• Effect of Financial Skills, Knowledge, and Attitude on The Financial Behaviour of Clergy
• A Decade of Review: Trends in Budget Execution and Financial Performance of Development Projects in Tanzania (2014/15-2023/24)
• The Influence of Pre-Project Planning on the Budget Absorption Rate of Public Funded Infrastructure Projects in Kenya a Comparative Case Study of Narok, Migori, and Kisii County Government Projects
• Assessment of Factors Influencing Digital Transformation in Hotels’ Facility Management in Abuja Metropolis, Nigeria