Advantages and Disadvantages of using Hibernate like ORM libraries
Traditionally Programmers used ODBC, JDBC, ADO etc to access database. Developers need to write SQL queries, process the result set and convert the data in the form of objects (Data model). I think most programmers would typically write a function to convert the object to query and result set to object. To overcome these difficulties, ORM provides a mechanism to directly use objects and interact with the database.
There are lots of advantages of using ORM
- Database independent. This is the biggest advantage. No need to write code specific to database. I have worked in various products where they maintain separate module / code base for every database and there is lot of effort invested to support multiple database. ORM is a boon.
- There is no need to write SQL queries. Session.saveOrUpdate(entityObject) takes care of insertion in case of Hibernate.
- Takes care of dependencies between tables and does join queries.
- Few ORM libraries has support of caching. Hibernate uses ehcache and provides caching support. This reduces the load from the database and increases the response time.
- Maintains transactions commit and rollback.
- Maintains database connection pool.
- Concurrency support.
- Easy maintenance and increases productivity.
- ORM makes life easier but developers will eventually skip learning SQL and database internals.
- There will be some overhead involved using ORM. If the database is accessed directly then developers are having some control and they could fine tune its performance.
- There is a learning curve involved in understanding ORM library. Java, .NET, PHP has better ORM libraries. .NET has support of LINQ, which is a Framework that encompass language-integrated query.
Reference:
Open source ORM libraries
Open source database
Open source connection pool libraries in Java
10318
comments powered by Disqus
Related Articles
How to learn from open source projects
Students ask this question frequently steps or methodology to learn from open source projects. There is no single answer or steps available. I listed the steps which i follow and i hope this will help for few.
8 Best Open Source Searchengines built on top of Lucene
Lucene is most powerful and widely used Search engine. Here is the list of 7 search engines which is built on top of Lucene. You could imagine how powerful they are.
Best situation to use Column database
Column oriented database or datastore as the name sounds it stores the data by column rather than by row. It has some advantages and disadvantages over traditional RDBMS. Developer should know the typical situation to choose column oriented database.
Should web application store images in Database or File system?
Web developers most frequent question, Should user images be stored in database or file system? Which is the best way. Both has some pros and cons.
Why require Searchengine? Why not use database for full text search in Enterprise application.
Most of the database has support of full text search, basically indexing and saarching. MySQL, Oracle and many more databases has in-built full text search. Then what is the need to go for external search engine like Lucene, Sphinx, Solr etc. Check out the advantage of using Searchengine.
Column database vs OLAP
OLAP (Online Analytical Processing), Reporting, Data mining related tasks are usually done by Business intelligence products. They do powerful Extraction, Transformation and Loading (ETL) the data and provides various reports. They use relational database as its back end. How could they generate better reports? Will column DB do a better job?
Is ZooKeeper mandatory for Cloud
Cloud is nothing but more than one system or application distributed across the network, across the globe. It may have couple of application servers, database server, shared data storage, backup server and lot more. The resources in the distributed environment must have information about each other so that they could co-ordinate and share without any issues. ZooKeeper helps to do that.
LucidWorks Vs SearchBlox - Enterprise Search Solution
Enterprise search software should be capable to search the data available in the entire organization or personnel desktop. The data could be in File system, Web or in Database. It should search contents of Emails, file formats like doc, xls, ppt, pdf and lot more. There are many commercial products available but LucidWorks and SearchBlox are best and free.
10 sites to get the large data set or data corpus for free
You may require GBs of data to do performance or load testing. How your app behaves when there is loads of data. You need to know the capacity of your application. This is the frequently asked question from the sales team "The customer is having 100GB of data and he wants to know whether our product will handle this? If so how much RAM / Disk storage required?". This article has pointers to the large data corpus.
How to create SEO friendly url
SEO friendly URL is recommended for any website which wants to be indexed and wants its presence in search results. Searchengine mostly index the static URL. It will avoid the URL which has lot of query strings. Almost all websites generate content dynamically then how could the URL be static. That is the job of the programmer.
