PostgreSQL for Data Architects, by Jayadevan Maymala
Sooner you get the book PostgreSQL For Data Architects, By Jayadevan Maymala, sooner you can appreciate reviewing the e-book. It will certainly be your count on maintain downloading guide PostgreSQL For Data Architects, By Jayadevan Maymala in provided web link. By doing this, you can really choose that is offered to get your very own book online. Right here, be the initial to obtain the publication qualified PostgreSQL For Data Architects, By Jayadevan Maymala and also be the very first to recognize exactly how the writer suggests the notification and knowledge for you.
PostgreSQL for Data Architects, by Jayadevan Maymala
Download Ebook PDF Online PostgreSQL for Data Architects, by Jayadevan Maymala
Discover how to design, develop, and maintain your database application effectively with PostgreSQL
About This Book
- Understand how to utilize the most frequently used PostgreSQL ecosystem-related tools and technologies
- A hands-on guide focused primarily on providing a practical approach to learning about architecture and design considerations for database architects
- The book covers PostgreSQL from a data architect's perspective – covering topics from installation from source to designing tables using SQL Power Architect, as well as deciding replication and failover strategies.
Who This Book Is For
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.
What You Will Learn
- Compile PostgreSQL from source and understand the PostgreSQL architecture
- Configure parameters and change default settings for a PostgreSQL server
- Leverage the logging mechanism to identify errors and suboptimal queries
- Use replication to scale horizontally
- Set up backup and recovery processes
- Tweak parameters to optimize queries and processes
- Troubleshoot connection errors
- Use indexes and rewrite queries to improve performance
- Install and use PostgreSQL extensions
- Learn how to leverage the command-line client (psql)
In Detail
PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up.
PostgreSQL for Data Architects will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running.
The book starts with basic concepts like installing PostgreSQL from source and covers theoretical aspects such as concurrency and transaction management. After this, you'll learn how to set up replication, use load balancing to scale horizontally, and troubleshoot errors.
Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzing PostgreSQL logs, setting up load balancing, and recovery.
PostgreSQL for Data Architects, by Jayadevan Maymala- Amazon Sales Rank: #212927 in Books
- Published on: 2015-03-27
- Released on: 2015-03-30
- Original language: English
- Number of items: 1
- Dimensions: 9.25" h x .62" w x 7.50" l, 1.04 pounds
- Binding: Paperback
- 290 pages
About the Author
Jayadevan Maymala
Jayadevan Maymala is a database developer, designer, and architect. He started working with the Oracle database in 1999. Over the years, he has worked with DB2, Sybase, and SQL Server. Of late, he has been working with open source technologies. His database of choice is PostgreSQL. In his career, he has worked in different domains spanning supply chain management, finance, and travel. He has spent an equal amount of time working with databases supporting critical transaction processing systems as well as data warehouses supporting analytical systems. When he is not working on open source technologies, he spends time reading and updating himself on economic and political issues.
Where to Download PostgreSQL for Data Architects, by Jayadevan Maymala
Most helpful customer reviews
8 of 8 people found the following review helpful. A good overview of PostgreSQL, especially for those who are familiar with databases By Geordee Naliyath This book gives a good overview of PostgreSQL database. It is an easy read, especially so if you have some background in any other databases. The book is logically organized from the installation steps to advanced topics. Even the process of installation is explained pretty nicely, explaining the internals of the database systems - which is pretty rare in similar books.In the past I have built quite a number of products with PostgreSQL as the backend. I could work with PostgreSQL easily with the general overview and DBMS concepts from other databases. The chapters on server architecture and object hierarchies really helped me to understand PostgreSQL in depth, especially in relation to other databases. As I mentioned earlier, and as the title implies, if you have been a database programmer, administrator or an architect, the details are presented concisely, in a logical order. I should also mention the handy queries and commands in every section, that prompts me to leave the eBook on the desktop.Next two chapters focus on the transactions, data modeling, and client tools which are more beginner-friendly. However, it helps to understand how PostgreSQL implements or supports those features. The book then takes a steep climb to more serious topics such as tuning, administration and scaling.SQL Tuning is quite enjoyable, starting with a few thought-provoking facts and strategies. Each of the tuning tips is well-demonstrated. A better (and consistent) layout would have made it a little more easier to read. The chapter on server tuning is also quite easy to read, especially if you have some similar background from any of the databases.Scaling, Replication, and Backup and Recovery is one of the longest, and toughest chapters. Overlapping concepts from all four topics are distilled here, and it would take some effort from the reader to keep everything in mind, together. A lot of details present here would require additional reading to get a fair understanding and grip on the subject. The book serves the purpose of keeping the concepts together as an overview.PostgreSQL is one database that competes well against the NoSQL data stores. The last chapter gives a glimpse of PostgreSQL’s not-so-conventional capabilities. The books covers PostgreSQL 9.3. Hope that it would be revised with 9.4 or even 9.5 in future, with more details on the newer features available to data architects.Overall a good read, and a book worth keeping.
0 of 2 people found the following review helpful. Five Stars By Denver Water - Dawson Wonderful published book. Great vendor!!
See all 2 customer reviews... PostgreSQL for Data Architects, by Jayadevan MaymalaPostgreSQL for Data Architects, by Jayadevan Maymala PDF
PostgreSQL for Data Architects, by Jayadevan Maymala iBooks
PostgreSQL for Data Architects, by Jayadevan Maymala ePub
PostgreSQL for Data Architects, by Jayadevan Maymala rtf
PostgreSQL for Data Architects, by Jayadevan Maymala AZW
PostgreSQL for Data Architects, by Jayadevan Maymala Kindle
Tidak ada komentar:
Posting Komentar