DBMS > Drizzle vs. Microsoft SQL Server vs. STSdb
System Properties Comparison Drizzle vs. Microsoft SQL Server vs. STSdb
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Drizzle Xexclude from comparison||Microsoft SQL Server Xexclude from comparison||STSdb Xexclude from comparison|
|Drizzle has published its last release in September 2012. The open-source project is discontinued and Drizzle is excluded from the DB-Engines ranking.|
|Description||MySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.||Microsofts flagship relational DBMS||Key-Value Store with special method for indexing optimized for high performance using a special indexing method|
|Primary database model||Relational DBMS||Relational DBMS||Key-value store|
|Secondary database models||Document store|
|Developer||Drizzle project, originally started by Brian Aker||Microsoft||STS Soft SC|
|Current release||7.2.4, September 2012||SQL Server 2019, November 2019||4.0.8, September 2015|
|License Commercial or Open Source||Open Source GNU GPL||commercial restricted free version is available||Open Source GPLv2, commercial license 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||FreeBSD|
|Typing predefined data types such as float or date||yes||yes||yes primitive types and user defined types (classes)|
|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|
|SQL Support of SQL||yes with proprietary extensions||yes||no|
|APIs and other access methods||JDBC||ADO.NET|
Tabular Data Stream (TDS)
|.NET Client API|
|Supported programming languages||C|
|Server-side scripts Stored procedures||no||Transact SQL, .NET languages, R, Python and (with SQL Server 2019) Java||no|
|Triggers||no hooks for callbacks inside the server can be used.||yes||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding||tables can be distributed across several files (horizontal partitioning); sharding through federation||none|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication|
|yes, but depending on the SQL-Server Edition||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||no|
|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||Pluggable authentication mechanisms e.g. LDAP, HTTP||fine grained access rights according to SQL-standard||no|
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.|
DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
Navicat for SQL Server gives you a fully graphical approach to database management and development.
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
Fivetran: Quickly and easily centralize your on-premise and cloud databases.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Drizzle||Microsoft SQL Server||STSdb|
|DB-Engines blog posts|
MySQL won the April ranking; did its forks follow?
MySQL is the DBMS of the Year 2019 The struggle for the hegemony in Oracle's database empire
The struggle for the hegemony in Oracle's database empire
|Recent citations in the news|
Microsoft Open Sources .NET 5 C# Language Extension for SQL Server
How to Exploit SQL Server Using OLE Automation
Managing SQL Server Agent Jobs with Notebook Jobs in Azure Data Studio - Microsoft
Why Activity Monitor May Be Hurting Your SQL Server's Performance
How to Exploit SQL Server Using Registry Keys
provided by Google News
SQL Server Database Administrator - Information Management
Microsoft SQL Server Database Administrator II - Remote
SQL Server Developer - Telecommute
SQL Server Database Administrators
SQL Server Developer
Share this page