I have developed a web application driven by a mysql database that stores information about users, site usage, photo uploads (its a photo based site) etc. I have multiple databases storing data for different aspects of the site. I want to be able to produce reports for some of the questions I will have about how the site is growing and how it is being used. For example, how many new users have uploaded over a certain number of photos this month.
我开发了一个由mysql数据库驱动的web应用程序，该数据库存储关于用户、站点使用情况、照片上传(基于照片的站点)等信息。我有多个数据库，可以存储站点不同方面的数据。我希望能够为我将会遇到的关于网站如何发展和如何使用的问题提供一些报告。例如，本月有多少新用户上传了一定数量的照片。
What tools are available to analyse databases - i have been using a trial version of microsoft access and exporting each of the database as an xml file and importing to access, where I created the relationships and used the query wizard to generate some queries and reports. These are the activities I want to do and they produced the reports I want to have. I also want to be able to run queries across databases...
可以使用什么工具来分析数据库——我一直在使用microsoft access的试用版，并将每个数据库导出为xml文件并导入到access中，在那里我创建了关系并使用查询向导生成一些查询和报告。这些是我想做的活动，他们制作了我想要的报告。我还想能够跨数据库运行查询……
What other tools to people use for this sort of task with mysql databases? Is there any good advice / training materials about the workflow for creating such reports and managing this activity over time - eg should I take weekly exports of databases and run the queries to generate the reports?
在mysql数据库中，还有什么工具可以用于此类任务?关于创建此类报告和管理这个活动的工作流有什么好的建议/培训材料吗?例如，我应该每周导出数据库并运行查询来生成报告吗?
What are people's experiences of this type of task?
人们对这类任务的体验是什么?
all advice, input welcome.
建议,所有输入的欢迎。
4 个解决方案
#1
4
Welcome to business intelligence, the art of making information out of data.
欢迎来到商业智能，从数据中获取信息的艺术。
A usual architecture is Source --> ETL --> Data warehouse --> Reporting tools
通常的架构是源——> ETL——>数据仓库——>报告工具
ETL : extract transform load (today you are copying your databases but some free tools can help you change that : CloverETL, Talend, etc...)
ETL:提取转换负载(今天您正在复制您的数据库，但是一些免费工具可以帮助您更改:CloverETL、Talend等)。
Data warehouse : this is the place where you put your data and prepare it to be easily used in reports
数据仓库:这是您放置数据并使其易于用于报表的地方
Reporting tools: many free tools exist today such as BIRT, JasperReports, etc... but I strongly recommend QlikView, the personal version is free (if you don't need to share your results), it's a very easy tool to use.
报告工具:现在有许多免费工具，如BIRT、JasperReports等。但是我强烈推荐QlikView，个人版是免费的(如果你不需要分享你的结果)，它是一个很容易使用的工具。
#2
0
Speaking as someone who used to earn a living developing on MSAccess, I would strongly recommend using just about anything else.
作为一个曾经靠MSAccess谋生的人，我强烈建议使用其他任何东西。
Crystal reports is a good option. But IIRC the free version has disappeared.
水晶报表是个不错的选择。但是IIRC的免费版本已经消失了。
You might also have a look at JasperReports, ReportMan, BIRT, DataVision and Agata
你也可以看看JasperReports, ReportMan, BIRT, DataVision和Agata
#3
0
Have a look at myDBR a reporting solution based on PHP and mySQL. myDBR is very easy to install and lets you create reports within a few minutes.
看看基于PHP和mySQL的myDBR报告解决方案。myDBR非常容易安装，允许您在几分钟内创建报告。
You write your reports in SQL and myDBR then takes care of the layout and display of the report. This is different from most other solutions in that it allows you to concentrate on the content of your report instead of having to spend too much time on the look and feel.
您在SQL和myDBR中编写报告，然后处理报告的布局和显示。这与大多数其他解决方案不同，因为它允许您集中精力于报告的内容，而不必花费太多时间在外观和感觉上。
Here is a short example on how you could create a usage statistic for your site:
这里有一个关于如何为站点创建使用统计数据的简短示例:
select 'dbr.chart', 'Column', 'Usage statistics';
select name, count(*)
from user_access
group by name;
More examples are available at the myDBR demo site. myDBR is available as a free community version and a paid premium version (129 EUR).
更多的例子可以在myDBR演示站点上找到。myDBR是免费的社区版本和付费的高级版本(129 EUR)。
#4
0
If you does not want download the data every time it seems a good idea to install a software on the server. If you want a reporting software on the server then which platform do you use on server?
如果您不希望每次都下载数据，那么最好在服务器上安装一个软件。如果您想在服务器上使用报表软件，那么在服务器上使用哪个平台呢?
If you can't install software on server then you can use a PHP-MySQL Bridge. A PHP script. With a JDBC driver you can access it. Then you can use a Java based reporting tool. For example the free (yet fully functional) designer from i-net Clear Reports (used to be i-net Crystal-Clear).
如果您不能在服务器上安装软件，那么您可以使用PHP-MySQL桥接。一个PHP脚本。使用JDBC驱动程序，您可以访问它。然后您可以使用基于Java的报告工具。例如，来自i-net Clear报告(以前是i-net Crystal-Clear)的免费(但功能完整)设计器。
#1
4
Welcome to business intelligence, the art of making information out of data.
欢迎来到商业智能，从数据中获取信息的艺术。
A usual architecture is Source --> ETL --> Data warehouse --> Reporting tools
通常的架构是源——> ETL——>数据仓库——>报告工具
ETL : extract transform load (today you are copying your databases but some free tools can help you change that : CloverETL, Talend, etc...)
ETL:提取转换负载(今天您正在复制您的数据库，但是一些免费工具可以帮助您更改:CloverETL、Talend等)。
Data warehouse : this is the place where you put your data and prepare it to be easily used in reports
数据仓库:这是您放置数据并使其易于用于报表的地方
Reporting tools: many free tools exist today such as BIRT, JasperReports, etc... but I strongly recommend QlikView, the personal version is free (if you don't need to share your results), it's a very easy tool to use.
报告工具:现在有许多免费工具，如BIRT、JasperReports等。但是我强烈推荐QlikView，个人版是免费的(如果你不需要分享你的结果)，它是一个很容易使用的工具。
#2
0
Speaking as someone who used to earn a living developing on MSAccess, I would strongly recommend using just about anything else.
作为一个曾经靠MSAccess谋生的人，我强烈建议使用其他任何东西。
Crystal reports is a good option. But IIRC the free version has disappeared.
水晶报表是个不错的选择。但是IIRC的免费版本已经消失了。
You might also have a look at JasperReports, ReportMan, BIRT, DataVision and Agata
你也可以看看JasperReports, ReportMan, BIRT, DataVision和Agata
#3
0
Have a look at myDBR a reporting solution based on PHP and mySQL. myDBR is very easy to install and lets you create reports within a few minutes.
看看基于PHP和mySQL的myDBR报告解决方案。myDBR非常容易安装，允许您在几分钟内创建报告。
You write your reports in SQL and myDBR then takes care of the layout and display of the report. This is different from most other solutions in that it allows you to concentrate on the content of your report instead of having to spend too much time on the look and feel.
您在SQL和myDBR中编写报告，然后处理报告的布局和显示。这与大多数其他解决方案不同，因为它允许您集中精力于报告的内容，而不必花费太多时间在外观和感觉上。
Here is a short example on how you could create a usage statistic for your site:
这里有一个关于如何为站点创建使用统计数据的简短示例:
select 'dbr.chart', 'Column', 'Usage statistics';
select name, count(*)
from user_access
group by name;
More examples are available at the myDBR demo site. myDBR is available as a free community version and a paid premium version (129 EUR).
更多的例子可以在myDBR演示站点上找到。myDBR是免费的社区版本和付费的高级版本(129 EUR)。
#4
0
If you does not want download the data every time it seems a good idea to install a software on the server. If you want a reporting software on the server then which platform do you use on server?
如果您不希望每次都下载数据，那么最好在服务器上安装一个软件。如果您想在服务器上使用报表软件，那么在服务器上使用哪个平台呢?
If you can't install software on server then you can use a PHP-MySQL Bridge. A PHP script. With a JDBC driver you can access it. Then you can use a Java based reporting tool. For example the free (yet fully functional) designer from i-net Clear Reports (used to be i-net Crystal-Clear).
如果您不能在服务器上安装软件，那么您可以使用PHP-MySQL桥接。一个PHP脚本。使用JDBC驱动程序，您可以访问它。然后您可以使用基于Java的报告工具。例如，来自i-net Clear报告(以前是i-net Crystal-Clear)的免费(但功能完整)设计器。