Wednesday Dec 31, 2014

Top 5 Oracle Database Tech Releases of 2014

It was a great year for Oracle Technology...with so many great new features and products for Oracle DBAs, Data Scientists and Developers. Here's the Top 5 new technologies that we rolled out, with the resources you need to get started...from your friends here at the OTN Watercooler.

  • Oracle Database 12c -- ...with the long awaited In-Memory option, plus 21 new features. Oracle Database 12c Release supports Linux and Oracle Solaris (SPARC and x86 64 bit). See the full list of features with direct links to docs and resources. 
And if you're ready to start your upgrade journey to Oracle Database 12c, be sure to check out this Upgrade Starter's Guide and follow the Oracle Upgrade NOW blog
    • Oracle Database In-Memory -- Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with virtually any existing Oracle Database compatible application is as easy as flipping a switch--no application changes are required. It is fully integrated with Oracle Database's scale-up, scale-out, storage tiering, availability and security technologies making it the most industrial-strength offering in the industry.

      This whitepaper Oracle Database In-Memory gives you more detail about the new option available only in Oracle Database 12c, and if you want to get started, check out this article series:

    • Oracle Key Vault is a software appliance designed to securely manage encryption keys and credential files in the enterprise data center. It provides secure, centralized management of encryption keys and credential files including Oracle wallet files, Java KeyStores, Kerberos keytab files and SSH key files and SSL certification files.  Want to get started?  Here's what you need to know.

    • Oracle Big Data SQL -- Oracle's unique approach to providing unified query over data in Oracle Database, Hadoop, and select NoSQL datastores. Read more about why SQL is becomming the "GoTo" language for Big Data Analysis.

    • Oracle Oracle Zero Loss Recovery Appliance --Launched in October at OOW2014, The Oracle Zero Data Loss Recovery Appliance is a terrific addition to the Oracle Engineered Systems Portfolio. With its support for real-time redo transport, the appliance is designed to bring "Data Guard-like",  robust data protection for all the Oracle Databases in the data center. It's a sweet ride... Get the full story here.

      But as with most "Top" lists, there are many more items to include. So Special Mention goes to:

        JSON Support in Oracle 12c -- Oracle Database 12c supports JSON natively with relational database features, including transactions, indexing, declarative querying, and views. You can project JSON data relationally, making it available for relational processes and tools. You can also query, from within the database, JSON data that is stored outside the database, in an external table. Get more information about JSON support in Oracle Database 12c. You can start with the XML DB Developer's Guide.

      • Happy New Year and

        Ciao for Now!


      Tuesday Jul 15, 2014

      Oracle Big Data SQL - Bringing Structured Queries to an Unstructured World

      Oracle has just launched Oracle Big Data SQL.  Watch the replay of the web launch here.

      Oracle Big Data SQL

      And it's interesting.  Big Data is unstructured. It's widely varied. And it "sits" in many places. Stovepipes. Caves. Vaults. And thanks to innovations from the Exadata technologies, this unstructured data can now be successfully and efficiently queried using Structured Query Language. (SQL)  That is to say: An approach to providing unified query over data in Oracle Database, Hadoop and select NoSQL datastores.  It's a step beyond "federated" query.  It's actually much more than that. 

      It's the ability to run SQL queries that work seamlessly across multiple datastores. As Dan McClary points out in his blog on today's announcement, "Ideally, in a Big Data world, SQL should "play data where it lies," using the declarative power of the language to provide answers from all data."

      All data? or just the relevant data?  Oracle Big Data SQL decided to go for Relevant Data by empowering very complex SQL statements that zero in on the relevant information across all these datastores to get a more valuable set of data that clearly pinpoints trends to analyze.

      How? Unifying Metadata and Optimizing Performance.  

      Dan McClary's blog gives an excellent overview.

      Get more information.

      And watch for the download that will be available later this quarter on the OTN Database Community page.

      Ciao for Now!



      The OTN DBA/DEV Watercooler is your official source of news covering Oracle Database technology topics and community activities from throughout the OTN Database and Developer Community. Find tips and in-depth technology information you need to master Oracle Database Administration or Application Development here. This Blog is compiled by @oracledbdev, the Oracle Database Community Manager for OTN, and features insights, tech tips and news from throughout the OTN Database Community.


      « December 2015