{"id":"https://openalex.org/W1568903045","doi":"https://doi.org/10.1007/978-3-642-04947-7_9","title":"First-Order Types and Redundant Relations in Relational Databases","display_name":"First-Order Types and Redundant Relations in Relational Databases","publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W1568903045","doi":"https://doi.org/10.1007/978-3-642-04947-7_9","mag":"1568903045"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-642-04947-7_9","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-642-04947-7_9","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/I10457146","display_name":"Universidad de Santiago de Chile","ror":"https://ror.org/02ma57s91","country_code":"CL","type":"education","lineage":["https://openalex.org/I10457146"]}],"countries":["CL"],"is_corresponding":true,"raw_author_name":"Flavio A. Ferrarotti","raw_affiliation_strings":["Departamento de Ingenier\u00eda Inform\u00e1tica, Facultad de Ingenier\u00eda, Universidad de Santiago de Chile,","Yahoo! Research Latin America, Santiago, Chile","Yahoo! Research Latin America, Santiago, Chile and Departamento de Ingenier\u00eda Inform\u00e1tica, Facultad de Ingenier\u00eda, Universidad de Santiago de Chile,"],"affiliations":[{"raw_affiliation_string":"Departamento de Ingenier\u00eda Inform\u00e1tica, Facultad de Ingenier\u00eda, Universidad de Santiago de Chile,","institution_ids":["https://openalex.org/I10457146"]},{"raw_affiliation_string":"Yahoo! Research Latin America, Santiago, Chile","institution_ids":[]},{"raw_affiliation_string":"Yahoo! Research Latin America, Santiago, Chile and Departamento de Ingenier\u00eda Inform\u00e1tica, Facultad de Ingenier\u00eda, Universidad de Santiago de Chile,","institution_ids":["https://openalex.org/I10457146"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068783589","display_name":"Alejandra Lorena Paoletti","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Alejandra L. Paoletti","raw_affiliation_strings":["Yahoo! Research Latin America, Santiago, Chile","Yahoo! Research Latin-America, Santiago, Chile"],"affiliations":[{"raw_affiliation_string":"Yahoo! Research Latin America, Santiago, Chile","institution_ids":[]},{"raw_affiliation_string":"Yahoo! Research Latin-America, Santiago, Chile","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5108684942","display_name":"Jos\u00e9 Mar\u00eda Turull Torres","orcid":null},"institutions":[{"id":"https://openalex.org/I51158804","display_name":"Massey University","ror":"https://ror.org/052czxv31","country_code":"NZ","type":"education","lineage":["https://openalex.org/I51158804"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 M. Turull Torres","raw_affiliation_strings":["School of Engineering and Advanced Technology, College of Sciences, Massey University, Wellington, New Zealand"],"affiliations":[{"raw_affiliation_string":"School of Engineering and Advanced Technology, College of Sciences, Massey University, Wellington, New Zealand","institution_ids":["https://openalex.org/I51158804"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5035972346"],"corresponding_institution_ids":["https://openalex.org/I10457146"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":0.5015,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.65914605,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"65","last_page":"74"},"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.9994000196456909,"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.9994000196456909,"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.9990000128746033,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9902999997138977,"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.8366556167602539},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7105137705802917},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5989851951599121},{"id":"https://openalex.org/keywords/order","display_name":"Order (exchange)","score":0.4862459897994995},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.44395023584365845},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4120176136493683},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3442845344543457}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8366556167602539},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7105137705802917},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5989851951599121},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.4862459897994995},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.44395023584365845},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4120176136493683},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3442845344543457},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-3-642-04947-7_9","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-642-04947-7_9","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"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W126976627","https://openalex.org/W149380172","https://openalex.org/W1482193060","https://openalex.org/W1501904253","https://openalex.org/W1580836907","https://openalex.org/W2002748825","https://openalex.org/W2033233376","https://openalex.org/W2051748083","https://openalex.org/W2059148270","https://openalex.org/W2097212968","https://openalex.org/W2111302825","https://openalex.org/W2112957043","https://openalex.org/W2147543331","https://openalex.org/W2155130690","https://openalex.org/W2161609549","https://openalex.org/W3023880007"],"related_works":["https://openalex.org/W2280934013","https://openalex.org/W1986599757","https://openalex.org/W2093148164","https://openalex.org/W2027048017","https://openalex.org/W3211141956","https://openalex.org/W2355364777","https://openalex.org/W4281562483","https://openalex.org/W2375701581","https://openalex.org/W2044272255","https://openalex.org/W3003553552"],"abstract_inverted_index":null,"counts_by_year":[{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}