{"id":"https://openalex.org/W2089719561","doi":"https://doi.org/10.1109/pcoda.2015.7067179","title":"Conceptual interpretation of SQL execution traces for program comprehension","display_name":"Conceptual interpretation of SQL execution traces for program comprehension","publication_year":2015,"publication_date":"2015-03-01","ids":{"openalex":"https://openalex.org/W2089719561","doi":"https://doi.org/10.1109/pcoda.2015.7067179","mag":"2089719561"},"language":"en","primary_location":{"id":"doi:10.1109/pcoda.2015.7067179","is_oa":false,"landing_page_url":"https://doi.org/10.1109/pcoda.2015.7067179","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 6th International Workshop on Program Comprehension through Dynamic Analysis (PCODA)","raw_type":"proceedings-article"},"type":"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/A5064829375","display_name":"Nesrine Noughi","orcid":null},"institutions":[{"id":"https://openalex.org/I149768937","display_name":"University of Namur","ror":"https://ror.org/03d1maw17","country_code":"BE","type":"education","lineage":["https://openalex.org/I149768937"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Nesrine Noughi","raw_affiliation_strings":["PReCISE Research Center, University of Namur, Belgium","University of Namur,Belgium"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"PReCISE Research Center, University of Namur, Belgium","institution_ids":["https://openalex.org/I149768937"]},{"raw_affiliation_string":"University of Namur,Belgium","institution_ids":["https://openalex.org/I149768937"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070165042","display_name":"Anthony Cleve","orcid":null},"institutions":[{"id":"https://openalex.org/I149768937","display_name":"University of Namur","ror":"https://ror.org/03d1maw17","country_code":"BE","type":"education","lineage":["https://openalex.org/I149768937"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Anthony Cleve","raw_affiliation_strings":["PReCISE Research Center, University of Namur, Belgium","University of Namur,Belgium"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"PReCISE Research Center, University of Namur, Belgium","institution_ids":["https://openalex.org/I149768937"]},{"raw_affiliation_string":"University of Namur,Belgium","institution_ids":["https://openalex.org/I149768937"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7013,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.75580496,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"19","last_page":"24"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9995999932289124,"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"}},"topics":[{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9995999932289124,"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/T10260","display_name":"Software Engineering Research","score":0.998199999332428,"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/T10639","display_name":"Advanced Software Engineering Methodologies","score":0.9977999925613403,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/computer-science","display_name":"Computer science","score":0.8103564381599426},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6990146636962891},{"id":"https://openalex.org/keywords/program-comprehension","display_name":"Program comprehension","score":0.6841413974761963},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6273115277290344},{"id":"https://openalex.org/keywords/interpretation","display_name":"Interpretation (philosophy)","score":0.582208514213562},{"id":"https://openalex.org/keywords/abstract-interpretation","display_name":"Abstract interpretation","score":0.4106115698814392},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.39210814237594604},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.34999385476112366},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.11760511994361877},{"id":"https://openalex.org/keywords/software-system","display_name":"Software system","score":0.07179775834083557}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8103564381599426},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6990146636962891},{"id":"https://openalex.org/C2777561058","wikidata":"https://www.wikidata.org/wiki/Q2652119","display_name":"Program comprehension","level":4,"score":0.6841413974761963},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6273115277290344},{"id":"https://openalex.org/C527412718","wikidata":"https://www.wikidata.org/wiki/Q855395","display_name":"Interpretation (philosophy)","level":2,"score":0.582208514213562},{"id":"https://openalex.org/C2780654840","wikidata":"https://www.wikidata.org/wiki/Q333341","display_name":"Abstract interpretation","level":2,"score":0.4106115698814392},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.39210814237594604},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.34999385476112366},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.11760511994361877},{"id":"https://openalex.org/C149091818","wikidata":"https://www.wikidata.org/wiki/Q2429814","display_name":"Software system","level":3,"score":0.07179775834083557}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/pcoda.2015.7067179","is_oa":false,"landing_page_url":"https://doi.org/10.1109/pcoda.2015.7067179","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 6th International Workshop on Program Comprehension through Dynamic Analysis (PCODA)","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.unamur.be:openaire_cris_publications/02147363-ddb9-46cf-adbd-12e8e47ad826","is_oa":false,"landing_page_url":"https://researchportal.unamur.be/en/publications/02147363-ddb9-46cf-adbd-12e8e47ad826","pdf_url":null,"source":{"id":"https://openalex.org/S4406922457","display_name":"Repository of the University of Namur","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Noughi, N & Cleve, A 2015, Conceptual Interpretation of SQL Execution Traces for Program Comprehension. in Proceedings of the 6th International Workshop on Program Comprehension through Dynamic Analysis (PCODA 2015) - Colocated with the 22nd IEEE International Conference on Software Analysis, Evolution, and Reengineering (SANER 2015). IEEE Computer Society Press.","raw_type":"contributionToPeriodical"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W39833282","https://openalex.org/W166193242","https://openalex.org/W1492005537","https://openalex.org/W1638356594","https://openalex.org/W2032915046","https://openalex.org/W2098161545","https://openalex.org/W2111273637","https://openalex.org/W2129879174","https://openalex.org/W2137619003","https://openalex.org/W2143568707","https://openalex.org/W2157943826","https://openalex.org/W2168795459","https://openalex.org/W6680155334"],"related_works":["https://openalex.org/W2611182424","https://openalex.org/W1537272321","https://openalex.org/W4206726327","https://openalex.org/W2789178056","https://openalex.org/W2172022734","https://openalex.org/W2382501300","https://openalex.org/W2360416485","https://openalex.org/W2377542611","https://openalex.org/W2137908418","https://openalex.org/W1504570344"],"abstract_inverted_index":{"Modern":[0],"data-intensive":[1,93],"software":[2],"systems":[3,18],"manipulate":[4],"an":[5,45],"increasing":[6],"amount":[7],"of":[8,33,56,105,110,116],"heterogeneous":[9],"data":[10],"usually":[11],"stored":[12],"in":[13,48,114],"a":[14,20,42,59,80,117],"database.":[15],"Maintaining":[16],"such":[17],"became":[19,41],"crucial":[21],"and":[22,44,61,88],"complex":[23],"task,":[24],"which":[25],"is":[26],"especially":[27],"true":[28],"due":[29],"to":[30,67,90],"the":[31,52,107],"lack":[32],"sufficient":[34],"documentation.":[35],"In":[36],"this":[37,49,76],"context,":[38],"program":[39],"comprehension":[40],"primary":[43],"important":[46],"step":[47],"task.":[50],"Unfortunately,":[51],"highly":[53],"dynamic":[54,85],"nature":[55],"interactions":[57,70],"between":[58],"system":[60],"its":[62],"database":[63,99],"makes":[64],"it":[65],"hard":[66],"analyze":[68],"these":[69],"with":[71],"static":[72],"analysis":[73,86],"techniques.":[74],"To":[75],"end,":[77],"we":[78],"propose":[79],"novel":[81],"approach":[82,103],"that":[83],"combines":[84],"techniques":[87],"visualization":[89],"ease":[91],"understanding":[92],"systems,":[94],"by":[95],"focusing":[96],"on":[97],"their":[98],"manipulation":[100],"behavior.":[101],"The":[102],"consists":[104],"defining":[106],"conceptual":[108],"interpretation":[109],"SQL":[111],"execution":[112],"traces":[113],"terms":[115],"domain-specific,":[118],"platform-independent":[119],"model.":[120]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}