{"id":"https://openalex.org/W2128198810","doi":"https://doi.org/10.1109/ccece.2008.4564486","title":"Automatic database normalization and primary key generation","display_name":"Automatic database normalization and primary key generation","alternate_titles":[],"publication_year":2008,"publication_date":"2008-05-01","ids":{"openalex":"https://openalex.org/W2128198810","doi":"https://doi.org/10.1109/ccece.2008.4564486","mag":"2128198810"},"language":"en","primary_location":{"id":"doi:10.1109/ccece.2008.4564486","doi":"https://doi.org/10.1109/ccece.2008.4564486","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ccece.2008.4564486","pdf_url":null,"source":{"id":"https://openalex.org/S4210221841","display_name":"Conference proceedings - Canadian Conference on Electrical and Computer Engineering","issn_l":"0840-7789","issn":["0840-7789"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 Canadian Conference on Electrical and Computer Engineering","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W2128198810"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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/A5039067401","display_name":"Amir Hassan Bahmani","orcid":"https://orcid.org/0000-0003-4533-9334","observed_orcids":["https://orcid.org/0000-0003-4533-9334"]},"institutions":[{"id":"https://openalex.org/I183859904","display_name":"Islamic Azad University, Mashhad","ror":"https://ror.org/00bvysh61","country_code":"IR","type":"education","lineage":["https://openalex.org/I110525433","https://openalex.org/I183859904"]}],"countries":["IR"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Amir Hassan Bahmani","raw_affiliation_strings":["Young Researchers Club Department of Computer Engineering, Islamic Azad University of Mashhad, Mashhad, Iran","Dept. of Comput. Eng., Islamic Azad Univ. of Mashhad, Mashhad"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Young Researchers Club Department of Computer Engineering, Islamic Azad University of Mashhad, Mashhad, Iran","institution_ids":["https://openalex.org/I183859904"]},{"raw_affiliation_string":"Dept. of Comput. Eng., Islamic Azad Univ. of Mashhad, Mashhad","institution_ids":["https://openalex.org/I183859904"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000670364","display_name":"Mahmoud Naghibzadeh","orcid":"https://orcid.org/0000-0001-5550-5565","observed_orcids":["https://orcid.org/0000-0001-5550-5565"]},"institutions":[{"id":"https://openalex.org/I86958956","display_name":"Ferdowsi University of Mashhad","ror":"https://ror.org/00g6ka752","country_code":"IR","type":"education","lineage":["https://openalex.org/I86958956"]}],"countries":["IR"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Mahmoud Naghibzadeh","raw_affiliation_strings":["Department of Computer Engineering, Ferdowsi University of Mashhad, Mashhad, Iran","Dept of Computer Engineering, Ferdowsi University of Mashhad, Iran"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Engineering, Ferdowsi University of Mashhad, Mashhad, Iran","institution_ids":["https://openalex.org/I86958956"]},{"raw_affiliation_string":"Dept of Computer Engineering, Ferdowsi University of Mashhad, Iran","institution_ids":["https://openalex.org/I86958956"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5111928796","display_name":"Behnam Bahmani","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210103782","display_name":"Islamic Azad University, Firoozkooh Branch","ror":"https://ror.org/025eayv75","country_code":"IR","type":"education","lineage":["https://openalex.org/I110525433","https://openalex.org/I4210103782"]}],"countries":["IR"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Behnam Bahmani","raw_affiliation_strings":["Department of Computer Engineering, Islamic Azad University Firoozkooh, Iran","Dept of Computer Engineering, Islamic Azad University of Firoozkooh, Iran"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Engineering, Islamic Azad University Firoozkooh, Iran","institution_ids":["https://openalex.org/I4210103782"]},{"raw_affiliation_string":"Dept of Computer Engineering, Islamic Azad University of Firoozkooh, Iran","institution_ids":["https://openalex.org/I4210103782"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2513,"has_fulltext":false,"cited_by_count":46,"citation_normalized_percentile":{"value":0.7870309,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"000011","last_page":"000016"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9940999746322632,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9940999746322632,"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/T11719","display_name":"Data Quality and Management","score":0.0010999999940395355,"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/T13681","display_name":"Engineering and Information Technology","score":0.0007999999797903001,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/relational-database-normalization","display_name":"relational database normalization","score":0.8510000109672546},{"id":"https://openalex.org/keywords/dependency-matrix","display_name":"dependency matrix","score":0.5929999947547913},{"id":"https://openalex.org/keywords/directed-graphs","display_name":"directed graphs","score":0.7360000014305115},{"id":"https://openalex.org/keywords/third-normal-form","display_name":"third normal form","score":1.0},{"id":"https://openalex.org/keywords/boyce-codd-normal-form","display_name":"Boyce-Codd normal form","score":0.9679999947547913},{"id":"https://openalex.org/keywords/data-redundancy","display_name":"data redundancy","score":0.7210000157356262},{"id":"https://openalex.org/keywords/database-schema-design","display_name":"database schema design","score":0.335999995470047}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7993437051773071},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7637920379638672},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.6589978933334351},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.6186634302139282},{"id":"https://openalex.org/C7545210","wikidata":"https://www.wikidata.org/wiki/Q838123","display_name":"Data redundancy","level":2,"score":0.6043307185173035},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5906194448471069},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.5112142562866211},{"id":"https://openalex.org/C162984825","wikidata":"https://www.wikidata.org/wiki/Q339072","display_name":"Database normalization","level":3,"score":0.48610520362854004},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4794125258922577},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.4404746890068054},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33359038829803467},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.28554004430770874},{"id":"https://openalex.org/C153180895","wikidata":"https://www.wikidata.org/wiki/Q7148389","display_name":"Pattern recognition (psychology)","level":2,"score":0.16954118013381958},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ccece.2008.4564486","doi":"https://doi.org/10.1109/ccece.2008.4564486","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ccece.2008.4564486","pdf_url":null,"source":{"id":"https://openalex.org/S4210221841","display_name":"Conference proceedings - Canadian Conference on Electrical and Computer Engineering","issn_l":"0840-7789","issn":["0840-7789"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 Canadian Conference on Electrical and Computer Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1528090796","https://openalex.org/W1575391024","https://openalex.org/W2026139222","https://openalex.org/W2093003289","https://openalex.org/W2138709157","https://openalex.org/W2158763191","https://openalex.org/W2895646556","https://openalex.org/W4285042649","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W7100589453","https://openalex.org/W2131367269","https://openalex.org/W6912437268","https://openalex.org/W2188812316","https://openalex.org/W2782740778","https://openalex.org/W7148841074","https://openalex.org/W2093003289","https://openalex.org/W4307028267","https://openalex.org/W2584736212"],"abstract_inverted_index":{"Normalization":[0],"is":[1,47,74,131,143],"the":[2,7,69,72,94,98,108,121],"most":[3],"exercised":[4],"technique":[5,56],"for":[6,138],"analysis":[8],"of":[9,18,128],"relational":[10,19,88],"databases.":[11],"It":[12,46,92,103],"aims":[13],"at":[14],"creating":[15],"a":[16,84],"set":[17],"tables":[20,116],"with":[21,106],"minimum":[22],"data":[23,60],"redundancy":[24],"that":[25],"preserve":[26],"consistency":[27],"and":[28,33,79,97,111],"facilitate":[29],"correct":[30],"insertion,":[31],"deletion,":[32],"modification.":[34],"A":[35],"normalized":[36],"database":[37,89],"does":[38],"not":[39],"show":[40],"anomalies":[41],"due":[42],"to":[43,52,57,64,76,132],"future":[44],"updates.":[45],"very":[48],"much":[49],"time":[50],"consuming":[51],"employ":[53],"an":[54],"automated":[55,87],"do":[58],"this":[59,129],"analysis,":[61],"as":[62,120],"opposed":[63],"doing":[65],"it":[66],"manually.":[67],"At":[68],"same":[70],"time,":[71],"process":[73],"tested":[75],"be":[77],"reliable":[78],"correct.":[80],"This":[81],"paper":[82],"presents":[83],"new":[85],"complete":[86],"normalization":[90],"method.":[91],"produces":[93],"dependency":[95],"matrix":[96],"directed":[99],"graph":[100],"matrix,":[101],"first.":[102],"then":[104],"proceeds":[105],"generating":[107],"2NF,":[109],"3NF,":[110],"BCNF":[112],"normal":[113],"forms.":[114],"All":[115],"are":[117],"also":[118],"generated":[119],"procedure":[122],"proceeds.":[123],"One":[124],"more":[125],"side":[126],"product":[127],"research":[130],"automatically":[133],"distinguish":[134],"one":[135],"primary":[136],"key":[137],"every":[139],"final":[140],"table":[141],"which":[142],"generated.":[144]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2128198810","counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
