RE: a tool to reverse-engineer a schema

2010-04-27 Thread Martin Gainty

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  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

Re: a tool to reverse-engineer a schema

2010-04-27 Thread David Nicol
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  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?


a tool to reverse-engineer a schema

2010-04-27 Thread David Nicol
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?


-- 
I like to think that when I ramble on, I'm speaking for others who
share my opinions or point of view but who aren't as expressive.