КОНФЕРЕНЦІЇ ВНТУ електронні наукові видання, 
Молодь в науці: дослідження, проблеми, перспективи (МН-2026)

Розмір шрифта: 
ENGINEERING AN ERROR-RESILIENT ORDER AND INVENTORY ACCOUNTING INFORMATION SYSTEM FOR SMALL AND MEDIUM-SIZED ENTERPRISES
Олександр Мирославович Хошаба, Роман Юрійович Ліневич

Остання редакція: 2026-02-18

Анотація


Small businesses frequently rely on spreadsheets and paper-based processes to track customer orders, supplier deliveries, and warehouse balances, which increases transcription errors, duplicate records, and delayed stock updates. This paper presents the design and implementation concepts of a web-based information system intended to automate order and inventory accounting while reducing manual operations and user errors. The solution is based on a relational database model with enforceable integrity constraints and an auditable inventory ledger built from immutable stock-movement records. Data quality requirements are defined as explicit business rules, aligned with the ISO 8000 data quality framework, and implemented through a combination of user-interface constraints, server-side validation, and database constraints. Verification activities are planned in accordance with ISO/IEC/IEEE 29119-4:2021 test techniques, with emphasis on inventory invariants and negative tests to validate and authorise failures. Security is addressed through a risk-based control set informed by the Open Worldwide Application Security Project (OWASP) Top 10:2021, governance alignment with ISO/IEC 27001:2022, and secure development practices from the National Institute of Standards and Technology (NIST) Secure Software Development Framework (SSDF). Accessibility objectives are mapped to the World Wide Web Consortium (W3C) Web Content Accessibility Guidelines (WCAG) 2.2 to support inclusive, low-error interaction. As production metrics are not yet available, the paper proposes an evaluation plan based on scenario-driven functional assessment, data-quality indicators, usability measures and performance criteria suitable for typical small-business workloads.

Ключові слова


small and medium-sized enterprises, accounting information system, order processing, inventory accounting, warehouse stock control, data quality, secure software development, web application, relational database, software testing, accessibility.

Посилання


1. OECD. The Digital Transformation of SMEs : report. — Paris : OECD Publishing, 2021. — 275 p. — DOI: 10.1787/bdb9256a-en. — URL: [https://doi.org/10.1787/bdb9256a-en](https://doi.org/10.1787/bdb9256a-en) (date of access: 26.01.2026).

2. Muller, P.; Ladher, R.; Booth, J.; Mohamed, S.; Gorgels, S.; Priem, M. et al. Annual report on European SMEs 2021/2022 : SMEs and environmental sustainability : report. — Luxembourg : Publications Office of the European Union, 2022. — ISBN 978-92-9469-291-7. — DOI: 10.2826/451263. — URL: [https://op.europa.eu/en/publication-detail/-/publication/0a009ca6-eac2-11ec-a534-01aa75ed71a1/language-en](https://op.europa.eu/en/publication-detail/-/publication/0a009ca6-eac2-11ec-a534-01aa75ed71a1/language-en) (date of access: 26.01.2026).

3. ISO 8000-1:2022. Data quality — Part 1: Overview. — Geneva : International Organization for Standardization, 2022. — 20 p. — URL: [https://www.iso.org/standard/81745.html](https://www.iso.org/standard/81745.html) (date of access: 26.01.2026).

4. Silberschatz, A.; Korth, H. F.; Sudarshan, S. Database System Concepts. — 7th ed. — New York : McGraw Hill, 2020. — ISBN 978-0-07-802215-9.

5. ISO/IEC/IEEE 29119-4:2021. Software and systems engineering — Software testing — Part 4: Test techniques. — Geneva : International Organization for Standardization, 2021. — 135 p. — URL: [https://www.iso.org/standard/79430.html](https://www.iso.org/standard/79430.html) (date of access: 26.01.2026).

6. Glas, B. The Release of the OWASP Top 10:2021 [Electronic resource]. — 24 September 2021. — URL: [https://www.owasptopten.org/the-release-of-the-owasp-top-10-2021c0a347a0](https://www.owasptopten.org/the-release-of-the-owasp-top-10-2021c0a347a0) (date of access: 26.01.2026).

7. ISO/IEC 27001:2022. Information security, cybersecurity and privacy protection — Information security management systems — Requirements. — Geneva : International Organization for Standardization, 2022. — 19 p. — URL: [https://www.iso.org/standard/27001](https://www.iso.org/standard/27001) (date of access: 26.01.2026).

8. Souppaya, M.; Scarfone, K.; Dodson, D. Secure Software Development Framework (SSDF) Version 1.1: Recommendations for Mitigating the Risk of Software Vulnerabilities : NIST Special Publication 800-218. — Gaithersburg, MD : National Institute of Standards and Technology, 2022. — 36 p. — DOI: 10.6028/NIST.SP.800-218. — URL: [https://doi.org/10.6028/NIST.SP.800-218](https://doi.org/10.6028/NIST.SP.800-218) (date of access: 26.01.2026).

9. Web Content Accessibility Guidelines (WCAG) 2.2 : W3C Recommendation [Electronic resource]. — 05 October 2023. — URL: [https://www.w3.org/TR/WCAG22/](https://www.w3.org/TR/WCAG22/) (date of access: 26.01.2026).

10. Sandhu, R. S.; Coyne, E. J.; Feinstein, H. L.; Youman, C. E. Role-Based Access Control Models // Computer. — 1996. — Vol. 29, No. 2. — P. 38–47. — DOI: 10.1109/2.485845.

11. Sommerville, I. Software Engineering. — 10th ed. — Boston : Pearson, 2016. — ISBN 978-0-13-394303-0.


Повний текст: PDF