PostgreSQL for Data Architects. Discover how to design, develop, and maintain your database application effectively with PostgreSQL

PostgreSQL for Data Architects. Discover how to design, develop, and maintain your database application effectively with PostgreSQL - Opis

Spis treści: 1. Installation and directory structure2. Server Architecture3. Object Hierarchy and Security4. Transactions5. Data modelling with SQL Power Architect6. Client Tools7. SQL Tuning8. Server Tuning9. PostgreSQL inbuilt tools10. Scaling, replication, backup and recovery11. PostgreSQL - Troubleshooting12. PostgreSQL - Extras O autorze: 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.