Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2006-11-03 : 02:56:14
|
Hi all,first I must say (hopefully you know this allready) that I'm in no way associated with db4o, nor do I have any intention of doing them any favors. But after reading this topic http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74262 it has cought my attention and after reading a bit more I have to admit that I got a little intrigued by it. Especially a *very* impressive client list and even though client lists are just for show it works for me when Boeing says it's great. But how does it actually work and what does it really do? It says something about object oriented databases and never needing a DBA and alot of other stuff, but what is it really and how does it perform compared to a "normal" RDBMS? Are they using a database technology that I'm not aware about? Feel free to elaborate  --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-03 : 03:36:04
|
| It is an object database that stores the objects in its own file format. There is no relational database behind it (nothing like SQL Server or Oracle anyway) - of course the data is stored in files, but not with a database server. The technical details are all at their web site (http://www.db4o.com/about/productinformation/whitepapers/)Really it is a Java or .NET library that you just embed in your app and it takes care of all the data for you. It is primarily used for mobile apps running on a laptop or PDA when disconnected from the central database.There are some examples of using it for a web and other server applications (http://developer.db4o.com/forums/thread/30394.aspx) and it has a client/server mode, but you have to write code to create the server and write code to create the client. I guess someone will write a nicely packaged server product based on db4o, but that doesn't seem to be their focus. It's free so download it and try it, it's pretty simply to run through the basic tutorial and see it in action. |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2006-11-03 : 11:21:29
|
| I suggested it to henrikop in all sincerity, it got taken the wrong way, (because of my signature), but it does seem like a good fit for his application, HRM is notoriously political, and therefore dynamic,tough to be changing columns all the time."it's definitely useless and maybe harmful". |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-11-03 : 15:03:08
|
Hehe, your sig might have been slightly misplaced in that exact response, but as a general rule I agree that it's usually quite applicable!  But it's comforting to know that I'll probably be able too keep my daytime job for some time still hehe--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2006-11-03 : 16:06:41
|
| ODBit has a single table called Everything it has a single column called the Oneand the column is datatype Universalinside that single value is an object, a really big honking object that encomapasess all that is known.A lone programmer writes the code to utilize that value.After he is done, he is very proud of himself and after a few beershe decides to ask his program "Is there a God"The screen flashes "There is now"If objects in databases make sense then someone would be a genius if they store it in that singlevalue because then it has the ultimate in universality and handles absolutely an situation."it's definitely useless and maybe harmful". |
|
|
|
|
|
|
|
|
db4o - how does it work?