新冠肺影-中國病理切片

Build faster and efficient real-world applications on the cloud with a fitting database model that's perfect for your needsKey FeaturesFamiliarize yourself with business and technical considerations involved in modeling the right databaseTake your data to applications, analytics, and AI with real-world examplesLearn how to code, build, and deploy end-to-end solutions with expert advicePurchase of the print or Kindle book includes a free PDF eBookBook DescriptionIn the age of lightning-speed delivery, customers want everything developed, built, and delivered at high speed and at scale. Knowledge, design, and choice of database is critical in that journey, but there is no one-size-fits-all solution. This book serves as a comprehensive and practical guide for data professionals who want to design and model their databases efficiently. The book begins by taking you through business, technical, and design considerations for databases. Next, it takes you on an immersive structured database deep dive for both transactional and analytical real-world use cases using Cloud SQL, Spanner, and BigQuery. As you progress, you'll explore semi-structured and unstructured database considerations with practical applications using Firestore, cloud storage, and more. You'll also find insights into operational considerations for databases and the database design journey for taking your data to AI with Vertex AI APIs and generative AI examples. By the end of this book, you will be well-versed in designing and modeling data and databases for your applications using Google Cloud.What you will learnUnderstand different use cases and real-world applications of data in the cloudWork with document and indexed NoSQL databasesGet to grips with modeling considerations for analytics, AI, and MLUse real-world examples to learn about ETL servicesDesign structured, semi-structured, and unstructured data for your applications and analyticsImprove observability, performance, security, scalability, latency SLAs, SLIs, and SLOsWho this book is forThis book is for database developers, data engineers, and architects looking to design, model, and build database applications on the cloud with an extended focus on operational consideration and taking their data to AI. Data scientists, as well ML and AI engineers who want to use Google Cloud services in the data to AI journey will also find plenty of useful information in this book. It will also be useful to data analysts and BI developers who want to use SQL impactfully to generate ML and generative AI insights from their data. Database Design and Modeling with PostgreSQL and MySQL Foreword Contributors About the authors About the reviewers Preface Who this book is for What this book covers To get the most out of this book Download the example code files Conventions used Get in touch Share Your Thoughts Download a free PDF copy of this book Part 1: Introduction to Databases 1 SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs Understanding databases and data models Exploring the relational data model (SQL databases) Tables, rows, and columns Normalization Structured Query Language (SQL) ACID transactions Navigating the document data model (NoSQL databases) Data models in NoSQL Types of NoSQL databases Key-value stores Document stores Column-family stores Graph databases Applying the CAP theorem and NoSQL design choices Consistency Availability Partition tolerance Consistency models in NoSQL databases NoSQL design choices and use cases Managing transaction management and concurrency control in NoSQL BASE transactions in NoSQL databases Reasons for the BASE model in NoSQL databases Implications for data integrity and concurrency control Analyzing the advantages and disadvantages of NoSQL databases Advantages of NoSQL databases Disadvantages of NoSQL databases Summary 2 Building a Strong Foundation for Database Design The importance of a solid foundation in database design Key terms and data models Understanding the relational model in detail Identifying entities, attributes, and relationships in database design Creating an ER diagram Advanced database design Normalization – reducing redundancy and improving data integrity Achieving normal forms – 1NF, 2NF, and 3NF Ensuring database validity and integrity Concluding thoughts Summary Part 2: Practical Implementation 3 Getting Your Hands Dirty with PostgreSQL and MySQL Understanding the sample database EDA and preprocessing Database schema MySQL Concluding thoughts Summary Part 3: Core Concepts in Database Design 4 Mastering the Building Blocks of Database Design and Modeling Understanding database objects Understanding data types and constraints Keys and how to use them Database checks and constraints Check constraint Default constraint Not null constraint Checking data quality with constraints No date in the future Value within a specific range How to avoid redundancy Database consistency and beyond Transactions – ensuring data integrity Concurrency control – managing multiple users PostgreSQL MySQL Summary Part 4: Advanced Database Techniques 5 Advanced Techniques for Advanced Databases Creating custom views of your data Understanding the purpose of views The advantages of using views in database management Indexing – how to find data faster Understanding indexing Types of indexes How indexing works PostgreSQL indexes MySQL indexes Stored procedures – reusable code for your database UDFs The essence of UDFs Efficiency through reusability – the role of UDFs in code optimization UDFs and performance optimization in database operations Using UDFs to enrich SQL queries for expressive interactions Practical insights into UDFs in MySQL and PostgreSQL Understanding CTEs The role of CTEs in code modularity Components and integration of CTEs Guidelines for efficient CTE usage Advanced strategies with CTEs Case studies in action – real-world examples of CTE transformations Summary 6 Understanding Database Scalability Introducing database scaling Challenges in database scaling Primary methods of database scaling Vitess – a horizontal scaling solution for MySQL Citus – a horizontal scaling solution for PostgreSQL Vertical scaling – enhancing capacity within existing infrastructure InnoDB Cluster for MySQL Sharding and resharding Future trends and emerging challenges in database scaling Serverless databases Summary Part 5: Best Practices and Future Trends 7 Best Practices for Building and Maintaining Your Database Designing for performance – optimizing database efficiency Schema design Query optimization Advanced query optimization techniques Using subqueries and JOIN clauses wisely Utilizing temporary tables Optimizing aggregates and GROUP BY clauses Using an index to assist GROUP BY clauses Iterative process and analysis Understanding database scaling Vertical scaling Horizontal scaling Replication in PostgreSQL MySQL replication Ensuring database security Access control Implementing robust authentication mechanisms Permission models PostgreSQL permission model Roles and privileges Example setup in PostgreSQL MySQL permission model Privileges and levels Example setup in MySQL Management and flexibility Exploring data encryption Protecting data at rest Protecting data in transit Monitoring and auditing Data quality and governance – maintaining high standards Learning about data cleaning Data governance frameworks Compliance Collaboration and documentation Effective communication Documentation practices Advanced topics in database management Backup and recovery Tools for monitoring PostgreSQL MySQL performance monitoring tools Strategies for regular performance analysis Summary 8 The Future of Databases and Their Designs Understanding vectorized search MySQL enhancements and innovations MySQL HeatWave Prospects of use cases of HeatWave TiDB as a MySQL drop-in replacement for distributed systems PostgreSQL – expanding horizons pgEdge – fully distributed PostgreSQL optimized for the network edge Multi-master replication in pgEdge Simplified cluster management Enhanced backup and recovery Advanced monitoring and alerting EnterpriseDB – elevating PostgreSQL for the enterprise Choosing your EDB deployment method Introduction to columnar databases with ClickHouse What is ClickHouse? Choosing the right alternative Summary Index Why subscribe? Other Books You May Enjoy Packt is searching for authors like you Share Your Thoughts Download a free PDF copy of this book Database Design and Modeling with PostgreSQL and MySQL: Build efficient and scalable databases for modern applications using open source databases Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercises Key Features Get to grips with fundamental-to-advanced database design and modeling concepts with PostgreSQL and MySQL Explore database integration with web apps, emerging trends, and real-world case studies Leverage practical examples and hands-on exercises to reinforce learning Book Description Database Design and Modeling with PostgreSQL and MySQL will equip you with the knowledge and skills you need to architect, build, and optimize efficient databases using two of the most popular open-source platforms. As you progress through the chapters, you'll gain a deep understanding of data modeling, normalization, and query optimization, supported by hands-on exercises and real-world case studies that will reinforce your learning. You'll explore topics like concurrency control, backup and recovery strategies, and seamless integration with web and mobile applications. These advanced topics will empower you to tackle complex database challenges confidently and effectively. Additionally, you’ll explore emerging trends, such as NoSQL databases and cloud-based solutions, ensuring you're well-versed in the latest developments shaping the database landscape. By embracing these cutting-edge technologies, you'll be prepared to adapt and innovate in today's ever-evolving digital world. By the end of this book, you’ll be able to understand the technologies that exist to design a modern and scalable database for developing web applications using MySQL and PostgreSQL open-source databases. What you will learn Design a schema, create ERDs, and apply normalization techniques Gain knowledge of installing, configuring, and managing MySQL and PostgreSQL Explore topics such as denormalization, index optimization, transaction management, and concurrency control Scale databases with sharding, replication, and load balancing, as well as implement backup and recovery strategies Integrate databases with web apps, use SQL, and implement best practices Explore emerging trends, including NoSQL databases and cloud databases, while understanding the impact of AI and ML Who this book is for This book is for a wide range of professionals interested in expanding their knowledge and skills in database design and modeling with PostgreSQL and MySQL. This includes software developers, database administrators, data analysts, IT professionals, and students. While prior knowledge of MySQL and PostgreSQL is not necessary, some familiarity with at least one relational database management system (RDBMS) will help you get the most out of this book. Master the capabilities of PostgreSQL 15 to efficiently administer and maintain your database. Purchase of the print or Kindle book includes a free PDF eBook.Key FeaturesUsing real world examples, get to grips with expert PostgreSQL 15 conceptsExplore performance improvement, database replication, data replication, database administration, and moreExtend PostgreSQL's functionalities to suit your organization's needs with minimal effortBook DescriptionStarting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system. You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, and user management to manage and maintain your database. You'll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. Among the other skills that the book will help you build, you'll cover transactions, handling recursions, working with JSON and JSONB data, and setting up a Patroni cluster. It will show you how to improve performance with query optimization. You'll also focus on managing network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases. By the end of this PostgreSQL book, you'll be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.What you will learnMake use of the indexing features in PostgreSQL and fine-tune the performance of your queriesWork with stored procedures and manage backup and recoveryGet the hang of replication and failover techniquesImprove the security of your database server and handle encryption effectivelyTroubleshoot your PostgreSQL instance for solutions to common and not-so-common problemsPerform database migration from Oracle to PostgreSQL with easeWho this book is forThis database administration book is for PostgreSQL developers, database administrators, and professionals who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 15. Prior experience in PostgreSQL and familiarity with the basics of database administration will assist with understanding key concepts covered in the book. Updated to keep up with the latest version of PostgreSQL, this fifth edition will help you build dynamic database solutions for enterprise applications using real-world hands-on examples, enabling you to design both the physical and technical aspects of the system architecture with ease.