{"id":"https://openalex.org/W4237795462","doi":"https://doi.org/10.1002/9780470050118.ecse350","title":"Relational Databases","display_name":"Relational Databases","publication_year":2007,"publication_date":"2007-12-06","ids":{"openalex":"https://openalex.org/W4237795462","doi":"https://doi.org/10.1002/9780470050118.ecse350"},"language":"en","primary_location":{"id":"doi:10.1002/9780470050118.ecse350","is_oa":false,"landing_page_url":"https://doi.org/10.1002/9780470050118.ecse350","pdf_url":null,"source":{"id":"https://openalex.org/S4306534807","display_name":"Wiley Encyclopedia of Computer Science and Engineering","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Wiley Encyclopedia of Computer Science and Engineering","raw_type":"other"},"type":"preprint","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/A5050019723","display_name":"Dominique Laurent","orcid":"https://orcid.org/0000-0002-7264-9576"},"institutions":[{"id":"https://openalex.org/I4210148552","display_name":"Equipes Traitement de l'Information et Syst\u00e8mes","ror":"https://ror.org/0592ata02","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I4210142324","https://openalex.org/I4210148552","https://openalex.org/I4210159245","https://openalex.org/I86175216"]},{"id":"https://openalex.org/I4210142324","display_name":"CY Cergy Paris Universit\u00e9","ror":"https://ror.org/043htjv09","country_code":"FR","type":"education","lineage":["https://openalex.org/I4210142324"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Dominique Laurent","raw_affiliation_strings":["University of Cergy-Pontoise, Cergy-Pontoise, France"],"affiliations":[{"raw_affiliation_string":"University of Cergy-Pontoise, Cergy-Pontoise, France","institution_ids":["https://openalex.org/I4210148552","https://openalex.org/I4210142324"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5050019723"],"corresponding_institution_ids":["https://openalex.org/I4210142324","https://openalex.org/I4210148552"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9919000267982483,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9842000007629395,"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.8322483897209167},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7394628524780273},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.7207192778587341},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7053223848342896},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.7019852995872498},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.599493145942688},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.5250158905982971},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.48872923851013184},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.45662957429885864},{"id":"https://openalex.org/keywords/property","display_name":"Property (philosophy)","score":0.45164793729782104},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.37922728061676025},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3445696532726288},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.19590291380882263}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8322483897209167},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7394628524780273},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.7207192778587341},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7053223848342896},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.7019852995872498},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.599493145942688},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5250158905982971},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.48872923851013184},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.45662957429885864},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.45164793729782104},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37922728061676025},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3445696532726288},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.19590291380882263},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1002/9780470050118.ecse350","is_oa":false,"landing_page_url":"https://doi.org/10.1002/9780470050118.ecse350","pdf_url":null,"source":{"id":"https://openalex.org/S4306534807","display_name":"Wiley Encyclopedia of Computer Science and Engineering","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Wiley Encyclopedia of Computer Science and Engineering","raw_type":"other"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.671.9288","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.671.9288","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://depinfo.u-cergy.fr/%7Edlaurent/ressources/publi/RELATIONAL+DATABASES.pdf","raw_type":"text"},{"id":"pmh:oai:HAL:hal-00523647v1","is_oa":false,"landing_page_url":"https://hal.science/hal-00523647","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Bejamin W. Wah. Wiley Encyclopedia of Computer Science and Engineering, John Wiley & Sons, Inc., 2008, ⟨10.1002/9780470050118.ecse350⟩","raw_type":"Book sections"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W180578187","https://openalex.org/W259338706","https://openalex.org/W657835803","https://openalex.org/W1493938990","https://openalex.org/W1496148388","https://openalex.org/W1509428113","https://openalex.org/W1512840853","https://openalex.org/W1535627680","https://openalex.org/W1545155892","https://openalex.org/W1569403765","https://openalex.org/W1581128883","https://openalex.org/W2132750992","https://openalex.org/W2162621793","https://openalex.org/W2173934156","https://openalex.org/W2185907055","https://openalex.org/W2753439427","https://openalex.org/W4206031975","https://openalex.org/W4206370914"],"related_works":["https://openalex.org/W4297044271","https://openalex.org/W2483382562","https://openalex.org/W2007556552","https://openalex.org/W4248533530","https://openalex.org/W2356642811","https://openalex.org/W2403346309","https://openalex.org/W296732031","https://openalex.org/W2040840314","https://openalex.org/W2606498729","https://openalex.org/W214590834"],"abstract_inverted_index":{"Abstract":[0],"Database":[1],"management":[2],"systems":[3,218],"(DBMSs)":[4],"aim":[5],"to":[6,117,126,178,205],"provide":[7],"users":[8,97],"with":[9,228],"an":[10],"efficient":[11,20],"tool":[12],"for":[13,17,141],"good":[14],"modeling":[15],"and":[16,19,32,73,111,146,193,207,210,219],"easy":[18],"manipulation":[21,139],"of":[22,44,77,83,90,105,153,173,189,197,216,234],"data.":[23],"The":[24,56,103],"first":[25],"DBMSs":[26],"were":[27],"based":[28,119],"on":[29,120,131,186,194,232],"a":[30,88,106,114,132,136,163,171,229],"hierarchical":[31,121],"then":[33],"network\u2010like":[34],"conceptual":[35,75],"data":[36,78,100,128,138],"organization,":[37],"which":[38,127],"actually":[39],"reflects":[40],"the":[41,45,71,74,84,91,99,151,157,167,187,190,214,220,235],"physical":[42,72],"organization":[43],"underlying":[46],"files.":[47],"These":[48],"systems,":[49],"although":[50],"efficient,":[51],"have":[52],"some":[53],"important":[54],"drawbacks.":[55],"relational":[57,85,107,142,168,191,217,236],"model,":[58,96],"proposed":[59],"by":[60,67],"Codd":[61],"in":[62,94],"1970,":[63],"avoids":[64],"these":[65],"drawbacks":[66],"distinguishing":[68],"explicitly":[69],"between":[70],"levels":[76],"organization.":[79],"This":[80],"basic":[81,195],"property":[82],"model":[86,169,192],"is":[87],"consequence":[89],"fact":[92],"that,":[93],"this":[95,182],"see":[98],"as":[101,113],"tables.":[102],"tables":[104],"database":[108],"are":[109,129,144,162],"accessed":[110],"manipulated":[112,130],"whole,":[115],"contrary":[116],"languages":[118,140],"or":[122],"network":[123],"models,":[124],"according":[125],"record\u2010by\u2010record":[133],"basis.":[134],"As":[135],"consequence,":[137],"databases":[143],"set\u2010oriented,":[145],"so,":[147],"they":[148],"fall":[149],"into":[150],"category":[152],"declarative":[154],"languages.":[155],"On":[156],"other":[158],"hand,":[159],"because":[160],"relations":[161],"well\u2010known":[164],"mathematical":[165],"concept,":[166],"stimulated":[170],"lot":[172],"theoretical":[174],"research":[175],"that":[176],"led":[177],"successful":[179],"implementations.":[180],"In":[181],"article,":[183],"we":[184,201,211],"focus":[185],"theory":[188],"aspects":[196],"dependency":[198],"theory.":[199],"Then,":[200],"address":[202],"problems":[203],"related":[204],"updates":[206],"transaction":[208],"management,":[209],"briefly":[212],"describe":[213],"structure":[215],"associated":[221],"reference":[222],"language":[223],"called":[224],"SQL.":[225],"We":[226],"conclude":[227],"brief":[230],"discussion":[231],"extensions":[233],"model.":[237]},"counts_by_year":[],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}