Re: DATABASE DESING ISSUE

Questions:  

> router statistics-> some numeric value
What does this data look like?
Is it atomic? What does the numeric value represent?

>multiple cpu utilization data->again in numeric ,
Same questions as for router statistics

> ip address..which would be primary key

Do you want to be able to easily search based partial IP?

Will your SQL queries always contain the first octet of the IP address in the WHERE clause?

e.g.

  for addresses 208.16.92.134 194.16.44.16 and 132.16.12.154   would there ever be a search done on the second octet (16 )?

In other words, should the IP be stored in a single column, or in four columns?

Is IPV6 compatibility important?

These questions must be asked to get an understanding of how you are trying to use the data.

Jared   

> i want to search the various cpu util data,memory utilisation data from ip
> address
> becuase each customer i am segregating by ip address

On Monday 09 April 2001 11:58, Nihar wrote:
> HI PPL
> i need some help on database design stuff.
>
> i am having data given below in one flat file and i want to put in tables.
> can anyone help in designing tables
>
> here is the data the info bout data
>
>
> my data is about
> router statistics-> some numeric value
> date,time,multiple cpu utilization data->again in numeric ,
> ip address..which would be primary key
> i want to search the various cpu util data,memory utilisation data from ip
> address
> becuase each customer i am segregating by ip address
>
>
> thanks and regards
>
>
> - NIHAR SANGHVI

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).