About Me

My photo
I worked as freelancer on freelance.com for many years, Then opened my Company. I did software coding with my company. But also did pottery -- I know well business management. Software coding is coming next to it as a plus. It helps but organising is as much important as coding. I have many years of experience in business management of Industrial Construction works. I am quite known as company for CAD drafting and 3d for architectural design. I had quite a lot experience at USA and at Turkey. I am less known, in my pottery love.

Tuesday, January 23, 2024

Popular DB`s comparison - some popular may be missing - comment if required


data  source: g2.com

I designed the following tables according the data from the source. I am not sure if I designed or not the graph but anyway the graph is rare in its kind. 

Popular DB comparison

(I doubt when people make these list they place at top their sponsor) :

 

RDBMS

NoSQL

DBMS

Big Data

Graph DB

MS SQL

x

 

x

x

 

My SQL

x

 

 

 

 

Oracle DB

x

 

 

 

 

Oracle sql dev

 

 

x

 

 

Oracle Enterprise

 

 

x

 

 

Oracle Toad

 

 

x

 

 

IBM dbz

x

x

 

 

 

Postgre SQL

x

 

 

 

 

SAP HANA

x

 

 

 

 

Mongo DB

 

x

 

 

 

Mongo Atlas

 

x

 

 

 

Hbase

 

x

 

 

 

Amazon Dyna.DB

 

x

 

 

 

Redis

 

x

 

 

 

Snow flake

 

 

x

x

 

PHP MyAdmin

 

 

x

 

 

MATLAB

 

 

 

x

 

Qubole

 

 

 

x

 

Qlid Sense

 

 

 

x

 

Google BigQuery

 

 

 

x

 

Neo4j

 

x

 

x

x

Open source RDBMS: 

I added in this table Neo4j which is mentioned nowhere. Graph database are not new as DB system. They got popular with no sql and with WYSIWYG popularity risng. Despite that fact, the graph databases are not mentioned. I guess it is like Java or C or even more Python of the programming language. It seems complex (but it is not) and everybody has a hell fear of it. 



leader

Contenders

Leaders

 

 

 

 

 

 

 

 

 

 

1 -

 

 

 

 

 

 

 

a

b

 

2

 

 

 

 

 

 

 

c

 

 

3

i

 

 

 

 

 

 

 

 

 

4

 

 

 

 

 

 

d

 

 

 

5

Market presence

 

 

 

h

 

 

e

 

 

 

6

 

 

 

g

 

 

 

 

 

 

7

 

 

 

 

 

 

 

 

 

 

8

 

 

 

 

 

f

 

 

 

 

9

 

 

 

 

 

 

 

 

 

 

10 +

Niche

1 -

2

3

4

5

6

7

8

9

10 +

High perform

satisfaction

 

a

Amazon RDBMS

b

My SQL

c

Postgre SQL

d

mariadb

e

SQL lite

f

Firebird

g

cockroach DB

h

Apache Derby

i

SAP adaptik server

Document DB

  • Mongo DB
  • Couch DB
  • Orient DB

Database types:

source: db-engines.com 

 

RDBMS

Document Store

Spatial DB

Graph DB

MySQL

x

x

x

 

PostgreSQL

x

x

x

 

MariaDB

x

x

x

x

Sqlite

x

 

 

 

Firebird

x

 

 

 

CockroachDB

x

 

 

 

Apache Derby

x

 

 

 

 

Supported programming languages in DB`s 


 source: db-engines.com 
again here I am not sure if the source has done or not this table, if not I am the first doing it. 

 

MySQL

PostgreSQL

Maria DB

Neo4j

C

x

x

x

 

C#

x

 

x

 

C++

x

x

x

 

D

x

 

x

 

Delphi

x

x

 

 

Eiffel

x

 

x

 

Erlang

x

 

x

 

Haskell

x

 

x

x

Java

x

x

x

x

JS *Node JS)

x

x

x

x

Objective C

x

 

x

 

Ocaml

x

 

x

 

Perl

x

x

x

x

PHP

x

x

x

x

Pyhton

x

x

x

x

Ruby

x

 

x

x

Scheme

x

 

x

 

Tcl

x

x

x

 

.NET

 

x

 

x

ADA

x

 

 

 

Go

 

 

x

x

Scala

 

 

 

x

Closure

 

 

 

x

Elixir

 

 

 

x



Apix Access methods

source: db-engines.com 

MySQL

PostgreSQL

MariaDB

Neo4j

ADO.NET

x

x

x

 

JDBC

x

x

x

 

Native C library

 

x

 

 

ODBC

x

x

x

 

Stream API

 

x

 

 

Prop. Native API

x

 

x

 

Bolt Protocol

 

 

 

x

Cypher Query

 

 

 

x

Java API

 

 

 

x

Neo4j OGM

 

 

 

x

Restful HTTP API

 

 

 

x

Spring Data N4j

 

 

 

x

Tinker Pop 3

 

 

 

x


Server Operating system

source: db-engines.com 

 

My SQL

PostgreSQL

MariaDB

Neo4j

Solaris

x

x

x

x

Linux

x

x

x

x

Free BSD

x

x

x

 

Mac OS

 

 

 

 

Windows

x

x

x

x

OSX

x

x

 

x

XML support

x

x

x

 


Just my note about sites using sponsorship and to sponsors

I guess none of the comparison website (this vs that) ever use this kind of table for comparing. I guess again this is related to their sponsorship. If ever sponsors just pay for non objective presentation of things, I think they do wrong. Because all user make this kind of table in their mind, or they ask to someone who can do this kind of table in their mind. The result of sponsoring: loosing credentials. So all sponsor should think again how do they sponsor some site making "this vs that" comparison things. That is just an advice based on my observation and my experience in programming business.

My Note about a missing DB

I don`t why on earth none of the website I visited do not mention at all Microsoft Access. I designed many company db`s using it, and it helped a lot of company ersolving their great management problems.=

Ms Access is low cost also it has not a great capacity, but it should be placed as mid performance but and mid market presence according to me.  


No comments:

Post a Comment

neo4j-mathematics

 create the nodes: CREATE   ( n : sil   { name : "k1" ,  val :   1250 }),( m : sil2   { name : "k2" ,  val : 1250 }),   ...