ITPub博客

首页 > Linux操作系统 > Linux操作系统 > NoSQL for Storage Relational for Reporting

NoSQL for Storage Relational for Reporting

原创 Linux操作系统 作者:jieforest 时间:2012-06-15 13:30:22 0 删除 编辑
Given I think there is a shift afoot towards client-side MVC dealing in whole JSON documents up and down the wire, I’m wondering if there is also need for a technology to transparently create/maintain relational record sets for the pertinent document writes.

Relational records are desirable as they would support easy SQL-using reporting tools. Tools like Crystal or Jasper Reports.

I’m not so much interested in the enhancements to SQL that allow for JSON fragments in queries. Nor am I interested the custom search engine solutions like elasticsearch that allow for sophisticated querying of an index.

I’m looking for something that does secondary writes to a normal relational schema (whether defined or automatically generated), in such a way that Crystal or Jasper reports (or equivalent) could easily consume records for reporting.

The resulting schema (aside from the cost of the secondary writes), would be optimized for queries.



pic387.jpg


Martin Fowler, as ever, sets the foundation for what I’m wanting with a bliki entry ReportingDatabase.











来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/301743/viewspace-732926/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-04-23

  • 博文量
    443
  • 访问量
    508569