Oracle has introduced Oracle Big Data SQL, SQL-based software that seamlessly integrates data across Hadoop, NoSQL, and Oracle Database.

Oracle Big Data SQL runs on Oracle Big Data Appliance and can work in conjunction with Oracle Exadata Database Machine.

By connecting proven technologies and simplifying information access through industry-standard SQL, Oracle Big Data SQL enables organisations to look across all enterprise data and uncover insights faster, which can help to transform their business.

With a unique architecture and Smart Scan technology inherited from Oracle Exadata, Oracle Big Data SQL can query all forms of structured and unstructured data while minimising data movement, enabling dramatically faster analysis for data distributed across Hadoop, NoSQL, and Oracle Database.

This approach also enables organisations to leverage existing SQL skills without investing in costly new talent and helps to maximise the potential of existing technology investments.
With Oracle Big Data SQL, Oracle Database security capabilities, including an organisation’s existing security policies, are now extended to Hadoop and NoSQL data.

Oracle Big Data SQL is scheduled for general availability in Q3 of CY2014.

Oracle’s big data solutions, now joined by Oracle Big Data SQL, enable customers to discover and predict faster, simplify access, and govern and secure big data.

By leveraging SQL to query and analyse data across their entire range of data management systems, organisations no longer have to copy and move data between platforms, analyse with a MapReduce-powered language, or construct separate queries for each platform and then figure out how to connect the results.

Smart Scan technology, inherited from Oracle Exadata, executes locally to intelligently find the data needed for a given query, minimising data movement and increasing performance.

Oracle Big Data SQL provides popular SQL-based business intelligence tools and applications with easier access to Hadoop and NoSQL data sources, outside of the traditional data warehouse, speeding discovery and operationalisation of big data insights without changes to existing applications and tools.

Bringing big data into the enterprise requires new technologies, languages, and skills. Oracle simplifies access to enterprise big data by combining relational and non-relational technologies into a single architecture, harnessing SQL, the industry-standard language for accessing data.

By extending SQL across the entire enterprise data ecosystem, organisations can use existing SQL skills to uncover and analyse all data.

Integration with Oracle engineered systems for data management offers fast deployment and a low total cost of ownership for Hadoop, relational, and NoSQL data, and allows customers to secure data insights immediately.

Oracle Big Data Appliance includes comprehensive data encryption capabilities for protecting data privacy and meeting regulatory requirements.

With data at rest and network encryption capabilities, sensitive and regulated information stored on Oracle Big Data Appliance is protected against theft and unauthorised access. Oracle Big Data Appliance also includes enterprise-grade authentication (Kerberos), authorisation (LDAP and Apache Sentry project), and auditing (Oracle Audit Vault and Database Firewall) that can be automatically set up on installation, greatly simplifying the process of hardening Hadoop.

To further ensure organisations can realise the benefits of big data without compromising data governance, Oracle Big Data SQL extends the advanced security capabilities of Oracle Database to Hadoop and NoSQL data. With Oracle Big Data SQL, customers can take advantage of proven Oracle Database security solutions for data redaction, privilege analysis, and strong controls that limit privileged user access to data.

With Oracle Big Data SQL, customers can now apply existing security policies to data in Hadoop and NoSQL, extending enterprise governance and security for sensitive and regulated data in the enterprise.

“As organisations increasingly use diverse data sources beyond relational databases, such as Hadoop and NoSQL, data is becoming more and more siloed – hampering data analysis and insights and limiting the true potential of big data,” says Andrew Mendelsohn, executive vice president, Database Server Technologies, Oracle.

“Oracle Big Data SQL harnesses the popular, proven SQL query language to break down these silos and finally bring big data into the mainstream of an enterprise. Oracle continues its leadership in database innovation with this simple yet powerful way for organisations to access all of their data, leverage existing investments and skills, and gain new value and insights that can transform their business.”