Spark with a K – how Apache Spark is omnipresent at Oracle OpenWorld 2016

Apache Spark made numerous appearances in many different sessions during Oracle OpenWorld 2016. It is clear that Oracle is very much embracing and leveraging and endorsing Spark at various levels. Apache Spark is “a fast and general engine for large-scale data processing”. Spark has taken over from Hadoop MapReduce as the most prominent distributed job engine that organizes jobs – including sending the function to the distributed data and gathering the results. You can run (more...)

Oracle Public Cloud and Kafka – Events powering the cloud – The Oracle PaaS Cloud Event BusHub

Apache kafka.pngEvents are quite relevant in modern computer architecture. At various levels of the stack. Events can represent various things – from IoT based measurements and logistical updates to web site activities and business transactions to operational IT metrics and situations. Events can be produced at peak speeds and high volumes – and may require rapid and robust processing. Apache Kafka has grown into almost the de facto foundation for event processing. Apache Kafka provides high (more...)

Application Container Cloud and Multi Tenant Services – Oracle embracing 3rd party technologies and open source projects

The Oracle PaaS cloud is turning into the next generation application server platform. More specifically: Oracle has announced the roadmap for the Application Container Cloud Service (not to be confused with the plain Container Cloud Service which runs pre built Docker containers without looking into them). The Application Container Cloud Servic

  • accepts and runs applications (not containers) implemented in a number of technologies – Node.js, Java SE, PHP, Python, Ruby, Go and Spark/Hadoop (more...)

Oracle Database 12c Release 2 is out – just only on the cloud

Graphic for Getting Started pageThe next major release of the Oracle Database has always been a big thing. Last year at Oracle OpenWorld [2015], a lot of sessions were dedicated to Release 2 of Oracle Database 12c – with sharding as probably its most eye catching new feature. Talk of the release date started at once. June 2016 was a popular date in these talks. June came and went. And now, come Oracle OpenWorld 2016, R2 is out – (more...)

Oracle Functions – Serverless architecture on the Oracle PaaS Cloud

One of the interesting tidbits, somewhat hidden away in Thomas Kurian’s keynote presentation last week at Oracle OpenWorld 2016, is a new member of the Oracle PaaS Cloud Services family called Oracle Functions (or at least that seems to be the working title). Oracle Functions are serverless applications that are run on the Oracle PaaS infrastructure when one of its triggering events has been published.

The next screenshot shows a function as part of a (more...)

Oracle SQL Pattern Recognition – introducing the Match Recognize operator

imageOracle Database Release 12c (12.1) introduced a new operator that we can use in SQL queries. The MATCH_RECOGNIZE operator allows us to detect patterns in our relational data. Specifically: it allows us to identify records that mark the beginning of a set of records that together form a pattern. In this set, each record satisifies a certain condition. The fact that in a set of records these conditions are met – in a certain (more...)

New PL/SQL pragma (12cR2) to deprecate program units – sign of a modern programming language

Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2. One of the features that stood out was a new pragma deprecate that can be added to program units such as functions and procedures inside packages. This pragma is used to mark a program unit at deprecated, which typically means: the program unit is still valid, but has been superseded by a better option and (more...)

Next Step in Row generation in Oracle Database 12c SQL using JSON_TABLE

One of those things SQL developers are frequently looking at is the generation of rows: having a query return records that do not really exist. For example to generate test data or to produce records for all days in a month. Tom Kyte usually selects from data dictionary views. Various tricks make the rounds, for example based on CONNECT BY or CUBE or UNPIVOT. This blog article by Natalka Roshak (2015) compares various row generation (more...)

Publishing applications to Application Container Cloud Service from Oracle Storage Cloud

This weekend, while preparing for a demo during Oracle OpenWorld 2016, I found a for me new way of publishing a new [version of an]application to Application Container Cloud: through Storage Cloud. The application archive – zip or tar – can be stored on Storage Cloud and the deployment to ACCS can be performed from Storage Cloud. I am not yet sure if this makes for a better automated workflow. What it does give me (more...)