Team Lead - Oracle Technologies at a financial services firm with 5,001-10,000 employees
Consultant
Top 20
2024-08-14T12:45:14Z
Aug 14, 2024
The platform is reliable and effective within our setup. However, potential users should be aware of the high costs and evaluate whether the benefits justify the investment.
The platform provides the best performance in terms of database analytics. It efficiently serves as a data lake. We can integrate it with any data sources as well. I recommend it to others and rate it a ten out of ten.
The solution improves the data analytics processes as it helps to meet the requirements of a database. To meet the recommendation of the company to have an Oracle-based product, we use Oracle Database In-Memory. The resources in our organization are mostly Oracle-based products. For bigger environments, I prefer Oracle because it allows me to have access to trained resources in the market. Due to the aforementioned aspects, Oracle works for me. The tool supports our organization's OLAP and OLTP workloads. My organization is a bank with 900 branches, and all of them are connected simultaneously. Considering the aforementioned scenario, most of the user activities were through the database. Large user bases are supported by Oracle and are much better than DB2. The columnar data storage format of the product is not used in our company's system. The inbuilt capability of the product was used in our company with regards to the storage part, but for the software part, my company does not use columnar data storage format. In most cases, a database is required by the application. It is not me who personally but the applications that require a database. In general, database requirements come from the application, and for such scenarios, I recommend others to go with Oracle as other databases may not be good enough, especially if the applications require only databases from Oracle. If the applications require DB2, then users should opt for DB2. My recommendation cannot be considered as a valid one, especially if we consider the requirements that may vary for applications. If there is a need to support terabytes of data, the database from Oracle is useful. The performance capability of Oracle is much better than DB2. The In-Memory Advisor is helpful, especially after the installation processes are done and the operation part is running. If any performance issues arise, the In-Memory Advisor helps users to find out the information as to what is the root cause of the problem and to explain what should be done. Whenever there is only a single node, my company faces a lot of password issues since there are many users. The company has to scale up to two nodes. The load balancing aspect is managed with the help of two nodes, so it is easily scalable. Though the steps are a bit complex, the product is very much scalable. The performance had increased by almost 200 percent when my company had added the second node. I rate the overall tool a nine out of ten.
IT Consultant at a computer software company with 1,001-5,000 employees
Consultant
Top 20
2023-07-10T02:50:09Z
Jul 10, 2023
After accessing the In-Memory database, we usually have some downtime. That's acceptable to me, but if they can eliminate that, it would be good. The downtime is needed now to change the allocated memory in Oracle. If you use a data block, the downtime lasts minutes. Oracle provides Exadata for customers, and that's very good because usually another cloud is not provided to them. I rate the solution a ten out of ten. When I compare solutions like In-Memory to FOSS 3.0, FOSS 3.0 has more features. But if you add all those features to one person, they are incompatible. Compatibility is an important thing, but many people just skip it.
I would rate the solution a ten out of ten. If you do not have high-frequency transactions, then Oracle Database In-Memory is not for you. You would require Oracle Database In-Memory for mission critical high-frequency transactions.
Before choosing the solution, evaluate the on-premises, public, and private cloud environments. Speak with a representative about what environment best meets your needs. In the public cloud arena, Azure and AWS also offer good products that compete with the solution. I rate the solution a seven because there are better public cloud options.
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.
Oracle Cloud Infra Architect at Sterlite Technologies Ltd
Real User
2020-04-05T09:13:00Z
Apr 5, 2020
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.
Database Administrator at a energy/utilities company
Real User
2019-12-09T10:58:00Z
Dec 9, 2019
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.
Oracle Database In-Memory transparently accelerates analytics by orders of magnitude while simultaneously speeding up mixed-workload OLTP. With Oracle Database In-Memory, users get immediate answers to business questions that previously took hours.
Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality, or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with any existing Oracle Database compatible...
I highly recommend Oracle Database In-Memory to other companies.
The platform is reliable and effective within our setup. However, potential users should be aware of the high costs and evaluate whether the benefits justify the investment.
The platform provides the best performance in terms of database analytics. It efficiently serves as a data lake. We can integrate it with any data sources as well. I recommend it to others and rate it a ten out of ten.
The solution improves the data analytics processes as it helps to meet the requirements of a database. To meet the recommendation of the company to have an Oracle-based product, we use Oracle Database In-Memory. The resources in our organization are mostly Oracle-based products. For bigger environments, I prefer Oracle because it allows me to have access to trained resources in the market. Due to the aforementioned aspects, Oracle works for me. The tool supports our organization's OLAP and OLTP workloads. My organization is a bank with 900 branches, and all of them are connected simultaneously. Considering the aforementioned scenario, most of the user activities were through the database. Large user bases are supported by Oracle and are much better than DB2. The columnar data storage format of the product is not used in our company's system. The inbuilt capability of the product was used in our company with regards to the storage part, but for the software part, my company does not use columnar data storage format. In most cases, a database is required by the application. It is not me who personally but the applications that require a database. In general, database requirements come from the application, and for such scenarios, I recommend others to go with Oracle as other databases may not be good enough, especially if the applications require only databases from Oracle. If the applications require DB2, then users should opt for DB2. My recommendation cannot be considered as a valid one, especially if we consider the requirements that may vary for applications. If there is a need to support terabytes of data, the database from Oracle is useful. The performance capability of Oracle is much better than DB2. The In-Memory Advisor is helpful, especially after the installation processes are done and the operation part is running. If any performance issues arise, the In-Memory Advisor helps users to find out the information as to what is the root cause of the problem and to explain what should be done. Whenever there is only a single node, my company faces a lot of password issues since there are many users. The company has to scale up to two nodes. The load balancing aspect is managed with the help of two nodes, so it is easily scalable. Though the steps are a bit complex, the product is very much scalable. The performance had increased by almost 200 percent when my company had added the second node. I rate the overall tool a nine out of ten.
I rate Oracle Database In-Memory a ten out of ten.
I would recommend this solution to larger companies that have specific requirements and can benefit from it. It's a highly effective product.
Overall, I rate the solution a nine out of ten.
After accessing the In-Memory database, we usually have some downtime. That's acceptable to me, but if they can eliminate that, it would be good. The downtime is needed now to change the allocated memory in Oracle. If you use a data block, the downtime lasts minutes. Oracle provides Exadata for customers, and that's very good because usually another cloud is not provided to them. I rate the solution a ten out of ten. When I compare solutions like In-Memory to FOSS 3.0, FOSS 3.0 has more features. But if you add all those features to one person, they are incompatible. Compatibility is an important thing, but many people just skip it.
I would rate the solution a ten out of ten. If you do not have high-frequency transactions, then Oracle Database In-Memory is not for you. You would require Oracle Database In-Memory for mission critical high-frequency transactions.
I recommend the solution to others and rate it as a nine.
Before choosing the solution, evaluate the on-premises, public, and private cloud environments. Speak with a representative about what environment best meets your needs. In the public cloud arena, Azure and AWS also offer good products that compete with the solution. I rate the solution a seven because there are better public cloud options.
The solution provides a good environment and it's a product we trust. I rate this solution eight out of 10.
I would rate Database In-Memory nine out of ten.
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.