Industry workflows
Your industry.
Four ways to query.
Build with SQL, vector, graph and full-text in one database—from financial investigations to product discovery.
OriginChainDB / Distributed multimodal database
Give an investigator records, relationships and supporting evidence.
13 industries / 65 use cases
Start with a use case.
Choose your modalities.
See where SQL, Graph, FTS and Vector fit—and what each adds to the workflow.
5 use cases / Banking
Banking use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Account servicing Bring balances, account details and recent activity into a service view. | Recommended modalities |
Why it fits
SQL joins customer and account records, filters recent transactions and calculates the totals the service team needs. |
| Connected-account investigations Explore transfers between accounts and their recorded counterparties. | Recommended modalities |
Why it fits
SQL narrows activity by amount and time. Graph follows account and counterparty links to reveal the connected records. |
| Case evidence review Connect an investigation to its correspondence and supporting documents. | Recommended modalities |
Why it fits
SQL selects case records, Graph connects accounts and documents, and FTS finds names, phrases and references within the evidence. |
| Policy knowledge retrieval Find relevant policy passages for a service or operations question. | Recommended modalities |
Why it fits
FTS matches policy terms; Vector retrieves passages with similar meaning. SQL supplies document versions and business context for the application. |
| Branch operations reporting Track transaction volumes and service workloads by branch and period. | Recommended modalities |
Why it fits
SQL groups operational records by branch, date and status, with the underlying rows available for drill-down. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Payments
Payments use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Settlement reconciliation Compare payment, settlement and refund records. | Recommended modalities |
Why it fits
SQL joins records on transaction references, compares amounts and groups unresolved differences for review. |
| Merchant network investigations Explore shared accounts, devices and other recorded merchant connections. | Recommended modalities |
Why it fits
SQL selects a merchant or transaction cohort. Graph traverses the shared relationships an investigator needs to inspect. |
| Dispute document lookup Find receipts, correspondence and policy wording for a chargeback. | Recommended modalities |
Why it fits
SQL retrieves the dispute and transaction details. FTS searches the indexed evidence for relevant terms and phrases. |
| Connected fraud case review Bring transaction links and documentary evidence into the same case. | Recommended modalities |
Why it fits
SQL filters payment activity, Graph follows merchant and account connections, and FTS locates matching language in case documents. |
| Merchant support knowledge Retrieve troubleshooting guidance for a payment issue. | Recommended modalities |
Why it fits
FTS matches error codes, Vector finds related explanations, and SQL adds merchant context and the source article's version. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / NBFCs
NBFCs use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Collections worklists Find overdue instalments and organise follow-up work. | Recommended modalities |
Why it fits
SQL filters due dates and repayment status, joins borrower records and aggregates outstanding amounts. |
| Borrower relationship review Explore borrower, guarantor and business connections. | Recommended modalities |
Why it fits
SQL provides loan and borrower attributes. Graph follows the declared relationships between borrowers, guarantors and businesses. |
| Collateral evidence review Trace a financed asset to its owners, loans and supporting records. | Recommended modalities |
Why it fits
SQL selects asset and loan records, Graph connects ownership and financing relationships, and FTS searches collateral descriptions and documents. |
| Loan file retrieval Find the relevant wording in application and verification documents. | Recommended modalities |
Why it fits
SQL retrieves the application and document metadata. FTS finds references and phrases in the indexed loan file. |
| Field-team knowledge Find process guidance for a servicing or collections question. | Recommended modalities |
Why it fits
FTS matches product terminology, Vector finds related guidance, and SQL identifies the applicable product and source revision. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Lending
Lending use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Application pipeline tracking Track applications, outstanding tasks and review status. | Recommended modalities |
Why it fits
SQL joins application and task records, filters by stage and groups turnaround times for operational reporting. |
| Borrower and guarantor context Explore the people, businesses and assets connected to an application. | Recommended modalities |
Why it fits
SQL retrieves application fields. Graph follows borrower, guarantor and asset relationships for the reviewer's assessment. |
| Underwriting evidence workspace Connect application records to related entities and source documents. | Recommended modalities |
Why it fits
SQL organises application data, Graph links the supporting entities, and FTS finds evidence within the associated documents. |
| Document and clause lookup Find application terms, conditions and verification references. | Recommended modalities |
Why it fits
SQL provides application IDs and document versions. FTS locates matching clauses and reference terms for the reviewer. |
| Lending policy assistant Retrieve source passages for an internal policy question. | Recommended modalities |
Why it fits
FTS matches lending terminology and Vector finds semantically related guidance. SQL supplies product context and source metadata. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Insurance
Insurance use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Claims operations Track claims, assignments and outstanding review tasks. | Recommended modalities |
Why it fits
SQL filters claims by stage, joins assignment records and calculates operational counts and elapsed times. |
| Connected claims investigations Explore shared claimants, providers and insured assets. | Recommended modalities |
Why it fits
SQL narrows the claim cohort. Graph follows shared entities and relationships for an investigator to assess. |
| Claims evidence review Connect a claim to its policy, parties and documentary evidence. | Recommended modalities |
Why it fits
SQL retrieves claim details, Graph connects the policy and parties, and FTS locates relevant wording in the evidence. |
| Policy wording lookup Find clauses and definitions in the relevant policy version. | Recommended modalities |
Why it fits
SQL identifies policy and revision metadata. FTS searches the indexed wording for exact terms and phrases. |
| Claims knowledge retrieval Find related guidance and reference cases for a handler's question. | Recommended modalities |
Why it fits
FTS matches terminology, Vector finds similar descriptions, and SQL provides source dates and case attributes for human review. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Wealth management
Wealth management use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Portfolio servicing Retrieve client positions, transactions and account activity. | Recommended modalities |
Why it fits
SQL joins portfolio records, filters effective dates and aggregates the imported holdings and transaction data. |
| Household relationship view Connect clients, households, accounts and advisers. | Recommended modalities |
Why it fits
SQL supplies account and client attributes. Graph follows household, ownership and adviser relationships. |
| Issuer research context Trace portfolio exposure to issuers and their published documents. | Recommended modalities |
Why it fits
SQL retrieves positions, Graph connects instruments and issuers, and FTS locates relevant terms in issuer research. |
| Adviser briefing retrieval Find source material relevant to a client meeting. | Recommended modalities |
Why it fits
SQL supplies client context. FTS and Vector retrieve research by named entities, exact wording and similarity of meaning. |
| Mandate document lookup Find recorded client instructions and agreement wording. | Recommended modalities |
Why it fits
SQL identifies the client and agreement version. FTS searches the indexed document for the instructions being reviewed. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Mutual funds
Mutual funds use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Fund operations reporting Inspect subscriptions, redemptions and imported valuation records. | Recommended modalities |
Why it fits
SQL filters records by fund and date, aggregates flows and retrieves the underlying transactions. |
| Holdings and issuer exposure Follow a fund's holdings to their issuers and related entities. | Recommended modalities |
Why it fits
SQL selects dated position records. Graph connects funds, instruments and issuers through declared relationships. |
| Scheme document search Find relevant terms in scheme documents and factsheets. | Recommended modalities |
Why it fits
SQL identifies the scheme and publication version. FTS finds phrases and named terms in the indexed text. |
| Distribution servicing context Connect an investor request to distributors, holdings and correspondence. | Recommended modalities |
Why it fits
SQL supplies request and holding records, Graph follows distributor relationships, and FTS searches the related correspondence. |
| Fund research retrieval Find research passages relevant to a fund or investment theme. | Recommended modalities |
Why it fits
FTS matches names and terminology, Vector finds related themes, and SQL supplies fund attributes and publication dates. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Capital markets
Capital markets use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Order and trade analysis Inspect trading activity by instrument, account and period. | Recommended modalities |
Why it fits
SQL filters and joins order and trade records, then aggregates the selected activity for analysis. |
| Entity and ownership exploration Trace relationships between issuers, entities and instruments. | Recommended modalities |
Why it fits
SQL supplies entity and instrument attributes. Graph traverses the ownership and issuance relationships in your data. |
| Surveillance case evidence Explore related accounts and search the documents attached to a case. | Recommended modalities |
Why it fits
SQL narrows recorded activity, Graph follows account and entity links, and FTS locates references in case evidence. |
| Filings and research retrieval Find relevant passages across filings and research publications. | Recommended modalities |
Why it fits
FTS matches names and phrases; Vector finds similar themes. SQL provides issuer, date and document-version context. |
| Connected research workspace Expand a research result into its issuer network and supporting sources. | Recommended modalities |
Why it fits
FTS and Vector retrieve source passages, Graph expands issuer relationships, and SQL supplies dated instrument and document records. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / E-commerce & retail
E-commerce & retail use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Product discovery Find products from exact keywords or a shopper's description. | Recommended modalities |
Why it fits
FTS matches product terms, Vector finds similar meaning, and SQL supplies price and stock for the application's final selection. |
| Related-product recommendations Build a shortlist of similar products and connected accessories. | Recommended modalities |
Why it fits
Vector finds similar items, Graph follows product and accessory relationships, and SQL provides availability and catalog attributes. |
| Order and inventory operations Track orders, product availability and fulfilment status. | Recommended modalities |
Why it fits
SQL joins order and inventory records, filters operational status and aggregates quantities and sales. |
| Catalog relationship navigation Explore variants, compatible accessories and category relationships. | Recommended modalities |
Why it fits
SQL retrieves product attributes. Graph follows the catalog relationships that your merchandising application defines. |
| Returns case investigations Connect returns, orders and customers with their supporting correspondence. | Recommended modalities |
Why it fits
SQL narrows return records, Graph connects orders and customers, and FTS searches descriptions and correspondence for relevant evidence. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Contact centres
Contact centres use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Agent knowledge assistance Retrieve useful knowledge passages for the current customer question. | Recommended modalities |
Why it fits
SQL supplies customer and case context, FTS matches exact terms, and Vector finds guidance phrased differently from the question. |
| Customer journey context Connect conversations, cases and service relationships. | Recommended modalities |
Why it fits
SQL retrieves customer attributes and interaction dates. Graph follows the links between customers, conversations and cases. |
| Escalation evidence review Follow an escalated case through related conversations and documents. | Recommended modalities |
Why it fits
SQL supplies case status, Graph connects the related interactions, and FTS finds promises, issue terms and quoted language. |
| Conversation quality review Find conversations containing phrases that a reviewer needs to inspect. | Recommended modalities |
Why it fits
SQL selects queues, teams and date ranges. FTS finds matching phrases in indexed transcripts for manual review. |
| Queue and workload reporting Track case volumes, assignments and resolution times. | Recommended modalities |
Why it fits
SQL groups operational records by team, queue and period, with filters for status and assignment. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Healthcare
Healthcare use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Encounter workspaces Connect an encounter to its document and care-team references. | Recommended modalities |
Why it fits
SQL retrieves encounter fields and dates. Graph follows the declared links to documents, teams and related operational records. |
| Referral coordination Track referral status alongside its assigned team and follow-up tasks. | Recommended modalities |
Why it fits
SQL filters referral and task status. Graph connects the encounter, receiving service and responsible team. |
| Connected document retrieval Find specific wording in the documents linked to an encounter. | Recommended modalities |
Why it fits
SQL selects encounter records, Graph resolves associated documents, and FTS searches their indexed text for relevant terms. |
| Service knowledge retrieval Find intake procedures and operational guidance for staff. | Recommended modalities |
Why it fits
FTS matches service terminology, Vector retrieves related guidance, and SQL supplies the source revision and service metadata. |
| Service capacity reporting Inspect appointment, queue and referral workloads. | Recommended modalities |
Why it fits
SQL filters dates and service locations, joins operational records and groups workloads by status or team. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Telecommunications
Telecommunications use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Service dependency exploration Trace customers and services to their network dependencies. | Recommended modalities |
Why it fits
SQL retrieves service and asset attributes. Graph follows the declared dependencies between customers, services and network assets. |
| Outage investigation workspace Connect affected services to incidents, assets and engineering notes. | Recommended modalities |
Why it fits
SQL selects incident records, Graph follows service dependencies, and FTS finds error terms and observations in the linked notes. |
| Support knowledge retrieval Find relevant troubleshooting articles and similar issue descriptions. | Recommended modalities |
Why it fits
FTS matches error codes, Vector finds similar symptoms, and SQL supplies product context and source versions. |
| Subscription and billing operations Inspect plans, subscriptions, invoices and service status. | Recommended modalities |
Why it fits
SQL joins customer and subscription records, filters billing periods and aggregates operational totals. |
| Device and runbook lookup Find model-specific commands and maintenance procedures. | Recommended modalities |
Why it fits
SQL supplies device and software-version attributes. FTS finds command names and exact procedures in indexed runbooks. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
5 use cases / Airlines & aviation
Airlines & aviation use cases
Start with the combination that fits your question. These are recommended starting points; the best fit depends on your data and query patterns.
- SQL Filter, join and aggregate records
- Graph Follow relationships between records
- FTS · Full-text search Find keywords, phrases and exact wording
- Vector Find similar items or meaning
| Use case | Recommended modalities | Why this combination fits |
|---|---|---|
| Disruption context Trace a disrupted flight to its connections and passenger records. | Recommended modalities |
Why it fits
SQL retrieves flight status and itinerary fields. Graph follows route and connection relationships for the operations application. |
| Maintenance evidence retrieval Connect an aircraft or component to work records and technical documents. | Recommended modalities |
Why it fits
SQL selects work records, Graph follows asset and component links, and FTS searches technical references and maintenance notes. |
| Flight operations reporting Review delays, service activity and operational status by route. | Recommended modalities |
Why it fits
SQL filters flight records by date, airport and status, then groups operational totals and delay durations. |
| Passenger service knowledge Retrieve relevant service rules and procedural guidance. | Recommended modalities |
Why it fits
FTS matches rule terminology, Vector finds guidance related to a question, and SQL supplies itinerary context and document versions. |
| Baggage journey exploration Connect a baggage record to scans, flights and transfer points. | Recommended modalities |
Why it fits
SQL retrieves scan events and timestamps. Graph follows the recorded relationships between baggage, flights and transfer locations. |
Combine query results in your application using shared record IDs. Keep text indexes and embeddings updated as the source data changes.
Start with your workflow.
13 industry guides. Use cases and recommended modalities.
Financial services
Put transactions, relationships and documents in context.
Banking
↗Connect account activity, customer relationships and case evidence.
Use cases & modalities →Payments
↗Investigate transaction patterns alongside merchant and account context.
Use cases & modalities →NBFCs
↗Bring borrower records and supporting loan documents together.
Use cases & modalities →Lending
↗Retrieve application data and the evidence behind a credit review.
Use cases & modalities →Insurance
↗Explore claims, related entities and relevant policy wording.
Use cases & modalities →Wealth management
↗Find research alongside client and portfolio context.
Use cases & modalities →Mutual funds
↗Connect fund information, investor records and distribution relationships.
Use cases & modalities →Capital markets
↗Explore market records, connected entities and research documents.
Use cases & modalities →Customer businesses
Help people find the right product or the next useful answer.
Essential services
Follow operational connections and find the source information.
Healthcare
↗Find documents and connected records for care and service workflows.
Use cases & modalities →Telecommunications
↗Navigate customer, service and network relationships.
Use cases & modalities →Airlines & aviation
↗Connect passenger, route and operations data with searchable knowledge.
Use cases & modalities →From a use case to a working example
Bring your data.
Build the workflow.
Start with a record and add the query models your application needs.