comp730:MeAndYou Spring 2016 Steven Saunders Log


 * Home
 * MeAndYou
 * Semesters
 * Spring 2016

Week Ending March 29, 2016

 * Task:


 * Results:


 * Plan:


 * Concerns:

Week Ending April 5, 2016

 * Task:
 * Determine search method
 * Consider using string matching for near matches


 * Results:
 * Team brainstorming on method to use for search
 * String matching coding started
 * Java chosen for program which will be stand alone application
 * Discussed database setup with representative of database team


 * Plan:
 * Review overall system with team


 * Concerns:
 * System implementation plan is unknown

Week Ending April 12, 2016

 * Task:
 * Develop program approach to test working with small database sample


 * Results:
 * Team members focused on posters


 * Plan:
 * Test basic concept of search with database


 * Concerns:

Week Ending April 19, 2016

 * Task:
 * Create working demo with Java program, DB and GUI per class whiteboard plan
 * Setup server
 * Access to server


 * Results:
 * Most of the week spent debugging the infrastructure, the server was setup
 * Exact match function created to substitute for Hamming distance function
 * Create Gantt chart to record timeline on white board
 * Tested access and running command line MySQL
 * Demo not ready for matching


 * Plan:
 * Test access to system and any offline software needed
 * Code testing with offline database
 * Load software needed on server and on users computers for access and testing


 * Concerns:
 * No complete working demo from team
 * Some issues with remote desktop access and only two users allowed

Week Ending April 26, 2016

 * Task:
 * Connect to database from command prompt
 * Get correct drivers for MariaDB which is the version of MySQL used
 * Connect to database from Java program
 * Read from database from Java program
 * Develop initial algorithm to compare all searches
 * Create searches insert script to test program


 * Results:
 * The database connection works offline and on server
 * The program can read from searches table and write to matches table
 * Algorithm tested offline and then coverted to MariaDB drive and loaded to server for demo
 * Created searches insert script for testing


 * Plan:
 * Develop programs offline to test database connections and reading the table.
 * Create loop for running through the searches.


 * Concerns:
 * With mixed offline and server testing it was not known if demo would run as expected

Week Ending May 3, 2016

 * Task:
 * Correct overmatching results
 * Clean up person array names
 * Add first name to search
 * Clean up files structures
 * Try storing in SVN if working (we can use Box as our main)
 * Implement config file and reader
 * Implement Jake's string match in if statement in for loops
 * Add a date field variable to store the time the search is done so next search could use it in the sql call
 * Create UNH directory to store files


 * Results:
 * Overmatching correction complete and tested
 * Directory created for team to share code updates
 * Person table in Java program modified to match updated database fields


 * Plan:
 * Created initial assignment of tasks to team members
 * Call on Friday to discuss plan
 * Notified team of task list
 * Online discussion of creating the overall match percent
 * Review results on Tuesday call


 * Concerns:
 * Process of elimination will help reduce searches but the size of existing list to search will eventually cause slow overall searches

Week Ending May 10, 2016

 * Task:
 * Setup and test scheduler
 * Update Java for first, last and averaged results
 * General code cleanup


 * Results:
 * Scheduler and logging tested and set to running in class
 * Unknown issue seen with initial setup in class (debugged at demo)
 * Demo functional if clearing matches table before search
 * Demo completed for "Movie Star" test with manual table clearing


 * Plan:
 * Update Java code extract for both fields
 * Update Java code loops for additional fields
 * Run tests to confirm updated Java code


 * Concerns:
 * All testing done in individual parts
 * Java code tested to SQL inserted fields
 * Interface tested to fields in table

Week Ending May 17, 2016

 * Task:
 * Correct need to truncate table
 * Add additional fields (requires some structural rework)
 * Updates to decompose into smaller functions


 * Results:
 * Java updated with new fields and correction
 * Initial tests work with SQL generated tables


 * Plan:
 * Update code, compile and test


 * Concerns:
 * Some database changes made since previous class

Week Ending May 24, 2016

 * Task:
 * Testing of system from webpage to prepare for demo
 * Test of updated Java code with
 * Updates needed from database to match all 3 system parts


 * Results:
 * Testing worked from Java to database until near duplicates
 * Some empty fields caused issues (debugged after demo)
 * Only one use notified, modify controller and model php files
 * Limited edit fields, update controller and model php files
 * Phone not originally included, add after successful testing of above
 * May 25th - demo successful
 * May 25th - debug unknown issues by lowering threshold and monitor in mysql


 * Plan:
 * Load webpage and test form inputs to database in mysql
 * Run Java program to test results of tables
 * Load and test database with mysql
 * Test all 3 parts together without scheduler to minimize waiting


 * Concerns:
 * Request database modifications to allow additional null fields in searches
 * Some unknown behavior with empty fields or very close matches