Introduction

This document describes the PL/SQL - Python API of the TAG data catalog. It has been implemented to allow both reading and writing to the catalog tables in a controlled way.

Technical API Documentation

DB details: accounts, packages

The API exists for the two catalog accounts:

• ATLAS_TAGS_CATALOG@int8r:production -- this account is replicated regularly to other TAG sites (ATLARC, BNL, TRIUMF)
• ATLAS_TAGS_CATALOG_WEB@int8r: development, test

DB packages involved:

• CATALOG_READ_API: has all functions that only read data
• CATALOG_WRITE_API: has all functions to write to the catalog tables

Procedures and Functions

CATALOG_READ_API:

Procedure/Function	Description	Input	Output	Used by
Function get_collections_sites	get collections and sites	run_nr, event_nr	cursor of collections and sites	?
Procedure get_collections_sites_proc	get collections and sites	run_nr, event_nr	cursor of collections and sites	?

CATALOG_WRITE_API:

Procedure/Function	Description	Input	Output	Used by
update_f_tagdata	update the table f_tagdata	ds, type, collection, runNr, stream, amitag, connection, nrEvents, timeUpload, timePosttag	sets the posttag stats for the corresponding row in F_TAGDATA by updating the row	Tier-0
insert_collection	insert a collection into D_COLLECTION	collection	inserts the collection, if not yet there	insert_tagdata, insert_tagdata_pretag
insert_run	inserts a run into D_RUN	runNr	inserts the run, if not yet there	insert_tagdata, insert_tagdata_pretag
insert_amitag	inserts an amitag into AMITAG	amitag	inserts the amitag, if not yet there	insert_tagdata, insert_tagdata_pretag
insert_dataset	inserts a dataset into AMITAG	dataset	inserts the dataset, if not yet there	insert_tagdata, insert_tagdata_pretag
insert_project_subproject	inserts a project into PROJECT and a subproject into D_SUBPROJECT	project, subproject	inserts project and subprojects, if not yet there	insert_tagdata, insert_tagdata_pretag
insert_tagdata	inserts a row into F_TAGDATA after completed posttagupload	ds, type, collection, runNr, stream, amitag, connection, nrEvents, timeUpload, timePosttag	inserts all values into F_TAGDATA	Tier-0 (deprecated!)
insert_tagdata_pretag	inserts into F_TAGDATA on pretagupload	ds, type, collection, runNr, stream, amitag, triggerKey, project, subproject, connection	inserts the values into F_TAGDATA	Tier-0
log_extract	logs extract usage, not yet implemented	to be implemented	to be implemented	Extract service

-- ElisabethVinek - 27-May-2010