PostgreSQL for data architects :: discover how to design, develop, and maintain your database application effectively with PostgreSQL /
Annotation
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, UK :
Packt Publishing,
2015.
|
| Schriftenreihe: | Community experience distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Annotation |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (1 volume) : illustrations |
| ISBN: | 9781783288618 1783288612 |
Internformat
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn908199866 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 150430s2015 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d COO |d DEBBG |d YDXCP |d C6I |d OCLCF |d N$T |d TEFOD |d CEF |d NLE |d UKMGB |d UAB |d AU@ |d UKAHL |d VLY |d OCLCO |d INARC |d OCLCQ |d QGK |d OCLCO |d OCLCL | ||
| 015 | |a GBB6G3026 |2 bnb | ||
| 016 | 7 | |a 018006617 |2 Uk | |
| 019 | |a 1259212966 | ||
| 020 | |a 9781783288618 |q (electronic bk.) | ||
| 020 | |a 1783288612 |q (electronic bk.) | ||
| 020 | |z 1783288604 | ||
| 020 | |z 9781783288601 | ||
| 035 | |a (OCoLC)908199866 |z (OCoLC)1259212966 | ||
| 037 | |a CL0500000580 |b Safari Books Online | ||
| 037 | |a 3A7920C5-A029-4102-A3C3-5382CAE26DF1 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.D3 | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 082 | 7 | |a 005.7565 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Maymala, Jayadevan, |e author. | |
| 245 | 1 | 0 | |a PostgreSQL for data architects : |b discover how to design, develop, and maintain your database application effectively with PostgreSQL / |c Jayadevan Maymala. |
| 246 | 3 | 0 | |a Discover how to design, develop, and maintain your database application effectively with PostgreSQL |
| 246 | 3 | |a Postgre Structured Query Language for data architects | |
| 264 | 1 | |a Birmingham, UK : |b Packt Publishing, |c 2015. | |
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 490 | 1 | |a Community experience disitlled | |
| 588 | 0 | |a Online resource; title from cover (Safari, viewed April 16, 2015). | |
| 500 | |a Includes index. | ||
| 520 | 8 | |a Annotation |b This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security. | |
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing PostgreSQL; Installation options; Downloading and extracting the source; Inspecting the contents; Dependencies to compile the source; Configuring and creating the makefile; Building and creating the executables; Installing and moving the files to where they belong; Inspecting the changes; Initializing a cluster; A quick walk through the directories; Processes created; Important files created; Working with extensions; Summary; Chapter 2: Server Architecture | |
| 505 | 8 | |a Starting with the daemon processUnderstanding the shared buffer; Inspecting the buffer cache; Checkpoint; WAL and the WAL writer process; Recovery; Incremental backup and point-in-time recovery; Replication; The background writer; The autovacuum launcher process; The logging process; The stats collector process; The WAL sender and WAL receiver; Sorting in memory with work_mem; Maintenance with maintenance_work_mem; Understanding effective_cache_size; Summary; Chapter 3: PostgreSQL -- Object Hierarchy and Roles; The PostgreSQL cluster; Understanding tablespaces | |
| 505 | 8 | |a Managing temporary objects with temporary tablespacesViews; Databases, schemas, and search_path; Schemas -- use cases; Roles and privileges; Summary; Chapter 4: Working with Transactions; Understanding transactions; ACID properties of transactions; A for atomicity; C for consistency; I for isolation; D for durability; PostgreSQL and MVCC; Summary; Chapter 5: Data Modeling with SQL Power Architect; Tools for databases and their uses; Database design tools; SQL Power Architect -- downloading and installing; Creating tables; Generating SQL; Reverse engineering and making changes | |
| 505 | 8 | |a Exporting the data modelProfiling; Summary; Chapter 6: Client Tools; GUI tools and command-line tools; pgAdmin -- downloading and installation; Adding a server; The pgAdmin main window; The Query tool; psql -- working from the command line; psql -- connection options; The power of \d; More meta-commands; Setting up the environment; History of commands; Summary; Chapter 7: SQL Tuning; Understanding basic facts about databases; Fact 1 -- databases are more frequently read from than written to; Fact 2 -- data is always read in blocks or pages, not as individual records or columns | |
| 505 | 8 | |a Approaches to reducing the number of blocks read/writtenQuery execution components; Planner; Access methods; Join strategies; Finding the execution plan; Optimization guidelines and catches; Indexing foreign keys; Using SELECT *; Using ORDER BY; Using DISTINCT; Using UNION ALL instead of UNION; Using functions in the FILTER clause; Reducing the number of SQL statements; Reducing function executions; Not using indexes; Partial indexes; Optimizing functions; Summary; Chapter 8: Server Tuning; Server-wide memory settings; shared_buffers; effective_cache_size | |
| 546 | |a English. | ||
| 630 | 0 | 0 | |a PostgreSQL. |0 http://id.loc.gov/authorities/names/n00067354 |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a Database design. |0 http://id.loc.gov/authorities/subjects/sh88004472 | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Bases de données |x Conception. | |
| 650 | 7 | |a COMPUTERS |x Database Management |x General. |2 bisacsh | |
| 650 | 7 | |a Database design |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 758 | |i has work: |a PostgreSQL for Data Architects (Text) |1 https://id.oclc.org/worldcat/entity/E39PCXm8797Fwq4dTF4jgcjm7d |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Maymala, Jayadevan. |t PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with postgreSQL. |d Birmingham, England ; Mumbai, [India] : Packt Publishing, ©2015 |h x, 247 pages |k Community experience distilled. |z 9781783288601 |
| 830 | 0 | |a Community experience distilled. | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=972843 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH28491065 | ||
| 938 | |a EBSCOhost |b EBSC |n 972843 | ||
| 938 | |a Internet Archive |b INAR |n postgresqlfordat0000maym | ||
| 938 | |a YBP Library Services |b YANK |n 12362355 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn908199866 |
|---|---|
| _version_ | 1816882311370637312 |
| adam_text | |
| any_adam_object | |
| author | Maymala, Jayadevan |
| author_facet | Maymala, Jayadevan |
| author_role | aut |
| author_sort | Maymala, Jayadevan |
| author_variant | j m jm |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 |
| callnumber-search | QA76.9.D3 |
| callnumber-sort | QA 276.9 D3 |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing PostgreSQL; Installation options; Downloading and extracting the source; Inspecting the contents; Dependencies to compile the source; Configuring and creating the makefile; Building and creating the executables; Installing and moving the files to where they belong; Inspecting the changes; Initializing a cluster; A quick walk through the directories; Processes created; Important files created; Working with extensions; Summary; Chapter 2: Server Architecture Starting with the daemon processUnderstanding the shared buffer; Inspecting the buffer cache; Checkpoint; WAL and the WAL writer process; Recovery; Incremental backup and point-in-time recovery; Replication; The background writer; The autovacuum launcher process; The logging process; The stats collector process; The WAL sender and WAL receiver; Sorting in memory with work_mem; Maintenance with maintenance_work_mem; Understanding effective_cache_size; Summary; Chapter 3: PostgreSQL -- Object Hierarchy and Roles; The PostgreSQL cluster; Understanding tablespaces Managing temporary objects with temporary tablespacesViews; Databases, schemas, and search_path; Schemas -- use cases; Roles and privileges; Summary; Chapter 4: Working with Transactions; Understanding transactions; ACID properties of transactions; A for atomicity; C for consistency; I for isolation; D for durability; PostgreSQL and MVCC; Summary; Chapter 5: Data Modeling with SQL Power Architect; Tools for databases and their uses; Database design tools; SQL Power Architect -- downloading and installing; Creating tables; Generating SQL; Reverse engineering and making changes Exporting the data modelProfiling; Summary; Chapter 6: Client Tools; GUI tools and command-line tools; pgAdmin -- downloading and installation; Adding a server; The pgAdmin main window; The Query tool; psql -- working from the command line; psql -- connection options; The power of \d; More meta-commands; Setting up the environment; History of commands; Summary; Chapter 7: SQL Tuning; Understanding basic facts about databases; Fact 1 -- databases are more frequently read from than written to; Fact 2 -- data is always read in blocks or pages, not as individual records or columns Approaches to reducing the number of blocks read/writtenQuery execution components; Planner; Access methods; Join strategies; Finding the execution plan; Optimization guidelines and catches; Indexing foreign keys; Using SELECT *; Using ORDER BY; Using DISTINCT; Using UNION ALL instead of UNION; Using functions in the FILTER clause; Reducing the number of SQL statements; Reducing function executions; Not using indexes; Partial indexes; Optimizing functions; Summary; Chapter 8: Server Tuning; Server-wide memory settings; shared_buffers; effective_cache_size |
| ctrlnum | (OCoLC)908199866 |
| dewey-full | 005.7565 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7565 |
| dewey-search | 005.7565 |
| dewey-sort | 15.7565 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06399cam a2200733 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn908199866</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr unu||||||||</controlfield><controlfield tag="008">150430s2015 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">UMI</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">UMI</subfield><subfield code="d">COO</subfield><subfield code="d">DEBBG</subfield><subfield code="d">YDXCP</subfield><subfield code="d">C6I</subfield><subfield code="d">OCLCF</subfield><subfield code="d">N$T</subfield><subfield code="d">TEFOD</subfield><subfield code="d">CEF</subfield><subfield code="d">NLE</subfield><subfield code="d">UKMGB</subfield><subfield code="d">UAB</subfield><subfield code="d">AU@</subfield><subfield code="d">UKAHL</subfield><subfield code="d">VLY</subfield><subfield code="d">OCLCO</subfield><subfield code="d">INARC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">QGK</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB6G3026</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018006617</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">1259212966</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781783288618</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1783288612</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1783288604</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781783288601</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)908199866</subfield><subfield code="z">(OCoLC)1259212966</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000580</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">3A7920C5-A029-4102-A3C3-5382CAE26DF1</subfield><subfield code="b">OverDrive, Inc.</subfield><subfield code="n">http://www.overdrive.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.7565</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Maymala, Jayadevan,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">PostgreSQL for data architects :</subfield><subfield code="b">discover how to design, develop, and maintain your database application effectively with PostgreSQL /</subfield><subfield code="c">Jayadevan Maymala.</subfield></datafield><datafield tag="246" ind1="3" ind2="0"><subfield code="a">Discover how to design, develop, and maintain your database application effectively with PostgreSQL</subfield></datafield><datafield tag="246" ind1="3" ind2=" "><subfield code="a">Postgre Structured Query Language for data architects</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham, UK :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2015.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1 volume) :</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Community experience disitlled</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resource; title from cover (Safari, viewed April 16, 2015).</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="520" ind1="8" ind2=" "><subfield code="a">Annotation</subfield><subfield code="b">This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing PostgreSQL; Installation options; Downloading and extracting the source; Inspecting the contents; Dependencies to compile the source; Configuring and creating the makefile; Building and creating the executables; Installing and moving the files to where they belong; Inspecting the changes; Initializing a cluster; A quick walk through the directories; Processes created; Important files created; Working with extensions; Summary; Chapter 2: Server Architecture</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Starting with the daemon processUnderstanding the shared buffer; Inspecting the buffer cache; Checkpoint; WAL and the WAL writer process; Recovery; Incremental backup and point-in-time recovery; Replication; The background writer; The autovacuum launcher process; The logging process; The stats collector process; The WAL sender and WAL receiver; Sorting in memory with work_mem; Maintenance with maintenance_work_mem; Understanding effective_cache_size; Summary; Chapter 3: PostgreSQL -- Object Hierarchy and Roles; The PostgreSQL cluster; Understanding tablespaces</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Managing temporary objects with temporary tablespacesViews; Databases, schemas, and search_path; Schemas -- use cases; Roles and privileges; Summary; Chapter 4: Working with Transactions; Understanding transactions; ACID properties of transactions; A for atomicity; C for consistency; I for isolation; D for durability; PostgreSQL and MVCC; Summary; Chapter 5: Data Modeling with SQL Power Architect; Tools for databases and their uses; Database design tools; SQL Power Architect -- downloading and installing; Creating tables; Generating SQL; Reverse engineering and making changes</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Exporting the data modelProfiling; Summary; Chapter 6: Client Tools; GUI tools and command-line tools; pgAdmin -- downloading and installation; Adding a server; The pgAdmin main window; The Query tool; psql -- working from the command line; psql -- connection options; The power of \d; More meta-commands; Setting up the environment; History of commands; Summary; Chapter 7: SQL Tuning; Understanding basic facts about databases; Fact 1 -- databases are more frequently read from than written to; Fact 2 -- data is always read in blocks or pages, not as individual records or columns</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Approaches to reducing the number of blocks read/writtenQuery execution components; Planner; Access methods; Join strategies; Finding the execution plan; Optimization guidelines and catches; Indexing foreign keys; Using SELECT *; Using ORDER BY; Using DISTINCT; Using UNION ALL instead of UNION; Using functions in the FILTER clause; Reducing the number of SQL statements; Reducing function executions; Not using indexes; Partial indexes; Optimizing functions; Summary; Chapter 8: Server Tuning; Server-wide memory settings; shared_buffers; effective_cache_size</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">PostgreSQL.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n00067354</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">PostgreSQL</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database design.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh88004472</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Conception.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Database Management</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database design</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">PostgreSQL for Data Architects (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCXm8797Fwq4dTF4jgcjm7d</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Maymala, Jayadevan.</subfield><subfield code="t">PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with postgreSQL.</subfield><subfield code="d">Birmingham, England ; Mumbai, [India] : Packt Publishing, ©2015</subfield><subfield code="h">x, 247 pages</subfield><subfield code="k">Community experience distilled.</subfield><subfield code="z">9781783288601</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Community experience distilled.</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=972843</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH28491065</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">972843</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Internet Archive</subfield><subfield code="b">INAR</subfield><subfield code="n">postgresqlfordat0000maym</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">12362355</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn908199866 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:26:36Z |
| institution | BVB |
| isbn | 9781783288618 1783288612 |
| language | English |
| oclc_num | 908199866 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (1 volume) : illustrations |
| psigel | ZDB-4-EBA |
| publishDate | 2015 |
| publishDateSearch | 2015 |
| publishDateSort | 2015 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Community experience distilled. |
| series2 | Community experience disitlled |
| spelling | Maymala, Jayadevan, author. PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL / Jayadevan Maymala. Discover how to design, develop, and maintain your database application effectively with PostgreSQL Postgre Structured Query Language for data architects Birmingham, UK : Packt Publishing, 2015. 1 online resource (1 volume) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier text file Community experience disitlled Online resource; title from cover (Safari, viewed April 16, 2015). Includes index. Annotation This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security. Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing PostgreSQL; Installation options; Downloading and extracting the source; Inspecting the contents; Dependencies to compile the source; Configuring and creating the makefile; Building and creating the executables; Installing and moving the files to where they belong; Inspecting the changes; Initializing a cluster; A quick walk through the directories; Processes created; Important files created; Working with extensions; Summary; Chapter 2: Server Architecture Starting with the daemon processUnderstanding the shared buffer; Inspecting the buffer cache; Checkpoint; WAL and the WAL writer process; Recovery; Incremental backup and point-in-time recovery; Replication; The background writer; The autovacuum launcher process; The logging process; The stats collector process; The WAL sender and WAL receiver; Sorting in memory with work_mem; Maintenance with maintenance_work_mem; Understanding effective_cache_size; Summary; Chapter 3: PostgreSQL -- Object Hierarchy and Roles; The PostgreSQL cluster; Understanding tablespaces Managing temporary objects with temporary tablespacesViews; Databases, schemas, and search_path; Schemas -- use cases; Roles and privileges; Summary; Chapter 4: Working with Transactions; Understanding transactions; ACID properties of transactions; A for atomicity; C for consistency; I for isolation; D for durability; PostgreSQL and MVCC; Summary; Chapter 5: Data Modeling with SQL Power Architect; Tools for databases and their uses; Database design tools; SQL Power Architect -- downloading and installing; Creating tables; Generating SQL; Reverse engineering and making changes Exporting the data modelProfiling; Summary; Chapter 6: Client Tools; GUI tools and command-line tools; pgAdmin -- downloading and installation; Adding a server; The pgAdmin main window; The Query tool; psql -- working from the command line; psql -- connection options; The power of \d; More meta-commands; Setting up the environment; History of commands; Summary; Chapter 7: SQL Tuning; Understanding basic facts about databases; Fact 1 -- databases are more frequently read from than written to; Fact 2 -- data is always read in blocks or pages, not as individual records or columns Approaches to reducing the number of blocks read/writtenQuery execution components; Planner; Access methods; Join strategies; Finding the execution plan; Optimization guidelines and catches; Indexing foreign keys; Using SELECT *; Using ORDER BY; Using DISTINCT; Using UNION ALL instead of UNION; Using functions in the FILTER clause; Reducing the number of SQL statements; Reducing function executions; Not using indexes; Partial indexes; Optimizing functions; Summary; Chapter 8: Server Tuning; Server-wide memory settings; shared_buffers; effective_cache_size English. PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Bases de données Gestion. Bases de données Conception. COMPUTERS Database Management General. bisacsh Database design fast Database management fast has work: PostgreSQL for Data Architects (Text) https://id.oclc.org/worldcat/entity/E39PCXm8797Fwq4dTF4jgcjm7d https://id.oclc.org/worldcat/ontology/hasWork Print version: Maymala, Jayadevan. PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with postgreSQL. Birmingham, England ; Mumbai, [India] : Packt Publishing, ©2015 x, 247 pages Community experience distilled. 9781783288601 Community experience distilled. FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=972843 Volltext |
| spellingShingle | Maymala, Jayadevan PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL / Community experience distilled. Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing PostgreSQL; Installation options; Downloading and extracting the source; Inspecting the contents; Dependencies to compile the source; Configuring and creating the makefile; Building and creating the executables; Installing and moving the files to where they belong; Inspecting the changes; Initializing a cluster; A quick walk through the directories; Processes created; Important files created; Working with extensions; Summary; Chapter 2: Server Architecture Starting with the daemon processUnderstanding the shared buffer; Inspecting the buffer cache; Checkpoint; WAL and the WAL writer process; Recovery; Incremental backup and point-in-time recovery; Replication; The background writer; The autovacuum launcher process; The logging process; The stats collector process; The WAL sender and WAL receiver; Sorting in memory with work_mem; Maintenance with maintenance_work_mem; Understanding effective_cache_size; Summary; Chapter 3: PostgreSQL -- Object Hierarchy and Roles; The PostgreSQL cluster; Understanding tablespaces Managing temporary objects with temporary tablespacesViews; Databases, schemas, and search_path; Schemas -- use cases; Roles and privileges; Summary; Chapter 4: Working with Transactions; Understanding transactions; ACID properties of transactions; A for atomicity; C for consistency; I for isolation; D for durability; PostgreSQL and MVCC; Summary; Chapter 5: Data Modeling with SQL Power Architect; Tools for databases and their uses; Database design tools; SQL Power Architect -- downloading and installing; Creating tables; Generating SQL; Reverse engineering and making changes Exporting the data modelProfiling; Summary; Chapter 6: Client Tools; GUI tools and command-line tools; pgAdmin -- downloading and installation; Adding a server; The pgAdmin main window; The Query tool; psql -- working from the command line; psql -- connection options; The power of \d; More meta-commands; Setting up the environment; History of commands; Summary; Chapter 7: SQL Tuning; Understanding basic facts about databases; Fact 1 -- databases are more frequently read from than written to; Fact 2 -- data is always read in blocks or pages, not as individual records or columns Approaches to reducing the number of blocks read/writtenQuery execution components; Planner; Access methods; Join strategies; Finding the execution plan; Optimization guidelines and catches; Indexing foreign keys; Using SELECT *; Using ORDER BY; Using DISTINCT; Using UNION ALL instead of UNION; Using functions in the FILTER clause; Reducing the number of SQL statements; Reducing function executions; Not using indexes; Partial indexes; Optimizing functions; Summary; Chapter 8: Server Tuning; Server-wide memory settings; shared_buffers; effective_cache_size PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Bases de données Gestion. Bases de données Conception. COMPUTERS Database Management General. bisacsh Database design fast Database management fast |
| subject_GND | http://id.loc.gov/authorities/names/n00067354 http://id.loc.gov/authorities/subjects/sh85035848 http://id.loc.gov/authorities/subjects/sh88004472 |
| title | PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL / |
| title_alt | Discover how to design, develop, and maintain your database application effectively with PostgreSQL Postgre Structured Query Language for data architects |
| title_auth | PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL / |
| title_exact_search | PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL / |
| title_full | PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL / Jayadevan Maymala. |
| title_fullStr | PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL / Jayadevan Maymala. |
| title_full_unstemmed | PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL / Jayadevan Maymala. |
| title_short | PostgreSQL for data architects : |
| title_sort | postgresql for data architects discover how to design develop and maintain your database application effectively with postgresql |
| title_sub | discover how to design, develop, and maintain your database application effectively with PostgreSQL / |
| topic | PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Bases de données Gestion. Bases de données Conception. COMPUTERS Database Management General. bisacsh Database design fast Database management fast |
| topic_facet | PostgreSQL. PostgreSQL Database management. Database design. Bases de données Gestion. Bases de données Conception. COMPUTERS Database Management General. Database design Database management |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=972843 |
| work_keys_str_mv | AT maymalajayadevan postgresqlfordataarchitectsdiscoverhowtodesigndevelopandmaintainyourdatabaseapplicationeffectivelywithpostgresql AT maymalajayadevan discoverhowtodesigndevelopandmaintainyourdatabaseapplicationeffectivelywithpostgresql AT maymalajayadevan postgrestructuredquerylanguagefordataarchitects |