19:01:08 RRSAgent has joined #auto 19:01:08 logging to https://www.w3.org/2022/01/25-auto-irc 19:01:09 inviting RRSAgent 19:01:10 RRSAgent, make logs Public 19:01:11 Meeting: Automotive Working Group Teleconference 19:01:14 Scribe: Ted 19:01:15 scribenick: ted 19:01:18 Chair: Ted 19:01:59 Present+ Ted, Ulf, Adnan, Felix, Carine, Daniel 19:02:02 Regrets+ Peter 19:03:09 Present+ Erik 19:04:17 Present+ Gunnar 19:05:35 Present+ Paul 19:08:42 Topic: MongoDB and VSS for Automotive use 19:08:59 Felix: hope people are already somewhat familiar with MongoDB 19:09:28 … we have evolved as a company, have 30k customers with 2M MongoDB clusters on AWS, Azure etc 19:09:44 … far more downloads and instances elsewhere 19:10:14 … we are the most popular non-relational database, at least according to search engine metrics 19:10:20 … @@slides 19:10:34 s/… @@slides/@@slides/ 19:10:42 … we use binary JSON 19:11:08 … we started combining as a pure non-relational db, JSON based and flexible meaning you could add fields on the fly 19:11:27 … in non-relational world still a need for joins 19:11:41 … we are focused on realtime workloads 19:12:14 s/Azure etc/Azure, GCP etc/ 19:12:41 … we use code versioning to align code to database structure at different points in time 19:13:20 … we can attain backwards compatibility of code 19:14:56 … what is the advantage of using MongoDB in vehicle? we have can store a representation of a vehicle in any structure as a complete object instead of having to dismantle data and put in different tables for wheels etc... 19:15:41 … MongoDB started as a document model database, set of name/value pairs, support graphs, joins - ability to show relationships 19:15:57 … support time series, queries 19:16:13 … JSON structure objects which are widely used 19:16:50 s/queries/indexed data, queries/ 19:17:25 … we can build data lakes for historic data as opposed to live, current view 19:17:35 … we use tls for transport, encryption at rest 19:18:30 … as mentioned we run on the major clouds platforms with failover capabilities between them 19:19:10 … Realm started as a DB, started in 2010 and acquired by Mongo in 2019 19:19:39 … they were very popular, open source 19:19:56 … over the last two years we've been merging with Mongo 19:20:46 … Realm can fit on an ECU, it uses websockets to transmit data 19:21:20 … there are a number of optimizations to reduce data transmission, only send delta differences for instance 19:22:43 … multiple sdk are available. we create a vehicle "shadow" in the cloud, REST APIs and GraphQL support and various ERP connectors 19:23:32 … vehicle architecture is more complex, multiple ECUs will want to synchronize data among themselves and with the TCU 19:23:56 … different Realm db can sync across vehicle and to the cloud 19:24:42 Gunnar: is what is shared restricted in any manner? 19:24:55 Felix: you can limit what object you share 19:25:24 Adnan: based on request you could dynamically supply what is needed, a use case we had initially 19:25:42 Gunnar: I was thinking about locking down access to ECU to data needed 19:25:56 Felix: you can create dynamic queries, define what data you want to replicate 19:26:33 … there might be scenarios where that changes, you may want to configure for lower connectivity data off-boarding 19:27:02 … this audience should be familiar with VSS. we created a JSON schema from it 19:27:23 q+ to ask if Mongo JSON differs from one in VSS repo, how and why? 19:28:01 … we support db per vehicle and db across multiple vehicles, different collections 19:29:47 … it is possible to modify the generated JSON 19:30:10 … we create a data model for the Realm db 19:33:34 … there are change notification capabilities 19:34:49 … for GraphQL API we go from JSON to generate schema 19:35:27 Present+ Peter 19:36:04 Gunnar: the query language specific to Mongo? it seems similar to GraphQL 19:36:11 Felix: yes 19:36:53 Gunnar: you may want to track how old data is, can you speak to time based use? 19:37:24 Felix: we can add timestamp to the generated JSON. it is a common way to transmit or store timestamps 19:39:36 ted, you wanted to ask if Mongo JSON differs from one in VSS repo, how and why? 19:41:41 Felix: what we generate is pretty close to what you have 19:42:20 s/you wanted to ask if we can use existing JSON or Graph schema instead of Mongo generated/ 19:43:19 Ted: possible to use our existing JSON? 19:43:40 Felix: it would need some tweaks and also depends if you want to keep database as one document or multiple 19:43:58 Gunnar: we expect to need translations between systems 19:44:15 … I think Ted cares about value structure 19:44:46 … here you are thinking more message based 19:45:22 Felix: JSON structure itself just controls how the data is written into the db and ours allows for querying and other capabilities 19:51:15 Topic: VSSo publication and workshop planning 19:51:36 Daniel: we have some open design discussions, where we use restrictions, what gets instantiated... 19:52:06 … we want to have a 2-3 workshop around VSSo including things like presentation from MS on their DTDL 19:52:29 … we can delve into specific issues to get feedback and garner interest for this work 19:52:41 … thinking the first week of March and setup a doodle 19:56:14 Topic: Sensors read only? 19:56:15 https://github.com/w3c/automotive/issues/443 19:57:18 Ulf encourages people to read issue, his slides and comments for next week 19:58:00 Topic: WG F2F at COVESA Spring AMM 20:01:35 Ulf: Ted and I discussed whether we should try to have a group face to face meeting at the Spring COVESA AMM 20:01:37 https://www.covesa.global/events 20:01:55 April 26-28 in Leipzig, Germany 20:02:30 [group inclined modulo pandemic changes and company policies] 20:02:31 I have made the request to generate https://www.w3.org/2022/01/25-auto-minutes.html ted