Page History

...

• Aqsa and Saba are working together. Their goal is focusing on visualization of PingER historical data using warehouse.  The idea is to develop a warehouse in UAF university and make it publicly available. They are 50-60% done with setting up a Hadoop cluster with 3 nodes, 1 master, 2 slaves. She is currently working on importing the PingER data into hdfs on the  cluster. they have run some Impala queries on the data and are working on visualization
• Topic: visualization on pingER data (email from Aqsa and Response from Renan)

  I have studied the google charts as visualization tools but here are some points need to be discussed.
  1. The idea of applying visualization on Data warehouse (Impala query results) does not seem to be so useful because Data warehouse contains static data and visualization charts will also remains static and need to be updated with the time.
  
  Yes, it needs to be updated with the time. My suggestion is to transform PingER data into data to be inserted into the data warehouse. Myself and some other Brazilian students have developed codes to do this. Such process should occur at least once a day to keep the data warehouse updated daily. This has never been done by any of us.
  
  2. Google charts API cannot integrate with Impala As Impala is hadoop distributed Big Data supported database Google can only integrate with flat files or flat databases like Mysql. 
  
  If Google charts API can only read flat files (e.g., CSV files), it is trivial to save a database query result as a CSV flat file that would be consumed by Google charts.  Can Google charts generate a plot dynamically after reading a just-created CSV file? 
  Is using a different data visualization library (e.g., D3 https://d3js.org/ ) an option? 

• Aqsa and  team members are working on creating Data warehouse and we are very close to complete this. Here are some updates.

  • Tehseen qureshi has transformed the pingER text files into binaries and soon he will be able to get CSV files.

  • Saba is working on defining a 4 node cluster.
  • Aqsa has uploaded some sample CSV files on HDFS and run Impala queries as i will get the actual CSV from tehseen these steps are also will be completed

• Visualization Status 

• Aqsa has 

  drawn a line chart and bar chart on the data of sample CSV file and i am exploring some more charts to be drawn by using Google API's.

• Sara Masood:

1. 1. pingER  monitoring host on android . I am using perl-android-apk Interpreter to run pearl on android.. it include execution of  3 perl scripts

      1. getdata.pl

      2. ping_data.pl

      3. pinger2.pl

   2. Resources Required

      1. i need ping_data.pl script file and getdata.pl script file.

      2. Joao will provide them via anonymous ftp.

   3. Research Status

   • • Perl-android-interpreter is not executing .pl file mainly because old Perl version (Perl 5.10) which is not comparable with android lollipop 5.0 version, i am compilingPerl .5.22.0 for android ,it may solve issue. 

...

Saqib's old supervisor  agreed to appoint a master student to take of PingER in UTM. Saqib has emailed  3/9/2016, no progress 4/6/2016, no progress 5/18/2016. 

1.     Currently, Pinger server is located in the faculty server room. Recently, faculty has closed the Server room. Now we have to move it to the University Central Server Room. For this we need support from Prof Johari and Prof Abdul Hanan.

2.     For the M.Sc. student in UTM we have to request again to Prof Hanan and Prof Asri and we need support from Prof JohariAny progress 6/22/2016.

UM

MYREN

• Email 6/15/2016 to Fitzi, pinger.fsksm.utm.my is down.

...