这个简单概述的BI工具用例的正确数据库技术是什么？ [英] What is the right database technology for this simple outlined BI tool use case?

问题描述

向社区伸出援手，对我们的内部思维进行压力测试。



我们正在构建一个简化的商业智能平台，该平台将汇总指标（即流量，反向链接）和来自多个数据提供商的文本列表（即搜索关键字，使用过的技术）。



数据结构有点松散，可能随着时间的推移而变化，供应商可能会更改其响应格式。



数据量可能是长期100,000行x25个输入向量。



数据将被更新并且连续读取但不是大量的并发卷。



我们期望在从UI到用户的途中对合作伙伴收集的数据进行一些ETL转换（例如，显示过去五个捕获数据点的趋势信息。）



我们想要存档每个数据快照（即版本）与仅存储最新数据数据点。



持久性技术应该可以通过AWS轻松获得。



我们的假设是我们的要求最适合DynamoDB（对比亚马逊海王星或Redshift或Aurora）。



这是公平的假设吗？我可以提供任何其他问题/信息来引导这个社区的意见吗？



我尝试了什么：



评估了4个市场;到目前为止假设DynamoDB是要走的路。

Reaching out to the community to pressure test our internal thinking.

We are building a simplified business intelligence platform that will aggregate metrics (i.e. traffic, backlinks) and text list (i.e search keywords, used technologies) from several data providers.

The data will be somewhat loosely structured and may change over time with vendors potentially changing their response formats.

Data volume may be long term 100,000 rows x 25 input vectors.

Data would be updated and read continuously but not at massive concurrent volume.

We'd expect to need to do some ETL transformations on the gathered data from partners along the way to the UI (e.g show trending information over the past five captured data points).

We'd want to archive every single data snapshot (i.e. version it) vs just storing the most current data point.

The persistence technology should be readily available through AWS.

Our assumption is our requirements lend themselves best towards DynamoDB (vs Amazon Neptune or Redshift or Aurora).

Is that fair to assume? Are there any other questions / information I can provide to elicit input from this community?

What I have tried:

Evaluated the4 market; so far assuming DynamoDB is the way to go.

推荐答案

不是一个深入的评论，但你可以在这里找到一些替代方案：

Amazon DynamoDB替代品及类似网站和应用 - AlternativeTo.net [ ^ ]



这里：https://www.slant。 co / improve / topics / 3193 / ~nosql-database-as-a-service-providers-for-stored-large-data-data- [ ^ ]



还在这里： HTTP s：//www.slant.co/improve/topics/3191/~nosql-database-as-a-service-providers [ ^ ]

Not really an in depth review, but you can find some alternatives here:
Amazon DynamoDB Alternatives and Similar Websites and Apps - AlternativeTo.net[^]

And here: https://www.slant.co/improve/topics/3193/~nosql-database-as-a-service-providers-for-storing-large-amounts-of-data[^]

And also here: https://www.slant.co/improve/topics/3191/~nosql-database-as-a-service-providers[^]

这篇关于这个简单概述的BI工具用例的正确数据库技术是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！