应该使用哪个存储来存储azure中的主数据 [英] Which storage should be used to store master data in azure

问题描述

我想将我的主数据存储在某个天蓝色存储中，以便在我在azure中部署的所有应用程序中访问它。数据需要被提取很多次并且很少更新。



目前这些数据存储在SQL Server中，并由数据中心的应用程序访问（不是天蓝色）



我的尝试：



我曾经想过SQL，Redis和CosmosDB截至目前但仍不确定使用哪一个。

I want to store my master data in some azure storage so that same can be accessed in all my applications deployed in azure. The data need to be fetched large number of times and will be updated rarely.

Currently this data is stored in SQL Server and is accessed by Applications in Data centers (not on azure)

What I have tried:

I have thought of SQL, Redis and CosmosDB as of now but still not sure of which one to be used.

推荐答案

您的问题只能由您真正回答。如果您的数据需要严格构建或严重基于关系，那么您可能希望坚持使用sql server。如果您的数据是非结构化的，或者没有立即明确定义，那么这就是使用NoSQL路由的众多原因之一。



因此，您可以自行决定如何使用数据存储，您希望如何存储，是否会经常更改？以及您的项目可能有的其他要求。



看看这些链接：



https://www.upwork.com/hiring/data/sql-vs -nosql-databases-whats-the-difference /



SQL和NoSQL DB之间的关键区别。 |关于网络和网络监控的一切 [ ^ ]



NoSQL vs. SQL：它关于性能和规模 - DATAVERSITY [ ^ ]



Google [ ^ ]

Your question can only really be answered by you. If your data needs to be strictly structured or is heavily based on being relational, than you probably want to stick with sql server. If your data is unstructured, or not clearly defined right away that is one of many reasons to go the NoSQL route.

So really its up to you to decide how your data is stored, how you want it to be stored, is it going to change often? and whatever other requirements your project may have.

Have a look at these links:

https://www.upwork.com/hiring/data/sql-vs-nosql-databases-whats-the-difference/

The key differences between SQL and NoSQL DBs. | EVERYTHING ABOUT WEB AND NETWORK MONITORING[^]

NoSQL vs. SQL: It's About the Performance and Scale - DATAVERSITY[^]

Google[^]

这篇关于应该使用哪个存储来存储azure中的主数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！