285
社区成员
This task is all about the front end
Team members | Task completed | Duration of the task | Remaining time |
---|---|---|---|
Li Liangkai | demand analysis | 5 hours | 7 Days |
Qing Qiguo | Daily maintenance of database | -- hours | 7 Days |
Tang Zijun | database conception structure design | 5 hours | 7 Days |
Ma Yunjun | Physical Design of database | 14 hours | 7 Days |
Xue Feiyang | Database logical structure design | 5 hous | 7 Days |
An Yi | Physical Design of database | 14 hours | 7 Days |
Peng Haitao | Test and trial run | 4 hours | 7 Days |
Li Xing | Operation of the system | 8 hours | 7 Days |
Li Hao | Physical Design of database | 14 hours | 7 Days |
Zhou Zijun | demand analysis | 5 hours | 7 Days |
a. How to design the structure of various elements in the database table.
b. How to optimize the database caching mechanism.
a.First, all elements are put into the database, such as time, fund type, user name, fund increase, etc. First, write the first normal form, because the first normal form is too redundant, and then convert to the second normal form, and so on. After comparison test, we choose the third normal form, too much time will be wasted, and the third normal form is more moderate.the integration of the back end.
b.In order to climb the real-time valuation, the client accesses the API link, inputting the fund code to return the valuation, preventing the lag caused by excessive access. Finally, we choose not to store in the hard disk but in the memory, which can quickly read in and read out, and store various information in the memory. Can allow the customer to search directly return the data crawled within a minute, can greatly reduce the pressure on the server.
Explore the structural design of various elements in the table of the database and discuss how to optimize the database cache.
https://github.com/LittleMatcher/EE308FZ-fund
E-R model:
Model of relationship:
The basic function of the database has been basically improved, and the speed can be relatively stable in the comparison of multiple access.
Team members | Contribution(%) |
---|---|
Li Liangkai | 99 |
Qing Qiguo | 109 |
Tang Zijun | 99 |
Ma Yunjun | 99 |
Xue Feiyang | 99 |
An Yi | 99 |
Peng Haitao | 99 |
Li Xing | 99 |
Li Hao | 99 |
Zhou Zijun | 99 |
Total | 1000 |