CFP last date
20 November 2026
Reseach Article

Deterministic Entity Resolution: Schema-Derived Decision Logic for Variant Disambiguation and Precision Queries in Retrieval-Augmented Commerce Search

by Shekhar Maheshwari
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 187 - Number 147
Year of Publication: 2026
Authors: Shekhar Maheshwari
10.5120/ijca3cabe21c92e5

Shekhar Maheshwari . Deterministic Entity Resolution: Schema-Derived Decision Logic for Variant Disambiguation and Precision Queries in Retrieval-Augmented Commerce Search. International Journal of Computer Applications. 187, 147 ( Oct 2026), 55-60. DOI=10.5120/ijca3cabe21c92e5

@article{ 10.5120/ijca3cabe21c92e5,
author = { Shekhar Maheshwari },
title = { Deterministic Entity Resolution: Schema-Derived Decision Logic for Variant Disambiguation and Precision Queries in Retrieval-Augmented Commerce Search },
journal = { International Journal of Computer Applications },
issue_date = { Oct 2026 },
volume = { 187 },
number = { 147 },
month = { Oct },
year = { 2026 },
issn = { 0975-8887 },
pages = { 55-60 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume187/number147/deterministic-entity-resolution-schema-derived-decision-logic-for-variant-disambiguation-and-precision-queries-in-retrieval-augmented-commerce-search/ },
doi = { 10.5120/ijca3cabe21c92e5 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2026-10-24T03:08:39.726467+05:30
%A Shekhar Maheshwari
%T Deterministic Entity Resolution: Schema-Derived Decision Logic for Variant Disambiguation and Precision Queries in Retrieval-Augmented Commerce Search
%J International Journal of Computer Applications
%@ 0975-8887
%V 187
%N 147
%P 55-60
%D 2026
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Deterministic entity resolution is a clear solution for differentiating between similar variants of products in retrieval-augmented commerce search. This study presents the schema-derived decision logic which can be used to alleviate the confusion between variants prior to retrieval and ranking based on the product title/brand field, the model terms, the pack signals, the attribute slots and the query intent markers. We have created a representative set of 171 instances for commerce-search for this study across six query patterns including exact product names, alias expressions, mixed attributes, ambiguous variants, bundle language and near duplicate product descriptions. The data was organized in a spreadsheet, processed with the Python scripting language and analyzed using rule tracing, text normalization, decision gates, summary tables, and plot visual outputs. This proposed framework requires no additional training labels; the decision of acceptance or rejection is made deterministically based on rules in the fields. The results suggest that the schema-aware logic helps to improve the separation of entities, reduces the number of irrelevant matches in high-intent commerce queries, and enables auditable query behavior. The study also demonstrates the value of compact decision traces, row-level evidence, and structured outputs in aiding product-search teams in diagnosis of retrieval errors, in addition to opaque scores. The framework is in general capable of disambiguating precisely, explainable and operationally for commerce search scenarios.

References
  1. S. S. Aanen, D. Vandic, and F. Frasincar, “Automated product taxonomy mapping in an e-commerce environment,” Expert Systems with Applications, vol. 42, no. 3, pp. 1298–1313, 2015. https://doi.org/10.1016/j.eswa.2014.09.032
  2. B. Gu, Z. Li, X. Zhang, A. Liu, G. Liu, K. Zheng, L. Zhao, and X. Zhou, “The interaction between schema matching and record matching in data integration,” IEEE Transactions on Knowledge and Data Engineering, vol. 29, no. 1, pp. 186–199, 2017. https://doi.org/10.1109/TKDE.2016.2611577
  3. P. Ristoski, P. Petrovski, P. Mika, and H. Paulheim, “A machine learning approach for product matching and categorization: Use case: Enriching product ads with semantic structured data,” Semantic Web, vol. 9, no. 5, pp. 707–728, 2018. https://doi.org/10.3233/SW-180300
  4. A. Allam, S. Skiadopoulos, and P. Kalnis, “Improved suffix blocking for record linkage and entity resolution,” Data & Knowledge Engineering, vol. 117, pp. 98–113, 2018. https://doi.org/10.1016/j.datak.2018.07.005
  5. G. Simonini, L. Gagliardelli, S. Bergamaschi, and H. V. Jagadish, “Scaling entity resolution: A loosely schema-aware approach,” Information Systems, vol. 83, pp. 145–165, 2019. https://doi.org/10.1016/j.is.2019.03.006
  6. J. Li, Z. Dou, Y. Zhu, X. Zuo, and J.-R. Wen, “Deep cross-platform product matching in e-commerce,” Information Retrieval Journal, vol. 23, no. 2, pp. 136–158, 2020. https://doi.org/10.1007/s10791-019-09360-1
  7. L. Akritidis, A. Fevgas, P. Bozanis, and C. Makris, “A self-verifying clustering approach to unsupervised matching of product titles,” Artificial Intelligence Review, vol. 53, pp. 4777–4820, 2020. https://doi.org/10.1007/s10462-020-09807-8
  8. D. C. Nascimento, C. E. S. Pires, and T. P. Nóbrega, “Configurable assembly of classification rules for enhancing entity resolution results,” Information Processing & Management, vol. 57, no. 3, art. 102224, 2020. https://doi.org/10.1016/j.ipm.2020.102224
  9. G. Papadakis, D. Skoutas, E. Thanos, and T. Palpanas, “Blocking and filtering techniques for entity resolution: A survey,” ACM Computing Surveys, vol. 53, no. 2, art. 31, pp. 1–42, 2020. https://doi.org/10.1145/3377455
  10. V. Christophides, V. Efthymiou, T. Palpanas, G. Papadakis, and K. Stefanidis, “End-to-end entity resolution for big data: A survey,” ACM Computing Surveys, vol. 53, no. 6, pp. 1–42, 2020. https://doi.org/10.1145/3418896
  11. O. S. Albayrak, T. Aytekin, and T. A. Kalaycı, “Duplicate product record detection engine for e-commerce platforms,” Expert Systems with Applications, vol. 193, art. 116420, 2022. https://doi.org/10.1016/j.eswa.2021.116420
  12. C. Ye, S. Jiang, H. Zhang, Y. Wu, J. Shi, H. Wang, and G. Dai, “JointMatcher: Numerically-aware entity matching using pre-trained language models with attention concentration,” Knowledge-Based Systems, vol. 251, art. 109033, 2022. https://doi.org/10.1016/j.knosys.2022.109033
  13. H. Ding, C. Dai, Y. Wu, W. Ma, and H. Zhou, “SETEM: Self-ensemble training with pre-trained language models for entity matching,” Knowledge-Based Systems, vol. 293, art. 111708, 2024. https://doi.org/10.1016/j.knosys.2024.111708.
Index Terms

Computer Science
Information Sciences

Keywords

Deterministic entity resolution; schema-derived logic; variant disambiguation; precision queries; retrieval-augmented commerce search