azure db 设置时区_使用Azure Cosmos DB开始您的旅程

azure db 设置时区

In this article, we will discuss why we need to use Azure Cosmos DB and how to configure it to store and query our data.

在本文中，我们将讨论为什么需要使用Azure Cosmos DB以及如何配置它以存储和查询我们的数据。

Before that, let us differentiate between the relational and non-relational database engines.

在此之前，让我们区分关系数据库引擎和非关系数据库引擎。

关系与非关系 (Relational vs Non- relational)

When working in the database world, you need to distinguish between the relational and non-relational database engines.

在数据库世界中工作时，您需要区分关系数据库引擎和非关系数据库引擎。

In relational database engines, such as Microsoft SQL Server, MySQL, PostgreSQL, and SQLite3, the data will be stored in tables in the shape of columns and rows, with the ability to link data from different tables using foreign key constraints. Besides, the schema of the relational database tables, which defines the name of the columns, the type of data that can be stored in these columns and the constraints on the table columns, should be defined.

在关系数据库引擎（例如Microsoft SQL Server，MySQL，PostgreSQL和SQLite3）中，数据将以列和行的形式存储在表中，并能够使用外键约束链接来自不同表的数据。 此外，应该定义关系数据库表的架构，该架构定义列的名称，可以存储在这些列中的数据的类型以及对表列的约束。

In the non-relational database engines, also called NoSQL database engines, such as MongoDB, DocumentDB, Cassandra, Coachbase and HBase, the data will NOT be stored in tables with defined schemas. Instead, the data will be stored in an optimized storage model, such as Key-value stores, Graph stores, stores, and Document stores.

在非关系数据库引擎（也称为NoSQL数据库引擎）（例如MongoDB，DocumentDB，Cassandra，Coachbase和HBase）中，数据不会存储在具有已定义架构的表中。 而是将数据存储在优化的存储模型中，例如键值存储，图存储，存储和文档存储。

为什么选择Azure Cosmos DB？ (Why Azure Cosmos DB?)

Azure Cosmos DB is a Microsoft Azure database service, fastest-growing Azure service that is available in all Azure regions, that fits any web application, mobile application, gaming or IoT application that requires processing, reading and writing a massive amount of data.

Azure Cosmos DB是Microsoft Azure数据库服务，是增长最快的Azure服务，可在所有Azure区域中使用，适用于需要处理，读取和写入大量数据的任何Web应用程序，移动应用程序，游戏或IoT应用程序。

Azure Cosmos DB provides the applications with:

Azure Cosmos DB为应用程序提供：

• least possible low latency, less than 10-ms latencies for both reads and writes workloads due to using SSD backed storage and the multi-master replication for your data wherever your users are, allowing the users to connect to the closest replica to them 尽可能低，延迟小于10毫秒，从而使用户可以连接到与其最近的副本
• highest possible availability, up to 99.999% high availability of the data stored in the Cosmos DB due to the ability to perform regional failover for your Cosmos DB account databases 可以实现最高的可用性 ，Cosmos DB中存储的数据的高可用性高达99.999％
• highest possible throughput 最高的吞吐量
• Variant consistency options, with the five well-defined consistency options, include strong, bounded staleness, session, consistent prefix, and eventual that provides full flexibility and low cost-to-performance ratio 变体一致性选项以及五个定义良好的一致性选项，包括强壮的，有界的陈旧性，会话，一致的前缀以及最终提供完全灵活性和低性价比的最终选择
• Advanced security options, where the Cosmos DB data will be encrypted at rest and in motion, in addition to the row-level authorization 进阶安全性选项 ，除了行级授权外，Cosmos DB数据还将在静态和动态状态下进行加密
• Elastically and globally scalable for the read and write operations, that helps in dealing with unexpected workload spikes, with the ability to modify the current structure anytime by adding or remove any of the Azure regions to your Cosmos account 弹性和全局可扩展的读写操作，有助于应对意外的工作负载，并可以通过向您的Cosmos帐户添加或删除任何Azure区域随时修改当前结构
• multiple APIs to work with your data that is stored in the Cosmos database, such as the SQL Core API, Cassandra, MongoDB, Gremlin and Azure Table Storage, providing you with an easy way to migrate the application to Cosmos DB without the need to perform significant changes. It requires no schema or index management is, as all data will be automatically indexed, and requires no complex multi-datacenter management or database software deployments or upgrade 多种API来处理存储在Cosmos数据库中的数据，例如SQL Core API，Cassandra，MongoDB，Gremlin和Azure Table Storage，为您提供了一种简便的方法，无需将应用程序迁移到Cosmos DB执行重大更改。 它不需要架构或索引管理，因为所有数据都将自动建立索引，并且不需要复杂的多数据中心管理或数据库软件部署或升级

For now, we