用于生成财务报表的 NoSQL
有人知道财务/会计领域有使用 NoSQL 的子集吗？
特别是，我想知道生产中是否有项目涉及报表和报告生成，而系统依赖于批处理。
传统上，批处理作业将通过 SQL 作业或计划任务来处理。 Web 界面基本上可以修改一大堆参数，然后发出适当的批量请求。
我认为 NoSQL 有吸引力的原因是批处理有时会处理 SQL 中的数百万行数据来处理计算。
如果设置正确，这在 NoSQL 中是否可行？
再说一次，我知道 NoSQL 和 SQL 一样都有其用途，但我想知道如果我们处理非常大的数据集，NoSQL 是否会用于财务报表生成。
Does anybody know of any subsets of the finance/accounting domain that uses NoSQL?
In particular, I am wondering if there are projects in production that deals with statement and report generation, where the system relies on batch processing.
Traditionally, the batch jobs would be handled through SQL jobs or scheduled tasks.
The web interface is there to basically modify a whole bunch of parameters and then make the appropriate batch requests.
The reason I think NoSQL would be attractive is that the batch process sometimes deals with millions of rows of data in SQL to process the calculations.
Given the right settings, would this even be practical in NoSQL?
Again, I understand NoSQL has its purpose as does SQL, but I was wondering if NoSQL would be used in the finance statement generation if we are dealing with very large data sets.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
财务报表只是财务记录的摘要，而财务记录本身只是采购订单和发票等源文件的摘要。无论财务记录存储在哪个数据库中，都与生成财务报表时查询的数据库相同。你无法真正将两者分开。您唯一会看到用于财务报表生成的 nosql 数据库是当 nosql 数据库首先用于财务记录存储时。这并非不可能——我还没有看到它，但我可以看到它是如何做到的； nosql数据库可以用来存储源文档，然后它的索引就相当于传统的会计记录。需要有一种方法来确保索引交易由借方和贷方平衡的记录组组成，但这也是可以做到的。
Financial statements are just summaries of financial records, which are themselves just summaries of source documents like purchase orders and invoices. Whatever database the financial records are stored in is the same one that gets queried for generating financial statements. You can't really separate the two. The only time you're going to see a nosql db used for financial statement generation is when a nosql db is used for financial record storage in the first place. This is not impossible -- I haven't seen it yet, but I can see how it could be done; the nosql db could be used to store the source documents, and then its indexes would be equivalent to conventional accounting records. There would need to be a way to make sure that index transactions are made up of sets of records in which the debits and credits balance, but again that could be done.