informix和mysql对接_Informix

Editorial information provided by DB-Engines

NameInformix  Xexclude from comparisonMySQL  Xexclude from comparison

DescriptionA secure embeddable database from IBM, positioned besides DB2 as a relatively low-cost product optimized for OLTP and Internet of Things dataWidely used open source RDBMS

Primary database modelRelational DBMS Since Version 12.10 support for JSON/BSON datatypes compatible with MongoDBRelational DBMS Key/Value like access via memcached API

Secondary database modelsDocument store

Time Series DBMS with Informix TimeSeries Extension

DB-Engines Ranking measures the popularity of database management systems

DeveloperIBM, HCL Technologies Effective May 1st, 2017, HCL took on development, technical support, and product management teams, and works jointly with IBM on product strategy, marketing, and sales.Oracle since 2010, originally MySQL AB, then Sun

Initial release19841995

Current release14.10.FC5, November 20208.0.23 , January 2021

License Commercial or Open Sourcecommercial free developer edition availableOpen Source GPL version 2. Commercial licenses with extended functionallity are available

Cloud-based only Only available as a cloud servicenono

DBaaS offerings (sponsored links) Database 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 JavaC and C++

Server operating systemsAIX

HP-UX

Linux

macOS

Solaris

WindowsFreeBSD

Linux

OS X

Solaris

Windows

Data schemeyesyes

Typing predefined data types such as float or dateyes Since Version 12.10 support for JSON/BSON datatypesyes

XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes

Secondary indexesyesyes

SQL Support of SQLyesyes with proprietary extensions

APIs and other access methodsJDBC

JSON API MongoDB compatible

MQTT (Message Queue Telemetry Transport)

ODBC

RESTful HTTP APIADO.NET

JDBC

ODBC

Proprietary native API

Supported programming languages.Net

C

C++

Java

JavaScript (Node.js)

PHP

Python

RubyAda

C

C#

C++

D

Delphi

Eiffel

Erlang

Haskell

Java

JavaScript (Node.js)

Objective-C

OCaml

Perl

PHP

Python

Ruby

Scheme

Tcl

Server-side scripts Stored proceduresyesyes proprietary syntax

Triggersyesyes

Partitioning methods Methods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabric

Replication methods Methods for redundantly storing data on multiple nodesMulti-source replication

Source-replica replicationMulti-source replication

Source-replica replication

MapReduce Offers an API for user-defined Map/Reduce methodsnono

Consistency concepts Methods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency

Foreign keys Referential integrityyesyes not for MyISAM storage engine

Transaction concepts Support to ensure data integrity after non-atomic manipulations of dataACIDACID not for MyISAM storage engine

Concurrency Support for concurrent manipulation of datayesyes table locks or row locks depending on storage engine

Durability Support for making data persistentyesyes

In-memory capabilities Is there an option to define some or all structures to be held in-memory only.yesyes

User concepts Access controlUsers with fine-grained authentication, authorization, and auditing controlsUsers with fine-grained authorization concept no user groups or roles

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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.

» more

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

» more

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

» 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

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

More resources

InformixMySQL