{"id":"https://openalex.org/W2055219908","doi":"https://doi.org/10.1088/1742-6596/219/4/042043","title":"The CMS DBS query language","display_name":"The CMS DBS query language","publication_year":2010,"publication_date":"2010-04-01","ids":{"openalex":"https://openalex.org/W2055219908","doi":"https://doi.org/10.1088/1742-6596/219/4/042043","mag":"2055219908"},"language":"en","primary_location":{"id":"doi:10.1088/1742-6596/219/4/042043","doi":"https://doi.org/10.1088/1742-6596/219/4/042043","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1742-6596/219/4/042043","pdf_url":"https://iopscience.iop.org/article/10.1088/1742-6596/219/4/042043/pdf","source":{"id":"https://openalex.org/S4210187594","display_name":"Journal of Physics Conference Series","issn_l":"1742-6588","issn":["1742-6588","1742-6596"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","jufo-1","norway-1","poland-40","vabb-shw"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Physics: Conference Series","raw_type":"journal-article"},"volume":null,"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://iopscience.iop.org/article/10.1088/1742-6596/219/4/042043/pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5080431761","display_name":"Valentin Kuznetsov","orcid":"https://orcid.org/0000-0003-0667-069X","observed_orcids":["https://orcid.org/0000-0003-0667-069X"]},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Valentin Kuznetsov","raw_affiliation_strings":["Cornell University, Ithaca, New York, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Cornell University, Ithaca, New York, USA","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Daniel Riley","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Daniel Riley","raw_affiliation_strings":["Cornell University, Ithaca, New York, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Cornell University, Ithaca, New York, USA","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113658324","display_name":"Anzar Afaq","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1314696892","display_name":"Fermi National Accelerator Laboratory","ror":"https://ror.org/020hgte69","country_code":"US","type":"facility","lineage":["https://openalex.org/I1314696892","https://openalex.org/I1330989302","https://openalex.org/I39565521","https://openalex.org/I4210114836"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Anzar Afaq","raw_affiliation_strings":["Fermilab, Batavia, Illinois, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Fermilab, Batavia, Illinois, USA","institution_ids":["https://openalex.org/I1314696892"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113305127","display_name":"V. Sekhri","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1314696892","display_name":"Fermi National Accelerator Laboratory","ror":"https://ror.org/020hgte69","country_code":"US","type":"facility","lineage":["https://openalex.org/I1314696892","https://openalex.org/I1330989302","https://openalex.org/I39565521","https://openalex.org/I4210114836"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vijay Sekhri","raw_affiliation_strings":["Fermilab, Batavia, Illinois, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Fermilab, Batavia, Illinois, USA","institution_ids":["https://openalex.org/I1314696892"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107679381","display_name":"Yuyi Guo","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1314696892","display_name":"Fermi National Accelerator Laboratory","ror":"https://ror.org/020hgte69","country_code":"US","type":"facility","lineage":["https://openalex.org/I1314696892","https://openalex.org/I1330989302","https://openalex.org/I39565521","https://openalex.org/I4210114836"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yuyi Guo","raw_affiliation_strings":["Fermilab, Batavia, Illinois, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Fermilab, Batavia, Illinois, USA","institution_ids":["https://openalex.org/I1314696892"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109044932","display_name":"Lee Lueking","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1314696892","display_name":"Fermi National Accelerator Laboratory","ror":"https://ror.org/020hgte69","country_code":"US","type":"facility","lineage":["https://openalex.org/I1314696892","https://openalex.org/I1330989302","https://openalex.org/I39565521","https://openalex.org/I4210114836"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lee Lueking","raw_affiliation_strings":["Fermilab, Batavia, Illinois, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Fermilab, Batavia, Illinois, USA","institution_ids":["https://openalex.org/I1314696892"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2442,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.83235639,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":94},"biblio":{"volume":"219","issue":"4","first_page":"042043","last_page":"042043"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.6377000212669373,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.6377000212669373,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.09640000015497208,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.07900000363588333,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-discovery","display_name":"data discovery","score":0.6190000176429749},{"id":"https://openalex.org/keywords/metadata-management","display_name":"metadata management","score":0.6240000128746033},{"id":"https://openalex.org/keywords/text-to-sql","display_name":"text-to-SQL","score":0.6830000281333923},{"id":"https://openalex.org/keywords/antlr","display_name":"ANTLR","score":0.6470000147819519},{"id":"https://openalex.org/keywords/data-management","display_name":"data management","score":0.4819999933242798}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8345518112182617},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.7663397789001465},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.7408910393714905},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.7052097916603088},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6350988745689392},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6035231947898865},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5220208764076233},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5002939701080322},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4950949251651764},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4899579584598541},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.48639658093452454},{"id":"https://openalex.org/C117667704","wikidata":"https://www.wikidata.org/wiki/Q2011708","display_name":"Object Query Language","level":5,"score":0.4860444664955139},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.4674053490161896},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4407130181789398},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.44040393829345703},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.42226314544677734},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.41190004348754883},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4101408123970032},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.29623639583587646},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2381666898727417},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2194482386112213},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12680324912071228}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1088/1742-6596/219/4/042043","doi":"https://doi.org/10.1088/1742-6596/219/4/042043","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1742-6596/219/4/042043","pdf_url":"https://iopscience.iop.org/article/10.1088/1742-6596/219/4/042043/pdf","source":{"id":"https://openalex.org/S4210187594","display_name":"Journal of Physics Conference Series","issn_l":"1742-6588","issn":["1742-6588","1742-6596"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","jufo-1","norway-1","poland-40","vabb-shw"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Physics: Conference Series","raw_type":"journal-article"},{"id":"pmh:oai:cds.cern.ch:1196159","doi":null,"is_oa":true,"landing_page_url":"http://cds.cern.ch/record/1196159","pdf_url":"http://cds.cern.ch/record/1196159","source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"pmh:oai:osti.gov:1973955","doi":null,"is_oa":true,"landing_page_url":"https://www.osti.gov/biblio/1973955","pdf_url":"https://www.osti.gov/servlets/purl/1973955","source":{"id":"https://openalex.org/S4306402487","display_name":"OSTI OAI (U.S. Department of Energy Office of Scientific and Technical Information)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I139351228","host_organization_name":"Office of Scientific and Technical Information","host_organization_lineage":["https://openalex.org/I139351228"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":{"id":"doi:10.1088/1742-6596/219/4/042043","doi":"https://doi.org/10.1088/1742-6596/219/4/042043","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1742-6596/219/4/042043","pdf_url":"https://iopscience.iop.org/article/10.1088/1742-6596/219/4/042043/pdf","source":{"id":"https://openalex.org/S4210187594","display_name":"Journal of Physics Conference Series","issn_l":"1742-6588","issn":["1742-6588","1742-6596"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","jufo-1","norway-1","poland-40","vabb-shw"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Physics: Conference Series","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G154696372","display_name":null,"funder_award_id":"DEAC02-07CH11359","funder_id":"https://openalex.org/F4320338288","funder_display_name":"Fermilab"},{"id":"https://openalex.org/G5616713406","display_name":null,"funder_award_id":"DE-AC02-07CH11359","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G585908603","display_name":null,"funder_award_id":"AC02-07CH11359","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G86560745","display_name":null,"funder_award_id":"DE\u2010AC02\u201007CH11359","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G969889393","display_name":null,"funder_award_id":"DE-AC02-","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320306084","display_name":"U.S. Department of Energy","ror":"https://ror.org/01bj3aw27"},{"id":"https://openalex.org/F4320338288","display_name":"Fermilab","ror":"https://ror.org/020hgte69"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2055219908.pdf","grobid_xml":"https://content.openalex.org/works/W2055219908.grobid-xml"},"referenced_works_count":2,"referenced_works":["https://openalex.org/W2040607317","https://openalex.org/W2074866620"],"related_works":["https://openalex.org/W2323040019","https://openalex.org/W2074866620","https://openalex.org/W2084131173","https://openalex.org/W2161208331","https://openalex.org/W2367709350","https://openalex.org/W3159853465","https://openalex.org/W1535512009","https://openalex.org/W6931145211","https://openalex.org/W4301044059","https://openalex.org/W2091465625"],"abstract_inverted_index":{"The":[0,21,120],"CMS":[1,17,40,104],"experiment":[2],"has":[3],"implemented":[4],"a":[5,27,48,70,92,138,143],"flexible":[6],"and":[7,29,35,58,101,107,134,174],"powerful":[8],"system":[9,51,66,97,186],"enabling":[10],"users":[11],"to":[12,33,39,54,61,109,128,150,156],"find":[13],"data":[14,19,105,184],"within":[15],"the":[16,30,55,62,75,78,84,96,115,125,130,147,152,162,165,171,182],"physics":[18,41],"catalog.":[20],"Dataset":[22],"Bookkeeping":[23],"Service":[24],"(DBS)":[25],"comprises":[26],"database":[28,80,88,116],"services":[31],"used":[32],"store":[34],"access":[36],"metadata":[37],"related":[38],"data.":[42],"To":[43],"this,":[44],"we":[45],"have":[46],"added":[47],"generalized":[49],"query":[50,65,71,132,139,154,166],"in":[52],"addition":[53],"existing":[56],"web":[57],"programmatic":[59],"interfaces":[60],"DBS.":[63],"This":[64,90],"is":[67,99],"based":[68],"on":[69],"language":[72,172],"that":[73,98,141],"hides":[74],"complexity":[76],"of":[77,94,114,146,164,170,176],"underlying":[79,157],"structure":[81],"by":[82,137],"discovering":[83],"join":[85],"conditions":[86],"between":[87],"tables.":[89],"provides":[91],"way":[93],"querying":[95],"simple":[100],"straightforward":[102],"for":[103],"managers":[106],"physicists":[108],"use":[110],"without":[111],"requiring":[112],"knowledge":[113],"tables":[117],"or":[118],"keys.":[119],"DBS":[121,148],"Query":[122],"Language":[123],"uses":[124,142],"ANTLR":[126],"tool":[127],"build":[129],"input":[131],"parser":[133],"tokenizer,":[135],"followed":[136],"builder":[140],"graph":[144],"representation":[145],"schema":[149],"construct":[151],"SQL":[153],"sent":[155],"database.":[158],"We":[159],"will":[160],"describe":[161],"design":[163],"system,":[167],"provide":[168],"details":[169],"components":[173],"overview":[175],"how":[177],"this":[178],"component":[179],"fits":[180],"into":[181],"overall":[183],"discovery":[185],"architecture.":[187]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-10-30T12:39:25.321706","created_date":"2016-06-24T00:00:00"}