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: davidni...@gmail.com
Date: Tue, 27 Apr 2010 09:26:40 -0500
Subject: Re: a tool to reverse-engineer a schema
To: dbi-users@perl.org
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 davidni...@gmail.com 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
