kdb+ vs. Oracle Autonomous Transaction Processing

kdb is well suited for real time tick data and time series analytics.

Incentivized

If your company's value is not increased by maintaining databases, you should use the ATP.

• Time series analysis. The built-in vector operations are extremely fast. Also with the q language you can code up any customized analytical ideas quickly.
• The database are all file based, very easy to maintain.
• Very solid and fast interface to websocket, so you can interface with javascript easily.

Incentivized

• Quick and simple to deploy (less than 5 steps to create a new instance)
• No administrative tasks (backup, re-sizing) required

Incentivized

• Run time error message readability, particularly for new users.
• Backwards compatibility between versions.

Incentivized

• Connectivity between ATP and Oracle Kuberentes Engine cluster seems to drop randomly
• The ATP could come in an even smaller shape as the smallest shape is already quite big . But if must be more than always free, as that version does have connectivity limitations about 20 connections

switching costs

Incentivized

its ok

Incentivized

You get almost all the features of Oracle Database, including the ability to deploy APEX applications, without having to worry about system, storage or database configuration and maintenance, backups, etc. Also, you can start for free and move up adding resources as you need.

Incentivized

We don't use it.

Incentivized

Python is very commonly used for large data analysis and in general is much easier to pickup than kdb+. The biggest drawback of kdb+ is the learning curve.

Incentivized

Both Azure SQL Database and Oracle Autonomous Transaction Processing offer a powerful and robust database platform. The advantage of Autonomous Transaction Processing is the ability to host APEX applications for free and without any special/complicated deployment or configuration process. Having a rapid development environment embedded for free was the main advantage for choosing Oracle as my cloud database provider.

Incentivized

• It perfectly solves most of our real time tick data needs.
• Finding good kdb resources is slightly difficult. Also new people trying to learn kdb experience a relatively longer learning curve.

Incentivized

• Approx 100 times faster spin up than manual setup of an Oracle DB
• 3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates