Re: Initial SVN Repository data model

On Tue, Feb 26, 2002 at 01:31:38AM -0800, Bill Tutt wrote:
> I've managed to put together a SVN data model that mostly represents
> what we currently have.
>
> . Directories are always modeled as being stored inline

What do you mean "inline" ? As in "the entries are not compressed" ?

> . Do we use the REP-OFFSET portion of the delta window?

Yes, we use both the offset and size of the window.

>...
> In fact all corrections/improvements to the data model are greatly
> appreciated.

* the nodes need properties :-)
* I don't understand the "CopyNode" field in the ER diagram; looking at the
  model, it seems "IsCopyNode" is the problem. That is really "if kind ==
  copynode". IOW, the table just needs "kind"
* why does "String" have a rep ID?
* I'd like to see prop names normalized into another table (there will be a
  lot of duplication there)
* speaking on props, we have some standard props, which we may want to model
  explicitly as columns: created-rev, log msg, author, date

>...
> All of this cool new stuff is available at:
> http://www.lyra.org/flytrap/SVNModel/

Oops. I was supposed to create a new area for you a long time ago. Done.
(lyra.org/rassilon/)

That's all my comments for now...

Cheers,
-g

-- 
Greg Stein, http://www.lyra.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org