- Implement an r-script that creates a mysql db instance and stores the instance object in an in-memory database (e.g redis) for future reusability. The r-script takes base 64 unique hash, dbname, dbuser, dbpass, dbhost as command arguments.
- Implement an r-script that updates redis with a mysql connection instance taking an old hash and new hash as arguments.
- Using some sample data, implement an r-script that analyzes most active users. Data representation support for table, histogram, bar chart. The r-script should takes a unique hash, filters as command arguments.
- Script execution should be able to:
- Parse the command arguments
- Retrieve a dataset from a remote mysql database using the stored mysql db instance (residing in an in-memory datastore)
- Outputs HTML charts with d3 support
- Script execution should be able to:
Note
- Example filters: filterDateRange=[]&session=2012/2013&level=grade12&programme=mathematics&period=year