Amazon Relational Database Service (Amazon RDS) is a database-as-a-service (DBaaS) from Amazon Web Services.
N/A
Oracle TimesTen
Score 7.8 out of 10
N/A
Oracle TimesTen In-Memory Database (TimesTen) delivers real time application performance by changing the assumptions around where data resides at runtime. By managing data in memory, and optimizing data structures and access algorithms, database operations execute achieve gains in responsiveness and throughput. With TimesTen Scaleout, a shared nothing scale-out architecture based on the existing in-memory technology, TimesTen allows databases to scale across hosts, reach hundreds of terabytes in…
Whether your organization is [an] early startup or large company AWS RDS fits in most of the cases such as 1. Easy to start, setup, used by [a] few or large developers team. 2. You can easily scale DB [instances] when your business required scaling as a startup or pay only for [users] to optimize cost as [a] large organization. 3. If your application requires SQL Server, Oracle, or Maria DB then you should use AWS RDS instance. 4. Your application requires better availability and security of data you can use AWS RDS instance. When AWS RDS is not recommended: 1. You need automatic scaling or capacity flexibility as request load gradually increases, better to use Amazon Aurora DB in this case.
TimesTen is well suited for applications using smaller data or smaller data stores and where transaction response times are not as business critical. TimesTen is good for applications already accessing Oracle and need to cache data for quick read/write operations. TimesTen is not appropriate for large data dependent applications or applications requiring fast response times. In these cases, using Oracle database or Exadata is better
Amazon RDS helps organizations handle relational database management tasks such as migration, backup, recovery, and patching. Some of the main features of Amazon RDS are replication, high-performance storage, and failure detection. One of the biggest advantages of Amazon RDS is its ease of use.
It has worked reliably in the past, we have not had any problems that would have been caused because of using RDS. Also it's future-proof, it will scale easily if user base of the application that relies on it is going to increase rapidly. Our application deployments also rely on it so renewing it is essential for business & switching to different provider would cause costs without any apparent benefit.
I've been using AWS Relational Database Services in several projects in different environments and from the AWS products, maybe this one together to EC2 are my favourite. They deliver what they promise. Reliable, fast, easy and with a fair price (in comparison to commercial products which have obscure license agreements).
I have only had good experiences in working with AWS support. I will admit that my experience comes from the benefit of having a premium tier of support but even working with free-tier accounts I have not had problems getting help with AWS products when needed. And most often, the docs do a pretty good job of explaining how to operate a service so a quick spin through the docs has been useful in solving problems.
[Amazon Relational Database Service (RDS)] is much better to have everything in the cloud instead of having it on-premise once you can get all the benefits from Cloud. Of course, it can be a bit expensive if your company it's not growing anymore but if you check it in detail, you can see that the scalability of Cloud makes a lot of sense and also the reliability.
Sybase does not have an in-memory database until version 15 so TimesTen was ideal for caching data. TimesTen has reliable replication and backing up mechanisms. Oracle takes longer to set up and use for most applications where as TimesTen is a smaller DBMS that is quick and easy to set up and use. TimesTen can connect to Oracle for caching data so using Oracle as a backend makes sense
TimesTen has had a positive impact from a developer's perspective because implementing TimesTen is quick and easy. The benefits of TimesTen can be seen almost instantly. For instance, the application start up time is faster, the data is easy to maintain and the performance is fast for TimesTen clients.
TimesTen has had a positive impact for the business because it can be made accessible to users via a GUI. This gives users transparency to the data at any time.
The negative impact is that once the TimesTen database has grown too large, the application should move to using Oracle database or else it suffers from performance degradation and stability issues.
