If you were talking to someone whose organization is considering Oracle Database In-Memory, what would you say?
How would you rate it and why? Any other tips or advice?
We're Oracle partners. We've been partners with Oracle for a long time. Our IT department first changed from on-premises to cloud. Our clients seem to like a hybrid deployment model. Now they are considering looking for other solutions that may not be as expensive or may even be open-source. I'm not really a database expert. My understanding is that some customers want to make a product from the portal website using the In-Memory DB. Others tend to want to migrate from an Oracle In-Memory database to another email database. It's difficult when users want to migrate off of Oracle or simply to another Oracle solution. They tend to run into a lot of issues. Personally, this solution wouldn't be my top choice, as it makes things difficult. There are a lot of alternative email database solutions. I'd just advise other companies to take a look at the options to see which would work best for their use case. That said, while we migrated to another solution, it's still a pretty good tool, and issues just seem to arise if you are migrating. Overall, I'd rate the solution seven out of ten. If the pricing was more reasonable, and the migration was easier, I'd rate it higher.
I would recommend In-Memory because it is a robust and scalable RDBMS. We are able to achieve high availability. I would rate it a nine out of ten. They should improve the licensing cost.
We use the on-premises deployment model in the virtualization environment. I'd rate the solution eight out of ten. If technical support was better and usability was improved, I'd rate it higher. It's the best solution on the market right now, but it's more for big data. For us, it's the best solution we can get for our specific needs.
We use the on-premises deployment model. I'd advise others to look at the solution, but to be mindful as it is costly. Whether it is right for a company or not depends on the requirements. If they have the budget, they should go for Oracle. If they do not, I'd suggest they look at something open-source like MySQL or Oracle SQL. I'd rate the solution nine out of ten.
Oracle is the best database, but I love open-source software. Oracle always has the first original features for three or four years and we use them because they are stable and we can buy in a large scale and use it for our office. It has no problems. I think Oracle is ten out of ten. About Oracle Database In-Memory, in particular, I would rate it as eight out of ten. It's a new feature. I think it's improved from the last version three years ago. Oracle's new features and data are very useful for us for storing data, loading it, etc. Oracle features based on processes are good. In Oracle, we just have four functions based on data types, but in post-production, we have more than ten functions. That is very useful for us. We'll add more functions and features like index and categorization based on data type, output, and large data. That would be very useful.
It is always worth testing or running a proof of concept to check its value.
In our opinion, what would be the best application SQL optimizer over the WAN?