Transcript G15 - Spatial Database Group

Versant Object Database
Group 15
Christopher Jonathan
Jungwoo Jang
OODBMS vs RDBMS
Differences
OODBMS
RDBMS
Main Objective
Data encapsulation and
independence
Ensuring data independence
from application program
Stores
Data and method
Data
Semantic Gap
Eliminates dis-assembly and
assembly as they can store
entire object as value in a
column within a row
Thus speed up object
retrieval and storage.
3NF (frequent dis-assembly
and assembly of an object
to/from many rows)
OODBMS vs RDBMS
Similarities
OODBMS
RDBMS
Query Language
Similar to SQL 3 (targets
classes and attributes)
SQL 3 (targets table and
columns)
Indexes
Hash, B-tree, etc. (placed on
attribute of classes)
Hash, B-tree, etc. (placed on
columns)
Concurrency Control
Locking, TimeStamp, etc.
Locking, TimeStamp, etc.
Success Story of Versant
 EidosMedia
 Challenge:
 The kind of data we would have to handle was complex and relatively
unstructured.
 wanted maximum flexibility to add and change data fields without having
to completely modify the database structure
 Result:
 Powers the new-generation Méthode editorial platforms that have been
adopted by global publishers such as the Wall Street Journal and the
Financial Times
Success Story of Versant
 China Telecom:
 Challenge:
 480,000 queries and 1,000 update transactions per second at peak times
 manages a customer base of 250 million ADSL subscribers
 Result:
 successfully tested by China Telecom to process up to 1,000,000 queries
per second
 named the best Object Database technology by China Telecom!
“Object Database manages ADSL account records as native objects and
therefore eliminates any object-relational mapping previously needed when
using an RDBMS.”
Success Story of Versant
 Echelon:
 Challenge:
 capable of handling the 70+ application classes, with up to 32,000 device
instances on one network.
 needed high performance to store / retrieve a persistent network size
of several hundred megabytes
 Result:
 50 million intelligent network devices have been installed into about 1
million individual networks.
 400 members using the platform. The platform is an international open
standard, ISO/IEC 14908-1.
Performance (# of iterations of test
cycles performed in fixed time)
Test (on Complex
Object Graph)
Versant
MySQL
PostgreSQL
Query
59210
1528
902
Update
15061
767
838
Delete
13686
618
546
Reference
http://www.odbms.org/download%5C048.04%20TechView%20Versant.pdf
http://polepos.sourceforge.net/results/PolePositionClientServer.pdf
http://www.thestreet.com/story/10940842/1/versant--ten-years-at-the-heart-of-eidosmedias-methode-crossmedia-publishing-platform.html
http://actian.com/customers/case-studies/cs-eidosmedia
http://actian.com/customers/case-studies/cs-echelon
http://actian.com/customers/case-studies/cs-china-telecom
http://revistaie.ase.ro/content/44/16%20sabau.pdf