Compare Features: Postgres Plus Advanced Server and ... - Varagi

pridefulauburnΔιαχείριση Δεδομένων

16 Δεκ 2012 (πριν από 4 χρόνια και 7 μήνες)

153 εμφανίσεις




VARAGI Technologies Private Limited, 394. 2
nd

Floor, Sector
-
15, Panchkula
-
134113. Haryana, INDIA. Ph
: +91 172 2591299.

www.varagitech.com



Compare Featu
res: Postgres Plus Advanced

Server and Oracle


Core Database Features

Oracle

Postgres Plus
Advanced Server

ACID transaction support

Yes

Yes

Crash recovery

Yes

Yes

Primary and Foreign keys

Yes

Yes

Cost
-
based optimizer

Yes

Yes

Data partitioning

Yes

Yes

Data compression

Yes

Yes

Wide array of indexing support (e.g.

clustered, B
-
tree, full text, etc.)

Yes

Yes

User
-
defined
data types


Yes

Yes

Spatial/GIS support

Yes

Yes

MVCC support

Yes

Yes

Wide range of
data type

support

Yes

Yes

Multi
-
terabyte database capable

Yes

Yes

Oracle data dictionary views

Yes

Yes

High
-
speed, parallel data loader

Yes

Yes

Memory/distributed caching option

Yes

Yes

Connection pooling

Yes

Yes

Globalization

Yes

Yes

Federated databases/database links

Yes

Yes

Distributed transactions

Yes

Yes

Wait
-
based performance diagnostics

Yes

Yes

Online documentation

Yes

Yes



Security Features

Oracle

Postgres Plus
Advanced Server

User login/password authentication

Yes

Yes

Group/role support

Yes

Yes

Granular object privileges

Yes

Yes

External authentication

Yes

Yes

Data auditing

Yes

Yes

Data encryption

Yes

Yes

Built
-
in SQL firewall

No

Yes

Code obfuscation

Yes

Yes






VARAGI Technologies Private Limited, 394. 2
nd

Floor, Sector
-
15, Panchkula
-
134113. Haryana, INDIA. Ph
: +91 172 2591299.

www.varagitech.com




High Availability and Data Protection

Features

Oracle

Postgres Plus
Advanced Server

Clustered database support

Yes

Yes

Built
-
in replication

Yes

Yes

Warm Standby database

Yes

Yes

Hot Standby database

Yes

Yes

Online backup

Yes

Yes

Parallel restore

Yes

Yes

Point
-
in
-
time recovery

Yes

Yes

Online operations

Yes

Yes


Development Capabilities

Oracle

Postgres Plus
Advanced Server

Oracle PL/SQL suppo
rt

Yes

Yes

Stored procedures

Yes

Yes

Functions

Yes

Yes

Triggers

Yes

Yes

Java stored
procedures

Yes

Yes

Perl, C, C++, Ruby, Python, TCL stored

procedures and functions

No

Yes

ANSI SQL support

Yes

Yes

Analytic SQL functions

Yes

Yes

Optimizer hints

Yes

Yes

Views

Yes

Yes

Table inheritance

No

Yes

Wide range support for connectors

(JDBC, ODBC, .NET, etc.)

Yes

Yes

XML support

Yes

Yes

Oracle DBMS packages

Yes

Yes

Proc*C Support

Yes

Yes














VARAGI Technologies Private Limited, 394. 2
nd

Floor, Sector
-
15, Panchkula
-
134113. Haryana, INDIA. Ph
: +91 172 2591299.

www.varagitech.com





Management and Tooling

Oracle

Postgres Plus
Advanced Server

Enterprise Manager (Global

management tool)

Yes

Yes

GUI Client

side

development/administration tools

Yes

Yes

Automated patch notification and

management

Yes

Yes

Performance monitoring

Yes

Yes

SQL capture/profiling

Yes

Yes

Expert, best practice enforcement

No

Yes

Job scheduler

Yes

Yes

Replication from Oracl
e to PostgreSQL

N
o

Yes

Replication from SQL Server to PostgreSQL

No

Yes

Migration toolkit (supporting moving

Oracle, SQL
Server, Sybase, and

MySQL) to PostgreSQL

No

Yes

Command line utilities

No

Yes

SQL*Plus support

Yes

Yes