{"id":"https://openalex.org/W1987283499","doi":"https://doi.org/10.1145/2823363.2823365","title":"SQL for deep dynamic analysis?","display_name":"SQL for deep dynamic analysis?","publication_year":2015,"publication_date":"2015-10-26","ids":{"openalex":"https://openalex.org/W1987283499","doi":"https://doi.org/10.1145/2823363.2823365","mag":"1987283499"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/2823363.2823365","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5041039248","display_name":"Mohammad R. Azadmanesh","orcid":null},"institutions":[{"id":"https://openalex.org/I57201433","display_name":"Universit\u00e0 della Svizzera italiana","ror":"https://ror.org/03c4atk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I57201433"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Mohammad R. Azadmanesh","raw_affiliation_strings":["University of Lugano, Switzerland#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Lugano, Switzerland#TAB#","institution_ids":["https://openalex.org/I57201433"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5078770676","display_name":"Matthias Hauswirth","orcid":"https://orcid.org/0000-0001-5527-5931"},"institutions":[{"id":"https://openalex.org/I57201433","display_name":"Universit\u00e0 della Svizzera italiana","ror":"https://ror.org/03c4atk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I57201433"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Matthias Hauswirth","raw_affiliation_strings":["University of Lugano, Switzerland#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Lugano, Switzerland#TAB#","institution_ids":["https://openalex.org/I57201433"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.199,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":1,"citation_normalized_percentile":{"value":0.190594,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":66,"max":73},"biblio":{"volume":null,"issue":null,"first_page":"2","last_page":"7"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9997,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9997,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10260","display_name":"Software Engineering Research","score":0.9992,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T12127","display_name":"Software System Performance and Reliability","score":0.9989,"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/trace","display_name":"TRACE (psycholinguistics)","score":0.71605885},{"id":"https://openalex.org/keywords/scratch","display_name":"Scratch","score":0.51097715},{"id":"https://openalex.org/keywords/interface","display_name":"Interface (matter)","score":0.4617299},{"id":"https://openalex.org/keywords/domain-specific-language","display_name":"Domain-specific language","score":0.42379892}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8922667},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.72488284},{"id":"https://openalex.org/C75291252","wikidata":"https://www.wikidata.org/wiki/Q1315756","display_name":"TRACE (psycholinguistics)","level":2,"score":0.71605885},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.63991517},{"id":"https://openalex.org/C201374245","wikidata":"https://www.wikidata.org/wiki/Q104534","display_name":"Digital subscriber line","level":2,"score":0.5757534},{"id":"https://openalex.org/C2781235140","wikidata":"https://www.wikidata.org/wiki/Q275131","display_name":"Scratch","level":2,"score":0.51097715},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.4617299},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.43098116},{"id":"https://openalex.org/C135257023","wikidata":"https://www.wikidata.org/wiki/Q691358","display_name":"Domain-specific language","level":2,"score":0.42379892},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.42160088},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4103397},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.27409247},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12710267},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"score":0.0},{"id":"https://openalex.org/C129307140","wikidata":"https://www.wikidata.org/wiki/Q6795880","display_name":"Maximum bubble pressure method","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/2823363.2823365","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":11,"referenced_works":["https://openalex.org/W1982328732","https://openalex.org/W2001717110","https://openalex.org/W2002530879","https://openalex.org/W2127225305","https://openalex.org/W2134429122","https://openalex.org/W2153919898","https://openalex.org/W2157922094","https://openalex.org/W2162126440","https://openalex.org/W2293624369","https://openalex.org/W4236425462","https://openalex.org/W4239249613"],"related_works":["https://openalex.org/W2582410692","https://openalex.org/W2460228634","https://openalex.org/W2258960507","https://openalex.org/W2140083133","https://openalex.org/W2119542776","https://openalex.org/W2109776807","https://openalex.org/W2097052821","https://openalex.org/W2014596857","https://openalex.org/W1981826665","https://openalex.org/W1485300234"],"abstract_inverted_index":{"If":[0],"we":[1,10,32],"develop":[2],"a":[3,19,21,77,123],"new":[4,124],"dynamic":[5,50,68],"analysis":[6,69,91],"tool,":[7],"how":[8,34],"should":[9],"expose":[11],"its":[12,73],"functionalities?":[13],"Through":[14],"an":[15,37,134],"interactive":[16],"user":[17],"interface,":[18],"DSL,":[20],"specific":[22],"API,":[23],"or":[24],"in":[25,136],"some":[26,106,137],"other":[27],"way?":[28],"In":[29],"this":[30],"paper,":[31],"discuss":[33],"to":[35,42,47,55,76,104],"use":[36,64],"already":[38],"existing":[39],"language":[40,125],"familiar":[41],"most":[43],"software":[44,110],"engineers,":[45],"SQL,":[46],"perform":[48],"deep":[49,90],"analyses.":[51],"The":[52],"goal":[53],"is":[54,86,99],"explore":[56],"the":[57,67,108,119],"trade-off":[58],"between":[59],"expressiveness":[60],"and":[61,71,95],"ease-of-use.":[62],"We":[63,80],"BLAST":[65],"as":[66,133],"tool":[70],"map":[72],"trace":[74],"information":[75,96],"relational":[78],"database.":[79],"find":[81],"that,":[82],"even":[83],"though":[84],"SQL":[85],"expressive":[87],"enough":[88],"for":[89],"of":[92,107,121],"program":[93],"executions":[94],"flow,":[97],"it":[98,117,131],"not":[100],"quite":[101],"straight":[102],"forward":[103],"express":[105],"queries":[109],"engineers":[111],"might":[112],"be":[113],"interested":[114],"in.":[115],"However,":[116],"removes":[118],"burden":[120],"learning":[122],"from":[126],"scratch,":[127],"which":[128],"could":[129],"make":[130],"worthwhile":[132],"option":[135],"cases.":[138]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1987283499","counts_by_year":[{"year":2018,"cited_by_count":1}],"updated_date":"2025-03-20T16:25:08.642363","created_date":"2016-06-24"}