Re: [Acd-devel] Proposal for DB design

[Matt D. <di...@ec...>]

Scott Michael Koch wrote:
> On Thu, Dec 16, 2004 at 12:01:01AM -0500, Matt Disney wrote:
>>So I think those tables should basically just look like we currently 
>>have them:
>>
>>network_interfaces
>>  interface_device
>>  hardware_addres
>>  netmask
>>  ip
>>  instance_id
>>
>>I understand that leaves us simply with a different but still somewhat 
>>undesirable database design, but I don't see another way. Anyone have 
>>other ideas or oppose this one?
>>
>>MD
>>
>>
> 
> 
> One idea that comes to mind is to store the unique info such as IP's, serials,
> etc. in flat files or using some other method.  The way I see it is 
> combining the disk serials, IP, etc.. with the type of info that is currently 
> in the acd_manual_info files into a single file stored on the server for each 
> host.
> 
> I think this would solve/clean-up our database issue, but is  there a way to
> do this without losing functionality?  The only problem I forsee is keeping
> historical information on the data in these files efficiently. There is 
> something else to thing about.
> 
> -Scott

Yeah, it does seem like history would be hard. Another concern is 
querying the data that's stored in files. For example, maybe you want to 
find all the hosts that are on a certain subnet. Or maybe you want to 
find all WD Raptor hard drives because you suspect a pattern of failures.

In general, I have to say I'm not terribly fond of combining file and 
database usage like this. But if it solves a big problem for us, we 
certainly can't dismiss it outright.

MD