Posts tagged Database
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all help convey and define the message about Oracle’s strategy and the roadmap for its close to 4000 thousand products. Concurrent with OOW is the JavaOne conference that – at a slightly smaller scale – does the same thing for the world of the Java platform, the JVM and the Java community.
AMIS each year sends a substantial delegation to attend and contribute to the conference. We speak in many sessions, ask questions in even more and do our utmost to gather information, digest it and distill the real meaning and relevant details. We have just completed our yearly review of the Oracle OpenWorld and JavaOne 2013 conferences: a 60-page PDF document that answers the ultimate question about life, the universe and everything [Oracle].
This white paper describes the major transitions that the industry at large and Oracle in specific is going through. It explains what these transitions mean to Oracle, cause in terms of product evolution and will result in for the users. The major product announcements are listed and commented on. The roadmaps for the most relevant More >
In this article a second brain dump with observations from the Oracle OpenWorld and JavaOne conferences. These are fairly raw notes – primarily for my own consumption. They may be useful to you as well.Dual Format In-Memory Database
In Memory Column store, allowing Row-scanning at 1 Billion (10E09) rows per second per core, Joining 100x faster
Imagine this: You have consolidated you applications into one database (version 10gR2). You take a full backup every Tuesday and Thursday evening and an archivelog backup every few hours. These backups go to an NFS share, and not straight to tape. Everything is running fine until one day a new release of one of the applications messes up its data. Let’s assume that happened on a Wednesday evening.
Application management want’s you to restore the data of app_schema to just before the new misbehaving release went live.
DBA: Say what? Mgmt: Yes, we have a backup don’t we? So please put the data back to just before this release went live. We’ll come back with the exact time we want you to go back to.
What are your options? (more…)
OOW13: Sneak Preview of the Major Announcements?! In-Memory Database, PaaS (Database and Java) and M6 big memory machine0
Recent press releases as well as the comment provided by Oracle’s top brass around the FY14 Q1 earning provide some insight in what the key stories seem likely to be during this year’s Oracle OpenWorld conference. Note: I write this article before having any real information (that would put be under embargo such as a NDA).
Some remarks around the FY14-Q1 earning report by Mark Hurd seem to suggest certain areas of interest: “….a couple of comments about Oracle OpenWorld, which is next week. We plan to have roughly 60,000 people at the event in San Francisco from 145 countries. We expect to have 2 million attendees online.
And we will make some significant product announcements at the event as well. We’ll be introducing Oracle 12c in-memory database. We’ll be talking about it, being able to deliver 100x faster application performance using our new architectural approach. We’ll talking about — we’ll be talking about existing Oracle apps that can now run in the Oracle Database functionality without change when using this in-memory capability. We’ll have some releases in cloud. We’ll talk about we’ll have some releases in HCM and talent management, we’ll talk about database as a More >
Vanaf 22 september vindt in San Francisco de Oracle OpenWorld conferentie plaats: hét evenement waar Oracle haar productstrategie uit de doeken doet en waar Oracle specialisten van over de hele wereld ervaringen uitwisselen. Tegelijk met Oracle OpenWorld wordt ook de JavaOne conferentie georganiseerd, het trefpunt voor de wereldwijde Java gemeenschap. Meer dan 2.000 sessies, ruim 45.000 bezoekers en optredens van wereldberoemde artiesten; beide conferenties zijn zo groot dat zelfs de straat voor het gigantische Moscone Center door Oracle wordt overgenomen
Helaas kan niet elke Oracle of Java specialist zo maar naar San Francisco. Daarom heeft AMIS de traditie om je de inhoud en sfeer van Oracle OpenWorld mee te laten beleven. Op donderdag 5 september organiseert AMIS weer de Oracle OpenWorld Preview sessie. Nederlandse en Belgische sprekers verzorgen een preview van hun presentatie die zij enkele weken later op het podium in San Francisco gaan geven. Tijdens het diner hoor je de verhalen van eerdere conferenties, technische tips en trucs en kun je feedback geven op de presentaties.
In a recent post (http://technology.amis.nl/2013/07/24/oracle-database-12c-find-most-valuable-player-using-match_recognize-in-sql/) I described how we can use the new Oracle Database 12c MATCH_RECOGNIZE operator to spot patterns in records and derive results from those patterns. I used the MATCH_RECOGNIZE to find the most valuable player in a football team (US readers: I mean the sports that you may refer to as Soccer). My definition of the MVP is the player who is most frequently part of a period of uninterrupted ball possession ending with a goal. Whether the play scores the goal, presents the assist or is involved earlier on does not matter: if he was part of the play leading up to the goal – we count the contribution. However, the ball possession ends when a player from the other team has possession of the ball.
On closer inspection, this is a type of pattern that we can also find using a Recursive Subquery – albeit not as elegantly and presumably not as well performing.