Wednesday May 04, 2016

New in May 2016 Data Visualisation Desktop

Oracle’s Data Visualization portfolio expands further with the availability of Data Visualization on the desktop (“DVD”), making it easier and even more convenient for anyone to analyze any data, anytime, anywhere. 

Start now - Download DVD now from OTN (522Mb) and install to start working with your data in as little as 15 minutes.

Get an easy-to-use desktop capability that is part of a complete visual analytics solution to meet all your needs, from individuals to the entire organization, for IT and the business.

Grow as you go by using DV in the cloud (DVCS) or on the desktop (DVD), or both – whatever best suits your needs now, and in the future.

A key element in Oracle’s analytics strategy, Data Visualization Desktop (DVD) is a standalone capability that provides rich, consumer-style analytics, including intelligent data visualization, self-service data discovery, visual storytelling, and predictive analysis, as well as out-of-the-box access to numerous data sources and built-in data preparation.  Highlights and benefits include:

Easy, Engaging Visual Analytics: Oracle Data Visualization (DV) blends drag-and-drop simplicity with powerful analytics, making it fun and easy for anyone to blend, visualize, and gain new insight from their data.  DVD makes visual analytics even more accessible through a quick download and install, allowing anyone to have a local best-in-class visual analytics capability that includes new visualizations, free form layouts, custom coloring and highlighting, and more.  See here the new features video.

Anytime, Anywhere:  DVD complements DVCS, BICS, and BI 12c, making the same rich experience and technology available for personal use on the desktop.  DVD is ideal for organizations that are still sorting out their cloud strategy, offering easy access to visual analytics that creates a natural bridge between premises and cloud.  Equally, it offers cloud customers a simple solution for local analytics, enabling people to work anywhere they need to.    

Push-Button Data Management:  Point-and-click data blending allows users to blend data from a variety of sources – Oracle and other SaaS applications, on-premises systems, external sources and personal files, including:  OTBI/E, Oracle database, Spark, SQL Server, MySQL, DB2, Teradata, Redshift, Hive, Impala, MongoDB, SybaseIQ, and Salesforce.  DVD also offers integrated data preparation capabilities, enabling anyone to quickly clean and enhance data as it is loaded, as well as export to CSV files.

Predictive Analytics:  Analytics has progressed from providing oversight to offering insight, and now to enabling foresight.   Oracle Data Visualization supports that progression, delivering embedded predictive capabilities that enable anyone to see trend lines and other visuals with a click, and extend their analysis using a free R download. 

“Buy 1 Get 1 Free”:  DVD is packaged at no extra cost with DVCS and BICS, so customers who subscribe to those services receive a matching number of DVD licenses at no extra charge.  On premises, customers license Oracle Data Visualisation for $1250 per named user (minimum lowered to 1), and receive both DV for OBI12c and DVD; when OBI12c and DV are licensed by processor, customers get 80 licenses of DVD per processor, again at no extra charge.

Resources to help you include:

 

Monday Apr 18, 2016

Partner Webcast: Adding value to your current offering with Oracle Data Visualisation Cloud Service

19th May, 10am UK BST/11am CET - Register Now

“This is a superb tool for gaining the interest of key business executives in our customers, from which further business expansion opportunities will arise.”

What we will cover

Oracle Data Visualisation Cloud Service (DVCS) is a powerful user friendly tool which can complement your existing offerings and help you to maximize the value for your customers of your solutions with powerful visual analytics and storytelling. A business user can easily connect to Oracle SaaS Applications & Databases and ‘mash-up’ Excel files to provide them with the ability to gain valuable business insight.

It’s a very simple and easy, yet powerful way of being seen to add value without complexity to your customers, whilst being very cost effective at $150 / Named User / Month, 5 user minimum.

This session will explore how DVCS can help complement the value of your offerings through:

Delivering powerful visual analytics accessible to your business users

  • Quickly uncovering and sharing hidden patterns and actionable insights
  • Visual storytelling. 100% self-service on every device
  • Exploiting the data in your solution via the connectors to Oracle SaaS Applications, Databases & Excel Files

The session will include both presentation and live demo and will give you the capability to develop simple business related offerings relevant to your customers and talk them through its benefits.

Audience

This session is aimed at all Oracle Partners - To register for this event please click here.

And please Tell Your Customers about Data Visualisation

And access collateral from the DVCS Sales Campaign tools – Partner Folder *

(*To download, you need to gain access to the Emea Analytics Partner shared folder. If you do not already have access granted (e.g. the link above does not work), then send to Mike.Hallett@Oracle.com your Oracle.com logon-ID, and I will add you.)

Wednesday Feb 17, 2016

Oracle Committed to Leadership in the Analytics Market

A number of analysts comment on the analytics marketplace from time to time, such as Forrester or Gartner: and as an Oracle partner we ask you to position these most effectively with your clients.

Specifically with the latest one from Gartner, Oracle chose not to participate in this survey for 2016, and if your clients ask about this we would ask that you individually present this “Oracle_Gartner BI Magic Quadrants Guidance.pdf” to your personal client contacts.*

As this guidance makes clear, our perspective is that your customers need a bi-modal analytics strategy designed for speed and discovery, as well as for consistency and scalability. Our market leadership grows from the integrated combination of these two capabilities with the foundation of OBI12c now integrated with Oracle Data Visualisation.

Also check out his blog from our VP Rich Clayton - Oracle’s Perspective on the Analytics Market.

(*This “Oracle_Gartner BI Magic Quadrants Guidance.pdf” can be downloaded from the BI Modernisation 12c Sales Campaign Partner Folder: to get logon access to this if you do not yet have it, email your Oracle ID to Mike.Hallett@Oracle.com.)

Partner Training in BICS Implementation 3-day Workshops

Partners can apply to attend these 3-days/4-days hands-on workshops on Oracle Business Intelligence Cloud Service (BICS) to help you implement BICS solutions for your clients.

We invite you to join the workshop In-Class or Remotely (avoid travel time and travel costs by joining remotely). This hands-on workshop will be delivered at No-Fee to OPN Member Partners.

Workshop dates: For Remote Participation instructions will be provided in the confirmation email.

1st - 3rd March, 2016 - In-Class Location: Germany, Munich.

19th - 22nd April, 2016 - In-Class Location: France, Colombes.

30th May - 2nd June, 2016 - In-Class Location: South-Africa, Johannesburg.

Workshop time: 9:00 AM – 5:00 PM - Exact times will be informed with confirmation email.

IMPORTANT: These workshops are available to Oracle Partners with a current OPN Gold Level or higher membership. A fully executed Partner Demonstration Services Addendum is required for this training workshop. If your company has not previously accepted this addendum, please click here to review and accept the terms and conditions. You should be authorized by your company to accept the legal addendum.

The workshop will cover the following topics:

  1. Oracle Cloud Overview, BI Cloud Overview, Front end Development, Visualization, Analysis & Dashboards, Mobile
  2. Data Visualization deep-dive, Data Mash-ups, Advanced Analytics, BI Search (ASK), BICS Modeler
  3. Data Loading techniques with BICS, Remote and SaaS Data Connectors, Technical Demos, Examples, POCs and Best Practices, Roadmap
  4. Deep-dive Database Cloud Service for BICS, Lift And Shift from On-Premise to Cloud, Integrations, Oracle IaaS Overview for Admin/Developers.

Prerequisite

As a student on this class you are expected to know the following before attending the training:
Domain experience in Business Intelligence, Data Warehouse Design, Dimensional model, and database design is required: and knowledge of data integration tools is a plus.

Please watch the following videos:

System Requirements - This workshop requires attendees to provide their own laptop.

Registration:

To Register, please provide the following information to your local Alliances & Channel Manager or local Oracle A&C Enablement Contact: InClass or Remote, Partner Company, Participant's name, Participant's Corporate Email Address, Resident Country, Participant's Manager's Corporate Email Address.

Oracle A&C Enablement Contacts are:

Benelux: claude.schlesser@oracle.com
CEE: adam.krynski@oracle.com
CIS: natalia.brovarnik@oracle.com
Denmark, Finland: corry.weick@oracle.com
France: jean-jacques.panissie@oracle.com
Germany, Switzerland: corry.weick@oracle.com, alan.blakely@oracle.com
Israel: alan.blakely@oracle.com
Italy: monica.brambilla@oracle.com
MEA: ahmed.zaky@oracle.com
Norway, Sweden:
alan.blakely@oracle.com
Spain/Portugal: elia.hernandez@oracle.com
Turkey: selma.levent@oracle.com
UK: kate.lynskey@oracle.com

Tuesday Feb 16, 2016

Tell Your Customers about Data Visualisation

DVCS “info-walls” are live in seven languages - EN, FR, IT, DE, ES, TK and PL.

Here is a new “Info-Wall” you can tell your clients to check out to learn about the new Oracle Data Visualisation capability (DVCS).

You can also download a set of Sales tools from the DVCS Sales Campaign tools – Partner Folder: to get logon access to this if you do not yet have it, email your Oracle-ID to Mike.Hallett@Oracle.com.

Please also invite your customers to attend one of these Data Visualisation Cloud Service Webcasts for Customers that we are running from Oracle:

Business Area Focus

Time

Webcast Language

Date

Registration Link

Marketing

10.00 UK

English

17.02.2016

Registration Link

Marketing

09.30 CET

German

18.02.2016

Registration Link

Marketing

11.00 CET

French

18.02.2016

Registration Link

Sales

10.00 UK

English

09.03.2016

Registration Link

Sales

09.30 CET

German

10.03.2016

Registration Link

Sales

11.00 CET

French

10.03.2016

Registration Link

HR

10.00 UK

English

30.03.2016

Registration Link

HR

09.30 CET

German

31.03.2016

Registration Link

HR

11.00 CET

French

31.03.2016

Registration Link

Finance

10.00 UK

English

13.04.2016

Registration Link

Finance

09.30 CET

German

14.04.2016

Registration Link

Finance

11.00 CET

French

14.04.2016

Registration Link

Wednesday Jan 06, 2016

See and Try Data Visualisation for Big Data

By now you have probably already looked at how you can See and Try Oracle Data Visualisation to Re-Boot your Business, and maybe you are thinking how can you do this for your clients who have complex problems with large amounts of data in many different varieties of formats, probably with lots of text and documents (email, call-centre notes, asset maintenance logs, click streams, twitter, facebook…).

Maybe these clients have already started with Hadoop, but would like to be more productive in their “Data Science” and need to show their business executives some visual stories about the “big data” and how this can create business value.

To start with you can still use Oracle Data Visualisation to access data in Hadoop – for instance see this video demonstration @ OBI 12.2.1 : Visual Analyzer on Big Data. Here the information being used is joining database sets with structured data on Hadoop.

For un-structured, messy data, text information, and where the number of data-sets is large and being acquired so fast that your teams are finding it hard to define structures and prioritise where to start… then you need Oracle Big Data Discovery (BDD) to pre-analyse, mash-up, clean-up, and visualize the many different data sets together – and then to share your evolving insights and analysis with business analysts who can see the value and prioritise further work.

  1. For example I suggest you start with Getting Started with Oracle Big Data Discovery – Module 2: Process Overview (maybe even skip to 2.30 minutes into this video …).
  2. Then review the whole Oracle Big Data Discovery Playlists,
  3. And to download your own VM image with Hadoop, Oracle DB12c and BDD 1.1.1 try Download VM Oracle Big Data Lite 4.2.1 Including Big Data Discovery
  4. And then check back to Partners’ Get-Started-Kit with Oracle Big Data and Analytics and more articles at big and advanced.

 

For partners, we are running a series of 2-day technical training workshops on Big Data Discovery in EMEA (e.g. in UK), so look out to join these in your or nearby countries.

Hopefully this will get you more productive in your Big Data Science practices and help you visualize a greater variety of solutions and business value for your clients: or even just to make Hadoop a lot easier for your consultants to exploit.

Wednesday Dec 23, 2015

1-Day Sales Workshop for Oracle Partners on Data Visualization and Modern Analytics

9th February 2016 in UK – Click here for more information – Free to all OPN Partners in EMEA

Business users want Self Service data Visualization and analytics where they can quickly mash-up their data with integrated enterprise data from ERP systems and data warehouses and Big Data. Combining this with an explosion in the variety and quantity of data, traditional IT approaches are struggling to keep up with costs and skills.

In this 1-Day Workshop for Oracle Partners we will present and demonstrate how Oracle is successfully selling solutions that rapidly deliver business value, and help our existing customer base to modernise and exploit their current investments in Oracle products and expand into new technologies such as Hadoop.

Partners can seize this great opportunity for self-service Data Visualisation by prototyping and showing visual stories to their clients; convincing them on the agility and depth of analysis the partner can deliver with an integrated Oracle architecture.

Click here for more information – Free to all OPN Partners in EMEA

To prepare yourself you can preview some of the new visualization tools such as:

  1. See and Try Oracle Data Visualisation to Re-Boot your Business
  2. And see Oracle Big Data Discovery Demos
  3. There are also many BICS tutorials @ BI Cloud Service - Oracle Business Intelligence Cloud Service DocumentationVideos and Tutorials.

Tuesday Dec 22, 2015

See and Try Oracle Data Visualisation to Re-Boot your Business

2016 will re-boot your Oracle analytics business with the new Data Visualisation.  You can captivate your clients by exploiting the revolutionary ease of use and simplicity of deployment in the new Oracle data visualisation software and cloud services. Partners can deliver rich services to help setup and exploit rapid deployments for Data Visualisation, and then expand in many directions to enrich this initial project with the full stack of integrated Oracle analytics solutions.

Demonstrate and Learn about these most recent Oracle BI and Data Visualisation capabilities with more than 30 short videos arranged into playlists at YouTube-BI-Tech-Demos. These include:

  1. Try the software, by downloading the pre-built VM @ Demo OBI 12c and Visual Analyzer with SampleApp v511 Download,
  2. Or you can request a trial on the cloud with BICS and visual analyzer for yourself or your clients with the “Try it >” button @ Oracle BI Cloud Service (BICS),
  3. Or subscribe to the Data Visualization Cloud Service (DVCS) for $150 / Named User / Month with a 5 user minimum.

Monday Dec 21, 2015

Demo OBI 12c and Visual Analyzer with SampleApp v511 Download

The latest OBI SampleApp v511 prebuilt Virtual Box image includes OBIEE 12c, Visual Analyzer, Advanced Analytics & Oracle Database 12c. It provides numerous examples of OBI 12c capabilities, and includes the new features and capabilities of the OBI 12.2.1 release.

This SampleApp is a complete BI virtualized environment for demonstrating Oracle BI solutions. It provides a fully self-contained and configured environment with a comprehensive out of the box collection of examples to demonstrate Oracle BI capabilities, product integrations, and design best practices, including:

  • Visual Analyzer Projects
    • Numerous Visual Analyzer features and functional examples
  • Mashups & XSA datasets
    • Numerous external Mash-up demo datasets & examples
    • Joining datasets, persisting BI reports as datasets
  • BI 12c Native Advanced Analytics
    • Native Advanced Analytics Function Examples in VA and in Answers
    • R/ORE integration, R visualizations embedding in dashboards
  • For additional information refer to the whats new in SA 511 document via the OTN download page.

INSTALLATION - Download SampleApp v511 from OTN

  • To assist in getting started, installing and starting the services for Sample App v511 refer to the Quick Deployment Guide
  • For further assistance in getting started, visit the Oracle BI TechDemo YouTube video Step by Step demo on how to deploy this release. This 4 minute video demonstrates how to download, deploy, setup and run the Sample App v511.

Monday Nov 02, 2015

BICS Partner Training 2-day Workshops

We are running more “BI Cloud Service” BICS workshops which are 2 or 3 days in-class, or alternatively can be remotely attended as a web-class; consisting of presentations, live demos, and hands-on laboratory exercises with the objective to help BI consultants learn how to implement BICS for their clients.

Start Dates

Week days

Location

Country Contact

5-Nov-15

Thu-Fri

ES, Madrid

anamaria.gallego@oracle.com

7-Dec-15

Mon-Tue

UAE, Dubai

Details

1-Mar-16

Tue-Thur

GE, Munich

corry.weick@oracle.com

1-Feb-16

Mon-Wed

SE, Stockholm

corry.weick@oracle.com

To register, please provide the following information for all people from your company wishing to attend, to your local Oracle A&C channel manager contact: Workshop, Workshop date, Partner Company, Participant's name, Participant's Corporate Email. Participation instructions will be provided together with the confirmation email. If you do not know your local contact, then please address your registration request to the above country contact. More information is here @ Details.

Prerequisites - This workshop requires attendees to provide their own laptop. Students are expected to know the following before attending the training:

Tuesday Oct 27, 2015

New Data Visualization Cloud Service

Powerful, Easy-to-Use Visual Analytics Now Accessible to Every Business User

Oracle Data Visualization is now available to your clients in three forms:

  1. As an integrated add-on module to OBI 12c on-premise (OBI 12c Major Release is Available)
  2. Within BICS (BI Cloud Service)
  3. And now in DVCS (Oracle Data Visualization Cloud Service)

This makes rich, powerful visual analytics accessible to every business user. People at all levels of an organization can blend and analyze enterprise, personal or big data in just a few clicks, effectively sifting through data clutter to quickly uncover and share hidden patterns and actionable insights. All of this can be done without the need for expert IT resources, resulting in faster time to value and significant increases in ROI.

“Adoption and usage patterns at our 400+ Business Intelligence Cloud Service customers confirm that fast, easy-to-use data visualization is critical to their businesses,” said Hari Sankar, group vice president, Business Analytics, Oracle. “Oracle Data Visualization Cloud Service makes data visualization 100 percent self-service, empowering business users to go from raw data to actionable business insights in just a few minutes. This new service delivers rich visual analysis, rapid discovery of insights and secure collaboration, enabling fact-based decisions at every level of the organization.”

Oracle Data Visualization Cloud Service eliminates the complexity typically associated with blending and correlating data sets. Easy, automatic data blending allows users to combine data from a variety of sources—Oracle and other SaaS applications, on-premises systems, external sources and personal files—and immediately gain new insights using visual analysis. They can enrich the analysis with narratives to create stories that can be shared across the organization in a scalable, secure fashion. The creation and sharing of analytic insights is supported on mobile, tablet and desktop devices, enabling complete flexibility and unlimited access.

“Skanska implemented Oracle as a common BI solution for all users around the globe, for easy mobile access, self-service tools, and improved decision-making—and it reduced costs,” said Peter Bjork, vice president of information systems strategies, Skanska AB. Conny Bjorling, the senior business analyst driving the BI project on Bjork’s team, added, “Now with Data Visualization, we have something that is as visually compelling as it is easy to use. The storytelling functionality is a pivot point in terms of being able to explain your insights effectively.”

For more information see:

Monday Oct 26, 2015

OBI 12c Major Release is Available

BI 12c is the strategic foundation of Oracle’s analytics platform, delivering significant new value and lower total cost of ownership to the many existing Oracle BI customers, as well as being a compelling analytics platform for new customers.  BI 12c is critical to Oracle’s hybrid strategy, complementing BI Cloud capabilities by making fast, friendly data visualization and managed, scalable enterprise-class analytics available on-premises.

The new Data Visualization offering appeals to a large set of existing Oracle BI users, as well as opening up expansion opportunities with new users.

What’s New

BI 12c delivers a major update to the Oracle BI platform, with enhancements across the entire platform, as well as new Data Visualization capabilities.  Highlights and benefits include:

Easy to upgrade:  BI 12c offers a radically simple and robust upgrade from 11g, saving customers time and effort in moving to the new version.  BI 12c includes a free utility to automate regression testing, the Baseline Validation Tool, which verifies data, visuals, catalog object metadata, and system-generated SQL across 11g and 12c releases.

More Visual:  A consistent set of Data Visualization capabilities are now available across Oracle BI Cloud Service and Oracle BI 12c, as well as the upcoming Oracle Data Visualization Cloud Service, offering customers a continuity of visual experience unmatched by our competitors.  Business users can point and click to upload personal data and blend it with IT-managed data in BI 12c, which automatically infers connections between data sets.  Visualizing data is as easy as dragging attributes onto the screen, with optimal visualizations automatically displayed – no modeling or upfront configuration required.  Related data is automatically connected, so highlighting data in one visual, highlights correlated data in every other visual, immediately showing patterns and revealing new insights.  These insights, along with narrative comments, can be shared as interactive visual stories, enabling seamless collaboration that drives fact-based decisions.

More Advanced Analytics:  Predictive analysis is more tightly integrated, enabling customers to more easily forecast future conditions based on existing data points, group elements that are statistically similar, and expose outliers.  BI 12c includes the ability to run the free Oracle R distribution on BI Server, and extend existing analytics with custom R scripts, which can point to any engine (R, Oracle Database, Spark, etc.) without needing to change the BI RPD to deliver results.

More Mobile:  Keyword search (“BI Ask”) empowers users to literally talk to their data, asking questions and having visualizations automatically created as responses, opening up an easy entry point for authoring.  Additionally, the interface for iOS has been completely redesigned; and Mobile BI for Android offers sharing and following for nearby devices, as well as the ability to project any dashboard or story to GoogleCast-enabled devices.

Faster:  Sophisticated in-memory processing includes BI Server optimizations and support for multiple in-memory data stores, while in-memory Essbase on Exalytics offers enhanced concurrency and scalability, as well as significant performance gains.

Friendlier:  Usability updates throughout BI 12c demonstrate Oracle’s continued commitment to making analytics as fast, flexible, and friendly as they are powerful and robust.  A new user interface simplifies the layout for the homepage, Answers, and Dashboards, making it easier for users to quickly see what’s important; HTML-5 graphics improve view rendering; and it’s easier for users to create new groups, calculations, and measures, for simpler, more direct interaction with results.

Bigger Data:  BI 12c enables customers to use new data, from local, Oracle, and Big Data sources, including personal files uploaded by users; direct access to data in Hyperion Financial Management and Hyperion Planning applications; and ODBC access to Cloudera Impala.

Higher ROI, Lower TCO:  Streamlined administration and life cycle management reduce the time and resources required to manage BI 12c, decreasing costs and increasing value for this and future releases.  Enhancements include separating metadata from configuration; simpler, more robust security; easier backup, restore, and disaster recovery; hot patching of metadata; and many more.

Oracle BI 12c is available for download from OTN

 

Tutorials -

Oracle Big Data Discovery 2-day Training Workshop

Nov 18 - Nov 19, 2015 - Register Now

This 2-days workshop, FREE to OPN member partners in EMEA, provides attendees with hands-on experience using Big Data Discovery version 1.1

In this workshop, you will start with a visual catalog of data in Hadoop to quickly see data sets, then explore it visually to understand its shape, quality and overall potential. You will be able to transform and enrich data in Hadoop, without complicated modeling or programming, simplifying prep and making the data better for future projects. And of course the discovery interface will make it easy for you to combine data sets and search, navigate and visualize new insights, then share results by collaborating within the tool and also publishing results back to Hadoop.

Nov 18 - Nov 19, 2015 – For more information and to Register Click Here

Oracle Office Reading, Oracle Thames Valley Park

Oracle Parkway, Reading RG6 1RA

United Kingdom

Friday Feb 20, 2015

Oracle Big Data Discovery Now Available - The Visual Face of Hadoop


There has been a lot of excitement about Oracle Big Data Discovery, and it is now generally available to customers and partners and can be sold and installed now.

This is a stunningly visual, intuitive tool that enables you to leverage the power of Hadoop and turn raw data into business insight in minutes — without learning complex products or relying only on specialists.

From a partner perspective it is perfect for proof of concept work with your clients to reveal the value they can find in their large information reservoirs combining a variety of data and text sources; potentially leading to much more and deeper analysis as part of an overall big data information architecture.

To find out more see these videos:

Check out the Capabilities of Big Data Discovery to

  1. Easily find relevant data by browsing a rich, interactive catalog of all data in hadoop using familiar keyword search and guided navigation.
  2. Explore data to understand its’ potential by visualizing the shape and quality of unfamiliar data and combining attributes to uncover interesting relationships.
  3. Transform and enrich to make data better with intuitive, user-driven data wrangling.
  4. See rich, interactive visualizations that reveal new patterns by blending diverse data sets for deeper perspectives.

More Resources:

Thursday Apr 25, 2013

How much faster is the Oracle R implementation compared to “Normal” R ?

For those of you just getting interested in “Advanced Analytics”, you may still be wondering “What is R ?”… R is an open-source language and environment for statistical computing and data visualization: and it works with OBI to enrich the graphics and predictive capabilities: see here a quick preview on YouTube.

It is being taught in colleges and universities in courses on statistics and advanced analytics – often in preference to more traditional statistical software tools – and so skills in R are readily available among younger graduates.

For you experts in the field who use R anyway, the key question is why use “Oracle’s version” ?

The tight integration between R, Oracle Database 11g, and Hadoop enables R users to write one R script that can run in three different environments: a laptop running open source R, Hadoop running with Oracle Big Data Connectors, and Oracle Database 11g.

For large analyses on large Oracle data-sets, it is much faster and easier to do this “inside” the database, than exporting the data into another specialised external data format.  Some of the benchmarks below, show 4x ~ 20x + faster for various operations, and even 100x + for some data scoring algorithms.

For Oracle Advanced Analytics Option, Oracle R Enterprise in-DB functionality, the performance gains come through the R-to-SQL transparency layer for native SQL performance and the OAA/ORE “mapping” to the OAA/Oracle Data Mining SQL based hi-performance data mining algorithms and statistical functions that are native in-DB parallelized implementations of the algorithms. 

Also, besides the simpler and more scalable architecture, the majority of the performance gains stem from eliminating the extract, mine, apply models, import outer loop which can take weeks to months, largely due to “human time” sinks to manually translate the data transformations and model logic to native SQL for in-DB deployment.  That conversion process is tedious, time consuming and error prone.  The OAA in-DB performance therefore cuts that latency time down to secs / mins / hours.

About



Search

Archives
« May 2016
SunMonTueWedThuFriSat
1
3
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today