Viewing entries in
2014

Comment

2014-12 – JSON in Oracle Database 12c

With the release of Database 12.1.0.2, Oracle introduced a new functionality oriented to exchange information in JavaScript Object Notation (JSON) data format between applications and the database engine.

JSON is a language-independent data format based on the JavaScript Programming Language often used for exchanging structured data between heterogeneous web applications.

JSON database implementation allows you store and retrieve data between the applications and the database engine conforming to the JSON standard avoiding the need of writing custom procedures and special code.

Comment

Comment

2014-11 – Identity Columns in Oracle 12c

In an effort to simplify the migration process from other RDBMS sources to Oracle databases, Oracle introduced in version 12c a new feature called “Identity Columns”.

Based on a sequence generator, the identity column will be assigned an increasing integer value from this sequence generator. Identity columns are automatically incrementing columns and can be indexed as any other column type.

Comment

Comment

2014-10 – Using File Watchers

Introduced in Oracle Database 11g Release 2, file watchers allow triggering jobs when a new file is created in a predefined operating system path. A file watcher can watch for a file on the local system or a remote system. As prerequisite to use file watchers, the database Java virtual machine (JVM) component must be installed.

Comment

Comment

VMworld Presentation: Database-as-a-Service Demo

Video demonstration of deploying 50 Oracle 12c databases using vRealize Automation (formerly vCloud Automation Center) on a Pure Storage All-Flash array in 22 minutes. This demo was presented in two sessions during VMworld 2014 US along with being featured in the Pure Storage booth. It was also presented at the VMware booth in the vCloud Automation Center and Virtualizing Business Critical Applications streams.

Comment

Comment

2014-09 – Oracle In-Memory Database

With Oracle Database 12.1.0.2, Oracle has released its In-Memory Database functionality. In short, Oracle In-Memory database provides transparent column-format memory access over an existing Oracle database. The normal row-format memory access is preserved for fast OLTP transactions; however, with new system parameters, that same data can be accessed from memory in column-format, drastically improving OLAP performance. Because it is transparent, there is no need to change applications to leverage this new functionality, which had previously only been exposed in engineered systems and ZFS as storage-level optimizations.

Comment