DBMS > Databricks vs. Interbase vs. LeanXcale
System Properties Comparison Databricks vs. Interbase vs. LeanXcale
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Databricks Xexclude from comparison||Interbase Xexclude from comparison||LeanXcale Xexclude from comparison|
|Description||The Databricks Lakehouse Platform combines elements of data lakes and data warehouses to provide a unified view onto structured and unstructured data. It is based on Apache Spark.||Light-weight proven RDBMS originally from Borland||A highly scalable full ACID SQL database with fast NoSQL data ingestion and GIS capabilities|
|Primary database model||Document store|
|Relational DBMS||Key-value store|
|Current release||InterBase 2020, December 2019|
|License Commercial or Open Source||Open Source||commercial||commercial|
|Cloud-based only Only available as a cloud service||yes||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||hosted||Android|
|Data scheme||Flexible Schema (defined schema, partial schema, schema free)||yes||yes|
|Typing predefined data types such as float or date||yes|
|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||no export as XML data possible|
|SQL Support of SQL||with Databricks SQL||yes||yes through Apache Derby|
|APIs and other access methods||JDBC|
RESTful HTTP API
proprietary key/value interface
|Supported programming languages||Python|
|Server-side scripts Stored procedures||user defined functions and aggregates||yes Interbase procedure and trigger language|
|Partitioning methods Methods for storing different data on different nodes||none|
|Replication methods Methods for redundantly storing data on multiple nodes||yes||Interbase Change Views|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes Multiversion concurreny control||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.||no||yes||yes|
|User concepts Access control||fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||Full ACID and full SQL operational database with analytical queries over operational...|
|Competitive advantages||Linear scalability upto 100s of nodes (tested with 100 nodes and TPC-C).|
|Typical application scenarios||Hybrid Transactional-Analytical Processing (HTAP) requiring an operational database...|
|Key customers||banking/finance/fintech, telco, insurance, traveltech, M2M/IoT, retail|
|Market metrics||15 beta testers|
|Licensing and pricing models||annual fee covering license and support based on number of physical cores|
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Recent citations in the news|
Databricks invests in Catalyst, targeting the elusive customer ...
Dell unveils Databricks deal, plus storage hits Apex cloud – Blocks ...
Databricks acquires AI-centric data governance platform Okera
Tredence attains Databricks Elite Partner status, reinforcing ...
provided by Google News
An independent soccer league transforming lives in a slum in Kenya
AHQ (Unit) Islamabad wins interbase shooting c’ship
Top 10 Data Management Platforms and Software to Know in 2022
7 Visual Studio Tools to Improve Your Software Development in 2021
transcosmos increases workstations at Kuala Lumpur KLCC, its ...
provided by Google News
Red Hot: The 2021 Machine Learning, AI and Data (MAD) Landscape
Big Data Market: 2018-2030 - $65 Billion Opportunities, Challenges ...
Big Data in the Healthcare & Pharmaceutical: A +$7 Billion ...
Big Data in the Insurance Industry: Opportunities, Challenges, Strategies & Forecasts 2018 - 2030
Llega a Madrid la sexta edición del South Summit
provided by Google News
Mortgage Support Specialist
Databricks Architect (Remote)
Spark (Databricks) Engineer – All Levels (REMOTE)
IT Systems Coordinator
I.T. Development Manager # 999
Share this page