Solved

Charting from Oracle database

Posted on 2014-10-15
4
441 Views
Last Modified: 2014-10-16
Hello,

Currently I have several excel templates which query Oracle and are used to update charts.  For the smaller files, it works well, but the larger excel files ~100MB's it is quite slow.  Does Oracle have something I could use to chart which would help with performance instead Excel?
0
Comment
Question by:jverasql
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40383338
Oracle's 'charting' is built in to Oracle Business Intelligence Enterprise Edition (OBIEE)
http://www.oracle.com/us/solutions/business-analytics/business-intelligence/enterprise-edition/overview/index.html

The bad part is, just like most Oracle products, it isn't cheap.

Can you do most/all of the processing at the database layer and only do presentation in Excel?

Instead of bringing back 100M of data, can you do whatever summarization necessary at the database?

If you can provide more information about what the charts do and the raw data, we might be able to provide some SQL or maybe a function/procedure to help.
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 40383344
The Oracle database does not, but the Oracle corporation has many products including business intelligence.

But a way to help you would be to see if the size of those files can be reduced.
Maybe the queries (that produce the files) could do more of the needed number crunching?
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 40384191
You could also try APEX.  It comes with a wide variety of charting options.
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 40384228
For free versions of preparing charts, you can try your queries with google chart apis

sample reference of how to incorporate your queries with google charts can be found here

http://www.pythian.com/blog/google-charts-for-dba-tablespaces-allocation/
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
get most recent and second most recent date in SQL Server 24 77
Maintaining Oracle Managed Accounts 2 29
Oracle and DateTime math 6 25
su - oracle could not open session 6 47
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Read about achieving the basic levels of HRIS security in the workplace.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now