kdb+ vs. SAP SQL Anywhere

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

Incentivized

SAP SQL Anywhere is better than not using a database, let's be clear there! However, I wouldn't pick it as my first or even second or third choice. I'd recommend looking at other options. Largely, it appears less powerful both in terms of its robustness and general performance and in its implementation of SQL. The standard Sybase utilities provided are lacking in basic features, and the interactive SQL utility is quite horrendous. However, the great thing is it is an ODBC-compliant SQL-compliant relational database.

Incentivized

• 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

• Good performance with relatively large data sets - its cost-based query optimizer is particularly robust
• ANSI SQL compliant
• Supports T-SQL
• Scales well between the desktop (single user) and client/server installations supporting 50-1000 users

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

Incentivized

• I think it should be more user friendly for non-technical users.
• More functional functionalities should be added to the object explore when working with a table to transform data/manipulate data.

Incentivized

switching costs

Incentivized

Ease of use, relationship to existing software's used in house and familiarity with the product

Incentivized

its ok

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

I worked with Oracle for years during my career. I wouldn't select SQL Anywhere to implement a global ATM system with tens of thousands of concurrent connections, but SQL Anywhere is much easier to use and deploy and works very well in workgroup settings. Query performance often exceeds some Oracle versions without having to rely on database tuning.

• 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

• Skilled/experienced resources are less prominent than Microsoft SQL Server or even Oracle, or MySQL, so finding solutions and assistance, if needed, takes more time than it would with other platforms
• You will need to find a good SQL query tool by yourself because the Sybase Central / Interactive SQL utilities are lacking in many basic features, and just generally have a bad user interface

Incentivized