Re: ApacheDS partition implementation based on Relational Model

2006-11-12 Thread Emmanuel Lecharny
On 11/11/06, David Boreham <[EMAIL PROTECTED]> wrote: >> > If we go to RDBMS, this would be the worst approach. It is suppose>> to be>> > a relationnal model, not an hierarchical model mapped on a relationnal>> > model. Performance will be awfull >I missed a few iterations in this thread (been busy

Re: ApacheDS partition implementation based on Relational Model

2006-11-11 Thread Ersin Er
On 11/12/06, David Boreham <[EMAIL PROTECTED]> wrote: >> > If we go to RDBMS, this would be the worst approach. It is suppose >> to be >> > a relationnal model, not an hierarchical model mapped on a relationnal >> > model. Performance will be awfull > I missed a few iterations in this thread (be

Re: ApacheDS partition implementation based on Relational Model

2006-11-11 Thread David Boreham
> If we go to RDBMS, this would be the worst approach. It is suppose to be > a relationnal model, not an hierarchical model mapped on a relationnal > model. Performance will be awfull I missed a few iterations in this thread (been busy with the day job), but some late thoughts: 1. Have you

Re: ApacheDS partition implementation based on Relational Model

2006-11-11 Thread Ersin Er
http://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-Systems/dp/1558609202 :-D On 11/2/06, Alex Karasulu <[EMAIL PROTECTED]> wrote: Emmanuel Lecharny wrote: > > >> The simplest way to do it is to construct tables that look just > like the > >> b-tree relations used in a

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Alex Karasulu
Emmanuel Lecharny wrote: >> The simplest way to do it is to construct tables that look just like the >> b-tree relations used in a custom LDAP data store. However this doesn't >> goal achieve #2 above. > > Can you explain this more? Basically he's saying mod

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread David Boreham
Ersin Er wrote: Well, this is just a test currently. It's a software engineering project for two students to make them familiar with all these (ldap, rdbms, ADS, pragmatic tools, etc.) stuff. It can also be thought as a DB research project to learn what the best way of storing directory data on

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread David Boreham
Emmanuel Lecharny wrote: If it woth 64 000$, then it's a BECAUSE :) Otherwise, there are many good other reasons beside being greedy : - SQL databases are reliable, when jdbm database is not Well, one might argue that there are better reliable storage manager choices than a client/server RDB

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread David Boreham
The simplest way to do it is to construct tables that look just like the b-tree relations used in a custom LDAP data store. However this doesn't goal achieve #2 above. Can you explain this more? Basically he's saying model the db like you do the jdbm tables in the ldbm rip off we use f

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Emmanuel Lecharny
>> The simplest way to do it is to construct tables that look just like the >> b-tree relations used in a custom LDAP data store. However this doesn't>> goal achieve #2 above.>> Can you explain this more?Basically he's saying model the db like you do the jdbm tables in the ldbm rip off we use for t

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Alex Karasulu
Ersin Er wrote: Hi, On 11/2/06, David Boreham <[EMAIL PROTECTED]> wrote: Ersin Er wrote: > I need some advice on implementing a partition for ADS based on the > relational model and using SQL or Hibernate or JPA, or framework like > them.. First the $64,000 question : WHY ? Well, this is ju

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Ole Ersoy
Incidentally IBM and BEA wrote the SDO specification, so there's a good chance they are using that for as the integration technology. --- Emmanuel Lecharny <[EMAIL PROTECTED]> wrote: > Hey, Stefan ! > > yeah, I saw IDS used with a 70 000 000 entries > database. Pretty impressive > :) > > Emmanu

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Stefan Zoerner
David Boreham wrote: Ersin Er wrote: I need some advice on implementing a partition for ADS based on the relational model and using SQL or Hibernate or JPA, or framework like them.. First the $64,000 question : WHY ? At least it would be a nice example on how to write your own partition i

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Emmanuel Lecharny
Hey, Stefan ! yeah, I saw IDS used with a 70 000 000 entries database. Pretty impressive :)EmmanuelOn 11/2/06, Stefan Zoerner < [EMAIL PROTECTED]> wrote:Ersin Er wrote:> I need some advice on implementing a partition for ADS based on the > relational model and using SQL or Hibernate or JPA, or fram

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Stefan Zoerner
Ersin Er wrote: I need some advice on implementing a partition for ADS based on the relational model and using SQL or Hibernate or JPA, or framework like them.. First of all, is this realistic? Can we reach a usable result? Just a little note (you probably already know this) ... IBM Tivoli D

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Emmanuel Lecharny
On 11/2/06, Ole Ersoy <[EMAIL PROTECTED]> wrote: Hey Emmanuel,How did you get the sexy vertical lines in the reply?Way better than all the >>>gmail do it for me :) Are you using thunderbird?yes, but not in office. --- Emmanuel Lecharny < [EMAIL PROTECTED]> wrote:> Hi Ole,>> On 11/2/06, Ole Ersoy <

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Ole Ersoy
Hey Emmanuel, How did you get the sexy vertical lines in the reply? Way better than all the >>> Are you using thunderbird? --- Emmanuel Lecharny <[EMAIL PROTECTED]> wrote: > Hi Ole, > > On 11/2/06, Ole Ersoy <[EMAIL PROTECTED]> wrote: > > > > Hi Ersin, > > > > > > Personally I need to be abl

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Emmanuel Lecharny
On 11/2/06, David Boreham <[EMAIL PROTECTED]> wrote: Ersin Er wrote:> I need some advice on implementing a partition for ADS based on the> relational model and using SQL or Hibernate or JPA, or framework like> them..First the $64,000 question : WHY ? If it woth 64 000$, then it's a BECAUSE :) Other

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Ersin Er
Hi, On 11/2/06, David Boreham <[EMAIL PROTECTED]> wrote: Ersin Er wrote: > I need some advice on implementing a partition for ADS based on the > relational model and using SQL or Hibernate or JPA, or framework like > them.. First the $64,000 question : WHY ? Well, this is just a test current

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Ersin Er
Hi, On 11/2/06, Emmanuel Lecharny <[EMAIL PROTECTED]> wrote: On 11/2/06, Alex Karasulu <[EMAIL PROTECTED]> wrote: > Ersin Er wrote: > > How can we map Attributes to SQL model? > > There are probably a few ways to do this but some will be much faster > however the faster it is the uglier it will

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Ersin Er
Hi! On 11/2/06, Alex Karasulu <[EMAIL PROTECTED]> wrote: Ersin Er wrote: > Hi all, > > I need some advice on implementing a partition for ADS based on the > relational model and using SQL or Hibernate or JPA, or framework like > them.. > > First of all, is this realistic? Can we reach a usable r

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread David Boreham
Ersin Er wrote: I need some advice on implementing a partition for ADS based on the relational model and using SQL or Hibernate or JPA, or framework like them.. First the $64,000 question : WHY ? First of all, is this realistic? Can we reach a usable result? Yes, but experience shows that

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Emmanuel Lecharny
Hi Ole,On 11/2/06, Ole Ersoy <[EMAIL PROTECTED]> wrote: Hi Ersin,Personally I need to be able to go between an LDAPformat, XML Schema format, and a relational format.This will be possible really soon, at least from ldap to XML. Pam is writting a DSML codec, so you will be able to extract data from

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Emmanuel Lecharny
On 11/2/06, Alex Karasulu <[EMAIL PROTECTED]> wrote: Ersin Er wrote:> How can we map Attributes to SQL model?There are probably a few ways to do this but some will be much fasterhowever the faster it is the uglier it will be.One way is to have one big table with the following columns: 1). ENTRY (BL

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Ole Ersoy
Hi Ersin, Alex and I talked about doing this. I need to finish the first version of the the design document. OpenLDAP supports relational backends. They also have this command: ldbmcat - LDBM to LDIF database format conversion utility I think that performs relational to LDIF conversion. Per

Re: ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Alex Karasulu
Ersin Er wrote: Hi all, I need some advice on implementing a partition for ADS based on the relational model and using SQL or Hibernate or JPA, or framework like them.. First of all, is this realistic? Can we reach a usable result? Ok first off you need to better define exactly what you are t

ApacheDS partition implementation based on Relational Model

2006-11-02 Thread Ersin Er
Hi all, I need some advice on implementing a partition for ADS based on the relational model and using SQL or Hibernate or JPA, or framework like them.. First of all, is this realistic? Can we reach a usable result? How can we map Attributes to SQL model? Should we hold Attribute Values in blob