[bestbird7788]

Hi, everybody
I need to conduct a large amount of data analysis on database. Could anyone recommend an interactive application for data analysis?
The requirements are:
1. Able to cope with the unexpected requirement rapidly.
2. Able to perform further computations on results interactively.
3. Easy to confront even a large amount of complex computations
What would you great expert recommend?
Thanks in advance.

[ElfBane]

bestbird7788, on 15 May 2012 - 11:19 PM, said:

Hi, everybody
I need to conduct a large amount of data analysis on database. Could anyone recommend an interactive application for data analysis?
The requirements are:
1. Able to cope with the unexpected requirement rapidly.
2. Able to perform further computations on results interactively.
3. Easy to confront even a large amount of complex computations
What would you great expert recommend?
Thanks in advance.

What was the DB created in?

[bestbird7788]

hi,ElfBane
mainly in MYSQL.
BTW, thank you for your reply.

[ElfBane]

Here's a link to several free DB analysis tools... http://www.computerw...on_and_analysis .

I don't know what your budget is, or your level of skill with DBs, so give this a try. If you wish to pursue this more thoroughly, you can google "database analysis software" (minus quotes) and see what's out there.

[bestbird7788]

ElfBane, on 17 May 2012 - 12:57 AM, said:

Here's a link to several free DB analysis tools... http://www.computerw...on_and_analysis .

I don't know what your budget is, or your level of skill with DBs, so give this a try. If you wish to pursue this more thoroughly, you can google "database analysis software" (minus quotes) and see what's out there.

thank you, I'm so grateful for your help.
I will check solutions you had recommended.But It's too many, I want to know Which one is more ideal you think.

I konw It's hard to image how to give a suggestion and make a choice without a discussible example.
So, I will give a discussible example below (with my friends's help, It's some difficult) ,please give me a suggestion about which solution is more fit for it, and how to use that solution to solve this problem( more details are ideal).

for example, I needs to compute the product whose annual sales values are all among the top 100
MSSQL data structure( sales table's fields): productID, time, value
SQL solution is as below:

WITH sales1 AS (
    SELECT productID, YEAR(time) AS year, SUM(value) AS value1
    FROM sales
    GROUP BY productID, YEAR(time)
)

SELECT productID
FROM (
    SELECT productID
    FROM (
        SELECT productID,RANK() OVER(PARTITION BY year ORDER BY      value1 DESC) rankorder 
    FROM sales1 ) T1
    WHERE rankorder<=100) T2
GROUP BY productID
HAVING COUNT(*)=(SELECT COUNT(DISTINCT year ) FROM sales1)

additional:I know well about Excel and common familiar with SQL.

This post has been edited by bestbird7788: 17 May 2012 - 07:07 PM

[bestbird7788]

ElfBane, on 17 May 2012 - 12:57 AM, said:

Here's a link to several free DB analysis tools... http://www.computerw...on_and_analysis .

I don't know what your budget is, or your level of skill with DBs, so give this a try. If you wish to pursue this more thoroughly, you can google "database analysis software" (minus quotes) and see what's out there.

I have read the article you recommended: http://www.computerw...18&pageNumber=2
I found there are only one software among section "Statistical analysis", It is "language R" (including RExcel). It seems interesting.
Do you know how to resolv the same problem (compute the product whose annual sales values are all among the top 100)?

[ElfBane]

bestbird7788, on 17 May 2012 - 10:06 PM, said:

ElfBane, on 17 May 2012 - 12:57 AM, said:

Here's a link to several free DB analysis tools... http://www.computerw...on_and_analysis .

I don't know what your budget is, or your level of skill with DBs, so give this a try. If you wish to pursue this more thoroughly, you can google "database analysis software" (minus quotes) and see what's out there.

I have read the article you recommended: http://www.computerw...18&pageNumber=2
I found there are only one software among section "Statistical analysis", It is "language R" (including RExcel). It seems interesting.
Do you know how to resolv the same problem (compute the product whose annual sales values are all among the top 100)?

I can't help you with actual coding. I'm not a programmer. I imagine there are software suites out there that can do sales analysis, but they may not be free. You'll have to find that out from someone else.
You may wish to ask your question on a MySQL forum, I'm sure they can help you better on one of those specialized forums.

[bestbird7788]

ElfBane, on 18 May 2012 - 12:49 AM, said:

bestbird7788, on 17 May 2012 - 10:06 PM, said:

ElfBane, on 17 May 2012 - 12:57 AM, said:

Here's a link to several free DB analysis tools... http://www.computerw...on_and_analysis .

I don't know what your budget is, or your level of skill with DBs, so give this a try. If you wish to pursue this more thoroughly, you can google "database analysis software" (minus quotes) and see what's out there.

I have read the article you recommended: http://www.computerw...18&pageNumber=2
I found there are only one software among section "Statistical analysis", It is "language R" (including RExcel). It seems interesting.
Do you know how to resolv the same problem (compute the product whose annual sales values are all among the top 100)?

I can't help you with actual coding. I'm not a programmer. I imagine there are software suites out there that can do sales analysis, but they may not be free. You'll have to find that out from someone else.
You may wish to ask your question on a MySQL forum, I'm sure they can help you better on one of those specialized forums.

Thank you. I'm willing to pay enough money for the correct software. Just like what u have said, It can not be free.
I had enough of SQL, It's too hard to maintain these indigestible SQL statements.
I think R maybe a ideal solution according your suggestion, But I'm not familiar with it, do you konw where I put that question about R is correct?( I mean compute the product whose annual sales values are all among the top 100)

[ElfBane]

I'm trying to lead you in the proper direction to find out what can help you. I, personnaly, am not qualified in DB software to give you credible advice on what to use. I suggest again you go to a specialized SQL forum to ask your questions. Good luck.

[datakeyword]

esProc seems what you want.
I copied some words below, hopes help-->
SQL (Structured Query Language) was initially developed in early 70s. To date, SQL is still a powerful, simple, and widely-applied database query language. However, the drawbacks of SQL are evident: non-stepwise computation, incomplete set-lization, no support for ordered set, and lack of object reference. Although several producers has developed a number of incompatible solutions, such as various stored procedures like PL-SQL®, and T-SQL®, these improvement solutions cannot solve the inherited SQL drawbacks.

As a query language of the new generation, esProc over-perform SQL in respect of computational capability, usability, and applicability.

the original link: http://www.esproc.co...erform-sql.html