您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

什么是 Azure SQL Edge?What is Azure SQL Edge?

Azure SQL Edge 是已针对 IoT 和 IoT Edge 部署进行了优化的关系数据库引擎。Azure SQL Edge is an optimized relational database engine geared for IoT and IoT Edge deployments. 它提供为 IoT 应用程序和解决方案创建高性能数据存储和处理层的功能。It provides capabilities to create a high-performance data storage and processing layer for IoT applications and solutions. Azure SQL Edge 提供了流式传输、处理和分析关系和非关系数据(如 JSON、图形和时序数据)的功能,这使其成为各种新式 IoT 应用程序的正确选择。Azure SQL Edge provides capabilities to stream, process, and analyze relational and non-relational such as JSON, graph and time-series data, which makes it the right choice for a variety of modern IoT applications.

Azure SQL Edge 基于最新版本的 SQL Server 数据库引擎而构建,提供行业领先的性能、安全性和查询处理功能。Azure SQL Edge is built on the latest versions of the SQL Server Database Engine, which provides industry-leading performance, security and query processing capabilities. 由于 Azure SQL Edge 建立在与 SQL ServerAzure SQL 相同的引擎上,因此它提供相同的 Transact-SQL (T-SQL) 编程外围应用,使应用程序或解决方案的开发更简单且更快速,使应用程序在 IoT Edge 设备、数据中心和云之间的可移植性变得简单。Since Azure SQL Edge is built on the same engine as SQL Server and Azure SQL, it provides the same Transact-SQL (T-SQL) programming surface area that makes development of applications or solutions easier and faster, and makes application portability between IoT Edge devices, data centers and the cloud straight forward.

什么是第9频道上的 Azure SQL Edge 视频:What is Azure SQL Edge video on Channel 9:

部署模型Deployment Models

Azure SQL Edge 支持两种部署模式。Azure SQL Edge supports two deployment modes.

  • 通过 Azure IoT Edge 进行的联网部署:Azure SQL Edge 在 Azure 市场中提供,可以部署为 Azure IoT Edge 模块。Connected deployment through Azure IoT Edge: Azure SQL Edge is available on the Azure Marketplace and can be deployed as a module for Azure IoT Edge. 有关详细信息,请参阅部署 Azure SQL EdgeFor more information, see Deploy Azure SQL Edge.

SQL Edge 概述关系图

SQL Edge 版本Editions of SQL Edge

SQL Edge 有两个不同的版本或软件计划。SQL Edge is available with two different editions or software plans. 这些版本具有相同的功能集,仅在使用权限和支持的 CPU/内存量方面存在差异。These editions have identical feature sets and only differ in terms of their usage rights and the amount of cpu/memory they support.

规划Plan 说明Description
Azure SQL Edge 开发人员Azure SQL Edge Developer 仅限开发 SKU,每个 SQL Edge 容器最多只能有 4 个内核和 32 GB 内存Development only sku, each SQL Edge container is limited to upto 4 cores and 32 GB Memory
Azure SQL EdgeAzure SQL Edge 生产 SKU,每个 SQL Edge 容器最多只能有 8 个内核和 64 GB 内存。Production sku, each SQL Edge container is limited to upto 8 cores and 64 GB Memory.

定价和可用性Pricing and Availability

Azure SQL Edge 现已正式发布。Azure SQL Edge is now generally available. 有关特定区域中的定价和可用性的详细信息,请参阅 Azure SQL EdgeFor more information on the pricing and availability in specific regions, see Azure SQL Edge.

重要

若要了解 Azure SQL Edge 与 SQL Server 的功能差异,以及不同 Azure SQL Edge 选项之间的区别,请参阅Azure SQL Edge 支持的功能To understand the feature differences between Azure SQL Edge and SQL Server, as well as the differences among different Azure SQL Edge options, see Supported features of Azure SQL Edge.

流式处理功能Streaming Capabilities

Azure SQL Edge 提供内置的流式处理功能,可用于实时分析和复杂事件处理。Azure SQL Edge provides built in streaming capabilities for real-time analytics and complex event-processing. 流式处理功能是使用与 Azure 流分析相同的构造构建的,其功能类似于 Azure IoT Edge 流分析The streaming capability is built using the same constructs as Azure Stream Analytics and similar capabilities as Azure Stream Analytics on IoT Edge.

Azure SQL Edge 的流式处理引擎专为实现低延迟、复原能力、有效使用带宽和合规性而设计。The streaming engine for Azure SQL Edge is designed for low-latency, resiliency, efficient use of bandwidth and compliance.

有关 SQL Edge 中的数据流式处理的详细信息,请参阅数据流式处理For more information on data streaming in SQL Edge, refer Data Streaming

机器学习和人工智能功能Machine Learning and Artificial Intelligence Capabilities

Azure SQL Edge 通过集成开放格式 ONNX (Open Neural Network Exchange) 运行时来提供内置的机器学习和分析功能,这允许在不同框架之间交换深度学习和神经网络模型。Azure SQL Edge provides built-in machine learning and analytics capabilities by integrating the open format ONNX (Open Neural Network Exchange) runtime, which allows exchange of deep learning and neural network models between different frameworks. 有关 ONNX 的详细信息,请参阅此处For more information on ONNX, see here. ONNX 运行时具有灵活性,可在你选择的语言或工具中开发模型,然后将其转换为 ONNX 格式,以便在 SQL Edge 内执行。ONNX runtime provides the flexibility to develop models in a language or tools of your choice, which can then be converted to the ONNX format for execution within SQL Edge. 有关详细信息,请参阅 在 SQL Edge 中使用 ONNX 实现机器学习和人工智能For more information, see Machine Learning and Artificial Intelligence with ONNX in SQL Edge.

使用 Azure SQL EdgeWorking with Azure SQL Edge

Azure SQL Edge 使应用程序的开发和维护更加轻松、高效。Azure SQL Edge makes developing and maintaining applications easier and more productive. 用户可以使用所有熟悉的工具和技能来构建功能强大的应用和解决方案,以满足其 IoT Edge 需求。Users can use all the familiar tools and skills to build great apps and solutions for their IoT Edge needs. 用户可以使用如下工具在 SQL Edge 中开发:User can develop in SQL Edge using tools like the following:

  • Azure 门户 - 一个基于 Web 的应用程序,用于管理所有 Azure 服务。The Azure portal - A web-based application for managing all Azure services.
  • SQL Server Management Studio - 一款免费、可下载的客户端应用程序,用于管理任何 SQL 基础结构(从 SQL Server 到 SQL 数据库,不一而足)。SQL Server Management Studio - A free, downloadable client application for managing any SQL infrastructure, from SQL Server to SQL Database.
  • Visual Studio 中的 SQL Server Data Tools - 一个免费、可下载的客户端应用程序,用于开发 SQL Server 关系数据库、SQL 数据库、Integration Services 包、Analysis Services 数据模型和 Reporting Services 报表。SQL Server Data Tools in Visual Studio - A free, downloadable client application for developing SQL Server relational databases, SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports.
  • Azure Data Studio - 一个免费、可下载的跨平台数据库工具,适用于在 Windows、macOS 和 Linux 上使用 Microsoft 系列本地和云数据平台的数据专业人员。Azure Data Studio - A free, downloadable, cross platform database tool for data professional using the Microsoft family of on-premises and cloud data platforms on Windows, macOS, and Linux.
  • Visual Studio Code - 一个免费、可下载的开放源代码代码编辑器,适用于 Windows、macOS 和 Linux。Visual Studio Code - A free, downloadable, open-source code editor for Windows, macOS, and Linux. 它支持各种扩展,其中包括 mssql 扩展(用于查询 Microsoft SQL Server、Azure SQL 数据库和 Azure Synapse Analytics)。It supports extensions, including the mssql extension for querying Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.

后续步骤Next steps