Objective: Replace basic database queries with a "Search Engine" pattern. This system pre-processes transaction descriptions, generates automated "Context Tags," and builds a dedicated search index for high-performance faceted filtering (e.g., search by amount range + category + merchant sentiment).
Files involved (9):
services/indexingEngine.js (New: Logic to pre-calculate search facets)
utils/metadataProcessor.js (New: Extracts merchant names and types)
models/SearchIndex.js (New: Dedicated flat store for fast querying)
middleware/searchCache.js (New: Result caching for frequent queries)
routes/search.js
(New: Advanced search API)
models/Transaction.js
(Update: Adding automated tagging fields)
jobs/searchIndexer.js (New: Background job to rebuild the index)
tests/searchEngine.test.js (New: Performance and facet tests)
SEARCH_ARCHITECTURE.md (Technical spec)
Objective: Replace basic database queries with a "Search Engine" pattern. This system pre-processes transaction descriptions, generates automated "Context Tags," and builds a dedicated search index for high-performance faceted filtering (e.g., search by amount range + category + merchant sentiment).
Files involved (9):
services/indexingEngine.js (New: Logic to pre-calculate search facets)
utils/metadataProcessor.js (New: Extracts merchant names and types)
models/SearchIndex.js (New: Dedicated flat store for fast querying)
middleware/searchCache.js (New: Result caching for frequent queries)
routes/search.js
(New: Advanced search API)
models/Transaction.js
(Update: Adding automated tagging fields)
jobs/searchIndexer.js (New: Background job to rebuild the index)
tests/searchEngine.test.js (New: Performance and facet tests)
SEARCH_ARCHITECTURE.md (Technical spec)