20 likes | 116 Views
IRMIS Collaboration Meeting. Extending RdbCore at SNS. Jeff Patton. March 9-11, 2005. Extending the Perl Crawler. Oracle extensions Create sequence objects to generate sequential numeric primary key values. Create table triggers to populate primary key sequence number from sequence.
E N D
IRMIS Collaboration Meeting Extending RdbCore at SNS Jeff Patton March 9-11, 2005
Extending the Perl Crawler • Oracle extensions • Create sequence objects to generate sequential numeric primary key values. • Create table triggers to populate primary key sequence number from sequence. • Modify PVCrawlerDBLayer.pm to make database connection, work with Oracle dates, last_insert_id. • Modify SNSBootScan.pm to skip specified IOC’s. • Add sprintf code. • Create SNS schema data synchronization code.