dbTalk Databases Forums  

design db

comp.databases comp.databases


Discuss design db in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
soalvajavab1@yahoo.com
 
Posts: n/a

Default design db - 04-25-2007 , 06:10 PM






In the early phase of data modeling how do you usually start with
these steps:

data layout, normalization, key definition, and performance tuning

Considering that application needs to design from dcratch and it is
100+ tables involve


Reply With Quote
  #2  
Old   
David Cressey
 
Posts: n/a

Default Re: design db - 04-26-2007 , 04:59 AM







<soalvajavab1 (AT) yahoo (DOT) com> wrote

Quote:
In the early phase of data modeling how do you usually start with
these steps:

data layout, normalization, key definition, and performance tuning

Considering that application needs to design from dcratch and it is
100+ tables involve

Here is an outline to data modeling:

http://www.utexas.edu/its/windows/da.../overview.html

You probably want to get a book with more detail in it, but this is a
start.





Reply With Quote
  #3  
Old   
soalvajavab1@yahoo.com
 
Posts: n/a

Default Re: design db - 04-26-2007 , 11:15 AM



On Apr 26, 3:59 am, "David Cressey" <cresse... (AT) verizon (DOT) net> wrote:
Quote:
soalvajav... (AT) yahoo (DOT) com> wrote in message

news:1177542646.546450.219350 (AT) n15g2000prd (DOT) googlegroups.com...

In the early phase of data modeling how do you usually start with
these steps:

data layout, normalization, key definition, and performance tuning

Considering that application needs to design from dcratch and it is
100+ tables involve

Here is an outline to data modeling:

http://www.utexas.edu/its/windows/da.../overview.html

You probably want to get a book with more detail in it, but this is a
start.
The web site was fgreat. Thanks a lot.

JUst want to know also What is your favourite book for this matter?
well written, practical with examples?



Reply With Quote
  #4  
Old   
Lemming
 
Posts: n/a

Default Re: design db - 04-27-2007 , 07:48 PM



On 26 Apr 2007 09:15:09 -0700, soalvajavab1 (AT) yahoo (DOT) com wrote:

Quote:
On Apr 26, 3:59 am, "David Cressey" <cresse... (AT) verizon (DOT) net> wrote:
soalvajav... (AT) yahoo (DOT) com> wrote in message

news:1177542646.546450.219350 (AT) n15g2000prd (DOT) googlegroups.com...

In the early phase of data modeling how do you usually start with
these steps:

data layout, normalization, key definition, and performance tuning

Considering that application needs to design from dcratch and it is
100+ tables involve

Here is an outline to data modeling:

http://www.utexas.edu/its/windows/da.../overview.html

You probably want to get a book with more detail in it, but this is a
start.

The web site was fgreat. Thanks a lot.

JUst want to know also What is your favourite book for this matter?
well written, practical with examples?
This response does rather explain why usenet is dying, doesn't it?

Lemming
--
Curiosity *may* have killed Schrodinger's cat.


Reply With Quote
  #5  
Old   
Last Boy Scout
 
Posts: n/a

Default Re: design db - 04-29-2007 , 08:26 PM



soalvajavab1 (AT) yahoo (DOT) com wrote:
Quote:
In the early phase of data modeling how do you usually start with
these steps:

data layout, normalization, key definition, and performance tuning

Considering that application needs to design from dcratch and it is
100+ tables involve

First Define the business rules and business functions the database
should support.

Then identify business objects and their relations.

This is just one possible solution. There are many methods. Defining
the business rules should always come first. You can not design
anything unless you have some requirements. Some people would say to
map out the processes. Depends how large and complex the scope of the
design is and how well you have to write up the specification.
Oversimplification can cause problems later. The trick is to identify
the hidden requirements, that the customers have overlooked.

One mistake in the design is you are designing a system to get
information out, not put data in.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.