Re: [Zope] Object DB versus Relational DB
On Sun, 21 Jan 2001, Tom Deprez wrote: Can somebody provide me informational links of documents which present the benefits and non-benefits of both DB? eg. When to use one and when not to use one? http://www.zope.org/Members/anthony/sql_vs_ZODB Oleg. Oleg Broytmann http://www.zope.org/Members/phd/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Object DB versus Relational DB
Tom Deprez wrote: Hi, Can somebody provide me informational links of documents which present the benefits and non-benefits of both DB? eg. When to use one and when not to use one? Thanks, Tom. A starting point is http://www.zope.org/Members/anthony/sql_vs_ZODB Rik ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Object DB versus Relational DB
Here is a short, but useful HowTo: http://www.zope.org/Members/anthony/sql_vs_ZODB Markus Kemmerling -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Deprez Sent: Sunday, January 21, 2001 11:50 PM To: [EMAIL PROTECTED] Subject: [Zope] Object DB versus Relational DB Hi, Can somebody provide me informational links of documents which present the benefits and non-benefits of both DB? eg. When to use one and when not to use one? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Object DB versus Relational DB
Can somebody provide me informational links of documents which present the benefits and non-benefits of both DB? eg. When to use one and when not to use one? Not sure if these papers specifically answer your question but I found them insightful: XML and Databases XML Database Products http://www.rpbourret.com/ Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: [EMAIL PROTECTED] URL: http://www.bris.ac.uk/ ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Object DB versus Relational DB
ZODB with Data.fs is optimized to fetch data. Inserts or updates have a lot of overhead. It's the price we pay for the excellent versioning features. Therefore, when the are many we have been avoinding ZODB even when the problem domain calls for an OODB We have implemented a highly hierarchical database for a Yahoo-like directory using a recipe found in the book SQL for Smarties, by Joe Celko, ISBN 1-55860-323-9 (see Chapter 26 - Trees). Celko's solutions allow for a hierarchy with unlimited levels and, amazingly, it does not require sub-selects or any other construct unsupported by MySQL. The rest of the book is filled with solutions to problems that test the limits of the relational database model. Best regards, Luciano Ramalho Tom Deprez wrote: A starting point is http://www.zope.org/Members/anthony/sql_vs_ZODB Reading this text is exactly the problem I'm having. Unfortunately, it doesn't give much examples. I hope somebody can give me some answers on my question : The problem I'm facing is the following. I've got a lot parent-child relationships - OODB But, I also need to perform some queries on these records and link some to each other - more RDB. I'm not sure which way to follow. A hybrid solution isn't the best one, I think, because then you do twice the same work. ie. You've to create the parent-child relationship in the OODB (the site structure) and in the RDB (to perform correct queries). The RDB solution is possible, but since I need lots of parent-child relationships not the best one. The OODB is probably the best. However, this implies several implementation problems I don't know how to solve at the moment. Can somebody elaborate on the following questions? Thanks in advance. Assume the following : Group1 SubGroup1 SubGroupA Problem1 Examination1 Equipment1 Paremeters Equipment2 Parameters Examination2 Campus1 Room1 Equipment1 Equipment2 Room2 Now, if a person is creating a new equipment in Examination2. How can I show it all the avalailable equipments in Campus1? So this person can choose from it and create it in the examination2 folder? In an OODB environment? If a person is browsing in Room1 and wants to get all the examinations which will be performed on Equipment1. How do I create such a query in OODB? (Or even further, the person wants to see all the examinations done on equipment1, but only with Group=Group1 and SubGroup=SubGroup1 How can this be done in Zope? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Object DB versus Relational DB
ZODB with Data.fs is optimized to fetch data. Inserts or updates have a lot of overhead. It's the price we pay for the excellent versioning features. Therefore, when the are many we have been avoinding ZODB even when the problem domain calls for an OODB Thanks for the link. However, the information in the database will not change much. Once the data is nin their, only sometimes data will be updated, inserted or deleted. So, the versioning system won't be a problem. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Object DB versus Relational DB
Maybe you need an ORDB (Object-Relational DB) like postgresql. PGSQL supports Inheritance: http://www.postgresql.org Troy -Original Message- From: Luciano Ramalho [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 6:12 AM To: Tom Deprez Cc: Rik Hoekstra; [EMAIL PROTECTED] Subject: Re: [Zope] Object DB versus Relational DB ZODB with Data.fs is optimized to fetch data. Inserts or updates have a lot of overhead. It's the price we pay for the excellent versioning features. Therefore, when the are many we have been avoinding ZODB even when the problem domain calls for an OODB We have implemented a highly hierarchical database for a Yahoo-like directory using a recipe found in the book SQL for Smarties, by Joe Celko, ISBN 1-55860-323-9 (see Chapter 26 - Trees). Celko's solutions allow for a hierarchy with unlimited levels and, amazingly, it does not require sub-selects or any other construct unsupported by MySQL. The rest of the book is filled with solutions to problems that test the limits of the relational database model. Best regards, Luciano Ramalho Tom Deprez wrote: A starting point is http://www.zope.org/Members/anthony/sql_vs_ZODB Reading this text is exactly the problem I'm having. Unfortunately, it doesn't give much examples. I hope somebody can give me some answers on my question : The problem I'm facing is the following. I've got a lot parent-child relationships - OODB But, I also need to perform some queries on these records and link some to each other - more RDB. I'm not sure which way to follow. A hybrid solution isn't the best one, I think, because then you do twice the same work. ie. You've to create the parent-child relationship in the OODB (the site structure) and in the RDB (to perform correct queries). The RDB solution is possible, but since I need lots of parent-child relationships not the best one. The OODB is probably the best. However, this implies several implementation problems I don't know how to solve at the moment. Can somebody elaborate on the following questions? Thanks in advance. Assume the following : Group1 SubGroup1 SubGroupA Problem1 Examination1 Equipment1 Paremeters Equipment2 Parameters Examination2 Campus1 Room1 Equipment1 Equipment2 Room2 Now, if a person is creating a new equipment in Examination2. How can I show it all the avalailable equipments in Campus1? So this person can choose from it and create it in the examination2 folder? In an OODB environment? If a person is browsing in Room1 and wants to get all the examinations which will be performed on Equipment1. How do I create such a query in OODB? (Or even further, the person wants to see all the examinations done on equipment1, but only with Group=Group1 and SubGroup=SubGroup1 How can this be done in Zope? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Object DB versus Relational DB
Hi, Can somebody provide me informational links of documents which present the benefits and non-benefits of both DB? eg. When to use one and when not to use one? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )