{"id":"https://openalex.org/W2129000232","doi":"https://doi.org/10.1109/icsmc.2004.1399817","title":"Automatic discovery of association paths in relational databases using software visualization","display_name":"Automatic discovery of association paths in relational databases using software visualization","publication_year":2005,"publication_date":"2005-03-31","ids":{"openalex":"https://openalex.org/W2129000232","doi":"https://doi.org/10.1109/icsmc.2004.1399817","mag":"2129000232"},"language":"en","primary_location":{"id":"doi:10.1109/icsmc.2004.1399817","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icsmc.2004.1399817","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2004 IEEE International Conference on Systems, Man and Cybernetics (IEEE Cat. No.04CH37583)","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/A5109959782","display_name":"Haider Ali Ramadhan","orcid":null},"institutions":[{"id":"https://openalex.org/I47818738","display_name":"Sultan Qaboos University","ror":"https://ror.org/04wq8zb47","country_code":"OM","type":"education","lineage":["https://openalex.org/I47818738"]}],"countries":["OM"],"is_corresponding":true,"raw_author_name":"H.A. Ramadhan","raw_affiliation_strings":["Computer Science Department, Sultan Qaboos University, Muscat, Oman","Dept. of Comput. Sci., Sultan Qaboos Univ., Muscat, Oman"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Sultan Qaboos University, Muscat, Oman","institution_ids":["https://openalex.org/I47818738"]},{"raw_affiliation_string":"Dept. of Comput. Sci., Sultan Qaboos Univ., Muscat, Oman","institution_ids":["https://openalex.org/I47818738"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5109959782"],"corresponding_institution_ids":["https://openalex.org/I47818738"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.18607685,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"2","issue":null,"first_page":"1371","last_page":"1376"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10799","display_name":"Data Visualization and Analytics","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.9922000169754028,"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/T12720","display_name":"Multimedia Communication and Technology","score":0.98580002784729,"subfield":{"id":"https://openalex.org/subfields/3312","display_name":"Sociology and Political Science"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8008996248245239},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.7340383529663086},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6917078495025635},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.643378496170044},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5778424739837646},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5226330757141113},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.4785902500152588},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.47334885597229004},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4688119888305664},{"id":"https://openalex.org/keywords/path","display_name":"Path (computing)","score":0.4462769627571106},{"id":"https://openalex.org/keywords/association-rule-learning","display_name":"Association rule learning","score":0.4285935163497925},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.42651355266571045},{"id":"https://openalex.org/keywords/data-visualization","display_name":"Data visualization","score":0.4202863574028015},{"id":"https://openalex.org/keywords/software-visualization","display_name":"Software visualization","score":0.4186880886554718},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.41469651460647583},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.3839139938354492},{"id":"https://openalex.org/keywords/software-system","display_name":"Software system","score":0.2895315885543823},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15588441491127014},{"id":"https://openalex.org/keywords/component-based-software-engineering","display_name":"Component-based software engineering","score":0.12809151411056519}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8008996248245239},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.7340383529663086},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6917078495025635},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.643378496170044},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5778424739837646},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5226330757141113},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4785902500152588},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.47334885597229004},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4688119888305664},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.4462769627571106},{"id":"https://openalex.org/C193524817","wikidata":"https://www.wikidata.org/wiki/Q386780","display_name":"Association rule learning","level":2,"score":0.4285935163497925},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.42651355266571045},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4202863574028015},{"id":"https://openalex.org/C4379982","wikidata":"https://www.wikidata.org/wiki/Q1273511","display_name":"Software visualization","level":5,"score":0.4186880886554718},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.41469651460647583},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.3839139938354492},{"id":"https://openalex.org/C149091818","wikidata":"https://www.wikidata.org/wiki/Q2429814","display_name":"Software system","level":3,"score":0.2895315885543823},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15588441491127014},{"id":"https://openalex.org/C174683762","wikidata":"https://www.wikidata.org/wiki/Q609588","display_name":"Component-based software engineering","level":4,"score":0.12809151411056519}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icsmc.2004.1399817","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icsmc.2004.1399817","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2004 IEEE International Conference on Systems, Man and Cybernetics (IEEE Cat. No.04CH37583)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1598077662","https://openalex.org/W1814907964","https://openalex.org/W2070921605","https://openalex.org/W2093050400","https://openalex.org/W2105474021","https://openalex.org/W2114877339","https://openalex.org/W2132881639","https://openalex.org/W2138199375","https://openalex.org/W2145737999","https://openalex.org/W4250177356"],"related_works":["https://openalex.org/W2091588998","https://openalex.org/W2090626944","https://openalex.org/W2153455914","https://openalex.org/W2585880425","https://openalex.org/W1548124079","https://openalex.org/W2911768431","https://openalex.org/W2121229754","https://openalex.org/W1512562726","https://openalex.org/W2955692919","https://openalex.org/W2901432962"],"abstract_inverted_index":{"We":[0],"introduce":[1],"a":[2],"visual":[3,35,132],"framework":[4,19,71,133],"for":[5],"facilitating":[6],"tasks":[7],"associated":[8],"with":[9,42],"database":[10,39,62,109],"maintenance":[11],"and":[12,27,52,113,138],"re-use.":[13],"The":[14,22,32,124],"prototype":[15],"system":[16,23,33],"embodying":[17],"the":[18,38,61,66,69,74,91,99,108,118,121],"is":[20,57,111,136],"presented.":[21],"utilizes":[24],"various":[25,43],"techniques":[26],"features":[28],"of":[29,37,68],"software":[30],"visualization.":[31],"supports":[34],"displays":[36],"structure":[40],"along":[41],"implicit":[44],"relationships":[45],"found":[46],"in":[47,72],"it":[48],"such":[49,134],"as":[50,117],"associations":[51],"path":[53,79,105],"views.":[54],"Information":[55],"visualized":[56],"automatically":[58],"extracted":[59],"from":[60,90,107],"schema.":[63],"To":[64],"assess":[65],"usefulness":[67],"proposed":[70],"helping":[73],"programmers":[75],"to":[76,94,102,115,140],"quickly":[77],"recognize":[78,104],"views":[80,106],"among":[81],"relations,":[82],"an":[83],"empirical":[84],"evaluation":[85,92,125],"was":[86],"conducted.":[87],"Results":[88],"collected":[89],"seem":[93],"support":[95],"our":[96,131],"hypothesis":[97],"that":[98,128],"time":[100,135],"required":[101],"manually":[103],"schema":[110],"considerable":[112],"tends":[114,139],"increase":[116],"depth":[119],"between":[120],"relations":[122],"increases.":[123],"also":[126],"showed":[127],"by":[129],"using":[130],"negligible":[137],"be":[141],"static.":[142]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}