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 > Altibase vs. Hive vs. mSQL

System Properties Comparison Altibase vs. Hive vs. mSQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAltibase  Xexclude from comparisonHive  Xexclude from comparisonmSQL infoMini SQL  Xexclude from comparison
DescriptionAn enterprise grade, high-performance RDBMSdata warehouse software for querying and managing large distributed datasets, built on HadoopmSQL (Mini SQL) is a simple and lightweight RDBMS
Primary database modelRelational DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.05
Rank#172  Overall
#85  Relational DBMS
Score81.93
Rank#15  Overall
#10  Relational DBMS
Score1.85
Rank#126  Overall
#61  Relational DBMS
Websitealtibase.comhive.apache.orghughestech.com.au/­products/­msql
Technical documentationgithub.com/­ALTIBASE/­Documents/­tree/­master/­Manualscwiki.apache.org/­confluence/­display/­Hive/­Home
DeveloperAltibaseApache Software Foundation infoinitially developed by FacebookHughes Technologies
Initial release199920121994
Current releasev7.1.0.5.3, March 20213.1.2, August 20194.4, October 2021
License infoCommercial or Open SourceOpen Source infosince February 2018Open Source infoApache Version 2commercial infofree licenses can be provided
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++JavaC
Server operating systemsAIX
HP-UX
Linux
All OS with a Java VMAIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
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.nono
Secondary indexesyesyesyes
SQL infoSupport of SQLANSI SQL-92SQL-like DML and DDL statementsA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggers
APIs and other access methodsJDBC
ODBC
Proprietary protocol
JDBC
ODBC
Thrift
JDBC
ODBC
Supported programming languagesC
C++
Java
C++
Java
PHP
Python
C
C++
Delphi
Java
Perl
PHP
Tcl
Server-side scripts infoStored proceduresstored procedures and stored functionsyes infouser defined functions and integration of map-reduceno
Triggersyesnono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesyesselectable replication factornone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReduceno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistencynone
Foreign keys infoReferential integrityyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnono
Concurrency infoSupport for concurrent manipulation of datayesyesno
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users, groups and rolesno

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 partiesSQLFlow: 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

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

More resources
AltibaseHivemSQL infoMini SQL
DB-Engines blog posts

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Recent citations in the news

Worldwide In-Memory Computing Industry to 2026 - Featuring Altibase, Fujitsu and GigaSpaces Technologies Among Others - ResearchAndMarkets.com
15 November 2021, Business Wire

Altibase is Adopted by CoreDAX, a Cryptocurrency Exchange, for Management of Key IT Functions of Matching, Data Distribution and Ledgers
7 January 2019, PRNewswire

Altibase Becomes the World's First Company to Develop Hybrid Partitioned Table for Efficacy and Efficiency in Writing Database Programs
11 November 2019, PRNewswire

Altibase is Adopted for Presence Service to Provide User Information and Online Presence
8 April 2019, PRNewswire

Database Software Market Analysis, Size, Share, Growth, Trends and Forecast 2021-2026
23 November 2021, Northwest Diamond Notes

provided by Google News

Compare Hadoop vs. Spark vs. Kafka for your big data strategy
15 November 2021, TechTarget

AWS Announces New Serverless Options for Three Analytics Services
30 November 2021, Business Wire

Starburst Unveils Cross-Cloud Analytics Service
29 November 2021, Datanami

Real-Time Exactly-Once Event Processing at Uber with Apache Flink, Kafka, and Pinot
12 November 2021, InfoQ.com

Okera Expands Its Footprint with AWS to Power Universal Data Authorization
29 November 2021, PRNewswire

provided by Google News

Job opportunities

Hortonworks Administrator
nFolks Data Solutions, Austin, TX

PS Engineering - Data Analysis
Procter & Gamble, Cincinnati, OH

Data Engineer - 4036504
Accenture, Walnut Creek, CA

GCP Developer
Cognizant Technology Solutions, Hamden, CT

Hadoop Administrator
Logic Loops, Atlanta, GA

Senior Programmer Analyst
Information Consulting Services of Delaware Valley, Philadelphia, PA

Java Programmer/Developer
Intone Networks, Philadelphia, PA

Java / PHP Programmer Analyst
Intone Networks, Philadelphia, PA

Sr. Developer/Programmer Analyst
Medical Guardian, Philadelphia, PA

Senior Programmer Analyst
Medical Guardian LLC, Philadelphia, PA

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here