SAP Adaptive Server Enterprise (ASE), legacy

High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.

Incentivized

• Easy to setup and maintain
• Reliable, rarely has major hiccups requiring reboots or crashes
• Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows

Incentivized

• Full database encryption - need to utilize external keys vs internal - for better separation of duties.
• History Tables.

Incentivized

Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.

Incentivized

It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.

Incentivized

Incredibly responsive, saving us countless hours in troubleshooting.

Incentivized

Much less effort than Oracle. Much better customer support than Oracle. Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server. Different ballpark from IQ. Same customer service.

Incentivized

• Negative - Costs a lot ... but so do they all.
• Positive - It does what we need it to do.

Incentivized