PostgreSQL for data architects : discover how to design, develop, and maintain your database application effectively with PostgreSQL /
Annotation
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham, UK :
Packt Publishing,
2015.
|
| Series: | Community experience distilled.
|
| Subjects: | |
| Online Access: | CONNECT CONNECT |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | mig00005353993 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 150430s2015 enka o 001 0 eng d | ||
| 005 | 20240618150232.6 | ||
| 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 1WRLDSHRocn908199866 | ||
| 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 | ||
| 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 | ||
| 049 | |a TXMM | ||
| 050 | 4 | |a QA76.9.D3 | |
| 082 | 0 | 4 | |a 005.7565 |2 23 |
| 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. | ||
| 500 | |a EBSCO eBook Academic Comprehensive Collection North America |5 TMurS | ||
| 500 | |a O'Reilly Online Learning Platform: Academic Edition (SAML SSO Access) |5 TMurS | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Database design. | |
| 730 | 0 | |a WORLDSHARE SUB RECORDS | |
| 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 | |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=972843&authtype=ip,sso&custid=s4672406 |z CONNECT |3 eBooks on EBSCOhost |t 0 |
| 856 | 4 | 0 | |u https://go.oreilly.com/middle-tennessee-state-university/library/view/-/9781783288601/?ar |z CONNECT |3 O'Reilly |t 0 |
| 949 | |a ho0 | ||
| 994 | |a 92 |b TXM | ||
| 998 | |a wi |d z | ||
| 999 | f | f | |s 1ab5d515-01b4-4a62-8917-f53ce4e50874 |i 1bc659d7-4089-4a07-bc42-a1c676aeedd0 |t 0 |
| 952 | f | f | |a Middle Tennessee State University |b Main |c James E. Walker Library |d Electronic Resources |t 0 |e QA76.9.D3 |h Library of Congress classification |
