Coursera 笔记

Module 01 · Relational Database Concepts

Summary and Highlights: Introducing Relational Database Products总结与要点：关系型数据库产品介绍

Coursera ↗

Congratulations! You have completed this lesson. At this point, you know that: 
恭喜！您已完成本课程。此时，您知道：

  • Deployment topology involves organizing hardware, software, and network components.
    部署拓扑涉及组织硬件、软件和网络组件。

  • The common deployment topologies include single-tier architecture, client-server architecture or two-tier database architecture, three-tier architecture, and cloud-based deployment.
    常见的部署拓扑包括单层架构、客户端-服务器架构或两层数据库架构、三层架构和基于云的部署。

  • Relational Database Management Systems (RDBMSs) offer distributed architectures for critical or large-scale workloads, employing shared disk and shared nothing strategies for optimized performance.
    关系型数据库管理系统（RDBMS）为关键或大规模工作负载提供分布式架构，采用共享磁盘和共享无策略以优化性能。

  • Databases cater to various user roles, including Data Engineers, Database Administrators (DBAs), Data Scientists, Analysts, and Application Developers.
    数据库服务于各种用户角色，包括数据工程师、数据库管理员（DBA）、数据科学家、分析师和应用开发人员。

  • Data Engineers/DBAs manage databases using GUIs, command line interfaces, and APIs for administrative tasks.
    数据工程师/DBA 使用图形用户界面、命令行界面和 API 来管理数据库，以执行管理任务。

  • Open-source relational databases have gained popularity, reaching approximately 50% in the past decade, while cloud databases offer increased scalability and data accessibility.
    开源关系型数据库在过去十年中获得了普及，占比约为 50%，而云数据库提供了更高的可扩展性和数据可访问性。

  • Db2 is a versatile family of products deployable across various platforms, providing high availability, disaster recovery, and scalability.
    Db2 是一个多功能的系列产品，可在各种平台上部署，提供高可用性、灾难恢复和可扩展性。

  • MySQL supports various programming languages and is a reliable, scalable, and widely adopted database system compatible with UNIX, Windows, and Linux.
    MySQL 支持多种编程语言，是一个可靠、可扩展且广泛采用的数据库系统，兼容 UNIX、Windows 和 Linux。

  • PostgreSQL is an open-source, object-relational database supporting a range of languages for client application development, including features for handling relational, structured, and non-structured data.
    PostgreSQL 是一个开源的对象关系型数据库，支持多种语言进行客户端应用程序开发，包括处理关系型、结构化和非结构化数据的功能。