Oracle Spatial Machine Learning and Spatial for FREE in the Oracle Database Last week at UKOUG Techfest19 I spoke a lot about Machine Learning both with Oracle Analytics Cloud and more in depth in the Database with Oracle Machine Learning together with Charlie Berger, Oracle Senior Director of Product Management. As mentioned several times in my previous blog posts, Oracle Analytics Cloud
Oracle Metadata Modeling in the Database with Analytic Views 12.2, the latest Oracle database release provides a whole set of new features enhancing various aspects of the product including JSON support, Auto-List Partitioning and APEX news among others. One of the biggest news in the Data Warehousing / Analytics area was the introduction of the Analytic Views, that as
Technical Rittman Mead BI Forum 2015 Call for Papers Now Open! I’m very pleased to announce that the Call for Papers for the Rittman Mead BI Forum 2015 is now open, with abstract submissions open to January 18th 2015. As in previous years the BI Forum will run over consecutive weeks in Brighton, UK and Atlanta, GA, with the provisional
Technical Oracle 12.1.0.2 and Data Warehouses If you follow Blogs and Tweets from the Oracle community you won’t have missed hearing about the recent release of the first patch-set for Oracle 12c. With this release there are some significant pieces of new functionality that will be of interest to Data Warehouse DBAs and architects. The
Technical Taking a Look at the Oracle Database 12c In-Memory Option The In-Memory Option for Oracle Database 12c became available a few weeks ago with the 12.1.0.2 database patchset, adding column-store and in-memory capabilities to the Oracle Database. Unlike pure in-memory databases such as Oracle TimesTen, the in-memory option adds an in-memory column-store feature to the regular row-based
Technical Rittman Mead Featured in Oracle In-Memory Option Launch Today saw the official launch of the Oracle Database In-Memory Option, with Larry Ellison going through the product features and then reading out some quotes and testimonials from beta testers. Rittman Mead were part of the beta testing program, with several of our team testing out various scenarios where we
Technical Preview of Maria Colgan, and Andrew Bond/Stewart Bryson Sessions at RM BI Forum 2014 We’ve got a great selection of presentations at the two upcoming Rittman Mead BI Forum 2014 events in Brighton and Atlanta, including sessions on Endeca, TimesTen, OBIEE (of course), ODI, GoldenGate, Essbase and Big Data (full timetable for both events here). Two of the sessions I’m particularly looking
Technical Rittman Mead BI Forum 2014 Registration Now Open - Don't Miss Out! Just a quick reminder to say that registration for the Rittman Mead BI Forum 2014 is now open, with the speaker and presentation list now up on the event website. As with previous years, the BI Forum runs in Brighton on the first week, and then moves over to Atlanta
Technical Using Oracle R Enterprise to Analyze Large In-Database Datasets The other week I posted an article on the blog about Oracle R Advanced Analytics for Hadoop, part of Oracle’s Big Data Connectors and used for running certain types of R analysis over a Hadoop cluster. ORAAH lets you move data in and out of HDFS and Hive and
Technical New OTN Article: Making the Move from Oracle Warehouse Builder to Oracle Data Integrator 12c One of the reasons I've been silent on the blog lately regarding new Oracle Data Integrator 12c content (even though I promised it some months ago) is because I've been writing an article focused on migration options from Oracle Warehouse Builder (OWB). Published recently on OTN, this article hopefully helps
Oracle BI Suite EE Oracle Openworld 2013 : Reflections on Product Announcements and Strategy I'm sitting writing this at my desk back home, with a steaming mug of tea next to me and the kids pleased to see me after having been away for eight days (or at least my wifepleased to hand them over to me after looking after them for eight days)
Technical Oracle Openworld 2013 Day 1 : User Group Forum, News on Oracle Database In-Memory Option The Sunday before Oracle Openworld proper is "User Group Forum Sunday", with each of the major user groups and councils having dedicated tracks for topics such as BI&DW, Fusion Development, Database and so on. Stewart, myself and Venkat were honoured to be presenting on behalf of
Oracle BI Suite EE Using Non-Oracle, and Cloud-Hosted Databases with OBIEE 11g The vast majority of our customers use Oracle Database as the underlying data source for OBIEE 11g, sometimes on Exadata but almost always the Enterprise Edition of the database. OBIEE typically sells best into customers that already extensively use Oracle products, and often it's often bundled-in with a wider technology
Technical Oracle Database 12cR1 - New Features for BI & DW Oracle Database 12c Release 1 came out last week, initially available for 64-bit Linux and Solaris (SPARC and x86_64), with the Windows and other versions presumably due over the next few months. So what's in this new release for Oracle BI & DW customers, and how does compatibility stand
Technical Using Oracle TimesTen With Oracle BI Applications (Part 1) Oracle BI Applications (OBIA) is a product for delivering industry best-practice dashboards and analysis over enterprise sources such as ERP, HR, SCM and CRM systems. OBIA includes the necessary functionality to extract data from the source systems, transform and load it to the target database's standardised data model and to
Oracle BI Suite EE Photos and Presentation Downloads from the Rittman Mead BI Forum 2013, Brighton & Atlanta Well, we're all back home now after two very successful Rittman Mead BI Forum events in Brighton, and then Atlanta, earlier this month in May 2013. Around 70 OBIEE, ODI, Endeca and Essbase developers from around Europe got together in the first week in Brighton, followed by around 60 in
Technical You Probably Need Parallel Except When You Don't My last post looked at some aspects of performance tuning that would make traditional DBAs blanche with horror, not once did I mention indexing, partitioning, PCTFREE or parallel. This was not because I don't consider them important, but more that the simple test of "am I doing the right thing"
Technical Oracle Exalytics, Oracle R Enterprise and Endeca Part 2 : Oracle Endeca, the Advanced Analytics Option and Oracle Exalytics In this week of postings we're going to look at Oracle Exalytics and how it enables "big data" and unstructured data analytics, using Oracle Endeca, Oracle Exadata, Oracle Big Data Appliance and the Oracle Database Advanced Analytics option. In case you've arrived via a Google search and you're interested in
Technical BI, Data Warehousing and Data Integration News from Oracle Openworld 2012 This week is Oracle Openworld week in San Francisco, USA, with around 50,000 attendees attending Openworld itself, Java One and fringe events such as Oaktable world. Rittman Mead have had ten sessions during the week, covering topics such as OBIEE, Endeca, data warehousing, Essbase and EPM, Exalyics and Oracle
Technical OOW2012 so far... It's now half way through Oracle Open World 2012 and I thought I would write up a brief update of what has happened so far. Last year saw the announcements of both Exalytics and the acquisition of Endeca, I didn’t expect the same sort of excitement this year for
Technical The PIVOT Clause is Only for Aggregates We briefly interrupt the transactional schemas series for this important message: the PIVOT clause of SELECT is only for aggregates! When Oracle added the PIVOT and UNPIVOT operators in Database 11g, at first, I was hopeful. It certainly scratched an itch that had been around in the Oracle DW space
Technical Tuning Philosophy - Hints This week Stewart, Mark and I are at Collaborate 12 in Las Vegas - look us out if you are at the conference. Long flights (it's about 10 hours from the UK to Las Vegas) give me plenty of blogging time so I decided to write a few new blogs.
Technical Basket Analysis in the Oracle Database Last time I gave a taster of my forthcoming Collaborate 12 talk on techniques beyond the traditional "slice and dice" that we know so well. I wrote mainly about the ways in which we can perform statistical analysis on our data either through SQL or by using R.
Business Insights Statistical Analysis in the Database My first ever presentation at the UKOUG conference (long before I started working with Mark Rittman and Jon Mead) was an introduction to analytic functions. Since then analytics have remained a key part of my work as a DW developer; many of the processes that I have implemented would be
Oracle BI Suite EE Real-time BI: EDW with a Real-time Component I apologize for the long delay in getting this last portion of the Real-time discussion in place. Since I wrote the first two installments, we've had the BI Forum (US and UK versions), plus a flurry of activity around Rittman Mead in the US, followed up by KScope11. But a
