Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Car Data


Car Data

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36162 Visits: 18751
Comments posted to this topic are about the item Car Data

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3684 Visits: 3118
In the UK I expect telematics to be widely adopted by the insurance industry. These telematic devices produce several "events" per second so 1 million events per user per day is a realistic figure as is 64Mb of data per user per day.

For the most part the data will be junk. I drive for about 3 hours a day so 21 hours worth of data will be useless other than to tell that my car stood still at a particular location.

I'm not sure how many vehicles there are active on the roads in the UK but the DVLA say that 28 million were registered last year.

If it becomes mandatory to have a telematics device in the vehicle that's about 1.8Pb of data that will have to be processed of which less than 0.3Pb will need to be retained. Not really that big in the grand scheme of things.

LinkedIn Profile

Newbie on www.simple-talk.com
Chris-354050
Chris-354050
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 241
There was an interesting side note in Road and Track's review of the Tesla S this month.They'd found that the car was speed limited during a performance test; they advised Tesla who, without the R & T being aware, updated the software remotely over the car's 3G link and removed the limit. It's a good thing it was the good guys updating the software. Smile
jay-h
jay-h
SSC Eights!
SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)

Group: General Forum Members
Points: 927 Visits: 2222
It's not just lost keys. Drop a mechanical key in a puddle, no big deal. Electronic key?

Fortunately a replacement key for my car costs about $2. That's fine with me. (In a blizzard a couple of years ago, I dropped my keys in a snowbank, only to find them after the snow melted. They still worked fine)


I carry my own electronics rather than have it installed in the car.

...

-- FORTRAN manual for Xerox Computers --
Richard Warr
Richard Warr
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2578 Visits: 1983
Best one for keys is the 2003/04 Nissan Micra.

From http://www.honestjohn.co.uk/carbycar/nissan/micra-k12-2003/

Early Micra K12s with 'intelligent keys' are becoming economic write-offs because when the system fails a new steering column and rack is required costing £1,500.


_____________________________________________________________________
MCSA SQL Server 2012
John Hanrahan
John Hanrahan
Say Hey Kid
Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)

Group: General Forum Members
Points: 672 Visits: 1449
Another type of data stored is video. Recently a meteor exploded over Russia. The event was captured on lots of dashcam's. Imagine storing all of that data? They do it to protect themselves.
jay-h
jay-h
SSC Eights!
SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)

Group: General Forum Members
Points: 927 Visits: 2222
John Hanrahan (3/25/2013)
Another type of data stored is video. Recently a meteor exploded over Russia. The event was captured on lots of dashcam's. Imagine storing all of that data? They do it to protect themselves.


Well not all that is stored. It's typically a looping camera, downloaded only when something interesting happens.

...

-- FORTRAN manual for Xerox Computers --
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36162 Visits: 18751
I hadn't thought about the puddle. I'd hope the keys can withstand some brief immersion. I know I've dropped the Prius keys in the snow and it hasn't been a big deal, partially because I don't need to "plug" it in. I can set it on the console and start the car.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Rod
Rod
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1132 Visits: 1931
What I don't like about newer vehicles is the windows getting smaller. I have a 25 year old Toyota van (they didn't call them minivans back then, although that's what it is) which I got used about 15 years ago. It was easy to see around the vehicle from the driver's seat. Recently we've gotten a newer Toyota minivan, a nice 2006 Sienna. However the windows are smaller. I have a much harder time backing up that vehicle because I can't see as well to back it up. I'm convinced that's the reason why manufacturers are putting in those cameras, so you can see in the back of the vehicle when you back it up. I kind of feel ripped off; you know they add something for $1000+ because they're reduced the visibility you used to have. Why not just make my windows larger, and save me the $1000?

Kindest Regards,RodConnect with me on LinkedIn.
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3684 Visits: 3118

Well not all that is stored. It's typically a looping camera, downloaded only when something interesting happens.


Jackpot!w00t

LinkedIn Profile

Newbie on www.simple-talk.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search