Recent Posts by Maria Colgan

In today's world, the ability to quickly create value from different types of data increasingly provides businesses with a competitive edge. An excellent example of this is how responsive, personalized and portable a food delivery app might be. But how does a business become data-driven?  The easiest way for businesses to generate this type of value or insight from data is to take advantage of data-driven applications built using modern development paradigms and deployed on...

There is an on-going debate in our community about the best approach for developing cloud-native or data-driven apps. On one side, you have folks who say use a single-purpose "best-of-breed" database for each data type or workload you have. While the other half say, you should use a single converged database. So, which approach is right for you and your projects? Let's examine some of the pros and cons of each approach. Single-purpose Databases Single-purpose databases or...

As a database administrator or manager, you may have had one or more of these conversations with your application teams? We need to build a new mobile app so customers can submit and retrieve documents, so I’m going to need a specialized database to store the documents, right? Oh, wait, next week this other project requires we provide a new payment system that has user fraud protection built in to meet compliance and I am going to store relational data as well.  That requires a...

Oracle Autonomous Database offers two deployment choices - Serverless or  Dedicated. With Autonomous Database Serverless, Oracle automates all aspect of the infrastructure and database management for customers including provisioning, configuring, monitoring, backing up and tuning. Users simply select what type of database they want (Data Warehouse or Transaction Processing), which region in the Oracle Cloud they want the database deployed, and the base compute and storage...

Today Larry Ellison announced the general availability of Oracle Autonomous Transaction Processing Cloud Service, the newest member of the Oracle Autonomous Database family, combining the flexibility of cloud with the power of machine learning to deliver data management as a service. Traditionally, creating a database management system required a team of experts to custom build and manually maintain a complex hardware and software stack. With each system being unique,...

Graphics processing units or GPUs are dedicated highly parallel hardware accelerators that were originally design to accelerate the creation of images. More recently, folks have been looking at GPUs to accelerate other workloads like Database analytics and transaction processing (OLTP). Although GPUs have little or no use for OLTP style workloads, they have been shown to accelerate analytics. So, what kind of benefits can you expect from running the Oracle Database on a GPU...

If you recall from part 1 of our blog series on RAC each RAC node has it’s own In-Memory column store (IM column store). When a table is populated into memory in a RAC environment it will be automatically distributed across all of the IM column stores in the cluster. That is to say, a piece of the table will appear in each RAC node, effectively making the IM column store a shared-nothing architecture. We have also discussed how you can use Database Services to control where an...

There is less than 6 weeks to go until Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts, which begins on September 18th in San Francisco. Of course the In-Memory development group will be there and you will have multiple opportunities to meet up with us, in one of our technical sessions, our hands-on-labs or at the Oracle demogrounds.This year the In-Memory team has 4 technical sessions and there are also a number...

A couple of weeks ago at the Spring Conference of the Bulgarian Oracle User Group, Joel Goodman gave a great session on Bloom Filters and how the can improve the performance of hash joins in the Oracle Database especially in the In-Memory column store. At the end of that session the chap sitting in front of me turned around to show me an execution plan they got while testing Oracle Database In-Memory and posed the following question, “Where did the other bloom filter go?” Belo...