Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ ZENODOarrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
ZENODO
Conference object . 2026
License: CC BY
Data sources: ZENODO
ZENODO
Article . 2026
License: CC BY
Data sources: Datacite
ZENODO
Article . 2026
License: CC BY
Data sources: Datacite
versions View all 2 versions
addClaim

Arabic Full-Text Search with Query-Level Authorization in Institutional Document Retrieval: A PostgreSQL Benchmark Study

Authors: Qareesh, Mansour;

Arabic Full-Text Search with Query-Level Authorization in Institutional Document Retrieval: A PostgreSQL Benchmark Study

Abstract

Abstract—Institutional correspondence systems require Arabic search that remains responsive at scale while enforcingaccess policies within the query execution path. This paperpresents an applied benchmark study of ICAS1, a Laravelbased institutional correspondence and archiving system backedby PostgreSQL. The evaluation uses a dedicated syntheticbenchmark database containing approximately 100,000 correspondences, 60,000 archives, and 120,000 recipient links. PostgreSQL Arabic full-text search (FTS) using to_tsvector andplainto_tsquery with Generalized Inverted Index (GIN)indexing is compared against an ILIKE baseline across threeprimary institutional scenarios. Latencies are measured usingEXPLAIN (ANALYZE, BUFFERS) with seven repeated runs.Results show FTS achieves median latencies of 21–55ms compared with 229–248ms for ILIKE, yielding speedups of 4.2×to 11.7×. An extended evaluation across 10 Arabic institutionalkeywords confirms a consistent warm-cache speedup of 4.15×4.98× for the global administrator scenario and 10.3×–12.7× fordepartment-scoped roles. Session-level cold-cache measurements(after DISCARD ALL and reconnect) show the same directionaladvantage. Retrieval overlap analysis over 30 keyword–scenariocombinations yields Jaccard = 1.0 for the corpus vocabulary used.Access-control validation using canary records confirms completeagreement between expected and observed visibility, includingnon-leakage of classified documents to restricted roles. The findings support combining Arabic FTS, query-level authorization,and GIN indexing for efficient and policy-consistent retrieval ininstitutional workloads, with the caveat that measurements reflectsingle-node conditions on a fixed synthetic corpus, and generalization to full cold-start or distributed deployments requires furtherinvestigation.

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average