DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > dBASE vs. FatDB vs. Manticore Search vs. Spark SQL

System Properties Comparison dBASE vs. FatDB vs. Manticore Search vs. Spark SQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NamedBASE  Xexclude from comparisonFatDB  Xexclude from comparisonManticore Search  Xexclude from comparisonSpark SQL  Xexclude from comparison
FatDB/FatCloud has ceased operations as a company with February 2014. FatDB is discontinued and excluded from the ranking.
DescriptiondBase was one of the first databases with a development environment on PC's. Its latest version dBase V is still sold as dBase classic, which needs a DOS Emulation. The up-to-date product is dBase plus.A .NET NoSQL DBMS that can integrate with and extend SQL Server.Multi-storage database for search, including full-text search.Spark SQL is a component on top of 'Spark Core' for structured data processing
Primary database modelRelational DBMSDocument store
Key-value store
Search engineRelational DBMS
Secondary database modelsTime Series DBMS infousing the Manticore Columnar Library
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score9.70
Rank#44  Overall
#28  Relational DBMS
Score0.29
Rank#302  Overall
#21  Search engines
Score18.04
Rank#33  Overall
#20  Relational DBMS
Websitewww.dbase.commanticoresearch.comspark.apache.org/­sql
Technical documentationwww.dbase.com/­support/­knowledgebasemanual.manticoresearch.comspark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperAsthon TateFatCloudManticore SoftwareApache Software Foundation
Initial release1979201220172014
Current releasedBASE 2019, 20196.0, February 20233.5.0 ( 2.13), September 2023
License infoCommercial or Open SourcecommercialcommercialOpen Source infoGPL version 2Open Source infoApache 2.0
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 languageC#C++Scala
Server operating systemsDOS infodBase Classic
Windows infodBase Pro
WindowsFreeBSD
Linux
macOS
Windows
Linux
OS X
Windows
Data schemeyesschema-freeFixed schemayes
Typing infopredefined data types such as float or dateyesyesInt, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Booleanyes
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.Can index from XMLno
Secondary indexesyesyesyes infofull-text index on all search fieldsno
SQL infoSupport of SQLnono infoVia inetgration in SQL ServerSQL-like query languageSQL-like DML and DDL statements
APIs and other access methodsnone infoThe IDE can access other DBMS or ODBC-sources..NET Client API
LINQ
RESTful HTTP API
RPC
Windows WCF Bindings
Binary API
RESTful HTTP/JSON API
RESTful HTTP/SQL API
SQL over MySQL
JDBC
ODBC
Supported programming languagesdBase proprietary IDEC#Elixir
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
Java
Python
R
Scala
Server-side scripts infoStored proceduresno infoThe IDE can access stored procedures in other database systems.yes infovia applicationsuser defined functionsno
Triggersnoyes infovia applicationsnono
Partitioning methods infoMethods for storing different data on different nodesnoneShardingSharding infoPartitioning is done manually, search queries against distributed index is supportedyes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesnoneselectable replication factorSynchronous replication based on Galera librarynone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Foreign keys infoReferential integrityyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infonot for dBase internal data, but IDE does support transactions when accessing external DBMSnoyes infoisolated transactions for atomic changes and binary logging for safe writesno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyes infoThe original contents of fields are not stored in the Manticore index.yes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.no
User concepts infoAccess controlAccess rights for users and rolesno infoCan implement custom security layer via applicationsnono

More information provided by the system vendor

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
dBASEFatDBManticore SearchSpark SQL
DB-Engines blog posts

DB-Engines Ranking coverage expanded to 169 database management systems
3 June 2013, Paul Andlinger

show all

Recent citations in the news

AIHA and dBase Media Launch Season Two of Healthier Workplaces, A Healthier World, an Occupational and ...
13 June 2024, Business Wire

30 Years Ago: The Rise, Fall and Survival of Ashton-Tate's dBASE
19 September 2013, eWeek

Microsoft Access 2016 Now Supports dBase Database Format
7 September 2016, Redmondmag.com

A malicious document could lead to RCE in Apache OpenOffice (CVE-2021-33035)
22 September 2021, Help Net Security

WFP DBase (Logistics Data, Budgets and Systems Execution) Factsheet (November 2019) - World
23 December 2019, ReliefWeb

provided by Google News

Integrating Manticore Search with Apache Superset
8 August 2023, hackernoon.com

Clickhouse vs Elasticsearch vs Manticore Search Query Times With a 1.7B NYC Taxi Rides Benchmark
1 June 2022, hackernoon.com

Manticore is a Faster Alternative to Elasticsearch in C++
25 July 2022, hackernoon.com

8 Google Alternatives: How to Search Crypto, the Dark Web, More
1 February 2023, Gizmodo

Highlighting in Search Results
24 May 2020, hackernoon.com

provided by Google News

Use Amazon Athena with Spark SQL for your open-source transactional table formats | Amazon Web Services
24 January 2024, AWS Blog

What is Apache Spark? The big data platform that crushed Hadoop
3 April 2024, InfoWorld

Cracking the Apache Spark Interview: 80+ Top Questions and Answers for 2024
1 April 2024, Simplilearn

Performance Insights from Sigma Rule Detections in Spark Streaming
1 June 2024, Towards Data Science

Simba Technologies(R) Introduces New, Powerful JDBC Driver With SQL Connector for Apache Spark(TM)
17 March 2024, Yahoo Singapore News

provided by Google News



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Present your product here