Fermilab Computing Division

CS Document 2990-v1

The CMS Dataset Bookkeeping Service Query Language (DBSql)

Document #:
CS-doc-2990-v1
Document type:
Conference
Submitted by:
Lee Lueking
Updated by:
Lee Lueking
Document Created:
12 Nov 2008, 11:45
Contents Revised:
12 Nov 2008, 11:45
Metadata Revised:
13 Nov 2008, 10:31
Viewable by:
  • Public document
Modifiable by:

Quick Links:
Latest Version

Abstract:
The CMS experiment has implemented a flexible and powerful approach enabling users to find data within the CMS physics data catalog. The Dataset Bookkeeping Service (DBS) comprises a database and the services used to store and access metadata related to its physics data. In addition to the existing WEB based and programmatic API, a generalized query system has been designed and built. This query system has a query language that hides the complexity of the underlying database structure. This provides a way of querying the system that is straightforward for CMS data managers and physicists. The DBS Query Language uses the ANTLR tool to build the input query parser and tokenizer, then a query builder using a graph representation of the DBS schema constructs the actual SQL sent to underlying database. We will describe the design of the query system and provide details of the language components. We will also provide an overview of how this component fits into the overall data discovery system, as well as providing access to information about Data Quality and Luminosity.
Files in Document:
Authors:
Keywords:
CMS - DBS -
Associated with Events:
CHEP 2009 held from 21 Mar 2009 to 27 Mar 2009 in Prague, Czech Republic
DocDB Home ]  [ Search ] [ Authors ] [ Events ] [ Topics ]

DocDB Version 8.8.9, contact Document Database Administrators