The question
Which holdings were disclosed for this scheme in September?
Select a scheme, plan and reporting-period snapshot.
Explore SQLMutual funds
Find holdings, scheme terms and addenda for the correct fund, plan and reporting period. Give service teams the source document for each answer.
Locate holdings and terms for the correct reporting period.
Illustrative use case01 / Use case guide
Compare the data models behind everyday industry tasks, from finding records to following connections.
Suggested model combination
Scroll across to compare all four models| Use case | How the data models help | SQL | Vector | Graph | Full-text | Source |
|---|---|---|---|---|---|---|
| Disclosed portfolio holdings review Find a scheme's holdings and commentary for the same reporting period. | Use SQL to select the scheme and dated holdings, and Full-text to locate matching scheme names and commentary in its factsheet. | SQL included | Vector not needed for this example | Graph not needed for this example | Full-text included | |
| Exit load term lookup Find the redemption wording applicable to a particular scheme and investment date. | Use SQL to select dated scheme terms, Vector to match investor wording, and Full-text to locate the exact exit-load clause. | SQL included | Vector included | Graph not needed for this example | Full-text included | |
| NAV publication reconciliation Identify missing or inconsistent published NAV records for each scheme and date. | Use SQL to compare imported NAV snapshots and Graph to trace each scheme–plan record to its source publication. | SQL included | Vector not needed for this example | Graph included | Full-text not needed for this example | |
| Riskometer change review Retrieve the notice behind a change in a scheme's disclosed riskometer. | Use SQL to select riskometer records by scheme and date, and Full-text to find the associated change notice. | SQL included | Vector not needed for this example | Graph not needed for this example | Full-text included | |
| KYC exception evidence lookup Find the recorded KYC status and guidance relevant to an investor's service request. | Use SQL to retrieve the authorized status record and Full-text to locate the matching status explanation and document checklist. | SQL included | Vector not needed for this example | Graph not needed for this example | Full-text included | |
| Unclaimed payment tracing Investigate redemption or distribution payments that did not reach the investor. | Use SQL to select unpaid items, Graph to trace folio and payment-account links, and Full-text to retrieve recorded failure reasons. | SQL included | Vector not needed for this example | Graph included | Full-text included | |
| SIP mandate servicing review Find the mandate and instructions behind a request to change a SIP bank account. | Use SQL to retrieve SIP status, Graph to follow the registered mandate–bank relationship, and Full-text to locate applicable change instructions. | SQL included | Vector not needed for this example | Graph included | Full-text included | |
| Nomination update evidence checks Review a new nomination request against existing folio and holder records. | Use SQL to select nomination versions, Graph to trace folio-holder relationships, and Full-text to retrieve the submitted request and signature instructions. | SQL included | Vector not needed for this example | Graph included | Full-text included | |
| Unit transmission document review Check the evidence supplied when a nominee requests transmission of units. | Use SQL to list received documents, Graph to connect the folio, deceased holder and nominee, and Full-text to retrieve the relevant checklist. | SQL included | Vector not needed for this example | Graph included | Full-text included | |
| Scheme disclosure change tracking Identify which scheme documents and service answers need review after an addendum. | Use SQL to select effective dates, Graph to link addenda to affected schemes and documents, and Vector to retrieve related existing explanations. | SQL included | Vector included | Graph included | Full-text not needed for this example |
Use the query interfaces you need, then connect their results through shared record IDs in your application.
These sources describe real industry workflows. The model combinations above are proposed OriginChainDB designs, not customer deployment claims.
02 / A closer look
An investor asks about a scheme’s holdings and exit-load wording. The service team must identify the correct scheme and plan, use the applicable disclosure date and locate the relevant document passage.
A scheme name may have several plans and options.
Monthly factsheets and later addenda can disagree if dates are ignored.
Holdings tables and scheme wording use different formats.
Select the exact scheme, plan and period before searching documents. Keep reporting dates and effective dates separate so answers do not mix holdings or terms from different versions.
03 / Queries
Select a model to see the question it answers.
The question
Select a scheme, plan and reporting-period snapshot.
Explore SQLThe question
Find relevant explanations when investor wording differs.
Explore VectorThe question
Connect the scheme to its manager, holdings and documents.
Explore GraphThe question
Locate exact scheme names, ISINs and terms.
Explore Full-textUse shared record IDs to combine results from the different query interfaces in your application.
04 / Implementation
Start with public or licensed disclosures and operations-approved questions. Leave investor records out of the first pilot.
Record scheme codes, plan options, ISINs, reporting dates and effective dates. Link passages to source documents and refresh indexes when versions change.
Filter by scheme and date, then retrieve wording and related disclosures. Show missing dates or conflicting versions to the service team.
Compare with approved answers. Test renamed schemes, changed terms and superseded documents before publishing responses to investors.
05 / Testing
Compare these results with your current process before rollout.
Check results against the intended scheme, plan and option in the evaluation set.
Track responses that use an incorrect disclosure period or superseded term.
Measure the delay from an approved source update to searchable, verified records and indexes.
06 / Sources
Published projects and reference material relevant to this use case.
HDFC Mutual Fund
HDFC Mutual Fund publishes factsheets containing scheme objectives, fund managers, portfolio holdings, risk ratios and historical performance, with a monthly publication intent.
Read the sourceSEBI
SEBI’s mutual-fund filings directory provides separate access to statements of additional information, scheme information documents and key information memoranda.
Read the sourceThese are industry references, not OriginChainDB customer stories. The implementation above is a proposed example.
Build with OriginChainDB