Graphical process engine for Oracle.

marrowyung
marrowyung used Ask the Experts™
on
hi,

do oracle has graphical data model? so that for expensive operation like inner join, we can do it in graphical way so that inner join stuff can be by pass and use graphical process.

This is some time MS SQL use it for big data query.

Also will oracle trying to any kind of extra technology like GPU to speed up big data queries ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
It appears Oracle offers GPU based systems in their Cloud:
https://cloud.oracle.com/compute/gpu/features

From the following blog, Oracle seems to be working towards leveraging GPUs where necessary:
https://blogs.oracle.com/database/does-gpu-hardware-help-database-workloads
marrowyungSenior Technical architecture (Data)

Author

Commented:
MS SQL 2017 can work on this already for native R and Python support, I want to see if we can do the same thing in Oracle.
ok so only Oracle Cloud will offer it.
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
If you license Oracle Advanced Analytics, R is available:
http://www.oracle.com/technetwork/database/database-technologies/r/r-enterprise/overview/index.html

Now if that uses GPU resources or not, I have no idea.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

marrowyungSenior Technical architecture (Data)

Author

Commented:
that one is free ?

from here: http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf

seems need USD23000 as processor license, why need cost if R is open source ?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>why need cost if R is open source ?

I'm not an Oracle Employee but I'm guessing you pay for the seamless integration with the database.  You can always use R outside of the database and write Java or .Net external procedures if you want.  All free at that point.

Advanced Analytics also has a lot more than just R integration.
marrowyungSenior Technical architecture (Data)

Author

Commented:
" You can always use R outside of the database and write Java or .Net external procedures if you want. "

you mean run a R server outside of Oracle ?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>you mean run a R server outside of Oracle ?

Yes.  I'm not familiar with how it does what it does but since it exists outside of Oracle, I'm guessing it can run outside of Oracle.
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks. and I just add one more zone on it and see if someone on that field can comment
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial