DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. Microsoft Access vs. Milvus vs. OceanBase

System Properties Comparison AlaSQL vs. Microsoft Access vs. Milvus vs. OceanBase

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonMicrosoft Access  Xexclude from comparisonMilvus  Xexclude from comparisonOceanBase  Xexclude from comparison
DescriptionJavaScript DBMS libraryMicrosoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. infoThe Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)A DBMS designed for efficient storage of vector data and vector similarity searchesA distributed, high available RDBMS compatible with Oracle and MySQL
Primary database modelDocument store
Relational DBMS
Relational DBMSSearch engineRelational DBMS
Secondary database modelsDocument store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.62
Rank#223  Overall
#35  Document stores
#107  Relational DBMS
Score140.03
Rank#9  Overall
#6  Relational DBMS
Score0.46
Rank#250  Overall
#17  Search engines
Score0.92
Rank#190  Overall
#90  Relational DBMS
Websitealasql.orgwww.microsoft.com/­en-us/­microsoft-365/­accessmilvus.ioopen.oceanbase.com
Technical documentationgithub.com/­agershun/­alasqldeveloper.microsoft.com/­en-us/­accessmilvus.io/­docs/­overview.mdopen.oceanbase.com/­docs
DeveloperAndrey Gershun & Mathias R. WulffMicrosoftOceanBase infopreviously Alibaba and Ant Group
Initial release2014199220192011
Current release1902 (16.0.11328.20222), March 20192.0, January 20223.2.3, March 2022
License infoCommercial or Open SourceOpen Source infoMIT-Licensecommercial infoBundled with Microsoft OfficeOpen Source infoApache Version 2.0Open Source infoCommercial license available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScriptC++C++, GoC++
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)Windows infoNot a real database server, but making use of DLLsLinux
macOS info10.14 or later
Windows infowith WSL 2 enabled
Linux
Data schemeschema-freeyesyes
Typing infopredefined data types such as float or datenoyesNumeric and Stringyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono
Secondary indexesnoyesnoyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.yes infobut not compliant to any SQL standardnoyes
APIs and other access methodsJavaScript APIADO.NET
DAO
ODBC
OLE DB
RESTful HTTP APIJDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Proprietary native API
Table API
Supported programming languagesJavaScriptC
C#
C++
Delphi
Java (JDBC-ODBC)
VBA
Visual Basic.NET
C++
Go
Java
JavaScript (Node.js)
Python
Ada infoin MySQL-compatible model
C infoin Oracle- and MySQL- compatible models
C++ infoin Oracle- and MySQL- compatible models
D infoin MySQL-compatible model
Delphi infoin MySQL-compatible model
Eiffel infoin MySQL-compatible model
Erlang infoin MySQL-compatible model
Haskell infoin MySQL-compatible model
Java infoin Oracle- and MySQL- compatible models
JavaScript (Node.js) infoin MySQL-compatible model
Objective-C infoin MySQL-compatible model
OCaml infoin MySQL-compatible model
Perl infoin MySQL-compatible model
PHP infoin MySQL-compatible model
Python infoin MySQL-compatible model
Ruby infoin MySQL-compatible model
Scheme infoin MySQL-compatible model
Tcl infoin MySQL-compatible model
Server-side scripts infoStored proceduresnoyes infosince Access 2010 using the ACE-enginenoPL/SQL in oracle-compatible mode, MySQL Stored Procedure in mysql-compatible mode
Triggersyesyes infosince Access 2010 using the ACE-enginenoyes
Partitioning methods infoMethods for storing different data on different nodesnonenoneShardinghorizontal partitioning (by hash, key, range, range columns, list, and list columns)
Replication methods infoMethods for redundantly storing data on multiple nodesnonenoneMulti-source replication using Paxos
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneBounded Staleness
Eventual Consistency
Immediate Consistency
Session Consistency
Tunable Consistency
Immediate Consistency
Foreign keys infoReferential integrityyesyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageACID infobut no files for transaction loggingnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyes infobut no files for transaction loggingyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlnono infoa simple user-level security was built in till version Access 2003noAccess rights for users, groups and roles according to SQL-standard
More information provided by the system vendor
AlaSQLMicrosoft AccessMilvusOceanBase
Specific characteristicsMilvus is an open-source and cloud-native vector database built for production-ready...
» more
OceanBase Database is the world’s only native distributed database that has set new...
» more
Competitive advantagesHighly available, versatile, and robust with millisecond latency. Supports batch...
» more
High Availability : The five IDCs across three sites disaster recovery solution sets...
» more
Typical application scenariosVideo media : video understanding, video deduplication. E-commerce and mobile applications...
» more
Key customersMilvus is trusted by over 1,000 enterprises, including Baidu, eBay, IKEA, LINE, Shopee,...
» more
OceanBase Database has helped over 400 customers across industries upgrade their...
» more
Market metricsAs of March 2022, 9.8k+ GitHub stars 1.4k+ Github forks 871k+ docker pulls 2k+ community...
» more
TPC-C No.1 Performance , achieved a result of 707.35 million tpmC in the TPC-C benchmark...
» more
Licensing and pricing modelsMilvus was released under the open-source Apache License 2.0 in October 2019. Managed...
» more
Mulan PubL v2 license for open source community edition. Commercial license for enterprise...
» more

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
AlaSQLMicrosoft AccessMilvusOceanBase
DB-Engines blog posts

MS Access drops in DB-Engines Ranking
2 May 2013, Paul Andlinger

Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking
3 December 2012, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

HarperDB - How and Why We Built It From The Ground Up on NodeJS
28 February 2021, hackernoon.com

provided by Google News

Microsoft fixes Access apps failing to open after July updates
22 July 2022, BleepingComputer

Data Use Specialist - Liberia
26 September 2022, ReliefWeb

Microsoft investigates July updates breaking Access applications
15 July 2022, BleepingComputer

Microsoft Employees Love Figma, and It's Testing the Company's Cozy Relationship With Adobe
7 September 2022, Slashdot

Vacancy for B.Tech/BE Graduates at Vodaphone Idea Limited
29 September 2022, StudyCafe

provided by Google News

Zilliz Vector Database Research Featured at VLDB 2022
30 September 2022, Datanami

Zilliz Pioneers Vector Database R&D, Shares New Findings at VLDB 2022
19 September 2022, insideBIGDATA

Zilliz, the startup behind the Milvus open source vector database for AI apps, raises $60M, relocates to SF
24 August 2022, TechCrunch

Frank Liu, Director of Operations at Zilliz - Interview Series
9 September 2022, Unite.AI

Zilliz Announces Key Contributions to Milvus 2.1, the Leading Open-Source Vector Database for Structured and Unstructured Data
3 August 2022, Business Wire

provided by Google News

Alibaba's OceanBase distributed database aims at markets outside China
16 August 2022, InfoWorld

OceanBase's New Database Open-Source Program Draws More Than 21300 Developers and 50 Institutional Partners Including Trip.com, Kuaishou, Meituan and Bilibili
19 October 2021, Business Wire

OceanBase Listed as a Notable Vendor in Translytical Data Platforms by Independent Research Firm
25 July 2022, Business Wire

China's Tech Crackdown Could Give It an Edge
30 April 2022, The Diplomat

Ant Group forms new SaaS company amid regulatory scrutiny of its consumer services
16 February 2022, KrASIA

provided by Google News

Job opportunities

Developer
Axle Informatics, Rockville, MD

Applications Developer
Axle Informatics, Rockville, MD

MS ACCESS DEVELOPER
Manufacturing Hire, Mojave, CA

MS Access Programer
Rattan Consulting, Oklahoma City, OK

Data Entry
Eddy Carolina Pride, Greenwood, SC

Warehouse Worker
Best Maid Cookie Company, Bonner Springs, KS

Sr Engineer, MS Access/SQL Server Developer
Raymond James Financial, Saint Petersburg, FL

Developer Advocate
Zilliz, San Francisco, CA

Software Engineer, High Performance Computing
Zilliz, San Francisco, CA

Head of Developer Relations
Zilliz, San Francisco, CA

Staff Software Engineer, Distributed System
Zilliz, San Francisco, CA

Head of Marketing
Zilliz, San Francisco, CA

Ant Group Solution Architect OceanBase
Alibaba, San Francisco, CA

Ant Group Sales Account Executive OceanBase
Alibaba, San Francisco, CA

jobs by Indeed



Share this page

Featured Products

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Present your product here