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