If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Chit Chat > Enterprise Data

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-02-10, 11:06
mayaron mayaron is offline
Registered User
 
Join Date: Jun 2007
Posts: 7
Enterprise Data

What would you be looking in the data when developing a new application?
Just throw anything on your mind such as indexes, relationships with other tables, join type etc.

Thank you!!!
Reply With Quote
  #2 (permalink)  
Old 07-02-10, 11:15
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,084
Quote:
Originally Posted by mayaron View Post
What would you be looking in the data when developing a new application?
i would look at the shape of the data, whether it has curves in the right places

then i would look at the type of the data, whether it is prim or promiscuous

finally, i would look at how agreeable the data might be to my ministrations
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 07-02-10, 11:26
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,556
Model the business. That's it.

If you design your database to support forms and features, supporting those specific forms and features is all that it will do.

If you design your database to model the business, then it will do everything the business could ask it to do.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #4 (permalink)  
Old 07-02-10, 12:27
mayaron mayaron is offline
Registered User
 
Join Date: Jun 2007
Posts: 7
Thanks for you reply!

I'm going to write that down to my boss!
Reply With Quote
  #5 (permalink)  
Old 07-02-10, 12:36
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,556
Tell him blindman said it. That gives it the stamp of authority.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #6 (permalink)  
Old 07-02-10, 13:03
mayaron mayaron is offline
Registered User
 
Join Date: Jun 2007
Posts: 7
God I'm laughing :)

Thank you blindman, I was reffering to r937 reply.
Your post sounds great and I will sure use your words, it describes so accurately my whole question
Reply With Quote
  #7 (permalink)  
Old 07-02-10, 13:49
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,556
Ouch. One-upped by a Canuck. Again.

I will be sure to loft some bottle-rockets northward this Sunday, in Rudy's general direction.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On