80 likes | 159 Views
Accessing SVS Metadata. Overview. MILS UI Export to Excel file Limited information available RESTful interface HTML query All information available XML return, easy to display visually DB2 SQL commands Not recommended. Metadata Types. Alert Record Event Record Summary Track
E N D
Overview • MILS UI • Export to Excel file • Limited information available • RESTful interface • HTML query • All information available • XML return, easy to display visually • DB2 SQL commands • Not recommended
Metadata Types • Alert Record • Event Record • Summary • Track • Event / Alert thumbnails • Background images
MILS UI Export • Save results of any search as Excel spreadsheet • Use “Export” option • Data limited to what is available via UI
RESTFUL API Overview • Queries structured as HTML • http://p-mils1a-1.phoenix.local/mils/content/alerts_external/(AND(EQ(view_id,1),GT(alertstart,2012-06-07-11.35.00.000000),LT(alertend,2012-06-07-12.35.00.000000))) • Results in XML format
RESTFUL cont. • HTML/XML makes suitable to manage via web browser • e.g. XML can be displayed graphically
Tools available 1 • Graphical web-based query • Easy to use query interface • Some limitations on types of query • Ability to play video clips
Tools available 2 • Command-line tool • Different set of limitations than graphical tool • No video playback • Same metadata display, but more steps involved