By Okcan Yasin Saygili-Oracle on Nov 09, 2015
The solution to this is to use a timezone supported by the database.[Read More]
During January 2015, Oracle Executive Chairman and Chief Technology Officer Larry Ellison announced Oracle’s next-generation engineered systems, the fifth generation X5. The X5 portfolio of Oracle's Engineered Systems includes among others the X5 Big Data Appliance for Hadoop and NoSQL big data jobs.
Big data is by far the most prevalent technology trend today, according to a recent study by consulting firm Capgemini. However, almost 80 percent of organizations have not achieved full-scale production of their big data initiatives.
Oracle Big Data Appliance is a high-performance, secure platform for running diverse workloads on Hadoop and NoSQL systems.
With the addition of Oracle Big Data SQL, Oracle Big Data Appliance extends Oracle’s industry-leading implementation of SQL to Hadoop and NoSQL systems, allowing to use existing SQL skills to query any data source.[Read More]
One of the new Database 12c features is the SQL Translation Framework. A key part of migrating non-Oracle databases to Oracle Database involves the conversion of non-Oracle SQL statements to SQL statements that are acceptable to Oracle Database. The conversion of the non-Oracle SQL statements of the applications is a manual and tedious process. To minimize the effort, or to eliminate the necessity for converting these statements, Oracle Database Release 12c introduces this new feature called SQL Translation Framework using which these SQL statements can be accepted from client applications and then can be translated at run-time before execution.
Although developed primarily to help customers migrate their 3rd party applications and databases to Oracle, by translating non-Oracle SQL statements, SQL Translation Framework can also be used to substitute an Oracle SQL statement with another Oracle statement to address a semantic or a performance issue, thus becoming an invaluable tool for application DBAs, who finally have the opportunity to substitute poorly performing SQL without the need change the application itself.[Read More]
What if a single Big Data breakthrough could enable you to simply reuse the skills you already have to access all your data in Hadoop, allowing you to leverage existing applications to query Hadoop, while keeping new data as secure as your existing enterprise data?
Oracle recently introduced Oracle Big Data SQL, an essential part of a big data management system. Oracle's unique approach to providing unified query over data in Oracle Database, Hadoop, and select NoSQL datastores. Big Data SQL offers you the capacity of One Fast SQL Query for All Your Data