php - Colleagues, please share your design ideas.

Question

I want to make such a backend, the requirements are:
1. Make a backend that adds keywords. . There are various categories and permission management. . .
2. Add a keyword with associated voice, associated answers, associated videos, animations and other learning resources.
For example: If I want to say a Snow White, then the robot will show a Snow White story or animation video, etc. .
The main purpose is: say a paragraph, and then search for the corresponding resources based on this paragraph. .
Only consider the back-end function and not the front-end function. How should I design this project? Write it in PHP
http://aiui.xfyun.cn/store/in...

Answer 1

Speech recognition + full text search.
Speak a paragraph, and then search for the corresponding resources based on this paragraph.

1. Speak a sentenceProve that voice recognition is needed

2. Search for the corresponding resourcesProof needs to be retrieved.
   So what is the search basis? Naturally, it will not be a simple like. At this time, full-text search is required.

The key points in database design are label design and various types of resource tag associations.
PHP is nothing more than data operations and calling external interfaces (Speech recognition, Full text search)