Database investigation

southdakotascrawnyData Management

Nov 29, 2012 (4 years and 8 months ago)

441 views

RDBMS

Database

MySQL Community Version

License

GNU GPL

http://www.thebigfly.com/gnu/gpl/

http://www.gnu.org/licenses/old
-
licenses/gpl
-
2.0.html

Copyleft

DB Type

RDBMS

Performance


Feature


Restriction

No transaction before 4.0


Database

PostgreSQL

License

MIT License


慬汯眠瑯⁵ 攠楮⁰ro灲楥i慲y⁳o晴w慲e

DB Type

Object Relational DBMS
http://en.wikipedia.org/wiki/Object
-
relational_database


Between RDBMS and Object DBMS

Performance

Better performance with large data storage
-

http://www.postgresql.org/about/

Feature



More index types, except B+ tree

Restriction




Database

JavaDB (Apache Derby)

License

Apache 2.0 license



it allows use of the source code for the development
of

proprietary software

as well as

free

and

open source
software
.



Like any

free software license
, the Apache License allows
the user of the software the freedom to use the software for
any purpose, to distribute it, to modify it, and to distribute
modified versions of the software, unde
r the terms of the
license.



No copyleft

DB Type

RDBMS

Performance


Feature


Restriction

JavaDB running in the same JVM with other Java programs,
may
impact performance




Database

Firebird

-

http://www.firebirdsql.org/

License

IDPL
-

http://www.firebirdsql.org/dotnetfirebird/files/IDPLicense.txt

DB Type

RDBMS

Performance


Feature

Small, efficient

Restriction



XML DB

Database

Oracle Berkeley DB XML

http://www.oracle.com/database/berkeley
-
db/xml/index.html

License

Open source,
oracle + apache license

http://www.oracle.com/technology/software/products/berkel
ey
-
db/htdocs/xmloslicense.html

DB Type

XML DB

Performance


Feature



Oracle Berkeley DB XML is an open source, embeddable
XML database with XQuery
-
based access to documents
stored in containers and indexed based on their content.
Oracle Berkeley DB XML is built on top of Oracle Berkeley
DB and inherits its rich features and attributes. Like Oracle
Berkeley DB, it runs in process with the application

with
no need for human administration. Oracle Berkeley DB
XML adds a document parser, XML indexer and XQuery
engine on top of Oracle Berkeley DB to enable the fastest,
most efficient retrieval of data



A lot available learning materials


Restriction




D
atabase

db
XML
http://www.dbxml.com/product.html

License

MIT style license

DB Type

XML Database

-

http://en.wikipedia.org/wiki/XML_database

Performance


Feature

XML DB



Stores and index collections of XML docuemnts


Restriction



2.0 is n
ot production release
, and it may not function
properly under all conditions.

Should not be used for
production systems.



XML DB may have performance
constraint



Database

BaseX

http://basex.org/

License


DB Type

Native XML DB

Performance


Feature

Efficien
t XPath/XQuery processor

Restriction

Written in Java


Relational DB:

Pros
:



We are familiar
, less learning
effort

Cons
:



Need to design suitable schema



XML DB:

Examples:

Java:
http://www.inf.uni
-
konstanz.de/dbis/basex/code.php?code=XMLDBCreate


Pros
:



Nature to use XML in this
project

Cons
:



Learning effort for both us and Bosch

-

http://www.w3.org/TR/xquery/



Performance constraints

Both of these can be risks..