Graphical process engine for Oracle.

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 ?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) 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.
slightwv (䄆 Netminder) 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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Maximize Customer Retention with Superior Service

The IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more to help build customer satisfaction and retention.

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 ?
slightwv (䄆 Netminder) 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 ?
slightwv (䄆 Netminder) 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Big Data

From novice to tech pro — start learning today.