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!


Thursday Jul 10, 2014

Database Application Development VM--Get It Now

Learning your way around a new software stack is challenging enough without having to spend multiple cycles on the install process. Instead, we have packaged such stacks into pre-built Oracle VM VirtualBox appliances that you can download, install, and experience as a single unit. Just downloaded/assemble the files, import into VirtualBox (available for free), import, and go (but not for production use or redistribution)!

Some of these VMs are designed to support Developer Day workshops, and have specific hands on labs embedded in them, but they're available to all. Just be sure to install VirtualBox first.

VirtualBox is powerful Cross-platform Virtualization Software for x86-based systems.
"Cross-platform" means that it installs on Windows, Linux, Mac OS X and Solaris x86 computers. And "Virtualization Software" means that you can create and run multiple Virtual Machines, running different operating systems, on the same computer at the same time. For example, you can run Windows and Linux on your Mac, run Linux and Solaris on your Windows PC, or run Windows on you Linux systems. 

Oracle VM VirtualBox is also available as Open Source or pre-built Binaries for Windows, Linux, Mac OS X and Solaris. GET IT HERE.

The DBA/DEV Crowd Favorite:    --> The Database Application Development VM <--

Kris Rice spends a lot of time grooming this little virtual environment...see all the exercises and tutorials he has included and let us know what you think!  

Ciao for Now!


Tuesday Jul 08, 2014

What's New in Oracle JDBC?

 If you're talking database connectivity, JDBC deserves a good look.

According to Sun's JDBC page, the Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases—SQL databases and other tabular data sources, such as spreadsheets or flat files. The JDBC API provides a call-level API for SQL-based database access. JDBC technology allows you to use the Java programming language to exploit "Write Once, Run Anywhere" capabilities for applications that require access to enterprise data. With a JDBC technology-enabled driver, you can connect all corporate data even in a heterogeneous environment.

Which version of JDBC drivers support which version of Oracle database?

Check out this table for the Oracle database versions supported by JDBC drivers.  Best Practice that we recommend is, JDBC driver version should always be either same as or higher than the Oracle database version being used in order to leverage the latest capabilities of the JDBC driver. 

Interoperability Matrix Database 12.1.0.x Database 11.2.0.x Database 11.1.0.x


JDBC 12.1.0.x
JDBC 11.2.0.x
JDBC 11.1.0.x
JDBC 10.2.0.x

Whats New in JDBC?

  • Support for Latest Java Standards:  Oracle JDBC and UCP now support JSE 7 with JDBC 4.1 specification. 

  • Support for Multitenant Container Support:The Oracle database 12c introduces a new multitenant architecture consisting of a root infrastructure called Container Database(CDB) which contains exclusively Oracle provided metadata, then a set of pluggable databases(PDBs), which are full fledged databases containing customers, applications data and metadata. Oracle JDBC and UCP furnish the Multitenant Datasource for Java by allowing sharing a single pool of connections across multiple PDBs i.e., tenants.  

  • Support for New SQL DataTypes: Java pplications may leverage new data types including: 32K VARCHAR, NVARCHAR, and RAW, invisible/hidden columns, implicit results, auto-increment or IDENTITY columns, PL/SQL packaged types and AS parameters, larger row count data type, and XStream enhancements. 

  • Improved Performance and Scalability:New performance and scalability enhancements include: New JDBC memory managemen, Database Resident Connection Pool (DRCP), very large network buffers(SDU), and RuntimeConnections Load Balancing across geographies (Global Data Services). 

  • Transaction Guard and Application Continuity for Java: When a database outage occurs, four problems confront applications:(1) hangs, (2) errors, (3) determining the outcome of in-flight work and (4) the resubmission of in-flight work.  Oracle database 12c handles these outages better throughTransaction Guard for a reliable outcome of in-flight work and Application Continuity for capturing and replaying in-flight transactions.

  • Better Manageability, Ease of use:Oracle database 12c furnishes row count per iteration for array DML,monitoring and tracing database operations, intelligent client connectivity and faster dead connection detection. 

  • Advanced Security:With Oracle database 12c, JDBC now supports SHA-2 hashing algorithms(including:SHA-256, SHA-384,and SHA-512) to generate secure message digests. Overall,Java applications can use the following hashing algorithms:MD5, SHA1, SHA-256, SHA-384 or SHA-512. 

  • Easier Applications Migration: Solves the problem for migrating Java applications built against non Oracle RDBMS.  Oracle 12c provides a framework for translating foreign SQL syntax into Oracle SQL syntax before being submitted to the Oracle RDBMS, SQL engine for compilation and execution. 

    Get the whole story from the JDBC page on OTN.

    Download JDBC Drivers and Documentation HERE.

    Ciao for now!


Friday Jun 20, 2014

The OTN Virtual Technology Summit--and Bobby Curtis

"You're stressing me out just a little bit..."  said Oracle ACE Bobby Curtis.

That was his response yesterday to our rapidly closing timeframe for producing his session for the upcoming Virtual Technology Summit Series.  

I had to laugh. 

And it confirmed for me that I definitely picked the perfect Oracle ACEs and experts to present sessions during the VTS Database Track.  

First of all, these guys are smart. Secondly, they are entertaining. And third of all, they know how to scramble the jets.

Here's what we're lining up for the OTN VTS Database Track on July 9th:

Mastering Oracle Database Management & Development Techniques – Oracle ACEs and product team experts present advanced features and management methods that will help you master your Oracle Database capabilities and drive greater performance, agility and manageability of your IT implementation. This track will build upon your skills with data management, migration, and performance.

Change the Way You Think About SQL Tuning with SQL Plan Management 
Bjoern Rost, Oracle ACE Director

Regression in SQL plans are a frequent cause for performance related incidents when the cost-based optimizer comes up with a new plan due to changes in data distribution, statistics, or binds. While most organizations have very strict processes for changes to applications or infrastructure, the CBO is most often left alone, accepting that SQL execution performance could change at any time. But with SQL Plan Management (SPM), it does not take much effort to implement a process that makes changes to SQL plans manageable. It starts with monitoring regression in execution times, capturing baselines, auto pre-evaluating potentially better plans, and documenting information needed to accept the change. Attendees will learn how SPM works, and how they can start using it in their organization today.

Understanding Oracle GoldenGate replication architecture: Performance tuning all the way to the OS level--
Bobby Curtis, Oracle ACE

During high transaction volume replication, Oracle Golden Gate 12c may need to be configured to ensure rapid fast data replication through each of its core processes (extract/replicat). Understanding what each of these GoldenGate processes is doing is necessary so the replication process can be tailored to ensure fast replication in any environment. This session examines replication use cases and identifies what each process is executing in order to ensure successful replication between environments. Attendees will learn an approach to the performance tuning methodology of Oracle GoldenGate 12c that traces the extract and replicat processes with debugging tools like strace or gdb-- thereby identifying any replication bottlenecks at the OS level.   By the end of the session, attendees will  have an understanding of how Oracle GoldenGate 12c behaves at the operating system layer and an increased understanding of Oracle’s GoldenGate replication architecture.

Oracle Data Guard and Oracle Database Server 12c
Ed Whalen, Oracle ACE

High Availability and Disaster Recovery are an important part of any company's business continuance plan. Oracle Data Guard is Oracle's recommended product of choice for Disaster Recovery (DR).  This session covers the new features and enhancements to Data Guard in the Oracle Database Server 12c and highlights: how to configure Oracle Data Guard with Container Databases and how to optimally use OEM Cloud Control 12c with Data Guard for Oracle Database 12c. Attendees will learn the new features in Data Guard 12c, understand why these new features improve Data Guard 12c, and learn what new features in OEM Cloud Control 12c Monitoring for Data Guard 12.

NoSQL 3.0 Installation and Cluster Topology Deployment
Seth Miller, Oracle ACE, & Robert C. Green, Oracle 

This session walks through the process and set up for a NoSQL database in a "quick start" format. We will present the tools and techniques used to manage an Oracle NoSQL database cluster. The discussion will also cover cluster management activities such as initial topology create, topology expansion, online software upgrades, and critical aspects of disaster recovery. Attendees will have hands-on experience managing a production instance of the Oracle NoSQL 3.0 database. 

Demystifying MySQL for Oracle DBAs and Developers
George Trujillo, Oracle ACE

MySQL continues to be the world’s most popular database management system for the internet and the cloud. This detailed technical session provides a fast-paced introduction to the MySQL architecture, core features, best practices, core parameters, and key performance metrics. It shows a MySQL version of the Optimal Flexible Architecture (OFA) standard as a best practice and teaches MySQL features from a perspective that is easy for Oracle DBAs and developers to understand.

And did I mention the ACEs will be available for live chat during the sessions? This could make for some real fun. 

Register Now!

Americas - Wednesday July 9th - 9am to 1pm PT / 12pm to 4pm  ET / 1 to 5 pm BRT



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.


« April 2015