dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Open Source Database Feature Comparison Matrix : Page 3

Looking for a database? This handy database feature comparison matrix and glossary let you compare and contrast the supported features of four popular open source databases: Apache Derby 10.1, MySQL 5.0, PostgreSQL 8.1, and One$DB 4.0.


advertisement

 

Apache Derby 10.1

MySQL 5.0

PostgreSQL 8.1

One$DB 4.0

Security

 

 

 

 

Users

Role

X

X

Privilege

X

Encryption

X

Database Administration Tools

 

 

 

 

Tools

IJ Scripting Tool, Cloudview,
Import/Export

WinMySQL Admin, MySQL Administrator, MySQL Query Browser
Command Shell

PgAdmin, psql, phpPgAdmin

Shell, Browser, Shell Server, Browser Server, Server

Hot Backup

*

X 

Table Spaces

X

X 

Point in Time recovery

X

*

X 

Table partitioning

X

X

X 

Graphical Interface

 

 

 

 

Creating Database Objects

*

 

Manipulate Data in Database Objects

*

 

Viewing Properties of Various Database Objects

*

 

Graphical Interface to Execute SQL Queries

*

 

Support for Executing Multiple Queries Simultaneously

*

 

 

Key to Symbols

Feature supported

X

Feature not supported

*

External or unofficial support



Uday Parmar is Head of Sales and Marketing at Daffodil Software, where he is responsible for corporate sales, account management, strategic planning, and business analysis. Uday holds a Bachelors degree in Statistics from Mumbai University, an MBA in Marketing and HR, and a Masters in Management from Durham Business School, England. .
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date