| Editorial information provided by DB-Tools |
| System |
| Name |
Arango DB |
Microsoft SQL Server |
| Version |
3.3.4 released in aug 2018 |
Sqlserver 2017 |
| Drawbacks |
NA |
high license costs. Applicable for transaction systems in large enterprises |
| Advantages |
Multi Model Native Database |
ACID compliant. Easy to use User Interface |
| Languages Supported |
C#
Clojure
Java
JavaScript (Node.js)
PHP
Python
Ruby |
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R (Microsoft R)
Ruby
Visual Basic |
| Website |
www.arangodb.com |
www.microsoft.com/en-us/sql-server |
| XML Support |
NA |
yes |
| JSON Support |
yes |
yes |
| Brief description |
ArangoDB is a native multi-model database system developed by ArangoDB Inc. The database system supports three data models (key/value, documents, graphs) with one database core and a unified query language AQL (ArangoDB Query Language). |
As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet). |
| Database Model |
Multi Model Database |
Primarily a relational database |
| Technical Documentation |
www.arangodb.com/documentation |
docs.microsoft.com/en-ie/sql/sql-server/sql-server-technical-documentation |
| License |
commercial on aws cloud. |
Commercial |
| Cloud-based / SaaS |
Available in AWS cloud - https://aws.amazon.com/marketplace/pp/B00RNJ092K/ref=mkt_ste_catgtm_dblp
SaaS - Not available |
Available in AWS, Azure Clouds. Available as a SaaS option in Microsoft Cloud |
| Implementation Language |
C,C++,Javascript |
C,C++ |
| Operating System Supported |
Linux , OS X, Windows |
Linux
Windows
|
| Options for Integration / Access API |
Rest API , Javascript API, Android, iOS |
OLE DB,
Tabular Data Stream (TDS),
ADO.NET,
JDBC,
ODBC |
| Consistency |
Eventual Consistency |
Highly Consistent |
| Foreign Keys |
No |
Yes |
| Streaming Support |
Yes |
No |
| Analytics Support |
NA |
Need to buy SQLServer Analytics Pack (SSAS) |
| Data Storage Schema |
Key Value Model |
Relational Database |
| Notable Users |
Reuters, FlightStats |
Most of the Fortune 500 Companies |
| Key Differentiator |
Multi - Model Native DataModel |
Highly reliable as a transactional database |
| Concurrency |
Yes |
Yes |
| Partitioning |
Sharding |
No |
| Replication |
Multi Data Center Replication supported |
Yes |
| Secondary Indexes |
Yes |
Yes |
| SchemaLess |
Yes |
No |
| SQL Query |
No |
Yes |
