Wednesday, July 24, 2013

Object Database Software in hibernate

Object Database Software: The Database software which can store software object as Database
table column value is called Object Database Software.
public class marks
{
-------------
---------------
}
marks mk=new marks();
mk(marks class obj)
Object Database Software
Object Database softwares failed in the industry because of following reasons.
i. They store multiple values in the single Database table column as software object but
storing multiple values in single Database table columns is against of normalization rule
number 1.
ii. Generating reports from the Database table of Object Database softwares is complex
process.
Note: SQL Queries are Database dependent queries.
m1=30
m2=50
m3=70
Student Tab(Database Tabel)
Sno sname     marks
10 Siva         m1=30, m2=50, m3=70
11 kumar
12 Reddy

Java application can use either JDBC or o-r mapping concepts to develop JDBC mapping
concepts and to interact with Database softwares. In small scale organizations we use files as
persistent stores and use I/O Streams to develop the persistent logic.
EX: Desktop games and mobile games.
In medium scale organizations Database software is used as persistence store ad JDBC to
develop the persistence logic.
EX: Office automation application.
Payroll applications
Library management application and e.t.c.,
In Large scale organizations Database software used as persistent store and use or mapping
style persistent logic.
EX: Banking applications/credit card applications and e.t.c.,
Drawbacks of JDBC:
1. SQL Queries are Database software dependent queries. JDBC uses SQL Queries so
JDBC persistent logic is Database software persistent.
2. Changing Database software in the middle of project development or production
environment is complex process.
3. All Exceptions in JDBC programming are checked exceptions we must catch and handle
those exceptions.
4. JDBC supplied Middleware services but those are not sufficient not good for industry
standard projects.
5. Middleware services are security transaction JDBC connection pooling and e.t.c., to
overcome all the above problems we use o-r mapping persistence logic instead of JDBC
persistence logic.
6. The Parameters of PreparedStatememnt related SQL query allows only positional
parameters (?) and they does not allow named parameters.
7. We can send only Serializable Java objects over the network. JDBC ResultSet object
can’t be sent over the network because it is not serializable object.
8. In JDBC programmer have to Write more common logics along with application
specific logics in every JDBC application (Scratch level coding is required).

No comments:

Post a Comment