Tag Archives: User Groups & Conferences
Thank You for Voting for Rittman Mead
Earlier in the year I announced that we had been nominated in 5 categories for the UKOUG Partner of the Year Awards. The award ceremony was last night and I’m proud to say that we received an award in each of the categories we entered and won two of them, results below:
- Business Intelligence – Gold
- Emerging (New Products) – Gold
- Engineered Systems – Silver
- Training – Silver
- Managed Services – Bronze
This is great recognition of the work everyone has put in at Rittman Mead across the group, from the Managed Services team we set up last year, to the investment we make in our training courses, the work we have done with Exalytics and the work we do with some of the new products, such as Endeca, R and RTD.
We very much appreciate the support of everyone who voted for us, it means a lot to everyone working at Rittman Mead.
Openworld is Over – Now We’re Coming to India..!
Oracle Openworld 2013 is now over, but no sooner have we unpacked from that trip, we’re packing again for our next one – our BI Masterclass Tour for India, starting in a few week’s time in Bangalore.
Running in partnership with ODTUG and with myself, Venkat Janakiraman and Stewart Bryson leading the sessions, we’re looking forward to sharing the news from Openworld, talking about the latest in Oracle BI and EPM development, and meeting Oracle BI enthusiast at each event.
The event is taking place over three cities – Bangalore, Hyderabad and Mumbia, with each masterclass running for a full day. We’ll go to Bangalore on Tuesday 15th October, Hyderabad on Thursday 17th October and then fly up to Mumbai for Saturday, 19th October 2013. Full details are on the event home page including details on how to register, with each masterclass’s agenda looking like this:
- 9.30am – 10.00am: Registration and Welcome
- 10.00am – 10.30am: Oracle BI, Analytics and EPM Product Update – Mark Rittman
- 10.30am – 11.30pm: Extreme BI: Agile BI Development using OBIEE, ODI and Golden Gate – Stewart Bryson
- 11.30pm – 12.30pm: OBIEE 11g Integration with the Oracle EPM Stack – Venkatakrishnan J
- 12.30pm – 1.30pm: Lunch & Networking
- 1.30pm – 2.30pm: OBIEE and Essbase on Exalytics Development & Deployment Best Practices – Mark Rittman
- 2.30pm – 3.30pm: Oracle BI Multi-user Development: MDS XML versus MUDE – Stewart Bryson
- 3.30pm – 4.00pm: Coffee Break & Networkng
- 4.00pm – 5.00pm: Intro and tech deep dive into BI Apps 11g + ODI
- 5.00pm – 6.00pm: Metadata & Data loads to EPM using Oracle Data Integrator - Venkatakrishnan J
The dates, locations and registration links for the three events are as follows:
- Bangalore, Fortune Select Trinity Hotel, Whitefield: October 15th 2013, 10am – 6pm (IST)
- Hyderabad, Westin Mindspace, Hyderabad, Hitec City: October 17th 2013, 10am – 6pm (IST)
- Mumbai, Courtyard Marriott, Mumbai: October 19th 2013, 10am – 6pm (IST)
We’re also investigating the idea of bringing our Rittman Mead BI Forum to India in 2014, so this would be a good opportunity to introduce yourself to us and the other attendees if you’d like to present at that event, and generally let us know what you’re doing with Oracle’s BI, EPM, analytics and data warehousing tools. There’ll also be lots of ODTUG goodies and giveaways, and a social event in the evening after the main masterclass finishes.
Numbers are limited though, and places are going fast – check out the event page for full details, and hopefully we’ll see some of you in either Bangalore, Hyderabad or Mumbai!
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). It was an excellent Oracle Openworld – probably the best in the ten years I’ve been going in terms of product announcements, and if you missed any of my daily updates, here’s the links to them:
- Oracle Openworld 2013 Day 0: Previewing the Week Ahead
- Oracle Openworld 2013 Day 1 : User Group Forum, News on Oracle Database In-Memory Option
- Oracle Openworld 2013 Day 2: Exalytics, TimesTen and Essbase Futures
- Oracle Openworld 2013 Days 3 & 4 : Oracle Cloud, OBIEE and ODI Futures
We also delivered sixteen sessions over the week, and whilst a few of them can’t be circulated because they contain details on beta or forthcoming products, here’s links to the ones that we can post:
- Deep Dive into OBIA 11.1.1.7.1 – Overview (Mark Rittman)
- Deep Dive into OBIA 11.1.1.7.1 – Data Integration (Stewart Bryson)
- Agile BI Development using OBIEE, ODI and Golden Gate (Stewart Bryson)
- Hyperion Profitability & Cost Management – Integration of Standard & Detailed Profitability (Venkatakrishnan J)
- Make the Most of your Exalytics and BI Investments with Enterprise Manager 12c (Mark Rittman, Henrik Blixt, Dhananjay Papde)
- Birds of a Feather Session: Best Practices for TimesTen on Exalytics (Mark Rittman, Chris Jenkins, Tony Heljula)
- Oracle BI EE Integration with Hyperion Data Sources (Venkatakrishnan J)
- Oracle Data Quality Solutions, Oracle Data Integrator and Oracle GoldenGate on Exadata (Jérôme Françoisse and Gurcan Orhan)
- Innovation in BI: OBIEE against Essbase and Relational (Stewart Bryson and Edward Roske)
- How to Handle Dev/Test/Prod with Oracle Data Integrator (Jerome Francoisse and Gurcan Orcan)
- Oracle Endeca User Experience Case Study at Barclays (James Knight and Kelvin Lau)
- Configuring OBIA 11.1.1.7.1 on ODI – Deep Dive (Mark Rittman, Kevin McGinley and Hari Cherukupalli)
So then, on reflection, what did I think about the various product announcements during the week? Here’s my thoughts now I’m back in the UK.
First off – Exalytics. Clearly there’s a lot of investment going into the Exalytics offering, both from the hardware and the software sides. For hardware, it’s just really a case of Oracle keeping up with additions to Sun’s product line, and with the announcement of the T5-8 model we’re now up to 4TB of RAM and 128 SPARC CPU cores – aimed at the BI consolidation market, where 1 or 2TB of RAM quickly goes if you’re hosting a number of separate BI systems. Cost-wise – it’s correspondingly expensive, about twice the price of the X3-4 machine, but it’s got twice the RAM, three times the CPU cores and runs Solaris, so you’ve got access to the more fine-grained workload separation and virtualisation that you get on that platform. Not a machine that I can see us buying for a while, but there’s definitely a market for this.
With Exalytics though you could argue that it’s been the software that’s underwhelmed so far, as opposed to the hardware. The Summary Advisor is good, but it doesn’t really handle the subsequent incremental refresh of the aggregate tables, and TimesTen itself whilst fast and powerful hasn’t had a great “out of the box” experience – in the wrong hands, it can give misleadingly-slow response-times, something I found myself a few months ago back on the blog. So it was interesting to hear some of the new features that we’re likely to see in “Exalytics v2.0″, probably late in calendar year 2014; an updated aggregate refresh mechanism based on DAC Server technology and with support for GoldenGate; new visualisations including data mash-up capabilities that I’m guessing we’ll see as exclusives on Exalytics and Oracle’s cloud products; enhancements coming for Essbase that’ll make it easier to spin-off ASO cubes from an OBIEE repository; and of course, the improvements to TimesTen to match those coming in the core Oracle database – in-memory analytics.
And what an announcement that was – in-memory column-store technology within the Oracle database, not predicated on using Exadata, and all running transparently in the background withminimal DBA setup required. Now in-reality, not only is this not the first in-memory Oracle database offering – the Exadata boxes in previous open world presentations also were positioned as in-memory, but that was flash memory, not DRAM – and they’re not the first vendor to offer in-memory, column-store as a feature, but given that it’ll be available to all Oracle 12.1.2 databases that license the in-memory option, and it’ll be so easy to administer – in theory – it’s a potential industry game-changer.
Of course the immediate question on my lips after the in-memory Oracle Database announcement was “what about TimesTen“, and “what about TimesTen’s role in Exalytics”, but Oracle played this in the end very well – TimesTen will gain similar capabilities, implemented in a slightly different way as TimesTen already stores its data in memory, albeit in row-store format – and in fact TImesTen can then take on a role of a business-controlled, mid-tier analytic “sandbox”, probably receiving new in-memory features faster than the core Oracle database as it’s got less dependencies and a shorter release cycle, but complementing the Oracle database an it’s own, more large-scale in-memory features. And that’s not forgetting those customers with data from multiple, heterogenous sources, or those that can’t afford to stump-up for the In-Memory option for all of the processors in their data warehouse database server. So – fairly internally-consisent at least at the product roadmap level, and we’ll be looking to get on any betas or early adopter programs to put both products through their paces.
The other major announcement that affects OBIEE customers, is, of course, OBIEE in the Cloud – or “Reporting-as-a-Service” as Oracle referred to it during the keynotes. This is one of the components of Oracle’s new “platform-as-a-service” or PaaS offering, alongside a new, full version of Oracle 12c based on its new multitenant architecture, identity-management-as-a-service, documents-as-a-service and so on. What reporting-a-service will give us isn’t quite “OBIEE in the cloud”, or at least, not as we know it now; Oracle’s view on platform-as-a-service is that it should be consumer-level in terms of simplicity to setup, and the quality of the user interface, it should be self-service and self-provisioning, and simple to sign-up for with no separate need to license the product. So in OBIEE terms, what this means is a simplified RPD/data model builder, simple options to upload and store data (also in Oracle’s cloud), and automatic provisioning using just a credit card (although there’ll also be options to pay by PO number etc, for the larger customers.)
And there’s quite a few things that we can draw-out of this announcement; first, it’s squarely aimed – at least at the start – at individual users, departmental users and the like looking to create sandbox-type applications most probably also linking to Oracle Cloud Database, Oracle Java-as-a-Service and the like. It won’t, for example, be possible to upload data to this service’s datastore using conventional ETL tools, as the only datasource it will connect to at least initially will be Oracle’s Cloud Database schema-as-a-service, which only allows access via ApEx and HTTP, because it’s a shared service and giving you SQL*Net access could compromise other users. In the future, it may well connect to Oracle’s full DBaaS which gives you a full Oracle instance, but for now (as far as I’ve heard) there’s no option to connect to an on-premise data source, or Amazon RDS, or whatever. And for this type of use-case – that may be fine, you might only want a single data source, and you can still upload spreadsheets which, if we’re honest, is where most sandbox-type applications get their data from.
This Reporting-as-a-Service offering though might well be where we see new user interface innovations coming through first, though. I get the impression that Oracle plan to use their Cloud OBIEE service to preview and test new visualisation types first, as they can iterate and test faster, and the systems running on it are smaller in scope and probably more receptive to new features. Similar to Salesforce.com and other SaaS providers, it may well be the case that there’s a “current version”, and a”preview version” available at most times, with the preview becoming the current after a while and the current being something you’ve got 6-12 months to switch from after that point. And given that Oracle will know there’s an Oracle database schema behind the service, it’s going to make services such as the proposed “personal data mashup” feature possible, where users can upload spreadsheets of data through OBIEE’s user interface, with the data then being stored in the cloud and the metrics then being merged in with the corporate dataset, with the source of each bit of data clearly marked. All this is previews and speculation though – I wouldn’t expect to see this available for general use until the middle of 2014, given the timetable for previous Oracle cloud releases.
The final product area that I was particularly interested in hearing future product direction about, was Oracle’s Data integration and Data Quality tools. We’ve been on the ODI 12c beta for a while and we’re long-term users of OWB, EDQ, GoldenGate and the other data integration tools; moreover on recent projects, and in our look at the cloud as a potential home for our BI, DW and data analytcs projects, its become increasingly clear that database-to-database ETL is no longer what data integration is solely about. For example, if you’re loading a data warehouse in the cloud, and the source database is also in the cloud, does it make sense to host the ETL engine, and the ETL agents, on-premise, or should they live in the cloud too?
And what if the ETL source is not a database, but a service, or an application such as Salesforce.com that provides a web service / RESTful API for data access? What if you want to integrate data on-the-fly, like OBIEE does with data federation but in the cloud, from a wide range of source types including services, Hadoop, message buses and the like. And where does replication come in, and quality-of-service management, and security and so forth come in? In my view, ODI 12c and its peers will probably be the last of the “on-premise”, “assumed-relational-source-and-target” ETL tools, with ETL instead following apps and data into the cloud, assuming that sources can be APIs, messages, big data sources and so forth as well as relational data, and it’ll be interesting to see what Oracle’ Fusion Middleware and DI teams come up with next year as their vision for this technology space. Thomas Kurian’s keynote touched on this as a subject, but I think we’re still a long way from working out what the approach will be, what the tooling will look like, and whether this will be “along with”, or “instead of” tools like ODI and Informatica.
Anyway – that’s it for Openworld for me, back to the real world now and time to see the family. Check-back on the blog next week for normal service, but for now – laptop off, kids time.
Oracle Openworld 2013 Days 3 & 4 : Oracle Cloud, OBIEE and ODI Futures
It’s getting to the end of day 4 of Oracle Openworld, with Team Oracle USA coming back from 8-1 down and pulling-off the unlikeliest of comeback victories, and Openworld sessions covering OBIEE, ODI and Oracle Cloud futures. Here’s the details:
1) Oracle’s Cloud Strategy
Last year Oracle announced a number of cloud initiatives, with database and java cloud service announcements followed by availability later in 2013. Unlike Amazon’s Web Services offering though which basically gave you an open platform for deploying database and web applications (Infrastructure-as-a-service, or “Iaas”), Oracle’s offerings last year were designed to be simpler, and offered you a single database schema in the case of the Database Cloud product, and a Java Cloud Service offering a single WebLogic managed server.
The Database Cloud Service only let you access the schema via HTTP and a RESTful API though, because providing SQL*Net access opened up security issues around the database listener, which left you with programmatic calls or uploading data via ApEx and spreadsheet uploads. Similarly, the Java Cloud Service was only really aimed at small applications and websites, and you could imagine building a simple web app using the Java Cloud front-end and the database cloud backend – but this was really PaaS (Platform-as-a-Service) and not something that would really be of interest to BI&DW developers - as there was no ETL capability and no way to run BI tools such as OBIEE.
In the meantime, organisations (such as ourselves) that wanted to run complete OBIEE, or a complete data warehouse, in the cloud have had to use services such as Amazon AWS, where compute, storage, network and other infrastructure are provided as-a-service, with few restrictions and with billing by the hour. In most cases, these are considered “BYOL” (bring your own license), with the customer providing the license, and also performing all the DBA and sysadmin work – what Amazon do is provide the virtual hardware, and host it for you in their cloud. Once you’re there though there are other options around the database – a few weeks ago I covered Amazon Redshift and EnterpriseDB as two alternatives to the Oracle database for cloud-based systems – and pricing for the Amazon AWS service itself is rock-bottom, making it quite an interesting option for customers that don’t have a big IT department, or big-company departments looking to spin-up sandbox or short-term development servers.
So Oracle’s announcements on Tuesday were very interesting – what they’re basically planning to offer is a direct competitor to Amazon AWS albeit Oracle-centric, so that they will in future offer infrastructure-as-a-service (basic compute, storage and networking services), alongside their existing platform-as-a-service; and, as we’ll see in a moment, they’ll also be offering applications such as OBIEE and their Fusion ERP stack as turnkey cloud applications with credit card sign-ups and consumer-level interfaces – this is Oracle moving full-scale into the cloud.
As well as this infrastructure-as-a-service offering, their platform-as-a-service database and java offerings will be expanded to now include full database-as-a-service, and a full WebLogic cluster-as-a-service to complement what’s now being referred to as schema-as-a-service and java-as-a-service. The full database-as-a-service (DBaas) will provide a full licensed Oracle instance (via the new pluggable database feature in 12cR1), your own listener, SQL*Net access and therefore the ability to ETL into it, but with backups and “tuning” covered in the background by Oracle’s staff.
Similarly, the updated WebLogic cloud service will support full WLST access, JMX interfaces and so on, arranged in a WebLogic cluster for high-availability and failover. So this setup will be conceptually similar to Amazon AWS, but run using Oracle software and with platform services designed around the needs of database, and Java application server, software.
No details on pricing and release dates were made in the session, but given last year’s releases I’d expect these to be available late summer next year.
2) OBIEE in the Cloud
So following on from the cloud keynote, the OBIEE roadmap session built on this announcement to provide details on their “reporting-as-a-service” offering, based on OBIEE but with a simplified, more consumer-style interface. What this seems to be offering is full OBIEE but with new, web-based tools for building the RPD, and with previews of new capabilities such as data mashups, faster previews of new visualisations, and a new cloud-style look and feel to match the rest of Oracle’s new cloud products.
Importantly though, reporting-as-a-service will come with a number of initial restrictions aimed at making the product as self-service and self-provisioning as possible; it’s likely that in the first iteration, it’ll only connect to the database schema-as-a-service offering, meaning that the only way you’ll get data in is via Apex and spreadsheet uploads or more likely, through Java applications you also build in Oracle’s platform-as-a-service cloud. Over time, presumably it’ll connect to the full DBaaS service making it possible to ETL data in, but for now it’s more aimed at departmental solutions and sandbox applications – but it’s a very interesting taste of the future.
3) ODI, and Moving to it from OWB
Moving on to today now, Rittman Mead’s Stewart Bryson along with Sumit’s Holger Friedrich presented alongside Oracle on ODI12c, with the session I attended being all about making the move to ODI from Oracle Warehouse Builder. ODI12c’s still in beta and we’re on the beta program, so I’ll have to be a bit circumspect with what I say on the blog, but in terms of the planned migration path from OWB, the plan from Oracle is that there’ll be three stages to a typical customer migration (if they want to migrate, that is):
1. From the first release of ODI12c, it’ll be possible to execute and monitor OWB jobs from within ODI, giving you a central place to run and control all of your Oracle ETL jobs
2. Then, shortly afterwards, there’ll be a command-line utility for migrating OWB project objects to their ODI equivalent, covering most object types but not process flows and data quality projects, for example
3. And then for all new ETL work, you’d use ODI 12c.
OWB itself will continue to be supported for many years, but the most recent release was the last one. Look out for more details on the blog once ODI 12c goes GA, and as one of the beta testers for the tool itself, and the migration utility, we’ll have a lot of advice and experiences to share once we’re allowed to talk about it publicly.
So that’s it for now – check back tomorrow for the last post in this series, where I’ll recap on the week
Oracle Openworld 2013 Day 2: Exalytics, TimesTen and Essbase Futures
Monday’s almost over at Oracle Openworld 2013 in San Francisco, and it started for me today with a presentation on Enterprise Manager 12c and the BI Management Pack, alongside Henrik Blixt (PM for the BI Management Pack) and Dhananjay Papde, author of a book on EM12c. I’ve covered EM12c and the BI Management Pack extensions quite a bit on the blog over the past few months so it was good to exchange a few ideas and observations with Henrik, and it was also good to meet Dhananjay, who’s been working with EM for a long time and has particularly specialized in the configuration management, and SLA-monitoring parts of the app.
Similarly, I finished-up the day with another joint session this time on TimesTen for Exalytics, with Peak Indicators’ Tony Heljula and Chris Jenkins, one of the TimesTen development PMs. As with all these sessions, it’s the audience interaction that makes them interesting, and we had a number of excellent questions, particularly at the TimesTen one given the very interesting product announcements during the day – more on which in a moment.
Before I get onto those though, here’s the links to today’s RM presentation downloads, with presentations today given by myself, Jérôme Françoisse (with Gurcan Orhan) and Venkat:
- Make the Most of your Exalytics and BI Investments with Enterprise Manager 12c (Mark Rittman, Henrik Blixt, Dhananjay Papde)
- Birds of a Feather Session: Best Practices for TimesTen on Exalytics (Mark Rittman, Chris Jenkins, Tony Heljula)
- Oracle BI EE Integration with Hyperion Data Sources (Venkatakrishnan J)
- Oracle Data Quality Solutions, Oracle Data Integrator and Oracle GoldenGate on Exadata (Jérôme Françoisse and Gurcan Orhan)
So, onto the product roadmap sessions:
1) Oracle Exalytics In-Memory Machine
The first set of announcements was around Oracle Exalytics In-Memory Machine, which started off as a Sun x86_64 server with 1TB RAM and 40 CPU cores, then recently went to 2TB and SSD disks, and now is available in a new configuration called Oracle Exalytics T5-8. This new version comes with 4TB RAM and is based on Sun SPARC T5 processes with, in this configuration, a total of 128 CPU cores, and is aimed at the BI consolidation market – customers who want to consolidate several BI applications, or BI environments, onto a single server – priced in this case around the $350k mark excluding the software.
What’s also interesting is that the T5-8 will use Sun Solaris on SPARC as the OS, giving it access to Solaris’ virtualisation and resource isolation technologies again positioning it as a consolidation play rather than host for a single, huge, BI application. Given the price I can’t quite see us getting one yet, but it’s an obvious upgrade path from the X2-3 and X2-4 servers and something you’d want to seriously consider if you’re looking at setting up a “private cloud”-type server infrastructure.
The Exalytics roadmap session also previewed other potential upcoming features for OBIEE, I would imagine earmarked for Exalytics given some of the computation work that’d need to go into the background to support them, including:
- A “Google Search” /. “Siri”-type feature called BI Ask, that presented the user with a Google-style search box into which you could type phrases such as “revenue for May 2010 for Widget A”, with the feature then dynamically throwing-up a table or graph based on what you’ve requested. Rather than attempting natural language parsing, BI Ask appears to work with a structured dictionary of words based on objects in the Presentation Services catalog, with choices available to the user (for example, lists of measures or dimensions) appearing under the search box in a similar manner to the “Google Suggest” feature.Although the demo was done using a desktop browser, where I think this could be particularly useful is in a mobile context, especially given most browsers’ and mobile platforms’ in-built ability to receive speed input and automatically pass that as text to the calling application. If you can imagine Siri for mobile analytics, with you holding your iPhone up and saying to it “revenue for southern region for past three months, compared to last year” and a graph of revenue over this period automatically appearing on your iPhone screen – that’s what I think BI Ask is trying to get towards.
- A user-driven data mashup feature that allowed the user to browse to a spreadsheet file on their local desktop, upload it to the OBIEE server (maybe to an Oracle Cloud database?), and then automatically join it to the main corporate dataset so that they could add their own data to that provided to the BI system. Clearly any setup like this needs to clearly differentiate between metrics and attributes uploaded by the user, compared to the “gold standard” ones provided as part of the RPD and Presentation Services Catalog, but this is potentially a very useful feature for users who’d otherwise export their OBIEE data to Excel, and then do the data combining there.
- Probably more for “Exalytics v2″, but a totally revamped aggregate refresh and reload framework, probably based around DAC technology, that would leverage the DAC’s own data loading capabilities and tools such as GoldenGate to perform incremental refreshes of the Exalytics adaptive in-memory cache. No specific details yet but it’s pretty obvious how this could improve over the current Exalytics v1 setup.
2) Oracle TimesTen for Exalytics
Yesterday of course had the big announcement about the new In-Memory Option for Oracle Database 12c, and this of course then led to the obvious question – what about TimesTen, which up until now was Oracle’s in-memory database – and what about Exalytics, where TimesTen was the central in-memory part of the core proposition? And so – given that I was on the TimesTen Birds of a Feather Panel this evening and no doubt would need to field exactly those questions, I was obviously quite keen to get along to one of the TimesTen roadmap sessions earlier in the day to hear Oracle’s story around this.
And – it actually does make sense. What’s happening is this:
- TimesTen’s development team has now been brought under the same management as Oracle Database 12c’s In-Memory option, with (over time) the same core libraries, and same performance features
- TimeTen will get the ability to store its tables (which are already held in memory) in columnar format as well as the existing row format – the difference being that unlike the Oracle in-memory feature, this is not done through on-the-fly data replication – it’s either stored row-store or column-store, something you decide when you create the table, and the only thing disk is used for is checkpointing and data persistence between reboots
- TimesTen will also gain the ability to be set up as a grid of servers that provide a single database instance – a bit like RAC and it’s single instance/cache fusion, and with support for replication so that you can copy data across the nodes to protect against machine failure. Currently you can link TimesTen servers together but each one is its own database instance, and you’d typically do this for high-availability and failover rather than creating one large database. What this grid setup also gives us though is the ability to do parallel query – Oracle didn’t say whether this would be one slave per grid node, or whether it’d support more than one slave per node, but coupled with the in-memory column store feature, presumably this is going to mean bigger TimesTen databases and a lot faster queries (and it’s fast already).
So what about the positioning of TimesTen vs. Oracle Database In-Memory Option – does one replace the other, or do you use the two together? Oracle’s ideas on this were as follows:
- Clearly the in-memory Oracle Database option is going to be a great query accelerator for large-scale data warehouses, but there’s still a lot of value in having a mid-tier in-memory data layer that’s under the control of the BI system owner, rather than the DBAs. You’ll have control over the data model, you can implement it quicker than you’d be able to upgrade the whole data warehouse database, and its physically co-located closer to the BI Server, so you’ll have less of an issue with network latency.
- TimesTen’s in-memory columnar storage technology will be based on a similar approach to that which is being taken by the database, and developed by the same overall team. But TimesTen most probably will have shorter development cycles, so new features might appear in TimesTen first, and it’s also lower risk for customers to test out new in-memory approaches in TimesTen rather than trying to reconfigure the whole warehouse to try out a new approach
And I think this makes sense. Of course, until we actually get hold of the two products and test them out, and see how the pace of development works out over time, we’re not going to fully know which product to deploy where – and of course pricing and packaging has yet to be announced; for example, I’d strongly predict that columnar storage for TimesTen will be an Exalytics-only feature, whilst the In-Memory Option for the database might be priced more like RAC than Partitioning, or even packaged up with Partitioning and OLAP as some sort of “data warehousing option”. We’ll just have to wait and see.
3) Oracle Essbase
The Essbase roadmap was the last session I managed to attend today, and again there were some pretty exciting new features announced or trailed (and it was made clear that the new features at the end of this list were more at planning or conceptual stage at the moment, and may well not make it into the product). Anyway, here’s what was talked about in the session, for BI and Exalytics-type use cases:
- Improved MDX query creation when working with the BI Server, including support for sub-selects – something that might help to reduce the number of separate MDX queries that OBIEE has to generate to work-out all the subtotals required for hierarchical column queries
- Improvements to the MDX AGGREGATE function and a revamped cube spin-off feature for OBIEE, including a prototype new web-based MOLAP Acceleration Wizard for auto-generating Essbase cubes for OBIEE aggregate persistence
- A new Cube Deployment Service private API, that’s used by the MOLAP Aggregation Wizard (amongst others) to generate and deploy an Essbase cube within a cloud-type environment
- A “renegade member” feature used for collecting in all the data load records for members that can’t be located – aimed at avoiding the situation where totals in an Essbase cube don’t then match the totals in the source system, because records got dropped during the data load
- Very speculatively – a potential hybrid BSO/ASO storage mode, combining BSO’s calculation capabilities with ASO’s dynamic aggregation.
So – lots of potential new features and a peek into what could be in the roadmap for three key OBIEE and Exalytics technologies. More tomorrow as we get to attend roadmap sessions for OBIEE in the Cloud, and ODI 12c.