J
Janis
I have a really simple structure for an ISP. I just need to get weekly
utilization figures. The problem is when the node is over utilized it
gets segmented and the field divides. I get the weekly data from a SQL db.
Actually it comes from SQL to another Access db. I have to query one of the
two instead of getting it in Excel.
area-->router-->transmistter-->nodeID-->statistics
areaID
area
transmitterID
AREAID
transmitter ports
nodeID
transmitterId
nodes
statisticsID
weekending
internet traffic
t.v. traffic
A tricky part is they split the node if the utilization is over 50% and
move it to a new router. The node is the pedestal that is connected to the
subscribers.
Each node has a 4 letter names, for example
ABCD,EFGH. The related transmitters sometimes have the exact same name
ABCD,EFGH. To split the transmitter ,they take one port, for example, ABCD
and call it A, ABCD-A and
ABCD-B to show the split on the transmitter. They take the first node ABCD
corresponds to transmitter ABCD-A and the 2nd EFGH and it corresponds to
transmitter ABCD-B to split it if the utilization is over 50%. Sometimes
there are more nodes than transmitter ports the ports and nodes aren't
always matching in number or names.
The nodes and transmitters are still unique but I have to show the history.
This part will be done by data input. If you start at the area and move to
the node you can find it.
QUESTION:Is this a relationship right or not?
Since the field contents for the
nodes will change should I show each separate node as a separate field?
instead of all the nodes on a transmitter as a group? That way I am dealing
with individual nodes instead of a group of nodes? This also might be a many
to many.
Matching them on this smaller level might be a lot more trouble than it is
worth for just getting out weekly statistics. That is all I ahve to do show
the nodes over 50% each week. I can get someone to do data input on the
segmentation.
So instead of one to one, relaitonship from one transmitter to a group of
nodes it would be individual relationships from the transmitter to each node?
Then when you split the transmitter you can do the relationships better. In
some cases the transmitter and ports are the same groups of letters. In some
cases there are more nodes.
thanks for any advice or just let me know if I am on track with the above.
utilization figures. The problem is when the node is over utilized it
gets segmented and the field divides. I get the weekly data from a SQL db.
Actually it comes from SQL to another Access db. I have to query one of the
two instead of getting it in Excel.
area-->router-->transmistter-->nodeID-->statistics
areaID
area
transmitterID
AREAID
transmitter ports
nodeID
transmitterId
nodes
statisticsID
weekending
internet traffic
t.v. traffic
A tricky part is they split the node if the utilization is over 50% and
move it to a new router. The node is the pedestal that is connected to the
subscribers.
Each node has a 4 letter names, for example
ABCD,EFGH. The related transmitters sometimes have the exact same name
ABCD,EFGH. To split the transmitter ,they take one port, for example, ABCD
and call it A, ABCD-A and
ABCD-B to show the split on the transmitter. They take the first node ABCD
corresponds to transmitter ABCD-A and the 2nd EFGH and it corresponds to
transmitter ABCD-B to split it if the utilization is over 50%. Sometimes
there are more nodes than transmitter ports the ports and nodes aren't
always matching in number or names.
The nodes and transmitters are still unique but I have to show the history.
This part will be done by data input. If you start at the area and move to
the node you can find it.
QUESTION:Is this a relationship right or not?
Since the field contents for the
nodes will change should I show each separate node as a separate field?
instead of all the nodes on a transmitter as a group? That way I am dealing
with individual nodes instead of a group of nodes? This also might be a many
to many.
Matching them on this smaller level might be a lot more trouble than it is
worth for just getting out weekly statistics. That is all I ahve to do show
the nodes over 50% each week. I can get someone to do data input on the
segmentation.
So instead of one to one, relaitonship from one transmitter to a group of
nodes it would be individual relationships from the transmitter to each node?
Then when you split the transmitter you can do the relationships better. In
some cases the transmitter and ports are the same groups of letters. In some
cases there are more nodes.
thanks for any advice or just let me know if I am on track with the above.