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. 진준호)
'2. DBMS이야기 > 01. PostgreSQL' 카테고리의 다른 글
| [PostgreSQL] Configuration 기본튜닝 (0) | 2014.08.01 |
|---|---|
| [Admin] 3.Server Configuration : Parameter 종류(Write Ahead Log) (0) | 2014.08.01 |
| PostgreSQL vs MySQL 비교 (0) | 2014.07.30 |
| PostgreSQL Privileges Test 1 (0) | 2014.07.28 |
| PG_RESTORE (0) | 2014.07.26 |