One of the things I miss the most is my dear Lazyweb. Even though, I know that many of you, my ocasional or fanatic readers (hi mom!), have more than the necessary skills to help me on my doubts.
So, this time I want to learn from you a couple book titles I should read in order to become a master in what concerns database design. From indexes to partitioning, from transactions to locks and clustering, I’m deeply interested in it all. I have some basic knowledge on some of these issues, but as I said, I want to be a master.
Also, I’d like to know from the .NET developers which persistence mechanism they use and why. I’m looking for something as open and mature as Hibernate for Java! I know there’s NHibernate, still I think it lacks a lot of functionality.. Am I wrong here?!
Cheers and thanks for all the fish!
Probably not what you’re looking for, but for all the theory behind RDBMS the authorative book is “An Introduction to Database Systems” by C.J. Date. The style is is very academic and can be hard to read, but you’ll get much more than an introduction.
By: Luís Miranda on August 23, 2008
at 7:00 pm
From what I’ve read about that book, it surely stands out as a very theoretical read. I guess I’m looking something more pragmatic, like a more “solution-to-problem” thing. Anyway, thanks for the tip
By: Paulo Pires on August 23, 2008
at 7:10 pm
I have learned a lot from studying to the IBM certification exams. I started with the tutorials for the Database Associate certification (http://www.ibm.com/developerworks/offers/lp/db2cert/db2-cert730.html) and then followed on with the more advanced series. It is focused on DB2, but most of the concepts are similar between the major DBMS systems.
By: Vitor on August 24, 2008
at 1:27 am
Can you explain more why you think NHibernate is missing?
We just released NHibernate 2.0, and we actually have more features than Hibernate 3.2 at this point.
By: Ayende Rahien on August 24, 2008
at 2:31 am
@Vitor: I’ll surely take a look on that. Thanks for noticing
@Ayende: Curious is to say that you “just” released NHibernate 2.0, as some features that have been added in this version where what I was looking for too, like implementation of the query plan that enables our applications to boost performance by caching named-queries. Anyway, I was even asking “am I wrong here?”, so I guess I really need more time with NHibernate. Thank you for updating me on the release status
By: Paulo Pires on August 24, 2008
at 4:29 am
I’m using NHibernate for production and I’m really happy with it. Another option could be subsonic.
By: Pedro Santos on August 24, 2008
at 8:23 am
[...] http://ppires.wordpress.com/2008/08/23/databases-and-persistence/ asks Hoosgot, [...]
By: Databases and Persistence on August 28, 2008
at 1:57 am