Aviation knowledge system
A technical-document retrieval workflow with answers linked to sources and relevant video.
I designed the retrieval workflows, prepared document routes and built SharePoint synchronization with the technical team.
System overview
- Input
- SharePoint documents, technical questions and optional uploaded documents
- Processing
- File-specific preparation, retrieval and Qwen answer generation
- Output
- Answers with source references and relevant video where supported
Answer examples
I designed the retrieval and response workflows and built SharePoint synchronization; teammates provided the Dify infrastructure and chat website.
Source-linked answer
Answer with video
Technical answers require review against the cited source.
System
SharePoint synchronization prepares incoming files for the knowledge base. At question time, the workflow retrieves context from that index or from a document uploaded with the question.
Ingestion and question paths
Integrated data ingestion
| Path | Engineering work |
|---|---|
| Ingestion | Synchronize SharePoint files; prepare formats separately before chunking, embedding and indexing. |
| Question routing | Distinguish standing-knowledge queries from questions with an uploaded document. |
| Retrieval and generation | Retrieve relevant passages and tune Qwen parameters for technical responses. |
| Response assembly | Combine answer text with source references and optional video output for the chat interface. |
Workflow implementation
Dify workflow overview
Question routing
Conditional video retrieval
Response assembly
Development trial
| Trial scope | Development trial outcome |
|---|---|
| About 100 documents, roughly 100 to 500 pages each, with 20 prepared questions per document. | 18 to 20 answers judged correct out of 20 for a tested document after adjustments. Author-reported; no held-out corpus or documented scoring rubric. This does not establish general retrieval accuracy or aviation safety. |







