{"id":"https://openalex.org/W3011885850","doi":"https://doi.org/10.1007/978-1-4842-5663-3_8","title":"Basic Errors and Handy Queries","display_name":"Basic Errors and Handy Queries","alternate_titles":[],"publication_year":2020,"publication_date":"2020-03-16","ids":{"openalex":"https://openalex.org/W3011885850","doi":"https://doi.org/10.1007/978-1-4842-5663-3_8","mag":"3011885850"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4842-5663-3_8","doi":"https://doi.org/10.1007/978-1-4842-5663-3_8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4842-5663-3_8","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"PostgreSQL Configuration","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W4246149243","display_name":"PostgreSQL Configuration: Best Practices for Performance and Security","relationship":"volume"}],"lineage":["https://openalex.org/W3011885850","https://openalex.org/W4246149243"],"child_works_count":0,"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/A5055636763","display_name":"Baji Shaik","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Baji Shaik","raw_affiliation_strings":["Hyderabad, Andhra Pradesh, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hyderabad, Andhra Pradesh, India","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5055636763"],"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":"173","last_page":"217"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9437999725341797,"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.9437999725341797,"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.011099999770522118,"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.008500000461935997,"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/postgresql","display_name":"PostgreSQL","score":0.996999979019165},{"id":"https://openalex.org/keywords/high-availability","display_name":"high availability","score":0.8119999766349792},{"id":"https://openalex.org/keywords/connection-pooling","display_name":"connection pooling","score":0.878000020980835},{"id":"https://openalex.org/keywords/database-administration","display_name":"database administration","score":0.6060000061988831},{"id":"https://openalex.org/keywords/common-mistakes","display_name":"common errors","score":0.6399999856948853},{"id":"https://openalex.org/keywords/database-queries","display_name":"database queries","score":0.4519999921321869}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6814709305763245},{"id":"https://openalex.org/C2779304628","wikidata":"https://www.wikidata.org/wiki/Q3503480","display_name":"Face (sociological concept)","level":2,"score":0.5778278112411499},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5241296887397766},{"id":"https://openalex.org/C13355873","wikidata":"https://www.wikidata.org/wiki/Q2920850","display_name":"Connection (principal bundle)","level":2,"score":0.47730955481529236},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4563801884651184},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.4368329644203186},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1919989287853241},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14364942908287048},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.094737708568573},{"id":"https://openalex.org/C36289849","wikidata":"https://www.wikidata.org/wiki/Q34749","display_name":"Social science","level":1,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4842-5663-3_8","doi":"https://doi.org/10.1007/978-1-4842-5663-3_8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4842-5663-3_8","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"PostgreSQL Configuration","raw_type":"book-chapter"}],"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/W3011566132","https://openalex.org/W7033375258","https://openalex.org/W2248550145","https://openalex.org/W7164244348","https://openalex.org/W197079117","https://openalex.org/W7062404768","https://openalex.org/W7137458603","https://openalex.org/W6986447037","https://openalex.org/W7051836049","https://openalex.org/W2534978811"],"abstract_inverted_index":{"In":[0,74],"the":[1,15,34,40,49,66],"last":[2],"chapter,":[3,76],"we":[4,8,77,86,89],"talked":[5,38],"about":[6,39,82],"why":[7],"need":[9],"High":[10,23],"Availability,":[11],"and":[12,29,51,94],"what":[13],"are":[14,78,99],"different":[16],"kinds":[17],"of":[18,42],"procedures":[19],"available":[20,32,46],"to":[21,53,65,80],"implement":[22,54],"Availability":[24],"using":[25],"some":[26,95],"open":[27],"source":[28],"enterprise":[30],"tools":[31],"in":[33,48],"market.":[35],"We":[36],"also":[37],"importance":[41],"a":[43,55,103],"connection":[44],"pooler,":[45],"poolers":[47],"market,":[50],"how":[52],"pooler":[56],"with":[57,72,92],"PostgreSQL":[58],"instances.":[59],"This":[60],"chapter":[61],"is":[62],"basically":[63],"targeted":[64],"users":[67],"who":[68],"just":[69],"started":[70],"working":[71,91],"PostgreSQL.":[73],"this":[75],"going":[79],"talk":[81],"basic":[83],"errors":[84],"that":[85,98],"face":[87],"when":[88],"start":[90],"PostgreSQL,":[93],"handy":[96],"queries":[97],"useful":[100],"day-to-day":[101],"for":[102],"database":[104],"administrator.":[105]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3011885850","counts_by_year":[],"updated_date":"2026-11-15T12:55:33.944570","created_date":"2020-03-23T00:00:00"}
