{"id":"https://openalex.org/W4232187080","doi":"https://doi.org/10.1002/9781119418504.ch13","title":"Databases","display_name":"Databases","publication_year":2018,"publication_date":"2018-04-14","ids":{"openalex":"https://openalex.org/W4232187080","doi":"https://doi.org/10.1002/9781119418504.ch13"},"language":"en","primary_location":{"id":"doi:10.1002/9781119418504.ch13","doi":"https://doi.org/10.1002/9781119418504.ch13","is_oa":false,"landing_page_url":"https://doi.org/10.1002/9781119418504.ch13","pdf_url":null,"source":{"id":"https://openalex.org/S4306464293","display_name":"Wiley eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Programming Interviews Exposed","raw_type":"other"},"volume":{"id":"https://openalex.org/W2303280499","display_name":"Programming Interviews Exposed"},"type":"book-chapter","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/A5110128617","display_name":"John Mongan","orcid":"https://orcid.org/0000-0003-2765-7451","observed_orcids":["https://orcid.org/0000-0003-2765-7451"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"John Mongan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069985790","display_name":"Noah Kindler","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Noah Kindler","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5083206227","display_name":"Eric Gigu\u00e8re","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Eric Gigu\u00e8re","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"203","last_page":"222"},"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.9980000257492065,"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.9980000257492065,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.000699999975040555,"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/T13681","display_name":"Engineering and Information Technology","score":0.0005000000237487257,"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/databases","display_name":"databases","score":0.9039999842643738},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.5569999814033508},{"id":"https://openalex.org/keywords/structured-query-language","display_name":"structured query language","score":0.8080000281333923},{"id":"https://openalex.org/keywords/object-oriented-databases","display_name":"object-oriented databases","score":0.8130000233650208},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.996999979019165},{"id":"https://openalex.org/keywords/transactions","display_name":"transactions","score":0.8240000009536743},{"id":"https://openalex.org/keywords/foreign-key-constraints","display_name":"foreign key constraints","score":0.9559999704360962},{"id":"https://openalex.org/keywords/data-consistency","display_name":"data consistency","score":0.7590000033378601},{"id":"https://openalex.org/keywords/nosql-databases","display_name":"NoSQL databases","score":0.9179999828338623},{"id":"https://openalex.org/keywords/distributed-databases","display_name":"distributed databases","score":0.8519999980926514},{"id":"https://openalex.org/keywords/cap-theorem","display_name":"CAP theorem","score":0.878000020980835},{"id":"https://openalex.org/keywords/web-application","display_name":"web application","score":0.5249999761581421}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7926372289657593},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7371365427970886},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.6526598334312439},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.6003848910331726},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5969302654266357},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5851976871490479},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5427572727203369},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5059995055198669},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.4975772202014923},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.4613513946533203},{"id":"https://openalex.org/C72615636","wikidata":"https://www.wikidata.org/wiki/Q58748","display_name":"Object-relational mapping","level":4,"score":0.4572443962097168},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.42094266414642334},{"id":"https://openalex.org/C2778514511","wikidata":"https://www.wikidata.org/wiki/Q1374194","display_name":"Programmer","level":2,"score":0.4148745536804199},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4116729497909546},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.4100992977619171},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.37351179122924805},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2618832290172577},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/9781119418504.ch13","doi":"https://doi.org/10.1002/9781119418504.ch13","is_oa":false,"landing_page_url":"https://doi.org/10.1002/9781119418504.ch13","pdf_url":null,"source":{"id":"https://openalex.org/S4306464293","display_name":"Wiley eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Programming Interviews Exposed","raw_type":"other"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4403747863","https://openalex.org/W1999170075","https://openalex.org/W4238769149","https://openalex.org/W3155576803","https://openalex.org/W2913945490","https://openalex.org/W6892741996","https://openalex.org/W4241695819","https://openalex.org/W7097926396","https://openalex.org/W2955212038","https://openalex.org/W7098293813"],"abstract_inverted_index":{"Tools":[0],"are":[1,22,81],"available":[2],"to":[3,35,88],"help":[4],"the":[5,15,18,42,83,113,130],"programmer":[6],"create":[7],"and":[8,37,77,93,104,136],"manage":[9],"databases,":[10],"many":[11],"of":[12,17,26,44,68,102,112,129],"which":[13],"hide":[14],"complexities":[16],"data":[19,57],"structures.":[20],"Databases":[21],"common":[23,33],"building":[24],"blocks":[25],"applications,":[27],"especially":[28],"web-based":[29],"applications.":[30],"The":[31,107,119],"most":[32],"way":[34],"manipulate":[36],"query":[38],"databases":[39,86],"is":[40,52,110],"through":[41],"use":[43],"Structured":[45],"Query":[46],"Language":[47],"(SQL).":[48],"An":[49],"object":[50,60],"database":[51,54,117,124],"a":[53,73,123],"that":[55,85,122],"stores":[56],"in":[58,64,69,72],"an":[59],"model":[61],"as":[62,71,99],"used":[63],"object-oriented":[65],"programming,":[66],"instead":[67],"tables":[70],"relational":[74],"database.":[75],"Transactions":[76],"foreign":[78],"key":[79],"constraints":[80],"among":[82],"mechanisms":[84],"provide":[87],"maintain":[89],"consistency.":[90],"NoSQL":[91],"concepts":[92],"questions":[94],"also":[95],"come":[96],"up":[97],"occasionally,":[98],"do":[100],"properties":[101],"transactions":[103],"distributed":[105,115],"databases.":[106],"CAP":[108],"theorem":[109,120],"one":[111],"core":[114],"network":[116],"concepts.":[118],"states":[121],"can":[125],"only":[126],"possess":[127],"two":[128],"following":[131],"three":[132],"properties:":[133],"consistency,":[134],"accessibility":[135],"partitionability.":[137]},"counts_by_year":[],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2022-05-12T00:00:00"}