Re: [SLUG] Re: A question of databases

From: Chuck Hast (wchast@gmail.com)
Date: Tue Dec 07 2004 - 10:12:13 EST


Data Rate... Hmm we are getting a environment report from the radio
every 2 seconds here is a few samples of what that looks like
This is the peerstat data (rf environment) it samples every 2 seconds
This has the field names at the top and 3 lines of data.

UID,MID,Time,Net,RSSI,TXraw,CID,RS,CS,PR,EcIo,TX,FT,FB,Hdg,Spd,Lat,Lon,a,b,c,d,e,FFER
rf-agl,1,20041129155650,1024,-55,-4209,160,1,1,6,-7,-42.09,10292,159,0.00,0.00,33.78039,-84.38678,0,0,0,0,0,0
rf-agl,2,20041129155652,1024,-55,-4417,160,1,1,6,-7,-44.17,10394,159,0.00,0.00,33.78037,-84.38677,0,0,0,0,0,0
rf-agl,3,20041129155654,1024,-55,-4343,160,1,1,6,-7,-43.43,10496,159,0.00,0.00,33.78037,-84.38678,0,0,0,0,0,0

This sample is similar but it contains the round trip time data (can
you hear me now)
along with environmental data captured at time test message was sent
and received.
ST = Send Time RT = Receive Time,
UID,MID,ST,RT,Net,Bytes,RTT,SRSSI,RRSSI,SCh,RCh,SRS,RRS,SCS,RCS,SPR,RPR,SEcIo,REcIo,STx,RTx,SFt,RFt,SFb,RFb,SLat,SLon,RLat,RLon,a,b,c,d,e,f
rf-agl,1,20041129160006,20041129160012,1024,100,5728,-55,-55,160,160,1,1,1,1,6,6,-7,-9,-52.25,-39.76,13203,13223,208,208,33.78036,-84.38676,33.78003,-84.38613,0,0,0,0,0,0
rf-agl,2,20041129160012,20041129160014,1024,100,2504,-55,-55,160,160,1,1,1,1,6,6,-9,-8,-39.76,-46.67,13223,13426,208,209,33.78003,-84.38613,33.77967,-84.38624,0,0,0,0,0,0
rf-agl,3,20041129160014,20041129160017,1024,100,2503,-55,-55,160,160,1,1,1,1,6,6,-8,-7,-46.67,-45.76,13426,13528,209,210,33.77967,-84.38624,33.78034,-84.38705,0,0,0,0,0,0

The final one which is only captured for CDMA networks is Call Setup.
This goes through
a call setup cycle every 45 seconds. So it does not go very fast.
UID,MID,DateTime,Net,RSSI,TXraw,CID,RS,CS,PR,EcIo,TX,FT,FB,Hdg,Spd,Lat,Lon,C_ctg,C_ctd,C_disctd,C_Error,RAS_Code,C_Dur
csu-agl,2,20041129160111,1024,-56,-1,283,0,0,0,0,-0.01,0,0,0.00,0.00,33.78017,-84.38653,-1,64,-1,1,0,16
csu-agl,3,20041129160151,1024,-56,-1,283,0,0,0,0,-0.01,0,0,0.00,0.00,33.78017,-84.38653,-1,64,-1,1,0,16
csu-agl,4,20041129160231,1024,-56,-1,283,0,0,0,0,-0.01,0,0,0.00,0.00,33.78047,-84.38652,-1,64,-1,1,0,17

These devices range from serial port devices (9k6 or 19k2) to PCMCIA
and USB devices
so on those am not sure what the data rate is between the device and
the host computer,
but assume that it is something greater than 128kb. But that will only
be the short burst
when the data arrives from the card, and actually it is being
processed by our tool so the
actual speed is that at which the tool is handing it to the odbc driver.

I shall pass the perl info on to the fellow that does the tool. That
looks like a great idea,
he is looking at other solutions, I assume that you use the perl code
to write the data
to a db and work around the odbc slowness?

I would rather go to MySQL or PostgreSQL rather than Oracle, we have
the licenses, but
I have seen too much Oracle grief, and in fact a customer just told me
that they would
take the db in any format BUT Oracle. (wonder who they p.o.'d) also
the guy that does
the tool wants to look at MySQL and PostgreSQL for other gateway
services so there
are several reasons to look at both of them.

No, No Access. It is a dog, and any machine that runs it should have a
blanket put over
it when the moon is full or it will wake you up baying at the moon. We
will transfer the
data to Access if the customer ask for it, but no processing in
access. I use it right
now for these little short files but want to move on to one of the
open source ones in
the next couple of weeks so I can get it out of my hair.
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 17:10:56 EDT