DBMS > Blazegraph vs. Hypertable vs. Microsoft SQL Server
System Properties Comparison Blazegraph vs. Hypertable vs. Microsoft SQL Server
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Blazegraph Xexclude from comparison||Hypertable Xexclude from comparison||Microsoft SQL Server Xexclude from comparison|
|Amazon has acquired Blazegraph's domain and (probably) product. It is said that Amazon Neptune is based on Blazegraph.||Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.|
|Description||High-performance graph database supporting Semantic Web (RDF/SPARQL) and Graph Database (tinkerpop3, blueprints, vertex-centric) APIs with scale-out and High Availability.||An open source BigTable implementation based on distributed file systems such as Hadoop||Microsofts flagship relational DBMS|
|Primary database model||Graph DBMS|
|Wide column store||Relational DBMS|
|Secondary database models||Document store|
|Current release||2.1.5, March 2019||0.9.8.11, March 2016||SQL Server 2019, November 2019|
|License Commercial or Open Source||Open Source extended commercial license available||Open Source GNU version 3. Commercial license available||commercial restricted free version is available|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Linux|
Windows an inofficial Windows port is available
|Typing predefined data types such as float or date||yes RDF literal types||no||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||yes|
|Secondary indexes||yes||restricted only exact value or prefix value scans||yes|
|SQL Support of SQL||SPARQL is used as query language||no||yes|
|APIs and other access methods||Java API|
RESTful HTTP API
Tabular Data Stream (TDS)
|Supported programming languages||.Net|
|Server-side scripts Stored procedures||yes||no||Transact SQL, .NET languages, R, Python and (with SQL Server 2019) Java|
|Partitioning methods Methods for storing different data on different nodes||Sharding||Sharding||tables can be distributed across several files (horizontal partitioning); sharding through federation|
|Replication methods Methods for redundantly storing data on multiple nodes||yes||selectable replication factor on file system level||yes, but depending on the SQL-Server Edition|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency or Eventual Consistency depending on configuration||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes Relationships in Graphs||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||no||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes|
|User concepts Access control||Security and Authentication via Web Application Container (Tomcat, Jetty)||no||fine grained access rights according to SQL-standard|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.|
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
Navicat for SQL Server gives you a fully graphical approach to database management and development.
SQL Complete: An advanced IntelliSense-style code completion add-in for SSMS and Visual Studio. Write, beautify, refactor your SQL code and give your productivity a dramatic boost.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Blazegraph||Hypertable||Microsoft SQL Server|
|DB-Engines blog posts|