Collaborating Authors

AWS may finally be breaking up with Oracle


Amazon's cloud computing division AWS has announced that it has decided to utilize its own databases instead of Oracle's and the company has finally turned off its last Oracle database. AWS has managed to move 75 petabytes of internal data stored on almost 7,500 Oracle databases back to its own service. In a blog post, AWS's Jeff Barr explained that the database migration is now complete after several years of work, saying: "Today I would like to tell you about an internal database migration effort of this type that just wrapped up after several years of work. Over the years we realized that we were spending too much time managing and scaling thousands of legacy Oracle databases. Instead of focusing on high-value differentiated work, our database administrators (DBAs) spent a lot of time simply keeping the lights on while transaction rates climbed and the overall amount of stored data mounted. This included time spent dealing with complex & inefficient hardware provisioning, license management, and many other issues that are now best handled by modern, managed database services."

Oracle brings the Autonomous Database to JSON


Long synonymous with relational databases, Oracle wants to tell developers that it's not only for SQL programmers or priced just for enterprises. And so, it's announcing a new JSON-only document database service on the Oracle Cloud on its most accessible platform – the Autonomous Database – to appeal to developers looking at JSON as their default. And it is pricing it very aggressively. The Oracle Autonomous JSON Database is exactly what the name states – it's the document-based edition of the Oracle Database that stores data natively as JSON documents and collections. And while you can query JSON documents using SQL (this is Oracle, remember?), You can run all the core create-read-update-delete (CRUD) functions through Java, JavaScript, Node.js,

Hey, Data Experts: Voice Assistants Are Calling Your Name


If you can ask Apple Siri or Amazon Alexa to search databases for restaurants and obscure bands, why can't you ask them to search or update the databases of your enterprise resource planning (ERP) or human resources (HR) applications? This question, or something like it, crossed the minds of Jorge Rimblas and Christoph Ruepprich--both of whom are database developers and Oracle ACEs. They each took the initiative to answer the question and learned lessons along the way. "It's a great time to be a database developer," says Rimblas, who has worked with Oracle Database since 1995. "But you have to keep learning," he says.

Oracle Database on Windows: Patch this flaw now, we fixed it on Linux in July


Database giant Oracle has released a fix for a severe bug in Oracle Database Server on Windows. The Oracle Database Server bug, tagged with the identifier CVE-2018-3110 is about as severe as it possible because it can not only give an attacker "complete control" over the vulnerable 11g, 12c, and new 18c database, but also provides shell access to the Windows server it is running on top of. The bug, which stems from a Java virtual machine component of the database, has a CVSS v3 base score of 9.9 out of 10. Vulnerable versions include Oracle Database Database vulnerability in versions and on Windows. It also affects version on Windows, Linux, and Unix servers, however the latter two were patched in Oracle's planned July update, according to Oracle.

Oracle Database Performance Tuning


By the end of this course, You will be able to perform the following skills: Determine the bottlenecks in low-performance Oracle databases Propose solutions to database performance issues And implement Oracle methodology in performance tuning