Simple Event Processing - Using SQL with Analytical Functions to detect traffic patterns

One of the intriguing subjects at last weeks Oracle Open World conference for me was Complex Event Processing. The ability to process streams of real time events, and up to 1000s per second of them, opens up many new avenues of interesting opportunities. Detecting patterns and anomalies, aggregating and comparing - reporting only the noteworthy [...]

The AMIS team reports from Oracle Open World - big and small announcements, guidance and tips

Last night, the AMIS crew that visited the Oracle Open World conference reported their findings in a 3.5 hour session. In segments on SOA & BPM, Middleware, Database, Oracle Applications (AIA) and Development technology, we presented the highlights from close to 1900 sessions - no small feat. And utterly incomplete of course. However, all in [...]

Kom op donderdag 2 oktober naar de sessie “Verslag van Oracle Open World”

Zoals je wellicht hebt gemerkt was afgelopen week in San Francisco de Oracle Open World conferentie. Via deze blog hebben we al over allerlei ontwikkelingen op hoofdlijnen iets verteld. Aanstaande donderdag 2 oktober gaan we in veel meer detail vertellen over onze week op OOW. Dit is je kans om in drie uur te worden [...]

Oracle Application Test Suite - for functional and load/stress testing of Web Applications (including Applets) & Web Services

A recent acquisition by Oracle involved a company called Empirix, that sold its e-Test Suite product to Oracle. Oracle is now integrating this product with Enterprise Manager, under the new Oracle Application Testing Suite label. The e-Test Suite is used for functional - black box - testing of Web Applications (those applications with a client [...]

The secret is out: Oracle launches “The Database Machine” - becoming a hardware vendor!

A few hours ago, Larry did his keynote here at Oracle Open World 2008. The big announcement that had loomed over the conference has been made. Oracle - in joint partnership with HP - introduces the world’s fastest hardware for running databases and especially data warehouses: the Exadata Storage Server. Proud as father who shows [...]

OOW Sneak preview of Database Excel-erator - on the ADF Desktop integration

One of the sessions I attended yesterday at OOW was by Juan Camilo Ruiz, Product Manager for Oracle Development Tools. His talk was titled ‘Introduction to Oracle ADF Desktop Integration; An Office front-end for ADF Applications.’ He showed how we will be able to use Excel as the client for ADF applications. Instead of having [...]

OOW Presentation: Optimal Use of Oracle Database 10g and Oracle Database 11g for Modern Application Development

I just completed my second presentation here at Oracle Open World. It discusses Application Development inside and with the Database, introducing and discussing quite a few trends, concepts, best practices and new or rediscovered database features. It was nice presentation to prepare and to present: fun stuff, useful too and a very receptive audience. I [...]

Using Regular Expressions in Check Constraint - no more articles on Obama, McCain, Palin or Biden

Recently I was working on an RSS feed aggregator - a SQL Merge statement that through the use of httpuritype and XMLTable scans multiple RSS feeds and merges the news items from those feeds into a central RSS_ARCHIVE table. I soon discoveredthat the archive would become flooded with stories on the candidates for the US [...]

Nice little feature in ADF 11g: ‘target data source’ attribute on tree binding helps synchronize page with tree node selection

Due to jet lag, I have plenty of time to shop around in the candy store that is called ADF 11g. Occasionally, upon close inspection of this or that property inspector, I come across interesting little things that I might as well share with you. Just now I came across the property ‘target data source’ [...]

Oracle Beehive - Next Next Generation of Collaboration software

One of the major announcements during Charles Philips’ keynote: Oracle Beehive: integrated and secure collaboration platform.The successor to Oracle Collaboration Suite.Targeted at Enterprise Collaboration. And allegedly ‘built from scratch in 3 years’. The demo showed the Outlook Client running against the Beehive server. And not Outlook as we know it - Outlook extended with many [...]

News from OOW 2008: JDeveloper 11g and ADF 11g go production - TopLink 11g available today

It has been a while. But now we are finally about to witness the production release of JDeveloper 11g and ADF 11g including the ADF RichFaces components. Today, Oracle announced that JDeveloper 11g will be available for download from OTN from October 1st, in a little over a week. At that time, ADF 11g application [...]

Castle in the clouds or reality - Oracle Database and Cloud Computing

One of the major hypes in the IT industry is cloud computing. The cloud being a remote, top-notch infrastructure for data storage only or the combination of Storage and Computation that can be enlisted on demand. Organizations like Amazon who have world class systems engineering and IT infrastructure management can provide cloud infrastructure at a [...]

TopLink 11g is available for download

I just found that at OTN’s TopLink page the announcement is already published that was expected later today: TopLink 11g is available. Note that TopLink 11g is based on EclipseLink - an open source product under the Eclipse Foundation. All functionality of TopLink 11g is available in the open source product.Among the many new features [...]

DBA 2.0 - how options are really not optional or: “the infinite database”

After Web 2.0, Enterprise 2.0 and Wife 2.0, Oracle introduces the term DBA 2.0. It seems to refer to the DBA of the very near future. The one who can rely on a formidable pal hiding inside the database and taking on many of the boring, repeating tasks as well as advising on some of [...]

Building a repository of reusable ADF artefacts using ADF Libraries - for example: a reusable Placeholder Data Control

Reusability - and from there higher productivity and easier maintenance - is one of the key themes for ADF 11g. There are several important new concepts introduced in this new release, including Task Flows, Declarative Components, Page Templates and Page Fragments. It is of course one thing to create artefacts that are potentially reusable.  It [...]

OOW 2008: The Database - really BIG announcement (industry shocking …)

All the tell tale signs are their: nervous Oracle staff - looking around them to check out whether no one can read their minds, some intriguing but very unspecific rumors, quiet anticipation building like a low rumble in the distance that preceeds a hurricane, the series of Thursday sessions on one new topic that seems [...]

Oracle Open World 2008 - the show is about to begin - what are this year’s stars?

It’s a very early Sunday morning in San Francisco. Over the past few days, thousands upon thousands of people arrived into the city - all connected to Oracle in some way - many of whom who were not in the least connected to Oracle only a short time ago (BEA comes to mind, among others). [...]

Some more details on ADF Placeholder Data Control (rebind component, master detail, load sample data from CSV file)

In a recent article I gave a brief introduction of the ADF 11g Placeholder Data Control - see: ADF 11g Placeholder Data Control - for off line demonstration of application and/or rapid UI prototyping without a need for a business service - and the value of using that type of Data Control for User Interface [...]

ADF 11g Placeholder Data Control - for off line demonstration of application and/or rapid UI prototyping without a need for a business service

ADF applications are typically heavily into data. One of the major strengths of the framework is the data binding layer that allows rapid development of complex user interfaces bound to underlying data controls. These data controls expose data sources such as relational databases, web services, content management systems, JMX beans (as of 11g), REST/URL services [...]

Analyzing Match Scores in ‘fuzzy searches’ - explaining the shades of gray in a non-binary world

In a previous article - Not all has to be black and white in SQL Queries - , I discuss how not all searches are about perfect matches. The search for your lifelong partner, or your next job are fine examples of searches where a perfect match is hard to obtain. No single person or [...]