Data Science
Critical-Link Identification and Flood-Disruption Resilience of the Hyderabad Road Network (OSMnx)
Betweenness-ranked corridors and measured accessibility deltas under bridge and metro-corridor closure scenarios
- Python
- OSMnx
- NetworkX
- +5
Graded-relevance, significance-tested comparison of sparse and dense retrieval on India's open-data catalogue
Mapped to your syllabusAnna University M.E. Regulation 2021 · CP4411 Project Work II · Semester 4OpenData-IR is an evaluation study that measures, with a defensible protocol, whether transformer-based sentence-embedding retrieval actually finds government datasets better than the classic BM25 lexical ranker when searching the metadata catalogue of data.gov.in — India's national open-government data platform.
data.gov.in publishes a very large catalogue of government datasets — over a lakh API-exposed resources by independent counts — each described by a title, description, sector tags and publishing organisation. Finding the right dataset is the first hurdle every student, journalist and analyst faces, and the portal's search is keyword-based: ask for "rainfall" and a dataset described as "actual precipitation" can rank below weaker matches. Dense retrieval promises to close that vocabulary gap, but adopting heavier infrastructure without measured evidence is engineering folklore.
The study builds a clean corpus of catalogue metadata through the portal's official resource APIs, designs a sampled query set of realistic information needs, collects graded relevance judgments (0/1/2) under a pooling protocol fixed in advance, and scores both systems with nDCG@10, MAP and MRR. Because single-number comparisons mislead, every pairwise claim is tested at query level with the Wilcoxon signed-rank test. Index build time, memory footprint and query latency of both index families are measured on the same laptop, so the accuracy-versus-cost trade-off is stated numerically, not rhetorically.
The deliverable is a paper-style study — corpus snapshot, judgment set, evaluation harness, results tables with confidence statements and an error analysis — executable end to end on a personal machine.
Syllabus alignment
India's open-data catalogue holds government datasets across agriculture, health, education, finance and utilities, but discovery still depends on keyword matching between a user's words and a record's words. Department authors use official terminology — scheme names, acronyms, technical terms — while citizens and analysts phrase needs in everyday language, so relevant records are missed ("crop insurance" against the actual scheme name) and near-duplicates crowd out the right one. Whether sentence-embedding retrieval fixes this on real catalogue metadata is asserted far more often than it is measured, and no graded-relevance benchmark for data.gov.in is public. An organisation upgrading its search must therefore either trust results borrowed from foreign web collections or run an unstructured bake-off. This study produces the missing evidence: a documented corpus, a pre-declared query and judgment protocol, head-to-head nDCG/MAP/MRR results with statistical significance, and measured latency and memory costs — turning the retrieval choice for government catalogue search into a defensible engineering decision rather than an article of faith.
This dissertation evaluates lexical (BM25) and sentence-embedding (dense) retrieval over the metadata catalogue of data.gov.in, India's national open-government data platform. A corpus of dataset records (title, description, sector, organisation) is assembled through the portal's official resource APIs; a sampled query set of 30–40 realistic information needs is judged for graded relevance under a pre-declared pooling protocol; and both systems are compared on nDCG@10, MAP and MRR with query-level Wilcoxon signed-rank tests. The study also measures index build time, index size and query latency, and closes with an error analysis locating where dense retrieval earns its cost.
Open data creates value only when it can be found. A citizen looking for crop-insurance statistics, a journalist verifying procurement numbers and a researcher building a district panel all start from the catalogue's search box. Metadata records are short, jargon-heavy and written by dozens of departments with inconsistent vocabulary, so keyword overlap is a fragile basis for ranking. The question is empirical: on this catalogue, does embedding-based ranking measurably improve retrieval quality over a well-tuned classical baseline?
The portal's discovery layer is keyword-led. The information-retrieval literature — from Cranfield through TREC practice to modern neural-ranking work — establishes BM25 as a strong baseline and dense retrieval as strong on large web collections. But published comparisons rarely cover Indian government catalogues: no public graded-relevance benchmark exists for data.gov.in, and web-collection findings do not automatically transfer to short, department-authored records where relevance often hinges on one scheme name or acronym. Adoption arguments for embeddings are asserted far more often than they are measured on this domain.
In scope
Out of scope
The study uses a quantitative, comparative-experimental research design: the protocol is fixed before scoring, all comparisons are paired at query level, and every artefact (corpus snapshot, judgment sheet, run configuration) is versioned. The evaluation protocol — query sources, pooling depth, grade scale, metrics, statistical test — was written down before the first system ran, following the research-methodology discipline of RM4151, so results cannot be reshaped by re-deciding the protocol after seeing them.
| Phase | Weeks | Activities | Deliverable |
|---|---|---|---|
| Survey and protocol design | 1–4 | IR evaluation literature (Cranfield/TREC practice, nDCG, pooling, significance testing); write the protocol pre-declaration | Survey chapter + frozen protocol |
| Corpus construction | 5–8 | Paginated harvest via the resource APIs; cleaning, deduplication, field selection; snapshot and data-quality report | Versioned corpus snapshot |
| Harness and systems | 9–11 | Implement indexers, retrievers and metrics behind one interface; tune BM25 k1/b and choose the embedding model on a development slice only | Reproducible harness |
| Query set and judgments | 12–15 | Sample and freeze queries; pool results (depth 10 per system plus portal order); grade 0/1/2; double-judge 20% and compute agreement | Judgment sheet |
| Runs and statistics | 16–19 | Score all systems; nDCG@10/MAP/MRR; per-query Wilcoxon tests; latency and memory profiling | Results tables |
| Error analysis and writing | 20–24 | Error taxonomy, qualitative examples, dissertation, slides and defence preparation | Dissertation + presentation |
Relevance protocol (declared before scoring). Queries are sampled from four sources — sector names, real scheme names published on the portal, analyst-style tasks and everyday paraphrases — then frozen. For each query, pooling merges the top 10 results from BM25, the top 10 from the embedding retriever and the portal's own first page; each pooled record is graded 0/1/2 against its full metadata page. A second assessor re-judges a 20% stratified sample; Cohen's kappa is reported, and disagreements are resolved by re-reading the record together before any system is scored.
Leakage-free indexing. Indexes are built from the corpus snapshot only — no query text and no judgment information ever enters an index. Embedding-model choice and BM25 tuning touch only the development slice of queries; the judged set is untouched until the final run, and the report states this explicitly.
OpenData-IR is a linear, scripted pipeline with strict artefact boundaries, so that corpus, judgments, runs and statistics cannot contaminate one another.
flowchart TD
A["data.gov.in resource APIs<br/>official catalogue endpoints"] --> B["Harvest and clean<br/>dedupe, snapshot date, provenance log"]
B --> C[("Corpus snapshot<br/>JSONL dataset records")]
C --> D["BM25 indexer<br/>inverted index, k1/b from dev slice"]
C --> E["Dense indexer<br/>sentence-transformers, cosine, FAISS/NumPy"]
Q["Frozen query set<br/>30-40 information needs"] --> F["Retrieval harness<br/>one interface, both systems"]
D --> F
E --> F
F --> G["Pooling depth 10<br/>BM25 top-10 + dense top-10 + portal order"]
G --> H["Graded judgments 0/1/2<br/>20 percent double-judged, kappa reported"]
H --> I[("Judgment sheet<br/>frozen before test runs")]
F --> J["Ranked run tables<br/>query id, document id, rank"]
I --> K["Metrics: nDCG@10, MAP, MRR"]
J --> K
K --> L["Wilcoxon signed-rank<br/>paired per-query tests"]
K --> M["Cost profiler<br/>build time, index size, p50/p95 latency"]
L --> N["Results tables + error taxonomy"]
M --> NThree boundaries carry the study's credibility. First, the corpus snapshot is an immutable artefact with a recorded harvest date; both indexers read only it, which makes the comparison fair and repeatable even as the live catalogue grows. Second, the judgment sheet is produced by the pooling step and frozen before the final scoring run — systems are never modified after judgments exist, which is what separates an evaluation from a leaderboard climb. Third, the cost profiler runs on identical hardware for both index families and reports build time, on-disk size and p50/p95 latency, so every accuracy claim in the results chapter is paired with the price of achieving it.
The harness stores each run as a tidy table (query id, document id, rank, score); metrics are computed only by joining run tables to the frozen judgment sheet, so any number in the dissertation can be recomputed with a single command from two artefacts.
Package 01
Harvests dataset records page by page from data.gov.in's official resource APIs with a registered API key, logging every request; normalises title, description, sector and organisation fields; removes duplicates and near-duplicates; records the snapshot date and writes a versioned JSONL corpus with a data-quality report.
Package 02
Builds the BM25 inverted index (rank-bm25) with document-length normalisation and development-slice-tuned k1/b, and the dense index that encodes each record as a normalised sentence-embedding vector (sentence-transformers) searched by cosine similarity via FAISS or NumPy; both expose one identical search interface to the harness.
Package 03
Samples and freezes 30–40 realistic information needs from sector names, published scheme names, analyst tasks and everyday paraphrases; produces the pooled candidate list (depth 10 per system plus the portal's own ordering); and drives the 0/1/2 grading worksheet, including the 20% double-judgment sample and the Cohen's kappa computation.
Package 04
Runs every system over the frozen query set into tidy run tables and computes nDCG@10, MAP and MRR per query and in aggregate, joined strictly against the frozen judgment sheet; no other component in the pipeline may compute a metric, which keeps the pre-declared protocol structurally tamper-proof.
Package 05
Applies the Wilcoxon signed-rank test to paired per-query nDCG scores for every system pair, reporting effect direction and p-values alongside descriptive statistics; measures index build time, index size and p50/p95 query latency for both families on the same machine with warm caches and single-query requests.
Package 06
Assigns each query a class (acronym lookup, scheme-name lookup, plain-language paraphrase, multi-topic) and each error a cause (vocabulary mismatch, acronym absent from metadata, sparse description, multi-topic drift), then tabulates wins and losses per class so the aggregate result is explained, not just reported.
Slide 1
BM25 vs Sentence-Embedding Retrieval on the data.gov.in Catalogue
Slide 2
Why catalogue search matters
Slide 3
Research questions
Slide 4
Gap in existing work
Slide 5
Corpus: official metadata, provenance-logged
Slide 6
Query set design
Slide 7
Relevance protocol
Slide 8
Systems compared
Slide 9
Evaluation and statistics
Slide 10
Results
Slide 11
Error analysis
Slide 12
Threats to validity and limitations
Slide 13
Conclusion & future scope
Slide 14
References & artefacts
Bullets, speaker notes and the .pptx · ₹2,000
Read each answer, close it, and say it in your own words. Your viva will ask. Now you'll know.
BM25 is a well-understood probabilistic ranking function that rewards exact term matches with length normalisation, and relevance in catalogues often hinges on exact strings — scheme names, acronyms, ministry titles. It is also cheap and fast. A tuned BM25 frequently stays competitive with dense systems on collections like this one, so any accuracy claim for embeddings must be measured against it, not assumed from web-collection literature.
nDCG@10 discounts each result's relevance gain logarithmically by its rank position up to rank 10, then divides by the ideal ranking's gain so scores are comparable across queries. Graded judgments matter because catalogue relevance is not binary — a district rainfall dataset is partially relevant to a crop-insurance query — and a 0/1/2 scale lets the metric reward the best record, penalise the merely adjacent one and capture the difference.
Exhaustively judging tens of thousands of records for every query is impossible, so pooling merges the top results from every system under comparison — plus the portal's own ranking — into one candidate list that is judged once. Records outside the pool are treated as non-relevant, a standard TREC practice whose bias stays small when the pool covers the top ranks of all systems, which is exactly where ranking quality is decided.
+13 more questions, with answers
Unlocks with the project · ₹2,000
Unlock for ₹2,000What to change before it goes anywhere near a submission. Skipping it is how the demo fails live.
Unlocks with the project · ₹2,000
Unlock for ₹2,000How to study it, adapt it and walk your examiner through it, step by step.
Unlocks with the project · ₹2,000
Unlock for ₹2,000OnlyProjects. (2026). BM25 vs Sentence-Embedding Retrieval on the data.gov.in Catalogue: A Significance-Tested Query-Level Evaluation: M.Tech / M.E. Data Science project bundle [Educational resource]. https://onlyprojects.online/projects/mtech-ds-bm25-vs-embedding-retrieval-datagov-catalogue-eval
Keep browsing
Same degree, same syllabus slot, different idea. Pick the one your guide will actually approve.
Data Science
Betweenness-ranked corridors and measured accessibility deltas under bridge and metro-corridor closure scenarios
Data Science
Day-ahead demand forecasts for the Karnataka grid — baselines versus ML, judged by honest walk-forward validation
Information Technology
p50/p95/p99 latency, throughput and proxy resource cost measured with k6 under one declared protocol on a pinned k3s cluster
Aerospace / Aeronautical
A mesh-converged OpenFOAM study of the NACA 0012 aerofoil validated against XFOIL and NASA's turbulence-modelling reference data
Artificial Intelligence & Machine Learning
A new annotated Telugu–English corpus with measured agreement, and an honest benchmark of TF-IDF+SVM, BiLSTM, mBERT, XLM-R and MuRIL
Automobile Engineering
Three BMS estimators benchmarked on NASA and CALCE battery data under drive-cycle loads and cold-start SOC errors