Skip to content

References: Advanced Data Management

  1. Data Warehouse - Wikipedia Comprehensive overview of data warehouse architecture, design methodologies, and ETL processes that technical PMs need to understand when managing large-scale data infrastructure projects.

  2. ACID - Wikipedia Explains atomicity, consistency, isolation, and durability properties of database transactions, essential knowledge for PMs overseeing systems that require reliable data integrity guarantees.

  3. Data Lake - Wikipedia Covers the data lake storage paradigm, contrasting it with traditional data warehouses, helping PMs understand when each approach fits their product's data management strategy.

  4. "Designing Data-Intensive Applications" by Martin Kleppmann (O'Reilly, 2017) Authoritative guide to the principles behind reliable, scalable, and maintainable data systems, covering replication, partitioning, transactions, and the trade-offs PMs must evaluate in system design.

  5. "Database System Concepts" by Abraham Silberschatz, Henry Korth, and S. Sudarshan (McGraw-Hill, 7th Edition, 2019) Leading academic textbook on database fundamentals including indexing, query optimization, entity-relationship modeling, and transaction management that underpins modern data infrastructure decisions.

  6. Database Indexing Explained - Use The Index, Luke Practical developer-oriented guide to SQL indexing and query performance tuning, giving PMs the vocabulary to discuss database optimization strategies with engineering teams.

  7. AWS Database Migration Service Documentation Official AWS guide to database migration strategies including homogeneous and heterogeneous migrations, useful for PMs planning data migration projects across environments.

  8. Data Modeling Techniques - Vertabelo Blog Explains conceptual, logical, and physical data modeling approaches with practical examples, helping PMs understand entity relationships and schema design during planning phases.

  9. Google Cloud: Database Performance Best Practices Production-tested performance guidance covering read/write optimization, connection management, and scaling strategies relevant to PMs managing high-throughput database systems.

  10. Backup and Recovery Best Practices - PostgreSQL Wiki Community-maintained guide to database backup strategies, point-in-time recovery, and disaster planning that PMs should understand when defining reliability requirements for data systems.