{"id":"https://openalex.org/W4233780605","doi":"https://doi.org/10.1002/(sici)1097-4571(19980415)49:5<455::aid-asi7>3.0.co;2-m","title":"Automated database schema design using mined data dependencies","display_name":"Automated database schema design using mined data dependencies","publication_year":1998,"publication_date":"1998-01-01","ids":{"openalex":"https://openalex.org/W4233780605","doi":"https://doi.org/10.1002/(sici)1097-4571(19980415)49:5<455::aid-asi7>3.0.co;2-m"},"language":"en","primary_location":{"id":"doi:10.1002/(sici)1097-4571(19980415)49:5<455::aid-asi7>3.0.co;2-m","is_oa":false,"landing_page_url":"https://doi.org/10.1002/(sici)1097-4571(19980415)49:5<455::aid-asi7>3.0.co;2-m","pdf_url":null,"source":{"id":"https://openalex.org/S4210220780","display_name":"Journal of the American Society for Information Science","issn_l":"0002-8231","issn":["0002-8231","1097-4571"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the American Society for Information Science","raw_type":"journal-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/A5113493572","display_name":"S. K. M. Wong","orcid":null},"institutions":[{"id":"https://openalex.org/I194028371","display_name":"University of Regina","ror":"https://ror.org/03dzc0485","country_code":"CA","type":"education","lineage":["https://openalex.org/I194028371"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"S. K. M. Wong","raw_affiliation_strings":["Department of Computer Science, University of Regina, Regina, Saskatchewan, Canada S4S 0A2"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Regina, Regina, Saskatchewan, Canada S4S 0A2","institution_ids":["https://openalex.org/I194028371"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081940776","display_name":"Cory J. Butz","orcid":"https://orcid.org/0000-0002-5964-3954"},"institutions":[{"id":"https://openalex.org/I194028371","display_name":"University of Regina","ror":"https://ror.org/03dzc0485","country_code":"CA","type":"education","lineage":["https://openalex.org/I194028371"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"C. J. Butz","raw_affiliation_strings":["Department of Computer Science, University of Regina, Regina, Saskatchewan, Canada S4S 0A2"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Regina, Regina, Saskatchewan, Canada S4S 0A2","institution_ids":["https://openalex.org/I194028371"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100666555","display_name":"Yang Xiang","orcid":"https://orcid.org/0000-0001-9740-6645"},"institutions":[{"id":"https://openalex.org/I194028371","display_name":"University of Regina","ror":"https://ror.org/03dzc0485","country_code":"CA","type":"education","lineage":["https://openalex.org/I194028371"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Y. Xiang","raw_affiliation_strings":["Department of Computer Science, University of Regina, Regina, Saskatchewan, Canada S4S 0A2"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Regina, Regina, Saskatchewan, Canada S4S 0A2","institution_ids":["https://openalex.org/I194028371"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5081940776","https://openalex.org/A5100666555","https://openalex.org/A5113493572"],"corresponding_institution_ids":["https://openalex.org/I194028371"],"apc_list":null,"apc_paid":null,"fwci":0.5353,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.7885502,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"49","issue":"5","first_page":"455","last_page":"470"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.9980999827384949,"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/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.9980999827384949,"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/T11719","display_name":"Data Quality and Management","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9947999715805054,"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/computer-science","display_name":"Computer science","score":0.7894132137298584},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.7071647644042969},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6632816195487976},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5957309603691101},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.557284414768219},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.545589804649353},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5403301119804382},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.5114235281944275},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.4685206115245819},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4504660964012146},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.4252646565437317},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4001503884792328},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.30616551637649536},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2873598635196686}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7894132137298584},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.7071647644042969},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6632816195487976},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5957309603691101},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.557284414768219},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.545589804649353},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5403301119804382},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.5114235281944275},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.4685206115245819},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4504660964012146},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.4252646565437317},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4001503884792328},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.30616551637649536},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2873598635196686},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/(sici)1097-4571(19980415)49:5<455::aid-asi7>3.0.co;2-m","is_oa":false,"landing_page_url":"https://doi.org/10.1002/(sici)1097-4571(19980415)49:5<455::aid-asi7>3.0.co;2-m","pdf_url":null,"source":{"id":"https://openalex.org/S4210220780","display_name":"Journal of the American Society for Information Science","issn_l":"0002-8231","issn":["0002-8231","1097-4571"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the American Society for Information Science","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":39,"referenced_works":["https://openalex.org/W180578187","https://openalex.org/W1481279574","https://openalex.org/W1505477995","https://openalex.org/W1550696814","https://openalex.org/W1558863764","https://openalex.org/W1562115776","https://openalex.org/W1593793857","https://openalex.org/W1862114498","https://openalex.org/W1965250678","https://openalex.org/W1965548659","https://openalex.org/W1965555277","https://openalex.org/W1971475250","https://openalex.org/W1975062332","https://openalex.org/W1988814833","https://openalex.org/W1993680510","https://openalex.org/W1996748356","https://openalex.org/W2039610696","https://openalex.org/W2091683358","https://openalex.org/W2110810394","https://openalex.org/W2148417962","https://openalex.org/W2148888997","https://openalex.org/W2320198223","https://openalex.org/W2352490338","https://openalex.org/W4250143236","https://openalex.org/W4297792526","https://openalex.org/W4300550420","https://openalex.org/W6601093276","https://openalex.org/W6605986943","https://openalex.org/W6607293039","https://openalex.org/W6628666425","https://openalex.org/W6633120874","https://openalex.org/W6633596644","https://openalex.org/W6636145420","https://openalex.org/W6640287885","https://openalex.org/W6676257875","https://openalex.org/W6678602247","https://openalex.org/W6680812728","https://openalex.org/W6685011611","https://openalex.org/W6696782425"],"related_works":["https://openalex.org/W2092058806","https://openalex.org/W139721835","https://openalex.org/W2582962420","https://openalex.org/W2153512431","https://openalex.org/W2093134728","https://openalex.org/W290184810","https://openalex.org/W2585347450","https://openalex.org/W2007556552","https://openalex.org/W2585783528","https://openalex.org/W1545044175"],"abstract_inverted_index":{"Data":[0],"dependencies":[1,23,49],"are":[2,24,34],"used":[3],"in":[4,51,78],"database":[5,14,86],"schema":[6,87],"design":[7,88],"to":[8,18,96],"enforce":[9],"the":[10,28,31,38,58,61,70,99],"correctness":[11],"of":[12,30,69,103],"a":[13,43,56],"as":[15,17],"well":[16],"reduce":[19],"redundant":[20],"data.":[21],"These":[22],"usually":[25],"determined":[26],"from":[27],"semantics":[29],"attributes":[32],"and":[33,101],"then":[35],"enforced":[36],"upon":[37],"relations.":[39],"This":[40],"article":[41],"describes":[42],"bottom-up":[44],"procedure":[45],"for":[46,74,84],"discovering":[47],"multivalued":[48],"(MVDs)":[50],"observed":[52],"data":[53],"without":[54],"knowing":[55],"priori":[57],"relationships":[59],"among":[60],"attributes.":[62],"The":[63],"proposed":[64],"algorithm":[65],"is":[66],"an":[67],"application":[68],"technique":[71],"we":[72],"designed":[73],"learning":[75],"conditional":[76],"independencies":[77],"probabilistic":[79],"reasoning.":[80],"A":[81],"prototype":[82],"system":[83],"automated":[85],"has":[89],"been":[90],"implemented.":[91],"Experiments":[92],"were":[93],"carried":[94],"out":[95],"demonstrate":[97],"both":[98],"effectiveness":[100],"efficiency":[102],"our":[104],"method.":[105],"\u00a9":[106],"1998":[107],"John":[108],"Wiley":[109],"&":[110],"Sons,":[111],"Inc.":[112]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}