ordbms comparative report
TRANSCRIPT
-
8/9/2019 ORDBMS Comparative Report
1/10
Erawat Chamanont
Postgraduate Software Engineering Student
University of Sunderland
-
8/9/2019 ORDBMS Comparative Report
2/10
Object/Relational DBMSy Major Object Database Vendors
y Oracley PostgreSQL
y Db4o
y The comparison will take three criteria which following:y Usabilityy Performance
y Security
-
8/9/2019 ORDBMS Comparative Report
3/10
Usabilityy Ease of Installation
y Oracle takes amount of time to install
y
PostgreSQL easy and quick according to its documentation,no admin right required
y Db4o - just place in a library part of a application as APIlibrary
y Features
y Oracle full supports relational and object-relational features
y PostgreSQL full supports for foreign keys, joins, views,triggers, and stored procedures and objects
y Db4o .NET and Java, client centric, support O/R features
-
8/9/2019 ORDBMS Comparative Report
4/10
Usability Cont.y Documentation
y Oracle provides fully documentations in different levels ofusers e.g. DBA, Developer, or End-User
y PostgreSQL provides clear and complete documentations
y Db4o less documentation and example compared to Oracleand PostgreSQL
y Support
y Oracle provides commercial support
y PostgresSQL mailing-list, IRC and commercial support fromexternal companies
y Db4o forum driven by community and commercial support
-
8/9/2019 ORDBMS Comparative Report
5/10
Performancey Query Optimisation
y Oracle provides Oracles optimiser.
y PostgeSQL provides Genetic Query Optimizationy Db40 provides SODA query API which db4o's low
level querying API
y Index
y Oracle supports several indexing schemes e.g. B-tree,B-tree cluster, Bitmap indexes
y PostgeSQL support B-Tree, R-tree, Hash, and GiST
y Db4o Provides index fields
-
8/9/2019 ORDBMS Comparative Report
6/10
Securityy UserManagement
y Oracle privileged user control
y PostgreSQL using the concept ofrolesy Db40 application manage (Java or .NET)
yAccess Control
y Oracle multi-levels security, row and column level
security , based on classification, user privilege controly PostgresSQL access privilege, multi-level security e.g.
table, column, function
y Db4o - code access permission (Java or .NET)
-
8/9/2019 ORDBMS Comparative Report
7/10
Security Cont.y Encryption
y Oracle Transparent data encryption, Backup
encryption, Encryption For Data In Transity PostgreSQL - offers encryption at several levels e.g.
Password Storage, Specific columns, Data Across aNetwork
y
Db4o - Built-In Simple Encryption, Custom EncryptionAdapters
-
8/9/2019 ORDBMS Comparative Report
8/10
Security Cont.y Monitoring
y Oracle Provides Oracle Audit Vault to monitor user
activitiesy PostgreSQL Provides statistics collector, able to use
Standard Unix Tools, Viewing Locks table
y Db40 No monitoring tools for security.
-
8/9/2019 ORDBMS Comparative Report
9/10
Summaryy Oracle
y Suitable for big companies that can afford the price. Oracleprovide good resource and support for their client anddatabase engine is support large and load of information
y PostgreSQL
y It is an powerful open source DBMS product which providesfeatures including relational and object/relational and it
suites for any size of company.y Db4o
y Suitable for specific applications not for using in applicationsthen storing load of data.
-
8/9/2019 ORDBMS Comparative Report
10/10
Referencesy Falsken E (2009) db4o Reference Documentation -
http://developer.db4o.com/documentation/reference/db4o-7.12/java/reference/ (accessed 3 June 2010)
y Oracle (undefined) Oracle Advanced Security,
http://www.oracle.com/technology/deploy/security/database-security/advanced-security/index.html (accessed 3 June 2010)
y Undefined (2009) PostgreSQL 8.4.4 Documentation -http://www.postgresql.org/docs/8.4/interactive/index.html
y Oracle (2009)Cost Effective Security and Compliance with Oracle Database 11gRelease 2, http://www.oracle.com/technology/deploy/security/database-
security/pdf/owp-security-database-11gr2.pdf(accessed 3 June 2010)y Undefined (2008) Oracle Database Object-Relational Developer's Guide
11g Release 1 (11.1) [internet] available at:http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28371/adobjint.htm#CHDCHDHB (accessed 1 June 2010)