RE: a tool to reverse-engineer a schema
[email protected] (Martin Gainty)
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
David-
My understanding of database design is that a database is used to organise the data..
so the upfront work of define tables..columns and their relationships..DDL usually comes first
if a bunch of statements are thrown at the Database the database could conceivably cache those statements and then
create and or modify the schema?
you might want to consider an ORM (Object Relation Mapper) such as hibernate and specify lazy=true (load data only when needed)
http://www.coderanch.com/t/218722/Object-Relational-Mapping/java/fetching-lazy
more specifically you will want to control of when to create your schema entities are created via the
hbm2ddl.auto option which will turn on automatic generation of
database schemas directly into the database.
http://docs.jboss.org/hibernate/stable/core/reference/en/html/tutorial.html#tutorial-firstapp-workingpersistence
hth
Martin Gainty
______________________________________________
Note de déni et de confidentialité
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
> From: [email protected]
> Date: Tue, 27 Apr 2010 09:26:40 -0500
> Subject: Re: a tool to reverse-engineer a schema
> To: [email protected]
>
> I mean of course DBD::Mock, sorry
> http://search.cpan.org/~drolsky/DBD-Mock-1.39/lib/DBD/Mock.pm
>
> On Tue, Apr 27, 2010 at 9:24 AM, David Nicol <[email protected]> wrote:
> > Has anyone extended DBD::Null to make a tool that after you run a mess
> > of prepare statements against the handle, it will give you some DDL to
> > create a schema that they will all make sense on?
_________________________________________________________________
Hotmail is redefining busy with tools for the New Busy. Get more from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2