04 Group - Sprint Log 3(12.10)

[小火柴x_x]

目录

• 1.The progress of task
•  1) The progress of each student:
•  2) Problems we met
•  3) The way to deal with them
• 2.The record of the stand-up meeting
•  1) meeting content
•  2) meeting process
• 3.Sprint project introduction
•  1) Github
•  2) Screenshots of the operation
•  3) The process
•  4) Burndown Chart
• 4.Team member contribution table
• 5.The implementation of the sub-use cases in the UML design

(Sofe blog)

1.The progress of task

 1) The progress of each student:

  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

 2) Problems we met

  a. How to design the structure of various elements in the database table.
  b. How to optimize the database caching mechanism.

 3) The way to deal with them

  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.

2.The record of the stand-up meeting

 1) meeting content

  Explore the structural design of various elements in the table of the database and discuss how to optimize the database cache.

 2) meeting process

3.Sprint project introduction

 1) Github

  https://github.com/LittleMatcher/EE308FZ-fund

 2) Screenshots of the operation

E-R model:

Model of relationship:

 3) The process

  The basic function of the database has been basically improved, and the speed can be relatively stable in the comparison of multiple access.

 4) Burndown Chart

4.Team member contribution table

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

5.The implementation of the sub-use cases in the UML design