Create entry

Microsoft SQL Server 2005 vs. BaseX

Microsoft SQL Server 2005 BaseX + Add column
Microsoft SQL Server 2012 BaseX
Category
Preference (63% global votes) (50% global votes)
Website www.​microsoft.​com/​sqlserver/​ basex.​org
License
Design
Database model
Data storage
Embeddable Yes Yes
Features
Query language
Data types
Conditional entry updates Yes Yes
Map and reduce No ?
Unicode Yes Yes
TTL for entries Yes ?
Compression Yes Yes
Integrity
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity Yes ?
Revision control Yes No
Locking model
Indexing
Secondary Indexes Yes Yes
Composite keys Yes Yes
Full text search Yes Yes
Geospatial Indexes Yes Yes
Graph support Yes Conditional
Graph type ?
Distribution
Horizontal scalable Yes No
Replication Yes No
Replication mode ?
Sharding Yes No
Shared nothing architecture Yes Yes
Restrictions
Value size max. 1 TB ?
System requirements
Operating system
Native driver
Memory minimum 100 MB ?
Architecture
Programming language
More
Description Relational database XML Database
Brand ?
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
Database ?
Multilingual content Yes Yes
Price rating ★★★★★ ★★★★★
WYSIWYG-Editor Yes Yes
Standard compliance Yes Yes
Software distribution
Object-Relational Mapping (ORM) Yes No
Release Date 24ᵗʰ July 2016 2007
Documentation level ★★★★★ ★★★★★
RESTful Yes Yes
Distributed Counter Yes ?
Free to use Conditional Yes
Active Yes Yes
Database Connection Pooling Yes ?
Real time analytics Yes ?
Creation Date 2011 ?
WSDL Yes ?
Web interface Yes Yes
Data encryption Yes Conditional
API Good Good
XML Aware Good ?
Cloud platform support ?
Online backup Yes ?
Function Based Index Yes ?
Key length max 800 ?
Log Yes Yes
Implementation flexibility (43% global votes) (50% global votes)
Download www.​microsoft.​com/​sqlserver basex.​org/​downloads
Level of access authorization ?
Backup functionality Good Good
Query Cache Yes Yes
Ease of use ★★★★★ ★★★★★
In-Place Update Yes Yes
Free for commercial use No Yes
Sorts Yes Yes
Event Driven Architecture Yes ?
Triggers Yes ?
Perfomance ★★★★☆ ★★★★★
Materialized Views Yes ?
OData Yes ?
JSON Yes Yes
Flexible Table(Schema) Yes Yes
Stored Procedure Yes ?
Continuous query Yes ?
24/7 support Yes ?
Free edition Yes Yes
Offheap Memory Yes ?
User and Group role based security model Yes ?
Multi-statement Transactions Yes Yes
Does your mom understand it No ?
Recursive queries Yes Yes
Online backup (no locking) Yes ?
CLI` Yes ?
Pingback ? Yes
Multiple projects ? Yes
Template language ?
Dynamic typing ? Yes
Programming paradigm ?
Comments ? Yes
Community Driven ? Good
Community feedback ? ★★★★★
Easy of Use ? Yes
Open Source ? Yes
XInclude Support ? Yes
XUpdate Support ? Yes
XQuery Support ? Yes
Maven support ? Yes
Cloud-enabled ? Yes
Geospatial ? Yes
? Yes
Monitoring UI ? Yes
+ Add row ++
Microsoft SQL Server 2005 BaseX
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    darker
    = better
    Legend
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.

Type
Review
Comment