Register now or log in to join your professional community.
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)
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.
General information
Maintainer
First public release date
Latest stable version
Latest release date
1990
6.x
Microsoft Access (JET)
1992
15 (2013)
1989
2014 (12)
2014-3-18
Microsoft SQL Server Compact (Embedded Database)
2000
2011 (v4.0)
Sun Microsystems (now Oracle Corporation)
1995-11
5.6.19
GPL v2 or Proprietary
OpenLink Software[21]
1998
7.x
GPL v2 or Proprietary
1979-11
12c Release1
1984
7.3.1.1.1
PostgreSQL Global Development Group[25]
1989-06
9.3.4[26]
PostgreSQL Licence (a liberal Open Source license)[27]
Raima Inc.[30]
1993
8.4
2010
1.0
Operating system support
The operating systems that the RDBMSes can run on.
Microsoft Access (JET)
Yes
No
No
No
No
No
No
No
No
No
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
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
?
Yes[36]
Yes
Yes
Yes
No
Yes
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
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.
Fine-grained locking
Interface
Microsoft Access (JET)
Yes
Yes
Yes
?
Yes
Yes
Yes
Yes
Yes (Row-level locking)[40]
Yes
Microsoft SQL Server Compact (Embedded Database)
Yes
Yes
Yes
?
Yes
Yes2
Partial3
Yes (Row-level locking)[41]
Yes
Yes
Yes
Yes (Row-level locking)[42]
Yes
Yes
Yes
Yes
?
Yes
Yes
Yes
Yes
Yes (Row-level locking)[43]
Yes
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)
2 GB
2 GB
16 MB
255
64 KB (memo field),1 GB ("OLE Object" field)
255 B (text field)
32 bits
0100
9999
64
524,272 TB (32 767 files *16 TB max file size)
524,272 TB
8,060 bytes (Unlimited)6
30,000
2 GB
2 GB6
126 bits2
0001
9999
128
Microsoft SQL Server Compact (Embedded Database)
4 GB
4 GB
8,060 bytes
1024
2 GB
4000
154 bits
0001
9999
128
MySQL 5
Unlimited
MyISAM storage limits:256 TB; Innodb storage limits:64 TB
64 KB3
4,0964
4 GB (longtext, longblob)
64 KB (text)
64 bits
1000
9999
64
Unlimited (4 GB * block size per tablespace)
4 GB * block size (with BIGFILE tablespace)
8 KB
1,000
128 TB
32,767 B11
126 bits
−4712
9999
30
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
Microsoft Access (JET)
No
No
Yes
Yes3
Microsoft SQL Server Compact (Embedded Database)
Yes
No
Yes
No4
Yes
Yes
Yes
Yes
Yes
Yes5
Indices
Information about what indices (other than basic B-/B+ tree indices) are supported natively.
Microsoft Access (JET)
No
No
No
No
No
No
No
No
No[73]
?
?
?
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]
?
?
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]
?
Yes 11
Cluster Tables
Yes
Yes 6
Yes
Yes
No
No
Yes[81]
Yes[82]
?
No
Yes
?
No
No
?
No
No
?
?
?
Yes
Yes
Yes
Yes
Yes7
Yes8
Yes
Yes
Yes[83]
PostGIS[84]
?
Database capabilities
Inner selects
Parallel Query
Microsoft Access (JET)
Yes
No
No
Yes
Yes
Yes
No
Yes
No
No
?
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
?
Yes
No
No
Yes
Yes
Yes
No
Yes
No[106]
No
No[107]
Yes
Yes
Yes, via MINUS
Yes
Yes
Yes
Yes
Yes
Yes 1
Yes
Yes[108]
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
?
?
?
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes[109]
Inner selects
Parallel Query
Data types
Decimal
Date/Time
Other
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
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)
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
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
Decimal
Date/Time
Other
Other objects
Information about what other objects are supported natively.
External routine 1
Microsoft Access (JET)
Yes
No
No
No
Yes, But single DML/DDL Operation
Yes
Yes (2000 and beyond)
Yes
Yes
Yes
Yes
Yes
Microsoft SQL Server Compact (Embedded Database)
No
Yes
No
No
No
No
No 3
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
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
?
Yes
No
No
No
?
Microsoft SQL Server Compact (Embedded Database)
No
No
No
No
?
Yes
Yes
Yes
Yes
?
Yes
Yes
Yes
Yes
?
Yes
Yes
?
?
?
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
Security Certification
Label Based Access Control (LBAC)
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
?
?
Yes (SSL with4.0)
No
Yes (with5.5, but only in commercial edition)
No
Partial (no security page)[133]
Yes
?
?
?8
No
?
Yes
Yes
Yes
Yes
?
Yes
Yes
Yes
Yes
Yes (EAL4+1)
?
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
Security Certification
Label Based Access Control (LBAC)
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
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.
