即席查询工具模式
我正在寻找以图形方式实现即席查询功能的常见模式。我研究过 Access 和 TOAD 中的 SQL 查询生成器，但我很感兴趣是否有人知道针对特定领域的数据仓库（例如临床数据库）构建此类工具的产品。
谢谢，
I'm looking for common patterns of implementing ad-hoc querying capabilites graphically. I've looked at SQL query builders in Access and TOAD, but I'm interested if anyone is aware of products that have build such a tool against a domain specific data warehouse (e.g. clinical databases).
Thanks,
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
除了 Tableau（Arthur 提到的）之外，我建议使用 Qlikview 或 Spotfire，它们都允许在内存数据库中进行临时图形查询。这些应用程序比 Crystal 或 Jasper 报告等功能强大得多。
Beyond Tableau (mentioned by Arthur), I would suggest either Qlikview or Spotfire, both of which allow for ad-hoc graphical querying in in-memory databases. These applications are much more powerful than something like Crystal or Jasper reports.
我没有具体的答案，但有一些报告工具可以帮助您做我认为您可能感兴趣的事情。
我自己尝试过并且喜欢安静一点的付费工具是 Tableau 这是付费软件，服务器可能很昂贵，但我喜欢桌面应用程序。您必须了解足够的数据库才能弄清楚如何从中提取数据。一旦完成，您就可以重复使用它。一旦绘制出数据集，您就可以以图形方式“玩”它。
您可以使用更复杂的报告工具，例如 Crystal Reports、Jasper Report，我认为 IBM 拥有处理“立方体”或其他内容的工具。您可以通过研究商业智能软件来查找所有这些内容。 （我讨厌这个名字）
拥有特定领域的东西的问题是数据库可能不同。即使您使用通用供应商工具，查询工具也必须针对数据库构建。
所以也许这并不能回答你的直接问题，但希望它能有点帮助。
I have no specific answer but there are reporting tools that help you do stuff that I think you might be interested in.
One pay one that I tried out myself and liked quiet a bit was Tableau It is pay software and the server can be expensive, but I liked the desktop app. You will have to know enough database to figure out how to draw data out of it. Once that is done though you can reuse it. Once you draw out the dataset though you can 'play' with it graphically.
You can get into more complicated Reporting tools like Crystal Reports, Jasper Report and I think IBM has something that deals with 'Cubes' or whatever. You can look up all that by looking into Business Intelligence software. (I hate that name)
The problem with having domain specific stuff is that databases can be different. And even if you use a common vendor tool then the the query tool would have to be built specific to the db.
So maybe this doesn't answer your direct question but hope it is a little helpful.