Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Monday, April 2, 2012

What is the difference between BLOB and CLOB?

What is the difference between BLOB and CLOB?
  • BLOB – Binnary Large OBject. Data type that relational databases use to store very large data. In Java, it is represented by the JDBC java.sql.Blob;
  • CLOB – Character Large OBject. Similar, but to store large strings, represented by the JDBC java.sql.Clob;

Friday, March 30, 2012

What is the difference Relational Databases and OO Databases?

What is the difference Relational Databases and Object-Oriented (OO) Databases?

A Relational Database:
  • is more widespread, it has more support and tools
  • separates the concern – database from program
  • lets you define your own schema
  • potentially has slower access to complex data (joins)

An Object Database:
  • is more consistent with the OO application
  • is easier to navigate
  • potentially has faster access to data (pointers)
  • higher performance

PS: my answer to this question is based on learning through online content, since I have not worked with Object databases yet.  If my opinion is naive, please feel free to complete with your experience here.