{"id":"https://openalex.org/W1976555430","doi":"https://doi.org/10.1016/s0169-023x(98)00012-3","title":"An ontology-based expert system for database design","display_name":"An ontology-based expert system for database design","publication_year":1998,"publication_date":"1998-10-01","ids":{"openalex":"https://openalex.org/W1976555430","doi":"https://doi.org/10.1016/s0169-023x(98)00012-3","mag":"1976555430"},"language":"en","primary_location":{"id":"doi:10.1016/s0169-023x(98)00012-3","is_oa":true,"landing_page_url":"https://doi.org/10.1016/s0169-023x(98)00012-3","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/s0169-023x(98)00012-3","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/I181565077","display_name":"Georgia State University","ror":"https://ror.org/03qt6ba18","country_code":"US","type":"education","lineage":["https://openalex.org/I181565077"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Veda C. Storey","raw_affiliation_strings":["Department of Computer Information Systems, College of Business Administration, Georgia State University, Atlanta, Georgia 30302-4015, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Information Systems, College of Business Administration, Georgia State University, Atlanta, Georgia 30302-4015, USA","institution_ids":["https://openalex.org/I181565077"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061459812","display_name":"Debabrata Dey","orcid":"https://orcid.org/0000-0001-5290-0578"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Debabrata Dey","raw_affiliation_strings":["School of Business Administration, University of Washington, Seattle, WA 98195-3200, USA","School of Business Administration, University of Washington, Seattle, WA 98195-3200 USA"],"affiliations":[{"raw_affiliation_string":"School of Business Administration, University of Washington, Seattle, WA 98195-3200, USA","institution_ids":["https://openalex.org/I201448701"]},{"raw_affiliation_string":"School of Business Administration, University of Washington, Seattle, WA 98195-3200 USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058547769","display_name":"Harald Ullrich","orcid":null},"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":false,"raw_author_name":"Harald Ullrich","raw_affiliation_strings":["William E. Simon Graduate School of Business Administration, University of Rochester, Rochester, NY 14627, USA"],"affiliations":[{"raw_affiliation_string":"William E. Simon Graduate School of Business Administration, University of Rochester, Rochester, NY 14627, USA","institution_ids":["https://openalex.org/I5388228"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5108393928","display_name":"Shankar Sundaresan","orcid":null},"institutions":[{"id":"https://openalex.org/I130769515","display_name":"Pennsylvania State University","ror":"https://ror.org/04p491231","country_code":"US","type":"education","lineage":["https://openalex.org/I130769515"]},{"id":"https://openalex.org/I931278978","display_name":"College of Business Administration","ror":"https://ror.org/03x1zq178","country_code":"LV","type":"education","lineage":["https://openalex.org/I931278978"]}],"countries":["LV","US"],"is_corresponding":false,"raw_author_name":"Shankar Sundaresan","raw_affiliation_strings":["Smeal College of Business Administration, Pennsylvania State University, University Park, PA 16802, USA","Smeal College of Business Administration Pennsylvania State University University Park, PA 16802, USA"],"affiliations":[{"raw_affiliation_string":"Smeal College of Business Administration, Pennsylvania State University, University Park, PA 16802, USA","institution_ids":["https://openalex.org/I130769515"]},{"raw_affiliation_string":"Smeal College of Business Administration Pennsylvania State University University Park, PA 16802, USA","institution_ids":["https://openalex.org/I931278978"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5002282690","https://openalex.org/A5061459812"],"corresponding_institution_ids":["https://openalex.org/I181565077","https://openalex.org/I201448701"],"apc_list":{"value":2590,"currency":"USD","value_usd":2590},"apc_paid":{"value":2590,"currency":"USD","value_usd":2590},"fwci":3.7466,"has_fulltext":false,"cited_by_count":45,"citation_normalized_percentile":{"value":0.93301742,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"28","issue":"1","first_page":"31","last_page":"46"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991999864578247,"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/T11106","display_name":"Data Management and Algorithms","score":0.9955000281333923,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/ontology","display_name":"Ontology","score":0.8043846487998962},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7651981115341187},{"id":"https://openalex.org/keywords/knowledge-base","display_name":"Knowledge base","score":0.6431598663330078},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.527864396572113},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.48824575543403625},{"id":"https://openalex.org/keywords/knowledge-acquisition","display_name":"Knowledge acquisition","score":0.46796590089797974},{"id":"https://openalex.org/keywords/open-knowledge-base-connectivity","display_name":"Open Knowledge Base Connectivity","score":0.4470238983631134},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.44174498319625854},{"id":"https://openalex.org/keywords/expert-system","display_name":"Expert system","score":0.43758338689804077},{"id":"https://openalex.org/keywords/meaning","display_name":"Meaning (existential)","score":0.43612056970596313},{"id":"https://openalex.org/keywords/knowledge-based-systems","display_name":"Knowledge-based systems","score":0.42059820890426636},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41213175654411316},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4068849980831146},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.311352014541626},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.27554911375045776},{"id":"https://openalex.org/keywords/personal-knowledge-management","display_name":"Personal knowledge management","score":0.10708624124526978}],"concepts":[{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.8043846487998962},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7651981115341187},{"id":"https://openalex.org/C4554734","wikidata":"https://www.wikidata.org/wiki/Q593744","display_name":"Knowledge base","level":2,"score":0.6431598663330078},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.527864396572113},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.48824575543403625},{"id":"https://openalex.org/C2777220311","wikidata":"https://www.wikidata.org/wiki/Q6423340","display_name":"Knowledge acquisition","level":2,"score":0.46796590089797974},{"id":"https://openalex.org/C29804473","wikidata":"https://www.wikidata.org/wiki/Q2025711","display_name":"Open Knowledge Base Connectivity","level":4,"score":0.4470238983631134},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.44174498319625854},{"id":"https://openalex.org/C58328972","wikidata":"https://www.wikidata.org/wiki/Q184609","display_name":"Expert system","level":2,"score":0.43758338689804077},{"id":"https://openalex.org/C2780876879","wikidata":"https://www.wikidata.org/wiki/Q3054749","display_name":"Meaning (existential)","level":2,"score":0.43612056970596313},{"id":"https://openalex.org/C115925183","wikidata":"https://www.wikidata.org/wiki/Q1412694","display_name":"Knowledge-based systems","level":2,"score":0.42059820890426636},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41213175654411316},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4068849980831146},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.311352014541626},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.27554911375045776},{"id":"https://openalex.org/C187572123","wikidata":"https://www.wikidata.org/wiki/Q2034224","display_name":"Personal knowledge management","level":3,"score":0.10708624124526978},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C169735623","wikidata":"https://www.wikidata.org/wiki/Q1430172","display_name":"Organizational learning","level":2,"score":0.0},{"id":"https://openalex.org/C542102704","wikidata":"https://www.wikidata.org/wiki/Q183257","display_name":"Psychotherapist","level":1,"score":0.0},{"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/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/s0169-023x(98)00012-3","is_oa":true,"landing_page_url":"https://doi.org/10.1016/s0169-023x(98)00012-3","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/s0169-023x(98)00012-3","is_oa":true,"landing_page_url":"https://doi.org/10.1016/s0169-023x(98)00012-3","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":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W1484991168","https://openalex.org/W1486440348","https://openalex.org/W1496545610","https://openalex.org/W1502094468","https://openalex.org/W1510137518","https://openalex.org/W1524969273","https://openalex.org/W1538989194","https://openalex.org/W1558378945","https://openalex.org/W1564932073","https://openalex.org/W1582487692","https://openalex.org/W1602005574","https://openalex.org/W1968945891","https://openalex.org/W1971189041","https://openalex.org/W1984018366","https://openalex.org/W2002792899","https://openalex.org/W2005379079","https://openalex.org/W2007524563","https://openalex.org/W2020514031","https://openalex.org/W2021570844","https://openalex.org/W2026735162","https://openalex.org/W2028544887","https://openalex.org/W2053627967","https://openalex.org/W2057161664","https://openalex.org/W2066157863","https://openalex.org/W2070270825","https://openalex.org/W2079814255","https://openalex.org/W2082625705","https://openalex.org/W2084130127","https://openalex.org/W2086906616","https://openalex.org/W2094309656","https://openalex.org/W2107658650","https://openalex.org/W2113827629","https://openalex.org/W2130474477","https://openalex.org/W2133431021","https://openalex.org/W2136027622","https://openalex.org/W2136841553","https://openalex.org/W2137079713","https://openalex.org/W2159525276","https://openalex.org/W2162702010","https://openalex.org/W2168018130","https://openalex.org/W2205031991","https://openalex.org/W2232772762","https://openalex.org/W4285719527","https://openalex.org/W6632181731","https://openalex.org/W6643222268"],"related_works":["https://openalex.org/W2374010509","https://openalex.org/W2106530619","https://openalex.org/W2075096090","https://openalex.org/W2381277088","https://openalex.org/W2140138473","https://openalex.org/W2086580554","https://openalex.org/W2592721119","https://openalex.org/W2086066989","https://openalex.org/W2146662229","https://openalex.org/W2095061810"],"abstract_inverted_index":{"Although":[0],"it":[1],"is":[2,49,130],"possible":[3],"to":[4,50,56,95,185],"encode":[5],"a":[6,16,25,83,91,100,114,133,136,156,178],"great":[7],"deal":[8],"of":[9,24,34,44,61,68,88,132,144,166,175,180],"process":[10],"knowledge":[11,33,52,137],"about":[12],"database":[13,35,46,92],"design":[14,36,47,93],"into":[15,116],"system,":[17],"experience":[18],"has":[19],"shown":[20,184],"that":[21,78,99,146],"the":[22,42,86,97,142,161,164],"contribution":[23],"human":[26],"designer":[27,101],"extends":[28],"beyond":[29],"his":[30,106],"or":[31,107,118,126],"her":[32,108],"techniques.":[37],"The":[38,111,168],"next":[39],"step":[40],"in":[41,90],"evolution":[43],"automated":[45],"tools":[48],"incorporate":[51],"and":[53,155,182],"reasoning":[54],"capabilities":[55],"support":[57],"this":[58],"higher":[59],"level":[60],"participation.":[62],"Doing":[63],"so":[64],"requires":[65],"some":[66],"understanding":[67],"what":[69],"different":[70,173],"terms":[71,145],"mean.":[72],"This":[73],"paper":[74],"presents":[75],"an":[76,150],"ontology":[77,112,169],"can":[79],"be":[80,186],"used":[81],"as":[82,122],"surrogate":[84],"for":[85,159],"meaning":[87,143],"words":[89],"system":[94,152],"simulate":[96],"contributions":[98],"would":[102],"make":[103],"based":[104],"on":[105,141,177],"general":[109],"knowledge.":[110],"classifies":[113],"term":[115],"one":[117],"more":[119],"categories":[120],"such":[121],"person,":[123],"abstract":[124],"good":[125],"tradable":[127],"document.":[128],"It":[129],"comprised":[131],"semantic":[134],"network,":[135],"base":[138],"containing":[139],"information":[140],"have":[147],"been":[148],"classified,":[149],"expert":[151],"knowledge-acquisition":[153],"component,":[154],"distance":[157,162],"measure":[158],"assessing":[160],"between":[163],"meanings":[165],"terms.":[167],"was":[170,183],"tested":[171],"by":[172],"types":[174],"users":[176],"variety":[179],"problems":[181],"quite":[187],"effective.":[188]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}