Oracle Large Data sql: Implementing SQL, Hadoop, and NoSQL fusion

"How do you associate a user handle with a person in a database?" Neil Mendelson, vice president of Oracle's Big Data and senior analysis, raised such a question to reporters. This is a tricky problem for anyone who makes data analysis on social media, because you need access to data stored on multiple platforms. To address this issue, Oracle's latest SQL expansion solution Oracle Large Data SQL (http://www.aliyun.com/zixun/aggregation/13527.html ">big Data sql") may help you answer.

Oracle large Data SQL is an option on the Oracle Large Data appliance, which provides the ability to process data in Hadoop and NoSQL systems. The technology is able to fetch data from Cloudera Hadoop (CDH) and Oracle NoSQL databases through an SQL query, while supporting Oracle relational databases running on Exadata. Mendelson says Oracle's large data SQL can find links between data and specific things, such as the link between a record in social media and a potential customer. Oracle's data management and security tools can be run in all supported environments, providing a single management framework.

Gartner analyst Merv Adrian says Oracle's big Data SQL is based on a "go-centric" concept, meaning that more processing is done outside of the core Oracle database, reducing the movement of data for querying and analyzing. Although Oracle large data SQL currently has some limitations, but it has a certain promotional potential.

According to Adrian, large enterprises generally have data governance policies and corresponding data usage rules, and relatively new technologies such as Hadoop and NoSQL are likely to break these rules if mismanaged. Oracle large data SQL enables Hadoop and NoSQL data to be placed under the umbrella of Oracle's security tools to ensure that the data does not exceed the scope of enterprise rules. Besides Oracle, there are many it vendors doing the same thing.

Oracle large data SQL is understood to require the latest version of Oracle database 12c as support, and to deploy Exadata to run 12c. Oracle has plans to extend large data SQL to more integrated system products, and of course it may support the environment of Mendelson systems in the future, he explained.

Original link: http://www.searchdatabase.com.cn/showcontent_84328.htm