{"id":"https://openalex.org/W1802964627","doi":"https://doi.org/10.1007/978-3-642-20920-8_14","title":"The Boyce-Codd-Heath Normal Form for SQL","display_name":"The Boyce-Codd-Heath Normal Form for SQL","publication_year":2011,"publication_date":"2011-01-01","ids":{"openalex":"https://openalex.org/W1802964627","doi":"https://doi.org/10.1007/978-3-642-20920-8_14","mag":"1802964627"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-642-20920-8_14","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-642-20920-8_14","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"book-chapter","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/A5035972346","display_name":"Flavio Ferrarotti","orcid":"https://orcid.org/0000-0003-2278-8233"},"institutions":[{"id":"https://openalex.org/I41156924","display_name":"Victoria University of Wellington","ror":"https://ror.org/0040r6f76","country_code":"NZ","type":"education","lineage":["https://openalex.org/I41156924"]}],"countries":["NZ"],"is_corresponding":true,"raw_author_name":"Flavio Ferrarotti","raw_affiliation_strings":["School of Information Management, Victoria University of Wellington, New Zealand"],"affiliations":[{"raw_affiliation_string":"School of Information Management, Victoria University of Wellington, New Zealand","institution_ids":["https://openalex.org/I41156924"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103092450","display_name":"Sven Hartmann","orcid":"https://orcid.org/0000-0003-4565-9645"},"institutions":[{"id":"https://openalex.org/I43980791","display_name":"Clausthal University of Technology","ror":"https://ror.org/04qb8nc58","country_code":"DE","type":"education","lineage":["https://openalex.org/I43980791"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Sven Hartmann","raw_affiliation_strings":["Institut f\u00fcr Informatik, Technische Universit\u00e4t Clausthal, Germany"],"affiliations":[{"raw_affiliation_string":"Institut f\u00fcr Informatik, Technische Universit\u00e4t Clausthal, Germany","institution_ids":["https://openalex.org/I43980791"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010236208","display_name":"Henning K\u00f6hler","orcid":null},"institutions":[{"id":"https://openalex.org/I165143802","display_name":"University of Queensland","ror":"https://ror.org/00rqy9422","country_code":"AU","type":"education","lineage":["https://openalex.org/I165143802"]},{"id":"https://openalex.org/I160993911","display_name":"Queensland University of Technology","ror":"https://ror.org/03pnv4752","country_code":"AU","type":"education","lineage":["https://openalex.org/I160993911"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Henning K\u00f6hler","raw_affiliation_strings":["School of Information Technology & Electrical Engineering, University of Queensland, Australia"],"affiliations":[{"raw_affiliation_string":"School of Information Technology & Electrical Engineering, University of Queensland, Australia","institution_ids":["https://openalex.org/I160993911","https://openalex.org/I165143802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069839542","display_name":"Sebastian Link","orcid":"https://orcid.org/0000-0002-1816-2863"},"institutions":[{"id":"https://openalex.org/I41156924","display_name":"Victoria University of Wellington","ror":"https://ror.org/0040r6f76","country_code":"NZ","type":"education","lineage":["https://openalex.org/I41156924"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Sebastian Link","raw_affiliation_strings":["School of Information Management, Victoria University of Wellington, New Zealand"],"affiliations":[{"raw_affiliation_string":"School of Information Management, Victoria University of Wellington, New Zealand","institution_ids":["https://openalex.org/I41156924"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5068367622","display_name":"Millist W. Vincent","orcid":null},"institutions":[{"id":"https://openalex.org/I170239107","display_name":"University of South Australia","ror":"https://ror.org/01p93h210","country_code":"AU","type":"education","lineage":["https://openalex.org/I170239107"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Millist Vincent","raw_affiliation_strings":["School of Computer and Information Science, University of South Australia, Australia"],"affiliations":[{"raw_affiliation_string":"School of Computer and Information Science, University of South Australia, Australia","institution_ids":["https://openalex.org/I170239107"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5035972346"],"corresponding_institution_ids":["https://openalex.org/I41156924"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":2.6772,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.90801343,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"110","last_page":"122"},"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.9994999766349792,"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.9994999766349792,"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.9991999864578247,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9854000210762024,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7756481170654297},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7548267245292664},{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.6524676084518433},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.5435109734535217},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5001590251922607},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.42778444290161133},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.40931442379951477},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3761485815048218},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.34381362795829773},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.19583457708358765},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.06279078125953674}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7756481170654297},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7548267245292664},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.6524676084518433},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5435109734535217},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5001590251922607},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.42778444290161133},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.40931442379951477},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3761485815048218},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.34381362795829773},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.19583457708358765},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.06279078125953674}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1007/978-3-642-20920-8_14","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-642-20920-8_14","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.493.7280","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.493.7280","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://slink.foiks.org/Articles/WoLLIC11.pdf","raw_type":"text"},{"id":"pmh:oai:espace.library.uq.edu.au:UQ:708798","is_oa":false,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4306402388","display_name":"Queensland's institutional digital repository (The University of Queensland)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I165143802","host_organization_name":"The University of Queensland","host_organization_lineage":["https://openalex.org/I165143802"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference Paper"},{"id":"pmh:oai:researchspace.auckland.ac.nz:2292/9873","is_oa":false,"landing_page_url":"https://hdl.handle.net/2292/9873","pdf_url":null,"source":{"id":"https://openalex.org/S7407055463","display_name":"ResearchSpace (University of Auckland)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I154130895","host_organization_name":"University of Auckland","host_organization_lineage":["https://openalex.org/I154130895"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Conference Item"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5899999737739563,"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":28,"referenced_works":["https://openalex.org/W1499274542","https://openalex.org/W1505165377","https://openalex.org/W1513634294","https://openalex.org/W1558832481","https://openalex.org/W1602012035","https://openalex.org/W1964399638","https://openalex.org/W1970372413","https://openalex.org/W1978767174","https://openalex.org/W1983304353","https://openalex.org/W1990391007","https://openalex.org/W1994193726","https://openalex.org/W2002649781","https://openalex.org/W2008396232","https://openalex.org/W2016515719","https://openalex.org/W2043117781","https://openalex.org/W2057773300","https://openalex.org/W2066837227","https://openalex.org/W2071678949","https://openalex.org/W2074877777","https://openalex.org/W2104094070","https://openalex.org/W2140100614","https://openalex.org/W2142421097","https://openalex.org/W2158763191","https://openalex.org/W2168578744","https://openalex.org/W2185907055","https://openalex.org/W2988119170","https://openalex.org/W3023595663","https://openalex.org/W4206031975"],"related_works":["https://openalex.org/W2382973082","https://openalex.org/W4312632526","https://openalex.org/W2086783690","https://openalex.org/W2056177422","https://openalex.org/W2573939812","https://openalex.org/W2155838697","https://openalex.org/W4320473518","https://openalex.org/W2120098008","https://openalex.org/W1639806124","https://openalex.org/W4366145086"],"abstract_inverted_index":null,"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}