001436123 000__ 04064cam\a2200529Ii\4500
001436123 001__ 1436123
001436123 003__ OCoLC
001436123 005__ 20230309004010.0
001436123 006__ m\\\\\o\\d\\\\\\\\
001436123 007__ cr\un\nnnunnun
001436123 008__ 210430s2021\\\\nyua\\\\o\\\\\001\0\eng\d
001436123 019__ $$a1249471751
001436123 020__ $$a9781484268858$$qelectronic book
001436123 020__ $$a1484268857$$qelectronic book
001436123 020__ $$z9781484268841
001436123 020__ $$z1484268849
001436123 0247_ $$a10.1007/978-1-4842-6885-8$$2doi
001436123 035__ $$aSP(OCoLC)1249012581
001436123 040__ $$aYDX$$beng$$erda$$cYDX$$dGW5XE$$dEBLCP$$dOCLCO$$dOCLCF$$dUKAHL$$dN$T$$dCOM$$dOCLCO$$dFTB$$dOCL$$dOCLCQ
001436123 049__ $$aISEA
001436123 050_4 $$aQA76.9.D3$$bD66 2021
001436123 08204 $$a005.74$$223
001436123 1001_ $$aDombrovskaya, Henrietta,$$eauthor.
001436123 24510 $$aPostgreSQL query optimization :$$bthe ultimate guide to building efficient queries /$$cHenrietta Dombrovskaya, Boris Novikov, Anna Bailliekova.
001436123 264_1 $$a[New York, NY] :$$bApress,$$c[2021]
001436123 300__ $$a1 online resource (xxiii, 319 pages) :$$billustrations (some color)
001436123 336__ $$atext$$btxt$$2rdacontent
001436123 337__ $$acomputer$$bc$$2rdamedia
001436123 338__ $$aonline resource$$bcr$$2rdacarrier
001436123 500__ $$aIncludes index.
001436123 5050_ $$a1. Why Optimize? -- 2. Theory: Yes, We Need It! -- 3. Even More Theory: Algorithms -- 4. Understanding Execution Plans -- 5. Short Queries and Indexes -- 6. Long Queries and Full Scans -- 7. Long Queries: Additional Techniques -- 8. Optimizing Data Modification -- 9. Design Matters -- 10. Application Development and Performance -- 11. Functions -- 12. Dynamic SQL -- 13. Avoiding the Pitfalls of Object-Relational Mapping -- 14. More Complex Filtering and Search -- 15. Ultimate Optimization Algorithm -- 16. Conclusion.
001436123 506__ $$aAccess limited to authorized users.
001436123 520__ $$aWrite optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries. You will learn to look at the process of writing a query from the database engine's point of view, and know how to think like the database optimizer. The book begins with a discussion of what a performant system is and progresses to measuring performance and setting performance goals. It introduces different classes of queries and optimization techniques suitable to each, such as the use of indexes and specific join algorithms. You will learn to read and understand query execution plans along with techniques for influencing those plans for better performance. The book also covers advanced topics such as the use of functions and procedures, dynamic SQL, and generated queries. All of these techniques are then used together to produce performant applications, avoiding the pitfalls of object-relational mappers. You will: Identify optimization goals in OLTP and OLAP systems Read and understand PostgreSQL execution plans Distinguish between short queries and long queries Choose the right optimization technique for each query type Identify indexes that will improve query performance Optimize full table scans Avoid the pitfalls of object-relational mapping systems Optimize the entire application rather than just database queries.
001436123 588__ $$aDescription based on online resource; title from digital title page (viewed on June 03, 2022).
001436123 63000 $$aPostgreSQL.
001436123 650_0 $$aQuerying (Computer science)
001436123 650_6 $$aBases de données$$xInterrogation.
001436123 655_0 $$aElectronic books.
001436123 7001_ $$aNovikov, Boris,$$eauthor.$$1https://orcid.org/0000-0003-4657-0757
001436123 7001_ $$aBailliekova, Anna,$$eauthor.
001436123 77608 $$iPrint version:$$z1484268849$$z9781484268841$$w(OCoLC)1227383209
001436123 852__ $$bebk
001436123 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-6885-8$$zOnline Access$$91397441.1
001436123 909CO $$ooai:library.usi.edu:1436123$$pGLOBAL_SET
001436123 980__ $$aBIB
001436123 980__ $$aEBOOK
001436123 982__ $$aEbook
001436123 983__ $$aOnline
001436123 994__ $$a92$$bISE