I am working on project in economy where I need to manage large data in linked tables, with many foreign keys. I have a few years of experience as Oracle DBA so I can manage all that without problem, But I need to be able to share the data with others that have no knowledge in databasing, There for I need to get them some graphic way to show the data. Toad does all what I need and much more, but the program is too complicated for my needs.
我正在研究经济项目,我需要在链表中管理大数据,并且有许多外键。我有几年的Oracle DBA经验,所以我可以毫无问题地管理所有这些,但我需要能够与其他没有数据库知识的人分享数据,我需要让他们以图形方式显示数据。 Toad完成了我需要的所有东西,但是这个程序对我的需求来说太复杂了。
Instead of wasting time on writing a program in C# that manages the data, I am looking for a good program that:
我没有浪费时间在C#中编写管理数据的程序,而是在寻找一个好的程序:
- Shows Main table/view data with option to filter/group/order with drop-box options
- Selects a row and shows data in linked tables by the selected row's data
- Makes report/data pages of my selected rows that I can adjust and print. (I know it's a bigger request)
显示主表/视图数据,可选择使用下拉框选项过滤/分组/订购
选择一行并按所选行的数据显示链接表中的数据
制作我可以调整和打印的所选行的报告/数据页面。 (我知道这是一个更大的要求)
In Addition, what is the most fit and easy DB for it? I worked only with Oracle but it's sure too much for that, so MySql? Access (I tried first to do all that in Access program but It's just too hard to adjust forms and so, and in the end you cannot make a publish version.
另外,最适合它的数据库是什么?我只与Oracle合作,但确实太过分了,所以MySql?访问(我首先尝试在Access程序中执行所有操作,但是调整表单太难了,因此最终您无法创建发布版本。
And the tables will be with start_date and finish_date that follow each other for same ID, But I don't think it will be a problem that I can maximum make view that shows only the last one. (BTW, what is the name of such table, I never knew that)
并且这些表将与start_date和finish_date相互跟随以获得相同的ID,但我不认为这是一个问题,我可以最大限度地使视图只显示最后一个。 (顺便说一下,这张桌子叫什么名字,我从来不知道)
1 个解决方案
#1
1
Take a look at Tableau http://www.tableausoftware.com
请访问Tableau http://www.tableausoftware.com
It will let users view the data many different ways, makes great visualizations and works with most databases. It's a read-only tool, so it's perfect for safe reporting, but you'll need to couple it with something else if you want your users to make changes to the data.
它将允许用户以多种不同的方式查看数据,实现出色的可视化并与大多数数据库一起使用。它是一个只读工具,因此它非常适合安全报告,但如果您希望用户对数据进行更改,则需要将其与其他内容结合使用。
You can define a connection in Tableau that sets up the relationships for users that don't understand foreign keys and the like. Or make views that hide those details, of course, regardless of the tool you choose.
您可以在Tableau中定义一个连接,为不了解外键等的用户设置关系。或者,无论您选择哪种工具,都可以制作隐藏这些细节的视图。
#1
1
Take a look at Tableau http://www.tableausoftware.com
请访问Tableau http://www.tableausoftware.com
It will let users view the data many different ways, makes great visualizations and works with most databases. It's a read-only tool, so it's perfect for safe reporting, but you'll need to couple it with something else if you want your users to make changes to the data.
它将允许用户以多种不同的方式查看数据,实现出色的可视化并与大多数数据库一起使用。它是一个只读工具,因此它非常适合安全报告,但如果您希望用户对数据进行更改,则需要将其与其他内容结合使用。
You can define a connection in Tableau that sets up the relationships for users that don't understand foreign keys and the like. Or make views that hide those details, of course, regardless of the tool you choose.
您可以在Tableau中定义一个连接,为不了解外键等的用户设置关系。或者,无论您选择哪种工具,都可以制作隐藏这些细节的视图。