Azure是否为我的组织提供一种查看和添加Azure SQL数据库中包含的数据的方法? [英] Does Azure offer a way for my organization to view and add to data contained in an Azure SQL database?

问题描述

我的场景: 我工作的公司生产大型工业机械，并且我希望使用这些机器的数据用于机器学习研究以改善它们.到目前为止，我 具有必要的数据流到Azure并存储在Blob存储帐户中.我已经能够使用Azure存储资源管理器来访问这些数据，并且我知道可以将这些Blob数据直接带入Azure机器学习中.我在做这个 是工程团队的成员，所以我不是经验丰富的IT人员.

我的目标: 我希望我的同事能够根据自己的目的询问数据.这类查询的一个很好的例子是向我显示所有数据，其中 我们在铝上钻了一个12mm的孔.

我还希望内部用户能够将信息附加到数据库中.通常在数据收集事件结束后很长时间，技术人员可能会测量12mm的孔并确定表面粗糙度.整合具体 我们的Azure解决方案不需要质量控制测量设备，但是手动更新数据库是非常可取的.

我的问题: 我认为我将需要一个数据库来满足我的需求.我看到了SQL受管实例，SQL，SQL数据仓库， SQL Elastic DB Pool等.我也将数据库服务器视为一种选择.

是否存在前端"?在Azure中可以用于我的内部团队来访问/修改数据库?我非常想避免构建"某样东西，无论是哪种首选的最佳实践，都希望这样做.

解决方案

你好，

https://cloudblogs.microsoft.com/sqlserver/2018/11/07/announcing-preview-of-machine-学习服务与r-support-azure-sql-database/

SQLCoffee.com

My Scenario:  The company I work for makes large industrial machines and I have the desire to use data from these machines in machine learning studies to improve them.  To date, I have the necessary data flowing to Azure and being stored in a blob storage account. I've been able to use Azure storage explorer to access this data and I understand that I can bring this blob data directly into Azure Machine learning.  I'm doing this work as a member of the engineering team, so I'm not a seasoned IT person.

My goal: I would like my co-workers to have the ability to interrogate the data for their purposes.   A good example of this type of query would be "show me all of the data where we drilled a 12mm hole in aluminum" 

I'd also like my internal users to have the ability to append information to the database.  Often long after the data collection event, a technician might measure the 12mm hole and determine the surface roughness for example.  Integrating the specific QC measurement device to our Azure solution is not desirable but, manually updating the database is highly desirable.  

My Question(s):  I believe that I will need a database for my purposes.  Which Database is appropriate?  I see options for SQL managed instance, SQL, SQL Data Warehouse, SQL Elastic DB Pool and so on.  I see database servers as an option as well.

Is there a "Front end" in Azure that I can use for my in-house team to access/modify the database? I'd very much like to avoid "building" something and would prefer to do this whatever might be the preferred best practice.

解决方案

Hello,

A new Machine Learning service for Azure SQL Database is currently in public preview. I think it could fit your needs.

https://cloudblogs.microsoft.com/sqlserver/2018/11/07/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database/

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

这篇关于Azure是否为我的组织提供一种查看和添加Azure SQL数据库中包含的数据的方法?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！