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 > Database Concepts & Design > Where to store data (what table)?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-01-12, 00:26
bt101 bt101 is offline
Registered User
 
Join Date: Feb 2012
Posts: 1
Where to store data (what table)?

Hi
I want to make a database to store a list of all my servers. I "think" it is pretty straight forward to make a table that has all of the servers and the attributes they have. However, as time goes by, I want to "use" the list of servers to "do things" to the servers using scripts.

For simplicity let's say a month from now a manager wants me to make a script that runs every day and does something to some servers servers. I need to record, in the database, a yes/no attribute for each server for that action. After another month, the manager wants another daily script that does something to a different set of servers. etc, etc.

I don't think it would be proper to add a column to the server list each time I need to record a new yes/no attribute for each server. Is that correct?

Should I make a completely new table each time I need to record a new attribute? It seems kinda kludgy because I would have the entire list of servers replicated many times in the database. Then, whenever I add/delete a server it would be a mess.

Any thoughts on where/how to store attributes that you don't know at the time you are designing the database?

Thanks
Reply With Quote
  #2 (permalink)  
Old 02-10-12, 12:38
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
No, just make a subtable of Events, with a foreign key to the Servers table.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

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