I think the best solution would be
TABLE ITEMS
[ item_id | parent_id | item_name ]
data
1, 0, foo
2, 0, bar
3, 2, baz
4, 2, quux
5, 1, fee
6, 1, fi
So above baz and quux are subcats of bar and fee/fi
are subcats of foo
This structure allows for unlimited levels of
sub-categories to be added. G
Hello all,
I have an 'items' table with 2 'types' of items -- 'foo' & 'bar'
Say that items of type 'bar' may be further classified as 'subtypes' 'baz',
'quux', etc.
Now I build an online store so that visitors may buy items.
Contstraints
1.) I would like to, as much as possible, use the same c
Can anyone suggest a good data modeling tool that can be used for:
a) Reverse enginering: dump file => data model
b) Create a new data model
c) Generate the ddl from the data model
d) The tool should handle the latest features of MySQL 3.23.52
Any comments about the tool called dezign. Is it
On Wed, 14 Feb 2001, Dario Brignardello wrote:
> Hey! That's exactly what I'm working in... is your dia's parser GPLed
> ?? :-) It could help me a lot... Thanks in advance :-)
I told folks at our local perl mongers ( http://norfolk.pm.org ) that I
was working on packaging up what I had to send to
On Wed, 14 Feb 2001, Dave Rolsky wrote:
> One feature I've been considering for Alzabo is to be able to somehow
> process dia's XML and generate a schema from it.
>
> Alzabo will (sometime soon, I hope) be able to read/write DBML, an XML
> language Barrie Slaymaker is working on (with some input
On Mon, 12 Feb 2001 [EMAIL PROTECTED] wrote:
> Moving back and forth is a manual process, which is a bit frustrating.
> Since dia stores everything in XML, I'm considering what it would take to
> make some sort of syncronization.
>
> I've been planning on looking into Alzabo too, which was alread
that a little poking around won't cure.)
Finally, the interface breaks with the commonly used symbols for data
modeling. Other tools use common symbols for entities and relationships.
DeZign chose to use similar but non-standard symbols.
All that said and done, what DeZign does have is a devel
On Sat, 10 Feb 2001, Cal Evans <[EMAIL PROTECTED]> wrote:
> As much as I love creating models by hand, my databases are growing to
> the point where I need a tool to help me "see" them. Does anyone know
> of a tool like ERWin or ER/Studio that supports MySQL?
I do my diagrams in UML with dia. A
w.calevans.com
>
>
>-Original Message-
>From: Mark Chalkley [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, February 10, 2001 6:12 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Data modeling tool
>
>
>I haven't tried ERWin, but CASE Studio (www.casestudio.com) is
I agree that a time-limited, but otherwise fully functional demo is better, especially
in the case (pardon the pun) of database modelling. It would certainly be worth
sending them a message telling them so. You never know - they might agree with you.
Mark Chalkley
-
models, I just can't save them. (Better than the other two but still not
what I want)
Cal
http://www.calevans.com
-Original Message-
From: Michael Lépine [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 10, 2001 10:12 PM
To: Cal Evans; [EMAIL PROTECTED]
Subject: RE: Data modeling
:)
I'd love to publish a full comparison of the tools but these size limited
demo's bite.
Cal
http://www.calevans.com
-Original Message-
From: Mark Chalkley [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 10, 2001 6:12 PM
To: [EMAIL PROTECTED]
Subject: Re: Data
I asked a similar question recently and as a result of my searching, I found
a moderately priced, $99 (I think), data modeling tool from XTG (download
here):
http://www.xtgsystems.com/download.php3
I downloaded it and set up a few tables (only 4 are allowed with eval), then
generated the sequel
On Sat, 10 Feb 2001, Cal Evans wrote:
> As much as I love creating models by hand, my databases are growing to the
> point where I need a tool to help me "see" them. Does anyone know of a tool
> like ERWin or ER/Studio that supports MySQL?
I have a project called Alzabo (alzabo.sourceforge.net)
I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers
a trial download, and does support MySQL.
Mark Chalkleyi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I wish, ERWin is wonderful!
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 10, 2001 6:41 PM
Subject: Data modeling tool
> As much as I love creating models by hand, my databases are growing to the
&g
As much as I love creating models by hand, my databases are growing to the
point where I need a tool to help me "see" them. Does anyone know of a tool
like ERWin or ER/Studio that supports MySQL?
Cal
http://www.calevans.com
-
will you all be doing anything for OS X?
At 8:01 AM + 2/2/01, John Dean wrote:
>Hi
>Hopefully, we plan to include Dezign for Databases in our new GUI
>client, but this is not yet embedded in stone.
>
>At 23:54 01/02/2001 -0500, Michael Lépine wrote:
>>I've tried searching the archives, but I
Hi
Hopefully, we plan to include Dezign for Databases in our new GUI client,
but this is not yet embedded in stone.
At 23:54 01/02/2001 -0500, Michael Lépine wrote:
>I've tried searching the archives, but I haven't seen a direct question
>about an open source tool or freely available application
For UNIX users (eg BSD, linux) there is something called dia which allows you
to draw ERDs
But, I assume you are looking something more like a RAD tool rather than a
simple program that allows you to draw UML, ERD's etc.
However, if you are intersted in dia and using Linux you can find the rpm
I've tried searching the archives, but I haven't seen a direct question
about an open source tool or freely available application that could be used
to model a relational database schema. Some of my friends use Sybase's Power
Designer or ERwin, but these are very expensive (at least for me) tools.
21 matches
Mail list logo
