DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Hypertable vs. MySQL vs. Solr vs. Trafodion

System Properties Comparison Hypertable vs. MySQL vs. Solr vs. Trafodion

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameHypertable  Xexclude from comparisonMySQL  Xexclude from comparisonSolr  Xexclude from comparisonTrafodion  Xexclude from comparison
Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
DescriptionAn open source BigTable implementation based on distributed file systems such as HadoopWidely used open source RDBMSA widely used distributed, scalable search engine based on Apache LuceneTransactional SQL-on-Hadoop DBMS
Primary database modelWide column storeRelational DBMS infoKey/Value like access via memcached APISearch engineRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1206.05
Rank#2  Overall
#2  Relational DBMS
Score58.53
Rank#19  Overall
#3  Search engines
Score0.45
Rank#245  Overall
#115  Relational DBMS
Websitewww.mysql.comlucene.apache.org/­solrtrafodion.apache.org
Technical documentationdev.mysql.com/­doclucene.apache.org/­solr/­resources.htmltrafodion.apache.org
DeveloperHypertable Inc.Oracle infosince 2010, originally MySQL AB, then SunApache Software FoundationApache Software Foundation, originally developed by HP
Initial release2009199520062014
Current release0.9.8.11, March 20168.0.28, January 20228.11.1, December 20212.3.0, February 2019
License infoCommercial or Open SourceOpen Source infoGNU version 3. Commercial license availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen Source infoApache 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.
ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
Implementation languageC++C and C++JavaC++, Java
Server operating systemsLinux
OS X
Windows infoan inofficial Windows port is available
FreeBSD
Linux
OS X
Solaris
Windows
All OS with a Java VM inforuns as a servlet in servlet container (e.g. Tomcat, Jetty is included)Linux
Data schemeschema-freeyesyes infoDynamic Fields enables on-the-fly addition of new fieldsyes
Typing infopredefined data types such as float or datenoyesyes infosupports customizable data types and automatic typingyes
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.yesyesno
Secondary indexesrestricted infoonly exact value or prefix value scansyesyes infoAll search fields are automatically indexedyes
SQL infoSupport of SQLnoyes infowith proprietary extensionsSolr Parallel SQL Interfaceyes
APIs and other access methodsC++ API
Thrift
ADO.NET
JDBC
ODBC
Proprietary native API
Java API
RESTful HTTP/JSON API
ADO.NET
JDBC
ODBC
Supported programming languagesC++
Java
Perl
PHP
Python
Ruby
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
Erlang
Java
JavaScript
any language that supports sockets and either XML or JSON
Perl
PHP
Python
Ruby
Scala
All languages supporting JDBC/ODBC/ADO.Net
Server-side scripts infoStored proceduresnoyes infoproprietary syntaxJava pluginsJava Stored Procedures
Triggersnoyesyes infoUser configurable commands triggered on index changesno
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL FabricShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor on file system levelMulti-source replication
Source-replica replication
yesyes, via HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnospark-solr: github.com/­lucidworks/­spark-solr and streaming expressions to reduceyes infovia user defined functions and HBase
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyes infonot for MyISAM storage enginenoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID infonot for MyISAM storage engineoptimistic lockingACID
Concurrency infoSupport for concurrent manipulation of datayesyes infotable locks or row locks depending on storage engineyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesno
User concepts infoAccess controlnoUsers with fine-grained authorization concept infono user groups or rolesyesfine grained access rights according to SQL-standard

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
3rd partiesFivetran: Quickly and easily centralize your on-premise and cloud databases.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

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

More resources
HypertableMySQLSolrTrafodion
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

Elasticsearch replaced Solr as the most popular search engine
12 January 2016, Paul Andlinger

Enterprise Search Engines almost double their popularity in the last 12 months
2 July 2014, Paul Andlinger

The DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

Recent citations in the news

Global Columnar Databases Software Market 2021 Research Analysis – The Apache Software Foundation, AWS, Snowflake, Google – Discovery Sports Media
20 January 2022, Discovery Sports Media

TimescaleDB goes distributed; implements ‘Chunking’ over ‘Sharding’ for scaling-out
22 August 2019, Packt Hub

Timescale Cloud: Managed Time Series Database on Azure, Google Cloud and AWS
27 June 2019, InfoQ.com

Timescale Launches Industry's First Multi-Node Relational Database for Time-Series Data, Giving Organizations Unprecedented Scale
29 October 2020, Business Wire

provided by Google News

Connect to an MySQL Database via Python | by Christianlauer | CodeX | Jan, 2022
13 January 2022, Medium

PostgreSQL vs MySQL | Compare Database Management Systems
20 December 2021, Server Watch

Cloudflare Introduces Support for Relational Database Connections Through Workers
20 January 2022, InfoQ.com

The 10 Most Common MySQL Queries
23 September 2010, Database Journal

Getting Started with Python and InfluxDB – The New Stack
21 January 2022, thenewstack.io

provided by Google News

SOLR: Under the Hood
18 January 2022, ETF Trends

The Energy Transition | Ofgem made heat networks regulator and SoLR consultation
10 January 2022, Lexology

Ofgem opens the door for third party finance providers to participate in the Supplier of Last Resort process
11 January 2022, JD Supra

Bulb energy: counting the cost of special administration
6 January 2022, Lexology

Together Energy becomes first supplier to collapse in 2022 amidst continuing high power prices
18 January 2022, Current News

provided by Google News

The Apache® Software Foundation Announces Annual Report for
31 August 2021, GlobeNewswire

provided by Google News

Job opportunities

Open Roles
Mayflower Venues, Boston, MA

Fulfillment Operations Application and Technology Administrator
The Orvis Company, Roanoke, VA

PHP/MySQL Developer
VS Media Inc, Westlake Village, CA

PHP & MySQL & HTML/CSS & JS Developers
Retail Ecommerce Ventures, Remote

CampusPress Support Enthusiast
Incsub, Remote

Java SOLR Consultant
Infinity Quest, Remote

Java SOLR Developer
Global Alliant Inc, Washington, DC

PHP Developer
Psychology Today, Remote

Software Engineer (Backend)
O'Reilly Media, Remote

Senior Web Developer (Angular/ReactJS, ElasticSearch or Solr)
Irisidea TechSolutions Pvt Ltd, Remote

jobs by Indeed



Share this page

Featured Products

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.

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.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Neo4j logo

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

Present your product here