{"id":"https://openalex.org/W1506623181","doi":"https://doi.org/10.1007/3-540-58907-4_21","title":"The average length of keys and functional dependencies in (random) databases","display_name":"The average length of keys and functional dependencies in (random) databases","publication_year":1995,"publication_date":"1995-01-01","ids":{"openalex":"https://openalex.org/W1506623181","doi":"https://doi.org/10.1007/3-540-58907-4_21","mag":"1506623181"},"language":"en","primary_location":{"id":"doi:10.1007/3-540-58907-4_21","is_oa":false,"landing_page_url":"https://doi.org/10.1007/3-540-58907-4_21","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":"conference-paper","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/A5089822651","display_name":"J\u00e1nos Demetrovics","orcid":null},"institutions":[{"id":"https://openalex.org/I4210117195","display_name":"HUN-REN Institute for Computer Science and Control","ror":"https://ror.org/0249v7n71","country_code":"HU","type":"facility","lineage":["https://openalex.org/I4210117195","https://openalex.org/I4387152226"]},{"id":"https://openalex.org/I7597260","display_name":"Hungarian Academy of Sciences","ror":"https://ror.org/02ks8qq67","country_code":"HU","type":"government","lineage":["https://openalex.org/I7597260"]}],"countries":["HU"],"is_corresponding":false,"raw_author_name":"J. Demetrovics","raw_affiliation_strings":["Comp. & Autom. Inst., Hungarian Academy, Kende u. 13-17, H-1111, Budapest","Comp. & Autom. Inst., Hungarian Academy, Budapest,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Comp. & Autom. Inst., Hungarian Academy, Kende u. 13-17, H-1111, Budapest","institution_ids":["https://openalex.org/I4210117195","https://openalex.org/I7597260"]},{"raw_affiliation_string":"Comp. & Autom. Inst., Hungarian Academy, Budapest,","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103253724","display_name":"Gyula O. H. Katona","orcid":"https://orcid.org/0000-0002-0188-0391"},"institutions":[{"id":"https://openalex.org/I127817813","display_name":"Alfr\u00e9d R\u00e9nyi Institute of Mathematics","ror":"https://ror.org/03vw74f64","country_code":"HU","type":"facility","lineage":["https://openalex.org/I127817813","https://openalex.org/I7597260"]},{"id":"https://openalex.org/I7597260","display_name":"Hungarian Academy of Sciences","ror":"https://ror.org/02ks8qq67","country_code":"HU","type":"government","lineage":["https://openalex.org/I7597260"]}],"countries":["HU"],"is_corresponding":false,"raw_author_name":"G. O. H. Katona","raw_affiliation_strings":["Mathematical Inst., Hungarian Academy, POBox 127, H-1364, Budapest","Mathematical Inst., Hungarian Academy, Budapest,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Mathematical Inst., Hungarian Academy, POBox 127, H-1364, Budapest","institution_ids":["https://openalex.org/I127817813","https://openalex.org/I7597260"]},{"raw_affiliation_string":"Mathematical Inst., Hungarian Academy, Budapest,","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029988381","display_name":"Dezs\u0151 Mikl\u00f3s","orcid":null},"institutions":[{"id":"https://openalex.org/I127817813","display_name":"Alfr\u00e9d R\u00e9nyi Institute of Mathematics","ror":"https://ror.org/03vw74f64","country_code":"HU","type":"facility","lineage":["https://openalex.org/I127817813","https://openalex.org/I7597260"]},{"id":"https://openalex.org/I7597260","display_name":"Hungarian Academy of Sciences","ror":"https://ror.org/02ks8qq67","country_code":"HU","type":"government","lineage":["https://openalex.org/I7597260"]}],"countries":["HU"],"is_corresponding":false,"raw_author_name":"D. Miklos","raw_affiliation_strings":["Mathematical Inst., Hungarian Academy, POBox 127, H-1364, Budapest","Mathematical Inst., Hungarian Academy, Budapest,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Mathematical Inst., Hungarian Academy, POBox 127, H-1364, Budapest","institution_ids":["https://openalex.org/I127817813","https://openalex.org/I7597260"]},{"raw_affiliation_string":"Mathematical Inst., Hungarian Academy, Budapest,","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062759091","display_name":"Oleg Seleznjev","orcid":null},"institutions":[{"id":"https://openalex.org/I19880235","display_name":"Lomonosov Moscow State University","ror":"https://ror.org/010pmpe69","country_code":"RU","type":"education","lineage":["https://openalex.org/I19880235"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"O. Seleznjev","raw_affiliation_strings":["Dept. of Mathematics and Mechanics, Moscow State University, RU-119 899, Moscow","Department of Mathematics and Mechanics, Moscow State University, Moscow,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Dept. of Mathematics and Mechanics, Moscow State University, RU-119 899, Moscow","institution_ids":["https://openalex.org/I19880235"]},{"raw_affiliation_string":"Department of Mathematics and Mechanics, Moscow State University, Moscow,","institution_ids":["https://openalex.org/I19880235"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039350841","display_name":"Bernhard Thalheim","orcid":"https://orcid.org/0000-0002-7909-7786"},"institutions":[{"id":"https://openalex.org/I4210143701","display_name":"Medizinische Universit\u00e4t Lausitz - Carl Thiem","ror":"https://ror.org/044fhy270","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I4210143701"]},{"id":"https://openalex.org/I51783024","display_name":"Brandenburg University of Technology Cottbus-Senftenberg","ror":"https://ror.org/02wxx3e24","country_code":"DE","type":"education","lineage":["https://openalex.org/I51783024"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"B. Thalheim","raw_affiliation_strings":["Computer Science Inst., Cottbus Technical University, POBox 101344, D-03013, Cottbus","Computer Science Inst., Cottbus Technical University, Cottbus,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Inst., Cottbus Technical University, POBox 101344, D-03013, Cottbus","institution_ids":["https://openalex.org/I4210143701","https://openalex.org/I51783024"]},{"raw_affiliation_string":"Computer Science Inst., Cottbus Technical University, Cottbus,","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":0.7033,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.69253402,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"266","last_page":"279"},"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.9987999796867371,"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.9987999796867371,"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.9986000061035156,"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/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.9789000153541565,"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.7047488689422607},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.6795312166213989},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.6347095966339111},{"id":"https://openalex.org/keywords/statistic","display_name":"Statistic","score":0.5248679518699646},{"id":"https://openalex.org/keywords/exponential-function","display_name":"Exponential function","score":0.5085347890853882},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.4965680241584778},{"id":"https://openalex.org/keywords/exponential-growth","display_name":"Exponential growth","score":0.48104599118232727},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.4411112666130066},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4384475350379944},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3884166181087494},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3808448612689972},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.32596439123153687},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.1441158950328827},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.1188618540763855}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7047488689422607},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.6795312166213989},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.6347095966339111},{"id":"https://openalex.org/C89128539","wikidata":"https://www.wikidata.org/wiki/Q1949963","display_name":"Statistic","level":2,"score":0.5248679518699646},{"id":"https://openalex.org/C151376022","wikidata":"https://www.wikidata.org/wiki/Q168698","display_name":"Exponential function","level":2,"score":0.5085347890853882},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.4965680241584778},{"id":"https://openalex.org/C75235859","wikidata":"https://www.wikidata.org/wiki/Q582659","display_name":"Exponential growth","level":2,"score":0.48104599118232727},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.4411112666130066},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4384475350379944},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3884166181087494},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3808448612689972},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.32596439123153687},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.1441158950328827},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.1188618540763855},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1007/3-540-58907-4_21","is_oa":false,"landing_page_url":"https://doi.org/10.1007/3-540-58907-4_21","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.7.2530","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.7.2530","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.informatik.tu-cottbus.de/~thalheim/icdt95-3.ps.gz","raw_type":"text"},{"id":"pmh:oai:eprints.sztaki.hu:868","is_oa":false,"landing_page_url":"http://eprints.sztaki.hu/868/","pdf_url":null,"source":{"id":"https://openalex.org/S4306401907","display_name":"SZTAKI Publication Repository (Hungarian Academy of Sciences)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I7597260","host_organization_name":"Hungarian Academy of Sciences","host_organization_lineage":["https://openalex.org/I7597260"],"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 or Workshop Item"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W105112013","https://openalex.org/W105854904","https://openalex.org/W587269134","https://openalex.org/W1503306447","https://openalex.org/W1526843800","https://openalex.org/W1562478345","https://openalex.org/W1623080549","https://openalex.org/W1909639835","https://openalex.org/W1976130757","https://openalex.org/W2002761806","https://openalex.org/W2016687162","https://openalex.org/W2045390532","https://openalex.org/W2079445843","https://openalex.org/W2098102356","https://openalex.org/W2132565565","https://openalex.org/W2165467455","https://openalex.org/W2275773297","https://openalex.org/W2288285317","https://openalex.org/W2751862591","https://openalex.org/W4243896617","https://openalex.org/W4301441647","https://openalex.org/W4302433310","https://openalex.org/W4400445037"],"related_works":["https://openalex.org/W1602624896","https://openalex.org/W1634993130","https://openalex.org/W1519862060","https://openalex.org/W2084061773","https://openalex.org/W2104564563","https://openalex.org/W32300376","https://openalex.org/W2794917831","https://openalex.org/W2013108996","https://openalex.org/W3023224836","https://openalex.org/W1970091080"],"abstract_inverted_index":null,"counts_by_year":[{"year":2012,"cited_by_count":1}],"updated_date":"2026-08-05T07:39:15.569665","created_date":"2025-10-10T00:00:00"}