ITS

COE Server:

• Further investigated Linux backup commands and strategies

• Refined backup script
• Monitoring data server logs

Other:

• Fixed SR date sort problem in all report types

• Beginning AWStats log compilation project
• Friends of Library updates

COE Server:

• Further analyzed structure of Compustat data

• Investigated Linux backup commands and strategies
• Implemented backup script
• Made Compustat documentation available w/DPO
• Assisted SET & DPO with discussions with Prof. Welch
• Completed Compustat queries to create dataset, class began use

Friends of Library updates

This is an Incomplete outline due to retrospective recording
COE Server:

• Further analyzed structure of Compustat data

• Set up new user accounts for Econ class incl. working directories, environmental variables
• Created CRSP documentation for test programs
• Assisted Joe in setting up backup drive on data server
• Began manual backups
• Assisted SET & DPO with discussions with Prof. Welch
• Learned command-line MySQL, began Compustat test outputs
• Misc. other work

This is an Incomplete outline due to retrospective recording
COE Server:

• Finished creation of MySQL version of Compustat Oracle data

• Installed Red Hat EL 3 Linux on new server; SSH, MySQL, etc. configured
• Compiled, ran CRSP C Programs on new data server, installed data
• Assisted SET & DPO with discussions with Prof. Welch
• Imported Compustat MySQL data to data server
• Worked with Professor Welch to determine Compustat variables required
• Misc. other work

This is an Incomplete outline due to retrospective recording
COE Server:

• Note: June visit to Boston College with DPO to investigate WRDS software

• Reinstalled Red Hat EL 3 on old test server
• Investigation of CRSP C Programs on test Red Hat Server – C Struct setups
• Compiled, ran CRSP C Programs, minor modifications
• Assisting SET & DPO with discussions with Prof. Welch
• Began reading Compustat documentation, investigating data structure
• Misc. other work

• Finished list of Web Applications PHP pages for REGISTER_GLOBALS, MySQL user security, etc.
• Mounted numerous brownradio pages for BT
• Installed SAS for CRSP/Compustat data exploration, reviewing SAS operation

• Creating list of Web Applications PHP pages for REGISTER_GLOBALS, MySQL user security, etc.
• Reading documentation for CRSP sample
• Met with Professor Ivo Welch, DPO and SET re. CRSP/Compustat

• Did find/grep for Webpub REGISTER_GLOBALS problems, found 7; fixed for new setting compatibility
• Fixed php/mysql problem on hay staff page
• Additional FOL updates

• input_filter.php, filtering class for form input->database
  • Finished bug fix for “string” problem
  • Posted input_filter.php bug issue to creator’s MEETUP board (no good contact method available)
  • Resumed testing, another bug surfaced
• Numerous FOL updates
• gis.brown.edu web data source addition (T.S. request)
• Emailed Patrick Laverty re. obtaining stable code for deep linking into Banner (works as expected from URLs)

• Reviewed PHP objects chapters – Safari
• Implemented test version of filtering class for form input->database
• Placed in include file, creating instance etc.
• Testing optional parameters for appropriateness
• Attended Web Programmers meeting/seminar
• FOL updates
• Eresources update