Winter 2014 | Report #005 – 02/12 /14 | Jiying Dong |
I. Plan for next week (***, **, *: order of priority)
· 90%: Test the stability of the project and the speed of handle data.
o To make the project running normally.
· 10%: write the documents about the project .
o Sort out the reference materials and documents.
II. Tasks achieved this week (***, **, *: order of priority)
· Code function modules for the program.
o Test the main function of the modules of the project ;
· Test the project to make sure it can be work normally :
o Create test proposal for the project ;
o Modify the code of the project to solve the problems that appeared in the test procedure.
III. Dr. Yan's feedback last week
· Suggest using one interface to operate the database. Reduce the concurrent access to the database.
· Get the time of a data node in the queue ,and the time of handling a data node in the test.
· Watch the memory status of the project .
IV. Reports
1. Code function modules for the program
Modify the data structure of the data node that store the SQL .to reduce the concurrent access to the database.
Any modules need to access the database make a data node ,and put the node to the queue of the database manage module. The database manage module take charge of the queue ,and dequeue the node to do the operations on the database.
2. Test the project to make sure it can be work normally
a. Test the main function of the modules of the project .
Test the data frame that sent from pmu to main station.
Case1. Send the data frame by a socket tool .and on the other computer installed linux os we use the command ‘nc -l port’ to listen and receive the data frame .watch the data flow direction in the project and the number of the data packets that received.
Case 1 result: In the database table,we can see a new record in every ten seconds(we configure the time interval).
The first record is inserted by hand,we can ignore it .the third and the fourth record are inserted by the project. Because we send four data packets by the socket tool. So the number of the packets are correct .
Case 2.We send the data frame non-stop to test the handling data performance of the project and the time of a data node in the queue,and the time of handling one data node.
Case 2 result. The project summarize the number of the packets,the number of crc error packets,the number of gps error packets to the database in every ten seconds(we configure the time interval). And we configured two main station, so the packets in the queue are at most two.
The time unit is microsecond.
| Enqueue time | Dequeue time | Elapsed time in the queue |
Start handle the node time | End handle the node time | Elapsed time for handling |
1 | 02/10/14 17:25:39 -583475 | 02/10/14 17:25:39 -583982 | 507 | 02/10/14 17:25:39 -584657 | 02/10/14 17:25:39 -611403 | 26746 |
2 | 02/10/14 17:25:39 -584570 | 02/10/14 17:25:39 -611849 | 27279 | 02/10/14 17:25:39 -612202 | 02/10/14 17:25:39 -622467 | 10265 |
3 | 02/10/14 17:25:29 -580353 | 02/10/14 17:25:29 -580906 | 553 | 02/10/14 17:25:29 -581944 | 02/10/14 17:25:29 -605236 | 23292 |
4 | 02/10/14 17:25:29 -581513 | 02/10/14 17:25:29 -605695 | 24182 | 02/10/14 17:25:29 -606052 | 02/10/14 17:25:29 -616230 | 10178 |
b. Test the heart beat packets that sent from main station to pmu.
Write a program to send the heart beat packets .and on the other computer run a socket tool to receive the packets.
Case1: send the heart beat in every one second,then the gps time of these packets are increased by two seconds .if gps time of the first packet is 02/10/14 14:58:05,and then the gps time of the second packet is 02/10/14 14:58:07. We send these heart beat packets in two minutes ,and then stop sending the packets.
Case 1 result : there will be two record in the data base ,the status field of the frist record is 0 normal status.it means that in the time span of ‘2014-02-10 14:56:48’ to ‘2014-02-10 14:58:07’,we can receive the heart beat packet normally,and the net status is normal.
The status field of the second record is -1 abnormal status.it means that in the time span of ‘2014-02-10 14:58:07’ to ‘2014-02-10 15:02:47’,we can’t receive the heart beat packets.and net status is abnormal.
Case 2: we don’t send any heart beat packets since the project start running.
Case 2 result :there will be one record in the database. The status field of the record is -1 abnormal status.it meas that in the time span of ‘time_begin ’ to ‘time_end ’ we don’t receive any heart beat packets,and the net status is abnormal.
And the record will be updated in every five seconds(configure the time interval);
V. Mile-Stone:
· Implement the project function:count the abnormal data packets,and according to these data packets to judge the network work status.
· Finish coding the project.