Oracle Database Oracle Database Performance Testing the Easy Way We have developed a tool for testing Oracle database performance. The tool connects to a database, executes a set of SELECT statements, and records their execution times. It can also execute queries in parallel by using a connection pool of multiple connections, thus simulating a real-life workload on a database.
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 [http://ritt.md/UK-iscorked] 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
Oracle Metadata Modeling in the Database with Analytic Views 12.2 [http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html] , the latest Oracle database release provides a whole set of new features [https://docs.oracle.com/en/cloud/paas/exadata-express-cloud/csdbf/oracle-database-12-2-new-features.html#GUID-D0673E3E-DF05-47C3-B1E2-BEF91FA36CEF] enhancing various aspects of the product including JSON support, Auto-List Partitioning and APEX news
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 [https://docs.google.com/a/rittmanmead.com/forms/d/18XWPmrzr3te55rloDJyB8vFP9j8AUNKKryvOToGHBlA/viewform] is now open, with abstract submissions open to January 18th 2015. As in previous years the BI Forum will run over
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 [http://docs.oracle.com/
Technical Rittman Mead Featured in Oracle In-Memory Option Launch Today saw the official launch of the Oracle Database In-Memory Option [http://www.oracle.com/us/corporate/events/dbim/index.html], 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
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 [http://www.rittmanmead.com/biforum2014] 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 [https://www.rittmanmead.
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 [http://www.rittmanmead.com/biforum2014] 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
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 [https://www.rittmanmead.com/blog/2014/03/running-r-on-hadoop-using-oracle-r-advanced-analytics-for-hadoop/] , part of Oracle’s Big Data Connectors [http://www.oracle.com/technetwork/database/database-technologies/bdc/big-data-connectors/overview/index.html] and used for running certain types
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 [https://www.rittmanmead.com/blog/2013/10/odi-12c-journey/]) is because I've been writing an article focused on migration options from
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
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 [http://www.oracle.com/us/products/database/overview/index.html] as the underlying data source for OBIEE 11g, sometimes on Exadata but almost always the Enterprise Edition [http://www.oracle.com/us/products/database/enterprise-edition/overview/index.html] of the database.
Technical Oracle Database 12cR1 - New Features for BI & DW Oracle Database 12c Release 1 [http://www.oracle.com/us/corporate/press/1967380] 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
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
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 [http://www.rittmanmead.com/biforum2013] in Brighton [http://www.rittmanmead.com/blog/2013/05/previewing-the-brighton-bi-forum-2013/] , and then Atlanta [http://www.rittmanmead.com/blog/2013/05/agenda-and-details-for-the-atlanta-rm-bi-forum-2013/] , earlier this month in May 2013. Around
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
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
Technical BI, Data Warehousing and Data Integration News from Oracle Openworld 2012 This week is Oracle Openworld week in San Francisco, USA [http://www.oracle.com/openworld], 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
Technical OOW2012 so far... It's now half way through Oracle Open World 2012 [http://www.oracle.com/openworld/index.html] and I thought I would write up a brief update of what has happened so far. Last year saw the announcements of both Exalytics [http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/
Technical The PIVOT Clause is Only for Aggregates We briefly interrupt the transactional schemas [https://www.rittmanmead.com/blog/2012/06/using-obiee-against-transactional-schemas-part-1-introduction/] 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
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
Technical Basket Analysis in the Oracle Database Last time [https://www.rittmanmead.com/blog/2012/03/statistical-analysis-in-the-database/] 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
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
