{"id":"https://openalex.org/W2050707370","doi":"https://doi.org/10.1016/0169-023x(95)00012-h","title":"Understanding database design expertise","display_name":"Understanding database design expertise","publication_year":1995,"publication_date":"1995-08-01","ids":{"openalex":"https://openalex.org/W2050707370","doi":"https://doi.org/10.1016/0169-023x(95)00012-h","mag":"2050707370"},"language":"en","primary_location":{"id":"doi:10.1016/0169-023x(95)00012-h","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0169-023x(95)00012-h","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1016/0169-023x(95)00012-h","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5002282690","display_name":"Veda C. Storey","orcid":"https://orcid.org/0000-0002-8735-1553"},"institutions":[{"id":"https://openalex.org/I5388228","display_name":"University of Rochester","ror":"https://ror.org/022kthw22","country_code":"US","type":"education","lineage":["https://openalex.org/I5388228"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Veda C. Storey","raw_affiliation_strings":["Wm. E. Simon Graduate School of Business Administration, University of Rochester, Rochester, NY 14627, USA","University of Rochester"],"affiliations":[{"raw_affiliation_string":"Wm. E. Simon Graduate School of Business Administration, University of Rochester, Rochester, NY 14627, USA","institution_ids":["https://openalex.org/I5388228"]},{"raw_affiliation_string":"University of Rochester","institution_ids":["https://openalex.org/I5388228"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102234127","display_name":"Cheryl Bagley Thompson","orcid":null},"institutions":[{"id":"https://openalex.org/I223532165","display_name":"University of Utah","ror":"https://ror.org/03r0ha626","country_code":"US","type":"education","lineage":["https://openalex.org/I223532165"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Cheryl Bagley Thompson","raw_affiliation_strings":["University of Utah, College of Nursing, 25 South Medical Drive, Salt Lake City, UT 84112, USA"],"affiliations":[{"raw_affiliation_string":"University of Utah, College of Nursing, 25 South Medical Drive, Salt Lake City, UT 84112, USA","institution_ids":["https://openalex.org/I223532165"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5044250210","display_name":"Sudha Ram","orcid":"https://orcid.org/0000-0001-6053-1311"},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sudha Ram","raw_affiliation_strings":["College of Business and Public Administration, University of Arizona, Tucson, AZ 85721, USA","College of Business and Public Administration, University of Arizona, Tucson, AZ 85721, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"College of Business and Public Administration, University of Arizona, Tucson, AZ 85721, USA","institution_ids":["https://openalex.org/I138006243"]},{"raw_affiliation_string":"College of Business and Public Administration, University of Arizona, Tucson, AZ 85721, USA#TAB#","institution_ids":["https://openalex.org/I138006243"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5002282690"],"corresponding_institution_ids":["https://openalex.org/I5388228"],"apc_list":{"value":2590,"currency":"USD","value_usd":2590},"apc_paid":{"value":2590,"currency":"USD","value_usd":2590},"fwci":0.9717,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.79998466,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"16","issue":"2","first_page":"97","last_page":"124"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9952999949455261,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9952999949455261,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9897000193595886,"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"}},{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.982200026512146,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6933153867721558},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.6841945648193359},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5729306936264038},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5194005966186523},{"id":"https://openalex.org/keywords/design-process","display_name":"Design process","score":0.4306965470314026},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3390539884567261},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.17511942982673645},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.17371582984924316}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6933153867721558},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.6841945648193359},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5729306936264038},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5194005966186523},{"id":"https://openalex.org/C48262172","wikidata":"https://www.wikidata.org/wiki/Q16908765","display_name":"Design process","level":3,"score":0.4306965470314026},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3390539884567261},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.17511942982673645},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.17371582984924316},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/0169-023x(95)00012-h","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0169-023x(95)00012-h","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1016/0169-023x(95)00012-h","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0169-023x(95)00012-h","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.47999998927116394,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":127,"referenced_works":["https://openalex.org/W6282175","https://openalex.org/W20474690","https://openalex.org/W44598474","https://openalex.org/W74995103","https://openalex.org/W75134691","https://openalex.org/W92559066","https://openalex.org/W105718829","https://openalex.org/W123930785","https://openalex.org/W139313190","https://openalex.org/W139773734","https://openalex.org/W163812436","https://openalex.org/W163917331","https://openalex.org/W165875069","https://openalex.org/W236674887","https://openalex.org/W638487840","https://openalex.org/W1484633057","https://openalex.org/W1489971507","https://openalex.org/W1492518088","https://openalex.org/W1510137518","https://openalex.org/W1525376319","https://openalex.org/W1533710763","https://openalex.org/W1537783470","https://openalex.org/W1541116164","https://openalex.org/W1550790342","https://openalex.org/W1569117688","https://openalex.org/W1577880763","https://openalex.org/W1597833494","https://openalex.org/W1761028980","https://openalex.org/W1811976956","https://openalex.org/W1853934302","https://openalex.org/W1945121096","https://openalex.org/W1950644452","https://openalex.org/W1963118906","https://openalex.org/W1963506920","https://openalex.org/W1966313356","https://openalex.org/W1966515155","https://openalex.org/W1967022935","https://openalex.org/W1970468344","https://openalex.org/W1971778345","https://openalex.org/W1977377778","https://openalex.org/W1977506082","https://openalex.org/W1987623058","https://openalex.org/W1992410740","https://openalex.org/W2008157322","https://openalex.org/W2012787923","https://openalex.org/W2019159042","https://openalex.org/W2021352015","https://openalex.org/W2028544887","https://openalex.org/W2035346816","https://openalex.org/W2039601877","https://openalex.org/W2040943120","https://openalex.org/W2045300586","https://openalex.org/W2048225703","https://openalex.org/W2053677015","https://openalex.org/W2060849841","https://openalex.org/W2063640365","https://openalex.org/W2066412942","https://openalex.org/W2066734883","https://openalex.org/W2071718761","https://openalex.org/W2082381519","https://openalex.org/W2088378932","https://openalex.org/W2088563966","https://openalex.org/W2089634871","https://openalex.org/W2097203724","https://openalex.org/W2098733151","https://openalex.org/W2099293367","https://openalex.org/W2104771072","https://openalex.org/W2113617564","https://openalex.org/W2113827629","https://openalex.org/W2114471852","https://openalex.org/W2119672088","https://openalex.org/W2122789628","https://openalex.org/W2126591553","https://openalex.org/W2129779112","https://openalex.org/W2133764456","https://openalex.org/W2140037779","https://openalex.org/W2143322794","https://openalex.org/W2144192824","https://openalex.org/W2145731266","https://openalex.org/W2149123875","https://openalex.org/W2151165380","https://openalex.org/W2172188251","https://openalex.org/W2177554891","https://openalex.org/W2185703560","https://openalex.org/W2275773297","https://openalex.org/W2297720061","https://openalex.org/W2325337107","https://openalex.org/W2334085438","https://openalex.org/W2352490338","https://openalex.org/W2579071965","https://openalex.org/W2588808342","https://openalex.org/W2751199251","https://openalex.org/W2753439427","https://openalex.org/W2782733505","https://openalex.org/W2889200856","https://openalex.org/W2945526390","https://openalex.org/W3029190516","https://openalex.org/W3185189058","https://openalex.org/W3189142755","https://openalex.org/W4232631306","https://openalex.org/W4247426396","https://openalex.org/W4301507461","https://openalex.org/W6600254316","https://openalex.org/W6601738867","https://openalex.org/W6602996023","https://openalex.org/W6603770062","https://openalex.org/W6605037515","https://openalex.org/W6606598371","https://openalex.org/W6606721586","https://openalex.org/W6620801669","https://openalex.org/W6631152419","https://openalex.org/W6634425381","https://openalex.org/W6635550806","https://openalex.org/W6637777553","https://openalex.org/W6639111317","https://openalex.org/W6640983107","https://openalex.org/W6653782626","https://openalex.org/W6659058693","https://openalex.org/W6666713136","https://openalex.org/W6675249881","https://openalex.org/W6679613935","https://openalex.org/W6697631583","https://openalex.org/W6778119218","https://openalex.org/W6805193426","https://openalex.org/W7019423986","https://openalex.org/W7058358401","https://openalex.org/W7071489825"],"related_works":["https://openalex.org/W584886505","https://openalex.org/W2366660644","https://openalex.org/W3184093474","https://openalex.org/W2371449207","https://openalex.org/W3162115094","https://openalex.org/W1568401719","https://openalex.org/W2188578519","https://openalex.org/W3130673957","https://openalex.org/W2130474477","https://openalex.org/W630074038"],"abstract_inverted_index":{"Database":[0],"design":[1,25,46,79,122],"is":[2,27,112],"a":[3,30,42,58],"complex":[4],"and":[5,81],"time-consuming":[6],"process.":[7],"In":[8],"order":[9],"to":[10,38,74,83,94,105,109],"automate":[11],"database":[12,43,45,121],"design,":[13],"an":[14],"understanding":[15],"of":[16,19,32,65,69,77,89,120],"the":[17,24,70,78,87,103,107,117],"nature":[18],"expertise":[20,47,90,111],"that":[21],"goes":[22],"into":[23],"process":[26,80],"needed.":[28],"Although":[29],"number":[31],"expert":[33,123],"systems":[34,98,124],"have":[35],"been":[36,50],"developed":[37],"assist":[39],"or":[40],"replace":[41],"designer,":[44],"has":[48],"not":[49],"examined":[51],"in":[52],"any":[53],"detail.":[54],"This":[55],"paper":[56],"proposes":[57],"conceptual":[59],"framework":[60,71],"for":[61,86,116],"explaining":[62],"this":[63],"type":[64],"expertise.":[66],"The":[67],"components":[68],"are":[72,99,125],"applied":[73],"each":[75],"phase":[76],"used":[82],"provide":[84],"guidelines":[85],"level":[88],"developers":[91],"might":[92],"strive":[93],"obtain.":[95],"Several":[96],"representative":[97],"analyzed,":[100],"based":[101],"on":[102],"framework,":[104],"explore":[106],"degree":[108],"which":[110],"being":[113],"captured.":[114],"Implications":[115],"future":[118],"development":[119],"discussed.":[126]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}