Сравнение на използваните сървъри за база данни с които работят различните версии на Kami SL

Версия Kami SL 2.7 работи с база данни Firebird

Версия Kami SL 3.0 (СУПТО) и Kami MSSQL версия работят с Microsoft SQL Server или с Безплатната версия Microsoft SQL Express Server

Сравнение на основните характеристики на базите данни

Editorial information provided by DB-Engines
NameFirebird  XMicrosoft SQL Server  X
DescriptionFirebird is an open source RDBMS forked from Borland’s InterBaseMicrosofts relational DBMS
Primary database modelRelational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
DB-Engines Ranking
Trend Chart
Score22.09
Rank#30  Overall
 #18  Relational DBMS
Score1081.91
Rank#3  Overall
 #3  Relational DBMS
Websitewww.firebirdsql.orgwww.microsoft.com/­en-us/­sql-server
Technical documentationwww.firebirdsql.org/­en/­reference-manualsdocs.microsoft.com/­en-ie/­sql/­sql-server/­sql-server-technical-documentation
DeveloperFirebird FoundationMicrosoft
Initial release20001989
Current release3.0.4, October 2018SQL Server 2019, SQL Experss Server
LicenseOpen Sourcecommercial
Cloud-based onlynono
DBaaS offerings (sponsored links)
Implementation languageC and C++C++
Server operating systemsAIX
FreeBSD
HP-UX
Linux
OS X
server-less
Solaris
Unix
Windows
Linux
Windows
Data schemeyesyes
Typingyesyes
XML supportyes
Secondary indexesyesyes
SQLyesyes
APIs and other access methodsADO.NET
C/C++ API
JDBC
ODBC
OLE DB
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesC
C#
C++
Delphi
Java
JavaScript
Lua
Perl
PHP
Python
Ruby
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scriptsPSQLTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersyesyes
Partitioning methodsnonetables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methodsnoneyes, but depending on the SQL-Server Edition
MapReducenono
Consistency conceptsImmediate Consistency
Foreign keysyesyes
Transaction conceptsACIDACID
Concurrencyyesyes
Durabilityyesyes
In-memory capabilitiesyes
User conceptsUsers with fine-grained authorization conceptfine grained access rights according to SQL-standard