02/12 /14 工作周报告

 

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.