适用于数据密集型软件的 SharePoint（基础）
我是 SharePoint 技术的新手，正在尝试弄清楚它是否适合要开发的产品。
我的目标是仅使用 SharePoint Foundation（而不是服务器）。以下是目标产品的一些关键方面：
- 该产品是数据密集型的。涉及到许多业务和系统实体。商业实体预计将持有大量数据（一年可能达到数百万）。业务实体需要相关。 SharePoint（列表）能够满足这种需求吗？
- 该产品有许多报告（预装报告和临时报告）。这意味着在运行时构建和执行许多复杂的查询。我不确定 SharePoint 是否适合此目的。
I am new to SharePoint technologies and trying to figure out its suitability for a product to be developed.
I am targeting using only SharePoint Foundation (not the server). Here are some of the key aspect of the target product:
- The product is data intensive. There are scores of business and system entities involved. Business entities are expected to hold lot of data (might run into millions in a year). The business entities need to be related. Would SharePoint (Lists) be able to suffice this need?
- The product has many reports (canned & ad-hoc). This would mean many complex queries being build and executed at run time. I am unsure if SharePoint would be suitable for this purpose.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
根据您的描述，我看不出 Sharepoint 可以为您提供任何帮助。
使用 Sharepoint 创建围绕文档和内容共享的社区门户。
您的要求将更适合带有报告系统的 ASP.NET MVC 应用程序或使用 OOXML 或类似工具进行模板化 Excel 下载。
From what you have described, I dont see anything that Sharepoint could do to help you.
Use Sharepoint to create a community portal around sharing of documents and content.
Your requirements would be better suited to an ASP.NET MVC app with a reporting system or templated Excel downloads using OOXML or similar.
因此，关键词是“数据密集型”、“大量数据……一年数百万”、“复杂查询”。
底层平台需要构建在 RDMS 上，例如 Sql Server/MySql/Oracle 等 - 而不是 SharePoint 列表。
有很多方法可以完成项目的其余部分（用于获取记录输入/输出和报告的界面），包括客户端应用程序、ASP.NET、RoR...任何最适合您的公司和个人专业知识的方法。
这些 UI 选项之一是位于 SharePoint 中的界面 - 但仍将使用 RDMS 进行数据存储/查询。
So the key phrases are "data intensive", "lots of data... millions in a year", "complex queries".
The underlying platform needs to be built on a RDMS such as Sql Server/MySql/Oracle etc etc - not SharePoint lists.
There are many ways to do the rest of the project (interface for getting records in/out and reporting) including client apps, ASP.NET, RoR ... whatever fits in best with your corporate and personal expertise.
One of these UI options is an interface sitting in SharePoint - but that would still use the RDMS for the data store/query.