ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What are the differences between Oracle , MSSql , MySql , Access and postgresql, please compare by the following points ?

Points are : (1) - number of the computers ( clients ) that I can Connect To that database (2) - security that make that database special (3) - command that help to make database very fast ( and if there GUI or just CLI) (4) - If I can make GUI for the database from within the program or not ( i.e do I must get program like visual studio.net or Eclipse to make graphic user interface for my database or the database it self has utilities for making this)

user-image
تم إضافة السؤال من قبل مستخدم محذوف‎
تاريخ النشر: 2014/03/18
Dhairyasheel Tawade
من قبل Dhairyasheel Tawade , Principal Technical Account Manager , Oracle India

Hi , rather than a general feature comparision what you should be looking at is what business will the database be supporting. If it's an enterprise wide database with business dependancy on it, then you are reduced to only3 choices really i.e. Oracle , DB2 and MS SQL. These3 are the market leaders in today's tech world.

Disadvantage of MS SQL is that you have to stick to Microsoft Platform only. 

When it comes to concurrency and high TPS support, there is really no beating Oracle and DB2.

 

In my personal exprience the added value you get with Oracle is the vast number of Oracle DBA professionals available in the market today. With attrition a major worry in IT industry now days, You don't want to implement a techonology which does not enjoy a good market penetration.

 

Oracle Database comes with Oracle SQL developer which is a free data query utility.

 

Regards.

Rami Nasr
من قبل Rami Nasr , Analyst Programmer , AUC -The American University in Cairo -

General information

 

 

Maintainer

First public release date

Latest stable version

Latest release date

Software license

Linter SQL RDBMS

RELEX Group

1990

6.x

Proprietary

Microsoft Access (JET)

Microsoft

1992

15 (2013)

Proprietary

Microsoft SQL Server

Microsoft

1989

2014 (12)

2014-3-18

Proprietary

Microsoft SQL Server Compact (Embedded Database)

Microsoft

2000

2011 (v4.0)

 

Proprietary

MySQL

Sun Microsystems (now Oracle Corporation)

1995-11

5.6.19

GPL v2 or Proprietary

OpenLink Virtuoso

OpenLink Software[21]

1998

7.x

GPL v2 or Proprietary

Oracle

Oracle Corporation

1979-11

12c Release1

Proprietary

Oracle Rdb

Oracle Corporation

1984

7.3.1.1.1

[22]

Proprietary

PostgreSQL

PostgreSQL Global Development Group[25]

1989-06

9.3.4[26]

PostgreSQL Licence (a liberal Open Source license)[27]

RDM Server

Raima Inc.[30]

1993

8.4

Proprietary

SAP HANA

SAP AG [31]

2010

1.0

 

Proprietary

 

 

 

Operating system support

The operating systems that the RDBMSes can run on.

 

Windows

OS X

Linux

BSD

UNIX

AmigaOS

Symbian

z/OS

iOS

Android

Microsoft Access (JET)

Yes

No

No

No

No

No

No

No

No

No

Microsoft SQL Server

Yes

No

No

No

No

No

No

No

No

No

Microsoft SQL Server Compact (Embedded Database)

Yes

No

No

No

No

No

No

No

No

No

MySQL

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

?

Yes[36]

Oracle

Yes

Yes

Yes

No

Yes

No

No

Yes

No

No

Oracle Rdb

No

No

No

No

No

No

No

No

No

No

PostgreSQL

Yes

Yes

Yes

Yes

Yes

No

No

Under Linux on System z[37]

No

Yes

 

 

Fundamental features

Information about what fundamental RDBMS features are implemented natively.

 

ACID

Referential integrity

Transactions

Fine-grained locking

Unicode

Interface

Microsoft Access (JET)

Yes

Yes

Yes

?

Yes

GUI & SQL

Microsoft SQL Server

Yes

Yes

Yes

Yes (Row-level locking)[40]

Yes

GUI & SQL

Microsoft SQL Server Compact (Embedded Database)

Yes

Yes

Yes

?

Yes

GUI & SQL

MySQL

Yes2

Partial3

Yes2 except for DDL[39]

Yes (Row-level locking)[41]

Yes

GUI 5 & SQL

Oracle

Yes

Yes

Yes except for DDL[39]

Yes (Row-level locking)[42]

Yes

API & GUI & SQL

Oracle Rdb

Yes

Yes

Yes

?

Yes

SQL

PostgreSQL

Yes

Yes

Yes

Yes (Row-level locking)[43]

Yes

API & GUI & SQL

 

 

 

Limits

Information about data size limits.

 

Max DB size

Max table size

Max row size

Max columns per row

Max Blob/Clob size

Max CHAR size

Max NUMBER size

Min DATE value

Max DATE value

Max column name size

Microsoft Access (JET)

2GB

2GB

16MB

255

64KB (memo field),1GB ("OLE Object" field)

255B (text field)

32 bits

0100

9999

64

Microsoft SQL Server

524,272TB (32767 files *16TB max file size)

524,272TB

8,060 bytes (Unlimited)6

30,000

2GB

2GB6

126 bits2

0001

9999

128

Microsoft SQL Server Compact (Embedded Database)

4GB

4GB

8,060 bytes

1024

2 GB

4000

154 bits

0001

9999

128

MySQL 5

Unlimited

MyISAM storage limits:256TB; Innodb storage limits:64TB

64KB3

4,0964

4GB (longtext, longblob)

64KB (text)

64 bits

1000

9999

64

Oracle

Unlimited (4GB * block size per tablespace)

4GB * block size (with BIGFILE tablespace)

8KB

1,000

128 TB

32,767B11

126 bits

−4712

9999

30

PostgreSQL

Unlimited

32 TB

1.6 TB

250–1600 depending on type

1 GB (text, bytea)[49] - stored inline or4 TB (stored in pg_largeobject)[50]

1 GB

Unlimited

−4,713

5,874,897

63

 

Max DB size

Max table size

Max row size

Max columns per row

Max Blob/Clob size

Max CHAR size

Max NUMBER size

Min DATE value

Max DATE value

Max column name size

 

 

 

Tables and views

Information about what tables and views (other than basic ones) are supported natively.

 

Temporary table

Materialized view

Microsoft Access (JET)

No

No

Microsoft SQL Server

Yes

Yes3

Microsoft SQL Server Compact (Embedded Database)

Yes

No

MySQL

Yes

No4

Oracle

Yes

Yes

Oracle Rdb

Yes

Yes

PostgreSQL

Yes

Yes5

 

 

 

Indices

Information about what indices (other than basic B-/B+ tree indices) are supported natively.

 

R-/R+ tree

Hash

Expression

Partial

Reverse

Bitmap

GiST

GIN

Full-text

Spatial

FOT

Microsoft Access (JET)

No

No

No

No

No

No

No

No

No[73]

?

?

Microsoft SQL Server

?

Non/Cluster & fill factor

Yes3

Yes4

No3

No

No

No

Yes[74]

Yes[75]

?

Microsoft SQL Server Compact (Embedded Database)

No

No

No

No

No

No

No

No

No[76]

?

?

MySQL

MyISAM tables only

MEMORY, Cluster (NDB), InnoDB,5 tables only

No[77]

No

No

No

No

No

MyISAM tables[78] and, since v5.6.4, InnoDB tables[79]

MyISAM tables only[80]

?

Oracle

Yes 11

Cluster Tables

Yes

Yes 6

Yes

Yes

No

No

Yes[81]

Yes[82]

?

Oracle Rdb

No

Yes

?

No

No

?

No

No

?

?

?

PostgreSQL

Yes

Yes

Yes

Yes

Yes7

Yes8

Yes

Yes

Yes[83]

PostGIS[84]

?

 

R-/R+ tree

Hash

Expression

Partial

Reverse

Bitmap

GiST

GIN

Full-text

Spatial

FOT

 

 

 

Database capabilities

 

Union

Intersect

Except

Inner joins

Outer joins

Inner selects

Merge joins

Blobs and Clobs

Common Table Expressions

Windowing Functions

Parallel Query

Microsoft Access (JET)

Yes

No

No

Yes

Yes

Yes

No

Yes

No

No

?

Microsoft SQL Server

Yes

Yes (2005 and beyond)

Yes (2005 and beyond)

Yes

Yes

Yes

Yes

Yes

Yes

Yes[104]

Yes[105]

Microsoft SQL Server Compact (Embedded Database)

Yes

No

No

Yes

Yes

?

No

Yes

No

No

?

MySQL

Yes

No

No

Yes

Yes

Yes

No

Yes

No[106]

No

No[107]

Oracle

Yes

Yes

Yes, via MINUS

Yes

Yes

Yes

Yes

Yes

Yes 1

Yes

Yes[108]

Oracle Rdb

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

?

?

?

PostgreSQL

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes[109]

 

Union

Intersect

Except

Inner joins

Outer joins

Inner selects

Merge joins

Blobs and Clobs

Common Table Expressions

Windowing Functions

Parallel Query

 

 

 

Data types

 

Type system

Integer

Floating point

Decimal

String

Binary

Date/Time

Boolean

Other

Microsoft SQL Server[118]

Static

TINYINT, SMALLINT, INT, BIGINT

FLOAT, REAL

NUMERIC, DECIMAL, SMALLMONEY, MONEY

CHAR, VARCHAR, TEXT, NCHAR, NVARCHAR, NTEXT

BINARY, VARBINARY, IMAGE, FILESTREAM

DATE, DATETIMEOFFSET, DATETIME2, SMALLDATETIME, DATETIME, TIME

BIT

CURSOR, TIMESTAMP, HIERARCHYID, UNIQUEIDENTIFIER, SQL_VARIANT, XML, TABLE

Microsoft SQL Server Compact (Embedded Database)[119]

Static

TINYINT, SMALLINT, INT, BIGINT

FLOAT, REAL

NUMERIC, DECIMAL, MONEY

NCHAR, NVARCHAR, NTEXT

BINARY, VARBINARY, IMAGE

DATETIME

BIT

TIMESTAMP, ROWVERSION, UNIQUEIDENTIFIER, IDENTITY, ROWGUIDCOL

MySQL[112]

Static

TINYINT (8-bit), SMALLINT (16-bit), MEDIUMINT (24-bit), INT (32-bit), BIGINT (64-bit)

FLOAT (32-bit), DOUBLE (aka REAL) (64-bit)

DECIMAL

CHAR, BINARY, VARCHAR, VARBINARY, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT

TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB

DATETIME, DATE, TIMESTAMP, YEAR

BIT(1), BOOLEAN (aka BOOL) = synonym for TINYINT

ENUM, SET, GIS data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon)

Oracle[121]

Static + Dynamic (through ANYDATA)

NUMBER

BINARY_FLOAT, BINARY_DOUBLE

NUMBER

CHAR, VARCHAR2, CLOB, NCLOB, NVARCHAR2, NCHAR, LONG (deprecated)

BLOB, RAW, LONG RAW (deprecated), BFILE

DATE, TIMESTAMP (with/without TIMEZONE), INTERVAL

N/A

SPATIAL, IMAGE, AUDIO, VIDEO, DICOM, XMLType

PostgreSQL[124]

Static

SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)

REAL (32-bit), DOUBLE PRECISION (64-bit)

DECIMAL, NUMERIC

CHAR, VARCHAR, TEXT

BYTEA

DATE, TIME (with/without TIMEZONE), TIMESTAMP (with/without TIMEZONE), INTERVAL

BOOLEAN

ENUM, POINT, LINE, LSEG, BOX, PATH, POLYGON, CIRCLE, CIDR, INET, MACADDR, BIT, UUID, XML, JSON, arrays, composites, ranges, custom

 

Type system

Integer

Floating point

Decimal

String

Binary

Date/Time

Boolean

Other

 

 

 

Other objects

Information about what other objects are supported natively.

 

Data Domain

Cursor

Trigger

Function 1

Procedure 1

External routine 1

Microsoft Access (JET)

Yes

No

No

No

Yes, But single DML/DDL Operation

Yes

Microsoft SQL Server

Yes (2000 and beyond)

Yes

Yes

Yes

Yes

Yes

Microsoft SQL Server Compact (Embedded Database)

No

Yes

No

No

No

No

MySQL

No  3

Yes

Yes

Yes

Yes

Yes

Oracle

Yes

Yes

Yes

Yes

Yes

Yes

Oracle Rdb

Yes

Yes

Yes

Yes

Yes

Yes

PostgreSQL

Yes

Yes

Yes

Yes

Yes

Yes

 

Data Domain

Cursor

Trigger

Function 1

Procedure 1

External routine 1

 

 

 

Partitioning

Information about what partitioning methods are supported natively.

 

Range

Hash

Composite (Range+Hash)

List

Expression

Microsoft Access (JET)

No

No

No

No

?

Microsoft SQL Server

Yes

No

No

No

?

Microsoft SQL Server Compact (Embedded Database)

No

No

No

No

?

MySQL

Yes

Yes

Yes

Yes

?

Oracle

Yes

Yes

Yes

Yes

?

Oracle Rdb

Yes

Yes

?

?

?

PostgreSQL

Yes1

Yes1

Yes1

Yes1

?

 

Range

Hash

Composite (Range+Hash)

List

Expression

 

 

 

Access control

Information about access control functionalities (work in progress).

 

Native network encryption1

Brute-force protection

Enterprise directory compatibility

Password complexity rules2

Patch access3

Run unprivileged4

Audit

Resource limit

Separation of duties (RBAC)5

Security Certification

Label Based Access Control (LBAC)

Microsoft SQL Server

Yes

?

Yes (Microsoft Active Directory)

Yes

Yes

Yes

Yes (From2008)

Yes

Yes

Yes (EAL4+11)

?

Microsoft SQL Server Compact (Embedded Database)

No (not relevant, only file permissions)

No (not relevant)

No (not relevant)

No (not relevant)

Yes

Yes (file access)

Yes

Yes

No

?

?

MySQL

Yes (SSL with4.0)

No

Yes (with5.5, but only in commercial edition)

No

Partial (no security page)[133]

Yes

?

?

?8

No

?

Oracle

Yes

Yes

Yes

Yes

?

Yes

Yes

Yes

Yes

Yes (EAL4+1)

?

PostgreSQL

Yes

Yes (for9.1)

Yes (LDAP, Kerberos…9)

Yes (as of9.0 with passwordcheck module)

Yes[134]

Yes

No

Yes

Yes

Yes (EAL11)

?

 

Native network encryption1

Brute-force protection

Enterprise directory compatibility

Password complexity rules2

Patch access3

Run unprivileged4

Audit

Resource limit

Separation of duties (RBAC)5

Security Certification

Label Based Access Control (LBAC)

 

 

 

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

 

Angelo Endaya
من قبل Angelo Endaya , Maximo Application Developer , IBM Solutions Delivery Inc.

the differences between Oracle , MSSql , MySql , Access and postgresql, is MSSQL and Access they are for Microsoft platform only, but Oracle, Mysql and Postgresql they are open source platform and they are on large scale environment.

Muhammad Ayoob
من قبل Muhammad Ayoob , Assistant at VTI Dajal , Work as Lab

the differences between Oracle , MSSql , MySql , Access and postgresql, is very simple .All languages sport differnt commonds .MS Access Provides simple methods to create table qurey form and report and other software langages needs to write commands .in the backend of MS Access SQL sports or acts as its language.But all other software uses there own file for sport.

 

المزيد من الأسئلة المماثلة