Postgres SQL과 Oracle의 Engine 비교

Postgres SQL과 Oracle의 Engine 비교

 

Name	Oracle		PostgreSQL
Description	넓게 쓰이는 RDBMS		RDBMS - Postgres에 기본을 둠
DB-Engines Ranking	Rank	1	Rank	4
	Score	1452.13	Score	257.36
Website	www.oracle.com/­us/­products/­database		www.postgresql.org
Technical documentation	www.oracle.com/­technetwork/­indexes/­documentation/­index.html		www.postgresql.org/­docs/­manuals
Developer	Oracle		PostgreSQL Global Development Group
Initial release	1980		1989
License	commercial (유료)		Open Source (무료)
Database as a Service (DBaaS)	no		no
Implementation language	C and C++		C
Server operating systems	AIX		HP-UX
	HP-UX		Linux
	Linux		OS X
	OS X		Solaris
	Solaris		Unix
	Windows		Windows
	z/OS
Database model	Relational DBMS (관계형 DBMS)		Relational DBMS  (관계형 DBMS)
Data scheme	yes		yes
Typing	yes		yes
Secondary indexes	yes		yes
SQL	yes		yes
APIs and other access methods	ODP.NET		native C library
	Oracle Call Interface (OCI)		streaming API for large objects
	JDBC		ADO.NET
	ODBC		JDBC
			ODBC
Supported programming languages	C		.Net
	C#		C
	C++		C++
	Clojure		Java
	Cobol
	Eiffel		Perl
	Erlang		Python
	Fortran		Tcl
	Groovy
	Haskell
	Java
	JavaScript
	Lisp
	Objective C
	OCaml
	Perl
	PHP
	Python
	R
	Ruby
	Scala
	Tcl
	Visual Basic
Server-side scripts	PL/SQL		user defined functions
Triggers	yes		yes
Partitioning methods	horizontal partitioning		no, but can be realized using table inheritance
Replication methods	Master-master replication		Master-slave replication
	Master-slave replication
MapReduce	no		no
Foreign keys	yes		yes
Transaction concepts	ACID		ACID
Concurrency	yes		yes
Durability	yes		yes
User concepts	Users with fine-grained authorization concept		Users with fine-grained authorization concept

 

출처 : DB Engine - System Properties Comparison Oracle vs. PostgreSQL

                                                                              (By. 진준호)