Databases
AuraScore 81/100

Litigation Hold Full-Text Indexing Architecture

Formulate a full-text search indexing, document parsing, and storage plan for legal discovery repositories.

Use this template when designing or optimizing an eDiscovery database backend for litigation hold corpora. It establishes parsing pipelines, inverted index parameters, and tamper-evident storage layouts for legal compliance.

Template

Role: Senior eDiscovery Database Engineer specializing in high-throughput full-text search and compliance storage.

Context

  • Law Firm / Legal Entity: {{law_firm_name}}
  • Matter Type: {{matter_type}}
  • Custodian Scope: {{custodian_count}}
  • Document Corpus Scale: {{unstructured_corpus_size}}
  • Core Search Platform: {{primary_search_engine}}
  • Preservation Requirement: {{retention_mandate}}

Task

Draft a comprehensive database indexing and search configuration brief for {{law_firm_name}} to ingest and index {{unstructured_corpus_size}} of evidentiary material under {{retention_mandate}}.

Method

  1. Define metadata catalog schemas to store document provenance, custodian tags, Bates numbers, and hash digests.
  2. Establish tokenization, language analyzers, and stemming rules optimized for {{matter_type}} evidentiary documents.
  3. Configure inverted index field mappings in {{primary_search_engine}} to support proximity searches, Boolean operators, and wildcard expansions.
  4. Design shard sizing, replication factor, and routing keys based on {{custodian_count}} to prevent hot-spotting.
  5. Set up payload storage boundaries separating raw document text, extracted metadata, and OCR-derived transcripts.
  6. Formulate immutable write-once-read-many (WORM) storage mechanics to satisfy {{retention_mandate}}.
  7. Structure index warm-up routines and memory cache allocations to support complex multi-term attorney search queries.
  8. Detail disaster recovery and zero-loss snapshotting procedures tailored to the search cluster.

Constraints

  • MUST enforce cryptographic hash validation (SHA-256) on ingestion to guarantee chain of custody.
  • MUST NOT allow mutable document updates; all updates must be appended as revised versions.
  • Memory configurations must stay within standard compute sizing for {{primary_search_engine}}.
  • Exclude vague recommendations; specify concrete index settings, analyzer names, and field types.

Output format

Litigation Hold Indexing & Search Brief

1. Metadata Catalog & Schema Mapping

(Document catalog structure and custody metadata fields)

2. Text Analysis & Index Configuration

(Analyzers, tokenizers, custom filters, and field types for {{primary_search_engine}})

3. Sharding, Routing & Capacity Strategy

(Shard allocations, segment merges, and node memory profiles)

4. Chain-of-Custody & Integrity Controls

(WORM verification, immutable logging, and snapshot schedule)

Self-review

  • Confirm that search analyzer configurations support Boolean and proximity syntax needed for {{matter_type}}.
  • Verify shard calculations directly reference {{unstructured_corpus_size}} and {{custodian_count}}.
  • Ensure chain-of-custody requirements are rigorously addressed in the output.
AuraScore breakdown
81/100Provisional
Instruction clarity15/15 · Strong

Explicit role, a named task, and discrete steps the model can follow.

Context architecture12/12 · Strong

Background, inputs and variables the model needs before it starts.

Constraint engineering12/12 · Strong

Hard boundaries — what the model must and must not do.

Output specification6/14 · Thin

A named, field-level shape for the response.

Reasoning structure10/10 · Strong

Ordered work items that force analysis before an answer.

Model compatibility10/10 · Strong

Length and structure that travel across frontier models.

Token efficiency5/10 · Thin

Signal density — instruction weight without padding.

Reusability7/7 · Strong

Documented variables so the scaffold adapts to new inputs.

Robustness3/5 · Adequate

Quality bar, assumptions and behaviour when inputs are thin.

Observed performance1/5 · Thin

How much real usage the template has behind it.

developers
developers-databases
research-productivity-operations
databases
legaltech
full-text-search