DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

DBMS > Apache Druid vs. Microsoft Azure Data Explorer vs. SpatiaLite vs. Teradata Aster

Vergleich der Systemeigenschaften Apache Druid vs. Microsoft Azure Data Explorer vs. SpatiaLite vs. Teradata Aster

Bitte wählen Sie ein weiteres System aus, um es in den Vergleich aufzunehmen.

Redaktionelle Informationen bereitgestellt von DB-Engines
NameApache Druid  Xaus Vergleich ausschliessenMicrosoft Azure Data Explorer  Xaus Vergleich ausschliessenSpatiaLite  Xaus Vergleich ausschliessenTeradata Aster  Xaus Vergleich ausschliessen
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
KurzbeschreibungOpen-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality dataFully managed big data interactive analytics platformSpatial extension of SQLitePlatform for big data analytics on multistructured data sources and types
Primäres DatenbankmodellRelational DBMS
Time Series DBMS
Relational DBMS infocolumn orientedSpatial DBMSRelational DBMS
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)
Spatial DBMS
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
Relational DBMS
DB-Engines Ranking infomisst die Popularität von Datenbankmanagement- systemenranking trend
Trend Chart
Punkte2,63
Rang#114  Overall
#58  Relational DBMS
#6  Time Series DBMS
Punkte7,34
Rang#60  Overall
#34  Relational DBMS
Punkte2,14
Rang#126  Overall
#3  Spatial DBMS
Websitedruid.apache.orgazure.microsoft.com/­services/­data-explorerwww.gaia-gis.it/­fossil/­libspatialite/­index
Technische Dokumentationdruid.apache.org/­docs/­latest/­designdocs.microsoft.com/­en-us/­azure/­data-explorerwww.gaia-gis.it/­gaia-sins/­spatialite_topics.html
EntwicklerApache Software Foundation and contributorsMicrosoftAlessandro FurieriTeradata
Erscheinungsjahr2012201920082005
Aktuelle Version24.0.0, September 2022cloud service with continuous releases5.0.0, August 2020
Lizenz infoCommercial or Open SourceOpen Source infoApache license v2kommerziellOpen Source infoMPL 1.1, GPL v2.0 or LGPL v2.1kommerziell
Ausschließlich ein Cloud-Service infoNur als Cloud-Service verfügbarneinjaneinnein
DBaaS Angebote (gesponserte Links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
ImplementierungsspracheJavaC++
Server BetriebssystemeLinux
OS X
Unix
gehostetserverlosLinux
Datenschemaja infoschema-less columns are supportedFixed schema with schema-less datatypes (dynamic)jaFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Store
Typisierung infovordefinierte Datentypen, z.B. float oder datejaja infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesjaja
XML Unterstützung infoVerarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLTneinjaneinja infoin Aster File Store
Sekundärindizesjaall fields are automatically indexedjaja
SQL infoSupport of SQLSQL for queryingKusto Query Language (KQL), SQL subsetjaja
APIs und andere ZugriffskonzepteJDBC
RESTful HTTP/JSON API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
ADO.NET
JDBC
ODBC
OLE DB
Unterstützte ProgrammiersprachenClojure
JavaScript
PHP
Python
R
Ruby
Scala
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
C
C#
C++
Java
Python
R
Server-seitige Scripts infoStored ProceduresneinYes, possible languages: KQL, Python, RneinR packages
Triggersneinja infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyjanein
Partitionierungsmechanismen infoMethoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen KnotenSharding infomanual/auto, time-basedSharding infoImplicit feature of the cloud servicekeineSharding
Replikationsmechanismen infoMethoden zum redundanten Speichern von Daten auf mehreren Knotenja, durch HDFS, S3 oder andere Storage Enginesja infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.keineja infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.
MapReduce infoBietet ein API für Map/Reduce OperationenneinSpark connector (open source): github.com/­Azure/­azure-kusto-sparkneinja infoSQL Map-Reduce Framework
Konsistenzkonzept infoMethoden zur Sicherstellung der Konsistenz in einem verteilten SystemImmediate ConsistencyEventual Consistency
Immediate Consistency
Immediate Consistency or Eventual Consistency depending on configuration
Fremdschlüssel inforeferenzielle Integritätneinneinjanein
Transaktionskonzept infoUnterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren DatenmanipulationenneinneinACIDACID
Concurrency infoUnterstützung von gleichzeitig ausgeführten Datenmanipulationenjajajaja
Durability infoDauerhafte Speicherung der Datenjajajaja
In-Memory Unterstützung infoGibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu haltenneinneinjanein
Berechtigungskonzept infoZugriffskontrolleRBAC using LDAP or Druid internals for users and groups for read/write by datasource and systemAzure Active Directory AuthenticationneinBenutzer mit feingranularem Berechtigungskonzept entsprechend SQL-Standard
Weitere Informationen bereitgestellt vom Systemhersteller
Apache DruidMicrosoft Azure Data ExplorerSpatiaLiteTeradata Aster
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
Licensing and pricing modelsAn Azure Data Explorer cluster is a pair of engine and data management clusters which...
» 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
Apache DruidMicrosoft Azure Data ExplorerSpatiaLiteTeradata Aster
DB-Engines Blog Posts

Spatial database management systems
6. April 2021, Matthias Gelbmann

alle anzeigen

Erwähnungen in aktuellen Nachrichten

Imply Announces Major Open Source Contribution for Apache Druid; New Financial Guarantee for Apache Druid Users
20. September 2022, Business Wire

Acceldata teams with Snowflake for improved visibility in modern data environments
29. September 2022, SiliconANGLE News

Apache Druid Takes Its Place In The Pantheon Of Databases
16. Juni 2022, The Next Platform

How to install the Apache Druid real-time analytics database on Ubuntu-based Linux distributions
25. Mai 2022, TechRepublic

Apache Druid Gets Multi-Stage Reporting Engine, Cloud Service from Imply
1. März 2022, Datanami

bereitgestellt von Google News

Azure Data Explorer Supports Native Ingestion from Amazon S3
7. September 2022, InfoQ.com

New Azure for Operators solution accelerator offers a fast path to network insights
27. September 2022, Microsoft

IoT Bridge for Microsoft Azure from Cirrus Link to Connect OT Data to Microsoft Azure
22. September 2022, ARC Advisory Group

Uptake Fusion to Support Microsoft Azure Data Explorer
1. März 2022, PR Newswire

Microsoft Azure Managed Grafana Tool Improves Data Visualizations
1. September 2022, Petri.com

bereitgestellt von Google News

Teradata Aster Analytics Going Places: On Hadoop and AWS
24. August 2016, PR Newswire

Teradata, Lunexa Partnership Introduces Digital Marketing Attribution Solution for Teradata Aster Analytics Platforms
5. Juni 2012, PR Newswire

What Is a Data Lakehouse?
5. März 2022, Coinspeaker

How to Select the Right Database for Time-Series Data
2. Dezember 2021, thenewstack.io

Case study: Siemens reduces train failures with Teradata Aster
12. September 2016, RCR Wireless News

bereitgestellt von Google News

Jobangebote

Big Data Engineer
Ennuviz, Remote

Sr Data Engineer – Marketing Data Analytics
Lowe's, Charlotte, NC

Java Developer with Big Data
Intone Networks, Manhattan, NY

Software Engineer All Seniority Levels
f5, San Jose, CA

Data Engineering Manager
Jewelers Mutual Insurance Company, SI, Dallas, TX

Data Engineer - Kusto / KQL / Kusto query language / Azure Data Explorer
Tech Mahindra / Microsoft, Remote

Embedded Escalation Engineer - Azure Data Explorer
Microsoft, United States

Data Engineer- Pyspark OR ADF (Azure Data Factory)
Tech Mahindra, Remote

Azure Data Engineer
DHL eCommerce, Remote

Sr. Azure Database Modernization Architect
PRICE WATERHOUSE COOPERS, Buffalo, NY

Consultant - Data Engineer
Insygnum, Chicago, IL

Sr Analyst, DACI Analytics - IoT, Store Inventory, & Asset Protection
Lowe's, Charlotte, NC

Sr. Consultant - Data Engineer
Insygnum, Chicago, IL

Sr Analyst, Digital Analytics
Lowe's, North Carolina

Director, Technical Product Manager - Data
MatrixCare, Peachtree Corners, GA

jobs by Indeed



Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

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.

Redis logo

The world’s most loved real‑time data platform.
Try free

Präsentieren Sie hier Ihr Produkt