DB-EngineseXtremeDB high availability featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Google Cloud Spanner vs. Graphite vs. Hypertable vs. MySQL vs. SAP IQ

System Properties Comparison Google Cloud Spanner vs. Graphite vs. Hypertable vs. MySQL vs. SAP IQ

Editorial information provided by DB-Engines
NameGoogle Cloud Spanner  Xexclude from comparisonGraphite  Xexclude from comparisonHypertable  Xexclude from comparisonMySQL  Xexclude from comparisonSAP IQ infoformer name: Sybase IQ  Xexclude from comparison
Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
DescriptionA horizontally scalable, globally consistent, relational database service. It is the externalization of the core Google database that runs the biggest aspects of Google, like Ads and Google Play.Data logging and graphing tool for time series data infoThe storage layer (fixed size database) is called WhisperAn open source BigTable implementation based on distributed file systems such as HadoopWidely used open source RDBMSColumnar RDBMS optimized for Big Data analytics
Primary database modelRelational DBMSTime Series DBMSWide column storeRelational DBMS infoKey/Value like access via memcached APIRelational DBMS infocolumn-oriented
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.89
Rank#106  Overall
#52  Relational DBMS
Score4.68
Rank#79  Overall
#4  Time Series DBMS
Score1255.45
Rank#2  Overall
#2  Relational DBMS
Score5.21
Rank#74  Overall
#41  Relational DBMS
Websitecloud.google.com/­spannergithub.com/­graphite-project/­graphite-webwww.mysql.comwww.sap.com/­products/­sybase-iq-big-data-management.html
Technical documentationcloud.google.com/­spanner/­docsgraphite.readthedocs.iodev.mysql.com/­dochelp.sap.com/­iq
DeveloperGoogleChris DavisHypertable Inc.Oracle infosince 2010, originally MySQL AB, then SunSAP, formerly Sybase
Initial release20172006200919951994
Current release0.9.8.11, March 20168.0.22, 202016.1 SPS04, April 2019
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0Open Source infoGNU version 3. Commercial license availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availablecommercial
Cloud-based only infoOnly available as a cloud serviceyesnononono
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 languagePythonC++C and C++
Server operating systemshostedLinux
Unix
Linux
OS X
Windows infoan inofficial Windows port is available
FreeBSD
Linux
OS X
Solaris
Windows
AIX
HP-UX
Linux
Solaris
Windows
Data schemeyesyesschema-freeyesyes
Typing infopredefined data types such as float or dateyesNumeric data onlynoyesyes
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.nonoyesno
Secondary indexesyesnorestricted infoonly exact value or prefix value scansyesyes
SQL infoSupport of SQLyes infoQuery statements complying to ANSI 2011nonoyes infowith proprietary extensionsyes
APIs and other access methodsgRPC (using protocol buffers) API
JDBC infoAt present, JDBC supports read-only queries. No support for DDL or DML statements.
RESTful HTTP API
HTTP API
Sockets
C++ API
Thrift
ADO.NET
JDBC
ODBC
Proprietary native API
ADO.NET
JDBC
ODBC
RESTful HTTP API
Supported programming languagesGo
Java
JavaScript (Node.js)
Python
JavaScript (Node.js)
Python
C++
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
C
C#
C++
Java
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresnononoyes infoproprietary syntaxyes
Triggersnononoyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingnoneShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabricshared disk or shared nothing architectures with SAP IQ Multiplexer
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication with 3 replicas for regional instances.noneselectable replication factor on file system levelMulti-source replication
Source-replica replication
SAP/Sybase Replication Server
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infousing Google Cloud DataflownoyesnoHadoop integration
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencynoneImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyes infoby using interleaved tables, this features focuses more on performance improvements than on referential integritynonoyes infonot for MyISAM storage engineyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infoStrict serializable isolationnonoACID infonot for MyISAM storage engineACID
Concurrency infoSupport for concurrent manipulation of datayesyes infolockingyesyes infotable locks or row locks depending on storage engineyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesno
User concepts infoAccess controlAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)nonoUsers with fine-grained authorization concept infono user groups or rolesfine 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 partiesNavicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

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

ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

Datadog: Improve MySQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards.
» more

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

More resources
Google Cloud SpannerGraphiteHypertableMySQLSAP IQ infoformer name: Sybase IQ
DB-Engines blog posts

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

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

Recent citations in the news

DoiT International Achieves Google Cloud Data Management Specialization
4 December 2020, AiThority

Google Updates Cloud Spanner with New Features: Backup on Demand, Local Emulator, and More
1 May 2020, InfoQ.com

Google enhances Cloud Spanner and other databases
20 August 2020, TechTarget

Google lays out HarbourBridge to tempt PostgreSQL users onto Cloud Spanner • DEVCLASS
13 February 2020, DevClass

CockroachDB adds Kubernetes and geospatial data support
10 November 2020, ZDNet

provided by Google News

Monitoring Microservices the Right Way
3 December 2020, InfoQ.com

Try out the Graphite monitoring tool for time-series data
29 October 2019, TechTarget

Graphite Miners News For The Month Of November 2020
27 November 2020, Seeking Alpha

Apple Watch 6 hits lowest price, up to $120 off in Amazon Cyber Monday deal
28 November 2020, Laptop Mag

Lomiko Forms Technical, Safety and Sustainability Committee and Charter to Oversee La Loutre Assessment
17 November 2020, Investing News Network

provided by Google News

Global NoSQL Databasess Market Size, Demand, Growth, Trends, Segmentation and Forecasts Research to 2025
2 December 2020, The Haitian-Caribbean News Network

Global Nosql Market 2026 Growth Analysis by Manufacturers, Regions, Type and Application, Forecast Analysis
28 November 2020, The Market Feed

Impact of Covid 19 On NoSQL Market 2020 Industry Challenges Business Overview And Forecast Research Study 2026
4 December 2020, Factory Maintenance

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

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

provided by Google News

Oracle Announces Availability of Integrated, High-performance Analytics Engine for MySQL Database Service
2 December 2020, PRNewswire

Oracle adds data warehousing to MySQL
3 December 2020, TechRadar

Oracle brings in-memory analytics to MySQL
3 December 2020, iTWire

Delphix Bets Big on MySQL, Mongo, and Couchbase with Select Connectors
17 November 2020, Security Boulevard

MySQL DBA - DialogTech
11 November 2020, Built In Chicago

provided by Google News

A look inside the SAP IQ column-oriented database
10 March 2016, TechTarget

What Will Happen After End Of Support For Sybase?
17 December 2019, E3zine.com

Forrester Research Names SAP a Leader in Data Management
18 February 2020, Data & Storage Asean

SAP data and analytics: in with the new, don't squander the old
22 July 2019, ZDNet

What's new in SAP HANA Cloud Services and why it matters
27 June 2019, TechTarget

provided by Google News

Job opportunities

Product Marketing Manager, Databases, Google Cloud
Google, Sunnyvale, CA

Technical Architect - Private Cloud (Remote)
Marriott International, Inc, Bethesda, MD

Senior GCP Architect | REMOTE JOB
iknowvate technologies, Memphis, TN

Cloud Engineer (Expert) - App & Platform Mgmt - IT - Cor
Bayer, St. Louis, MO

Software Engineer - Offers
Honey, Los Angeles, CA

Orvis Fly-Rod Manufacturing Associate
The Orvis Company, Manchester Center, VT

SHEET METAL MECHANIC (AIRCRAFT/PAINTER)
US Department of the Air Force, Macdill AFB, FL

Public Health Assistant Laboratories Director
City of Milwaukee, Milwaukee, WI

Infrastructure Engineer
Disney Streaming Services, New York, NY

Lead GPFS Engineer
RedLine Performance Solutions, Greenbelt, MD

IT Service Desk Agent
Percona, Remote

Loss Prevention Specialist
Amazon.com Services LLC, Memphis, TN

MySQL Database Administrator
Updox, Remote

Software Engineer Internship
WebFX, Inc., Harrisburg, PA

Junior Backend Web Developer
First Community Credit Union of Oregon, Coquille, OR

Junior Data Strategy Analyst (JDSA)*
National Capitol Contracting (NCC), Puget Sound, WA

DBA de Motores de base de datos
ACTIVOS S A S, Washington, DC

Profesional DBA Motores SAP
ACTIVOS S A S, Washington, DC

jobs by Indeed




Share this page

Featured Products

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Present your product here