Home / Current Issue / Paper 1724498
Smart Vendor Hub: An Evidence-Aware Adaptive Ranking and Multi-Factor Trust Framework for Hyperlocal Municipal Service Discovery
Subject area: Science,Engineering and Technology · Area of research: Computer Science and Information Technology
DOI: 10.64388/IREV10I4-1724498
Abstract
Evidence-aware ranking reduces rating manipulation and commercial bias in local service directories by conditioning vendor order on verified reviews, physical distance, and identity trust stored in a shared database index. Deploying hyperlocal discovery as a multi-role civic product requires durable relational storage, role and booking isolation, and a ranking path that does not force a separate paid-bidding or machine learning service beside the application. This paper presents a PostgreSQL-centred architecture for that setting. All vendors, service categories, and user roles share one PostgreSQL database with GIN full-text and GiST spatial indexes. Isolation and rating integrity are obtained by tagging every booking and review with customer and vendor identifiers and applying a completed-booking check before any rating updates the vendor score. Sparse ratings are stabilised by Dynamic Bayesian Shrinkage, distance is modelled by continuous Haversine decay, and identity trust is captured by a Multi-Factor Verification Trust Score (MFVTS). The design is realised in Smart Vendor Hub, an Angular 19 and FastAPI platform that connects citizens with local tradespeople, answers searches with Explainable Information Retrieval (XIR) score breakdowns, and exposes the same ranking function to a citizen discovery portal and to a live Researcher simulation lab. We describe the index schema, the ranking and review-gate algorithms, the isolation invariant, and an empirical evaluation on a deployed instance. The result is a practical blueprint for using PostgreSQL as a shared ranking store in hyperlocal service discovery without pay-to-play ad auctions or an external neural ranker.
Keywords
Bayesian rating shrinkage; explainable ranking; Haversine distance; hyperlocal service discovery; multi-factor trust; PostgreSQL
References
[1] Kumar S, Smith SR, Fowler G, Velis C, Kumar SJ, Arya S, et al. Challenges and opportunities associated with waste management in India. Royal Society Open Science. 2017;4(3):160764. https://doi.org/10.1098/rsos.160764
[2] Amasuomo E, Baird J. The concept of waste and waste management. Journal of Management and Sustainability. 2016;6(4):88–96.
[3] Kadus T, Nirmal P, Kulkarni K. Smart hyperlocal service management system. International Journal of Engineering Research & Technology (IJERT). 2020;9(4).
[4] Gupta K. Smart civic service management system using automated discovery. International Journal of Engineering Research. 2021.
[5] de Campos LM, Fernández-Luna JM, Huete JF. A collaborative filtering method based on Bayesian networks. Inf. Sci. 2010;180(14):2736–2753.
[6] Arthur MP, Shoba S, Pandey A. A survey of intelligent discovery systems using machine learning. Artif. Intell. Rev. 2024;57(56).
[7] PostgreSQL Global Development Group. PostgreSQL documentation: Full-text search and GIN/GiST indexes [Internet]. 2026. https://www.postgresql.org/docs/
[8] Nisarga NTD, Sahana S, Parashar S, Girijamaba DL. Civic monitoring system using integrated web technology. International Journal of Engineering Research & Technology (IJERT). 2018;6(13).
[9] Imran, Ahmad S, Kim DH. Quantum GIS based descriptive and predictive data analysis for effective planning of waste management. IEEE Access. 2020;8.
[10] Shahab S, Anjum M. Solid waste management scenario in India and illegal dump detection using deep learning: An AI solution towards the development of clean India. Sustainability. 2022;14(23):15896.
[11] Krebs R, Momm C, Kounev S. Architectural concerns in multi-tenant SaaS applications. In: Proceedings of the 2nd International Conference on Cloud Computing and Services Science (CLOSER). 2012. p. 426–431.
[12] OWASP Foundation. OWASP Top 10 – 2021 [Internet]. https://owasp.org/Top10/
[13] Angular Team. Angular documentation (v19) [Internet]. https://angular.dev
[14] Ramírez S. FastAPI documentation [Internet]. https://fastapi.tiangolo.com
[15] Agafonkin V, OpenStreetMap Contributors. Leaflet.js interactive maps documentation [Internet]. https://leafletjs.com
[16] Robertson S, Zaragoza H. The probabilistic relevance framework: BM25 and beyond. Found. Trends Inf. Retr. 2009;3(4):333–389.
[17] Järvelin K, Kekäläinen J. Cumulated gain-based evaluation of IR techniques. ACM Trans. Inf. Syst. 2002;20(4):422–446.
[18] Singh A, Joachims T. Fairness of exposure in rankings. In: Proceedings of the 24th ACM SIGKDD International Conference on Knowledge Discovery & Data Mining. 2018. p. 2219–2228.
[19] Bayer M. SQLAlchemy 2.0 documentation [Internet]. https://docs.sqlalchemy.org
[20] Microsoft. Playwright end-to-end testing documentation [Internet]. https://playwright.dev
How to cite this paper
@article{1724498,
author = {Chetan Khandare, Neha Kumbhalwad, Shreya Katkar, Sakshi Somwanshi, Ashwini Garkhedkar},
title = {Smart Vendor Hub: An Evidence-Aware Adaptive Ranking and Multi-Factor Trust Framework for Hyperlocal Municipal Service Discovery},
journal = {Iconic Research And Engineering Journals},
year = {2026},
volume = {10},
number = {4},
pages = {4967-4974},
issn = {2456-8880},
url = {https://www.irejournals.com/formatedpaper/1724498.pdf},
abstract = {Evidence-aware ranking reduces rating manipulation and commercial bias in local service directories by conditioning vendor order on verified reviews, physical distance, and identity trust stored in a shared database index. Deploying hyperlocal discovery as a multi-role civic product requires durable relational storage, role and booking isolation, and a ranking path that does not force a separate paid-bidding or machine learning service beside the application. This paper presents a PostgreSQL-centred architecture for that setting. All vendors, service categories, and user roles share one PostgreSQL database with GIN full-text and GiST spatial indexes. Isolation and rating integrity are obtained by tagging every booking and review with customer and vendor identifiers and applying a completed-booking check before any rating updates the vendor score. Sparse ratings are stabilised by Dynamic Bayesian Shrinkage, distance is modelled by continuous Haversine decay, and identity trust is captured by a Multi-Factor Verification Trust Score (MFVTS). The design is realised in Smart Vendor Hub, an Angular 19 and FastAPI platform that connects citizens with local tradespeople, answers searches with Explainable Information Retrieval (XIR) score breakdowns, and exposes the same ranking function to a citizen discovery portal and to a live Researcher simulation lab. We describe the index schema, the ranking and review-gate algorithms, the isolation invariant, and an empirical evaluation on a deployed instance. The result is a practical blueprint for using PostgreSQL as a shared ranking store in hyperlocal service discovery without pay-to-play ad auctions or an external neural ranker.},
keywords = {Bayesian rating shrinkage; explainable ranking; Haversine distance; hyperlocal service discovery; multi-factor trust; PostgreSQL},
month = {October},
doi = {https://doi.org/10.64388/IREV10I4-1724498}
}