Changes between Version 4 and Version 5 of IPP_Progress_Report_20120123
- Timestamp:
- Jan 30, 2012, 11:48:45 AM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
IPP_Progress_Report_20120123
v4 v5 23 23 Since I already had code to load entire DVO databases into MySQL for faster access I adapted it to ingest a portion at a time, defined by a box of RA/Dec. Steps included: 24 24 25 * code to load SkyList.fits table into MySQL database25 * code to load !SkyTable.fits table into MySQL database 26 26 * code to query the above table and get region files contained in RA/Dec box (could be whole sky, or anything smaller) 27 27 * new Db table to maintain list of DVO files imported, including modified date and size and an index number (so we can delete associated detections later) … … 29 29 * rsync-style system that checks file modified dates so that we don't re-ingest unchanged files or ignore recently modified ones 30 30 * process can be stopped and restarted as it remembers what has and hasn't been ingested 31 * implemented a method to delete a DVO region from the Db, but retain Images.dat and SkyTable from DVO (to save time)31 * implemented a method to delete a DVO region from the Db, but retain Images.dat and !SkyTable from DVO (to save time) 32 32 33 33 Future work will be an algorithm to decide which region of the sky is optimal to load next, i.e. figuring out the size available smf/cmf files versus the size on disk in DVO - there is no point ingesting 30GB of DVO data if I only have 2 smf files to load to PSPS.
