The CMS DBS Query Language
- Cornell U., Phys. Dept.
- Fermilab
The CMS experiment has implemented a flexible and powerful system 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 relate d to CMS physics data. To this, we have added a generalized query system in addition to the existing web and programmatic interfaces to the DBS. This query system is based on a query language that hides the complexity of the underlying database structure by discovering the join conditions between database tables. This provides a way of querying the system that is simple and straightforward for CMS data managers and physicists to use without requiring knowledge of the database tables or keys. The DBS Query Language uses the ANTLR tool to build the input query parser and tokenizer, followed by a query builder that uses a graph representation of the DBS schema to construct the SQL query sent to underlying database. We will describe the design of the query sy stem, provide details of the language components and overview of how this component fits into the overall data discovery system architecture.
- Research Organization:
- Fermi National Accelerator Laboratory (FNAL), Batavia, IL (United States)
- Sponsoring Organization:
- USDOE Office of Science (SC), High Energy Physics (HEP) (SC-25)
- DOE Contract Number:
- AC02-07CH11359
- OSTI ID:
- 1973955
- Report Number(s):
- FERMILAB-CONF-10-774; oai:inspirehep.net:860113
- Journal Information:
- J.Phys.Conf.Ser., Journal Name: J.Phys.Conf.Ser. Vol. 219
- Country of Publication:
- United States
- Language:
- English
Similar Records
SQTTEXT: A tool for editing Structured Query Language (SQL) text within ORACLE SQL*Forms applications
Interpretation of natural-language data base queries using optimization methods