DB-EnginesInfluxDB download bannerEnglish
Deutsch
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

DBMS > Google Cloud Spanner vs. Graphite vs. Hypertable vs. Microsoft Azure Data Explorer vs. SAP IQ

Vergleich der Systemeigenschaften Google Cloud Spanner vs. Graphite vs. Hypertable vs. Microsoft Azure Data Explorer vs. SAP IQ

Redaktionelle Informationen bereitgestellt von DB-Engines
NameGoogle Cloud Spanner  Xaus Vergleich ausschliessenGraphite  Xaus Vergleich ausschliessenHypertable  Xaus Vergleich ausschliessenMicrosoft Azure Data Explorer  Xaus Vergleich ausschliessenSAP IQ infofrüher: Sybase IQ  Xaus Vergleich ausschliessen
Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
KurzbeschreibungA 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 WhisperEine Open Source BigTable Implementation basierend auf Distributed File Systems wie HadoopFully managed big data interactive analytics platformColumnar RDBMS optimized for Big Data analytics
Primäres DatenbankmodellRelational DBMSTime Series DBMSWide Column StoreRelational DBMS infocolumn orientedRelational DBMS infospaltenorientiert
Sekundäre DatenbankmodelleDocument Store infoIf a column is of type dynamic docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types/­dynamic then it's possible to add arbitrary JSON documents in this cell
Event Store infothis is the general usage pattern at Microsoft. Billing, Logs, Telemetry events are stored in ADX and the state of an individual entity is defined by the arg_max(timestamps)
Suchmaschine infosupport for complex search expressions docs.microsoft.com/­en-us/­azure/­kusto/­query/­parseoperator FTS, Geospatial docs.microsoft.com/­en-us/­azure/­kusto/­query/­geo-point-to-geohash-function distributed search -> ADX acts as a distributed search engine
Time Series DBMS infosee docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis
DB-Engines Ranking infomisst die Popularität von Datenbankmanagement- systemenranking trend
Trend Chart
Punkte2,74
Rang#105  Overall
#51  Relational DBMS
Punkte4,68
Rang#77  Overall
#4  Time Series DBMS
Punkte4,32
Rang#80  Overall
#44  Relational DBMS
Punkte4,97
Rang#76  Overall
#41  Relational DBMS
Websitecloud.google.com/­spannergithub.com/­graphite-project/­graphite-webazure.microsoft.com/­services/­data-explorerwww.sap.com/­products/­sybase-iq-big-data-management.html
Technische Dokumentationcloud.google.com/­spanner/­docsgraphite.readthedocs.iodocs.microsoft.com/­en-us/­azure/­data-explorerhelp.sap.com/­iq
EntwicklerGoogleChris DavisHypertable Inc.MicrosoftSAP, formerly Sybase
Erscheinungsjahr20172006200920191994
Aktuelle Version0.9.8.11, Maerz 2016cloud service with continuous releases16.1 SPS04, April 2019
Lizenz infoCommercial or Open SourcekommerziellOpen Source infoApache 2.0Open Source infoGNU Version 3. Kommerzielle Lizenzen verfügbarkommerziellkommerziell
Ausschließlich ein Cloud-Service infoNur als Cloud-Service verfügbarjaneinneinjanein
DBaaS Angebote (gesponserte Links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
ImplementierungssprachePythonC++
Server BetriebssystemegehostetLinux
Unix
Linux
OS X
Windows infoein inoffizieller Windows-Port ist verfügbar
gehostetAIX
HP-UX
Linux
Solaris
Windows
DatenschemajajaschemafreiFixed schema with schema-less datatypes (dynamic)ja
Typisierung infovordefinierte Datentypen, z.B. float oder datejaNumeric data onlyneinja infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesja
XML Unterstützung infoVerarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLTneinneinjanein
Sekundärindizesjaneineingeschränkt infoNur Gleichheits- und Präfixabfragenall fields are automatically indexedja
SQL infoSupport of SQLja infoQuery statements complying to ANSI 2011neinneinKusto Query Language (KQL), SQL subsetja
APIs und andere ZugriffskonzeptegRPC (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
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
ADO.NET
JDBC
ODBC
RESTful HTTP API
Unterstützte ProgrammiersprachenGo
Java
JavaScript (Node.js)
Python
JavaScript (Node.js)
Python
C++
Java
Perl
PHP
Python
Ruby
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
C
C#
C++
Java
Perl
PHP
Python
Ruby
Server-seitige Scripts infoStored ProceduresneinneinneinYes, possible languages: KQL, Python, Rja
Triggersneinneinneinja infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyja
Partitionierungsmechanismen infoMethoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen KnotenShardingkeineShardingSharding infoImplicit feature of the cloud serviceshared disk or shared nothing architectures with SAP IQ Multiplexer
Replikationsmechanismen infoMethoden zum redundanten Speichern von Daten auf mehreren KnotenMulti-source replication with 3 replicas for regional instances.keinewählbarer Replikationsfaktor auf Filesystemebeneja infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.SAP/Sybase Replication Server
MapReduce infoBietet ein API für Map/Reduce Operationenja infousing Google Cloud DataflowneinjaneinHadoop integration
Konsistenzkonzept infoMethoden zur Sicherstellung der Konsistenz in einem verteilten SystemImmediate ConsistencykeineImmediate ConsistencyEventual Consistency
Immediate Consistency
Immediate Consistency
Fremdschlüssel inforeferenzielle Integritätja infoby using interleaved tables, this features focuses more on performance improvements than on referential integrityneinneinneinja
Transaktionskonzept infoUnterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren DatenmanipulationenACID infoStrict serializable isolationneinneinneinACID
Concurrency infoUnterstützung von gleichzeitig ausgeführten Datenmanipulationenjaja infolockingjajaja
Durability infoDauerhafte Speicherung der Datenjajajajaja
In-Memory Unterstützung infoGibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu haltenneinneinnein
Berechtigungskonzept infoZugriffskontrolleAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)neinneinAzure Active Directory AuthenticationBenutzer mit feingranularem Berechtigungskonzept entsprechend SQL-Standard
Weitere Informationen bereitgestellt vom Systemhersteller
Google Cloud SpannerGraphiteHypertableMicrosoft Azure Data ExplorerSAP IQ infofrüher: Sybase IQ
Specific characteristicsAzure Data Explorer is a fast and highly scalable data exploration service for log...
» mehr
Competitive advantagesKusto Query Language (innovative query language, optimized for high performance data...
» mehr
Typical application scenariosIoT applications IoT devices generate billions of sensor readings. Normalizing and...
» mehr
Key customersMicrosoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd
» mehr
Market metricsAzure Data Explorer is the data service for Azure Monitor, Azure Time Series Insights,...
» mehr

Wir laden Vertreter der Systemhersteller ein uns zu kontaktieren, um die Systeminformationen zu aktualisieren und zu ergänzen,
sowie um Herstellerinformationen wie Schlüsselkunden, Vorteile gegenüber Konkurrenten und Marktmetriken anzuzeigen.

Zugehörige Produkte und Dienstleistungen

Wir laden Vertreter von Anbietern von zugehörigen Produkten ein uns zu kontaktieren, um hier Informationen über ihre Angebote zu präsentieren.

Weitere Ressourcen
Google Cloud SpannerGraphiteHypertableMicrosoft Azure Data ExplorerSAP IQ infofrüher: Sybase IQ
DB-Engines Blog Posts

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

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

alle anzeigen

Erwähnungen in aktuellen Nachrichten

Google Updates Cloud Spanner with New Features: Backup on Demand, Local Emulator, and More
1. Mai 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. Februar 2020, DevClass

Google Releases Spanner Emulator
1. Juni 2020, iProgrammer

Google’s Cloud Spanner database adds new features and regions
19. Dezember 2018, TechCrunch

bereitgestellt von Google News

EcoGraf Limited: Western Australian EcoGraf(TM) Battery Graphite Facility Advancing to Development
25. Januar 2021, Yahoo Finance UK

Ceylon Graphite Announces Participation in O&M Town Hall Webinar Thursday, January 21st, 2021 and Upcoming Investor Conference Schedules
20. Januar 2021, Financial Post

Gerhard Richter's 'Cage Paintings' on view at Gagosian gallery
26. Januar 2021, Los Angeles Times

National Ignition Facility conducts first-ever shot with explosives
26. Januar 2021, Newswise

Coatue and T. Rowe Price Funds Anchor $590m Investment in Sila Nanotechnologies
26. Januar 2021, Odessa American

bereitgestellt von Google News

NoSQL Databases Market Is Booming Worldwide | Accumulo, Aerospike, Flink, HBase – Murphy's Hockey Law
16. Januar 2021, Murphy's Hockey Law

Columnar Databases Software Market to Grow at a Stayed CAGR from 2020 to 2025
5. Januar 2021, News.MarketSizeForecasters.com

Global Columnar Databases Software Market Analysis (2021-2026)
11. Januar 2021, Industry Today

NoSQL Databases Market 2020: Key Players with Product Particulars, Applications, Market Size & Forecast till 2027 : Accumulo, Aerospike, Amazon SimpleDB, Azure Table, Cassandra, BigTable, Couchbase Server, CouchDB, Dynamo DB, Elasticsearch, Flink, HBase, HPCC Systems, Hypertable, MongoDB, NeDB, Oracle NoSQL, Riak, Redis
21. Januar 2021, NeighborWebSJ

NoSQL Market Analysis And Demand With Forecast Overview To 2027 – Reviewindependent
25. Januar 2021, Reviewindependent

bereitgestellt von Google News

Azure Data Explorer gets new engine, numerous enhancements and Synapse integration
14. Oktober 2020, ZDNet

What Is Azure Purview?
25. Januar 2021, Virtualization Review

AMD Boosts Microsoft Azure Data Explorer Performance
16. Oktober 2020, SDxCentral

AMD EPYC Processors Power Microsoft Azure Data Explorer, Offers Users 30 Percent Better Performance
15. Oktober 2020, HPCwire

Azure Data Explorer gets Synapse integration and other enhancements
15. Oktober 2020, EnterpriseTalk

bereitgestellt von Google News

Sap odp faq
26. Januar 2021, TandaaBiashara

A look inside the SAP IQ column-oriented database
10. März 2016, TechTarget

Forrester Research Names SAP a Leader in Data Management for Analytics
18. Februar 2020, Data & Storage Asean

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

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

bereitgestellt von Google News

Jobangebote

Data Engineer - Remote, SF, or DEN
Quizlet, San Francisco, CA

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

Engineering Manager, Data Platform
Box, Redwood City, CA

Systems Engineer
Major League Baseball, New York, NY

Application Engineer, M&A Technical Integrations
Google, New York, NY

Orvis Fly-Rod Winder (off-premise)
The Orvis Company, Manchester, VT

Rod Repair Data Entry (Orvis Rod Shop)
The Orvis Company, Manchester, VT

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

Cloud Application Engineer, Strategic Infrastructure - HBO Max
HBO, Seattle, WA

OpenShift Software Development Internship
Red Hat Software, Sacramento, CA

Data Engineer - Minecraft
Microsoft, Redmond, WA

BI Data Analyst
NCR, Addison, TX

Data Architect, ACL/ OIRM
BCT Partners, Washington, DC

Program Manager
Covestic, Redmond, WA

Software Engineer - Front-End
Microsoft, San Francisco, CA

SAS Admin - REMOTE
My HR Management, Port Washington, NY

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

jobs by Indeed




Teilen sie diese Seite mit ihrem Netzwerk

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 5 GB free..

Neo4j logo

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

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Couchbase logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Präsentieren Sie hier Ihr Produkt