Now that we have covered the installation, key objects (databases and schemas) and high-level architecture, let's look at what is probably the most important concept when it comes to working with databases: transactions. The ability to provide transaction control at different isolation levels is one reason why relational databases, whether it is PostgreSQL, Oracle, DB2, or SQL Server, still rule the roost when it comes to supporting critical applications where data integrity is important. Due to their tried and tested transaction handling capabilities, relational database management systems have managed to hold their place even in a time when NoSQL databases seem to be getting most of the attention and blogspace. In this chapter, we will learn the theoretical underpinnings of transactions. We will also see how PostgreSQL manages transactions and concurrency.

PostgreSQL for Data Architects
By :

PostgreSQL for Data Architects
By:
Overview of this book
Table of Contents (19 chapters)
PostgreSQL for Data Architects
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Installing PostgreSQL
Server Architecture
PostgreSQL – Object Hierarchy and Roles
Working with Transactions
Data Modeling with SQL Power Architect
Client Tools
SQL Tuning
Server Tuning
Tools to Move Data in and out of PostgreSQL
Scaling, Replication, and Backup and Recovery
PostgreSQL – Troubleshooting
PostgreSQL – Extras
Index
Customer Reviews