IRC log of auto on 2022-01-25

Timestamps are in UTC.

19:01:08 [RRSAgent]

RRSAgent has joined #auto

19:01:08 [RRSAgent]

logging to https://www.w3.org/2022/01/25-auto-irc

19:01:09 [Zakim]

inviting RRSAgent

19:01:10 [Zakim]

RRSAgent, make logs Public

19:01:11 [Zakim]

Meeting: Automotive Working Group Teleconference

19:01:14 [ted]

Scribe: Ted

19:01:15 [ted]

scribenick: ted

19:01:18 [ted]

Chair: Ted

19:01:59 [ted]

Present+ Ted, Ulf, Adnan, Felix, Carine, Daniel

19:02:02 [ted]

Regrets+ Peter

19:03:09 [ted]

Present+ Erik

19:04:17 [ted]

Present+ Gunnar

19:05:35 [ted]

Present+ Paul

19:08:42 [ted]

Topic: MongoDB and VSS for Automotive use

19:08:59 [ted]

Felix: hope people are already somewhat familiar with MongoDB

19:09:28 [ted]

… we have evolved as a company, have 30k customers with 2M MongoDB clusters on AWS, Azure etc

19:09:44 [ted]

… far more downloads and instances elsewhere

19:10:14 [ted]

… we are the most popular non-relational database, at least according to search engine metrics

19:10:20 [ted]

… @@slides

19:10:34 [ted]

s/… @@slides/@@slides/

19:10:42 [ted]

… we use binary JSON

19:11:08 [ted]

… we started combining as a pure non-relational db, JSON based and flexible meaning you could add fields on the fly

19:11:27 [ted]

… in non-relational world still a need for joins

19:11:41 [ted]

… we are focused on realtime workloads

19:12:14 [ted]

s/Azure etc/Azure, GCP etc/

19:12:41 [ted]

… we use code versioning to align code to database structure at different points in time

19:13:20 [ted]

… we can attain backwards compatibility of code

19:14:56 [ted]

… 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 [ted]

… MongoDB started as a document model database, set of name/value pairs, support graphs, joins - ability to show relationships

19:15:57 [ted]

… support time series, queries

19:16:13 [ted]

… JSON structure objects which are widely used

19:16:50 [ted]

s/queries/indexed data, queries/

19:17:25 [ted]

… we can build data lakes for historic data as opposed to live, current view

19:17:35 [ted]

… we use tls for transport, encryption at rest

19:18:30 [ted]

… as mentioned we run on the major clouds platforms with failover capabilities between them

19:19:10 [ted]

… Realm started as a DB, started in 2010 and acquired by Mongo in 2019

19:19:39 [ted]

… they were very popular, open source

19:19:56 [ted]

… over the last two years we've been merging with Mongo

19:20:46 [ted]

… Realm can fit on an ECU, it uses websockets to transmit data

19:21:20 [ted]

… there are a number of optimizations to reduce data transmission, only send delta differences for instance

19:22:43 [ted]

… multiple sdk are available. we create a vehicle "shadow" in the cloud, REST APIs and GraphQL support and various ERP connectors

19:23:32 [ted]

… vehicle architecture is more complex, multiple ECUs will want to synchronize data among themselves and with the TCU

19:23:56 [ted]

… different Realm db can sync across vehicle and to the cloud

19:24:42 [ted]

Gunnar: is what is shared restricted in any manner?

19:24:55 [ted]

Felix: you can limit what object you share

19:25:24 [ted]

Adnan: based on request you could dynamically supply what is needed, a use case we had initially

19:25:42 [ted]

Gunnar: I was thinking about locking down access to ECU to data needed

19:25:56 [ted]

Felix: you can create dynamic queries, define what data you want to replicate

19:26:33 [ted]

… there might be scenarios where that changes, you may want to configure for lower connectivity data off-boarding

19:27:02 [ted]

… this audience should be familiar with VSS. we created a JSON schema from it

19:27:23 [ted]

q+ to ask if Mongo JSON differs from one in VSS repo, how and why?

19:28:01 [ted]

… we support db per vehicle and db across multiple vehicles, different collections

19:29:47 [ted]

… it is possible to modify the generated JSON

19:30:10 [ted]

… we create a data model for the Realm db

19:33:34 [ted]

… there are change notification capabilities

19:34:49 [ted]

… for GraphQL API we go from JSON to generate schema

19:35:27 [ted]

Present+ Peter

19:36:04 [ted]

Gunnar: the query language specific to Mongo? it seems similar to GraphQL

19:36:11 [ted]

Felix: yes

19:36:53 [ted]

Gunnar: you may want to track how old data is, can you speak to time based use?

19:37:24 [ted]

Felix: we can add timestamp to the generated JSON. it is a common way to transmit or store timestamps

19:39:36 [Zakim]

ted, you wanted to ask if Mongo JSON differs from one in VSS repo, how and why?

19:41:41 [ted]

Felix: what we generate is pretty close to what you have

19:42:20 [ted]

s/you wanted to ask if we can use existing JSON or Graph schema instead of Mongo generated/

19:43:19 [ted]

Ted: possible to use our existing JSON?

19:43:40 [ted]

Felix: it would need some tweaks and also depends if you want to keep database as one document or multiple

19:43:58 [ted]

Gunnar: we expect to need translations between systems

19:44:15 [ted]

… I think Ted cares about value structure

19:44:46 [ted]

… here you are thinking more message based

19:45:22 [ted]

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 [ted]

Topic: VSSo publication and workshop planning

19:51:36 [ted]

Daniel: we have some open design discussions, where we use restrictions, what gets instantiated...

19:52:06 [ted]

… we want to have a 2-3 workshop around VSSo including things like presentation from MS on their DTDL

19:52:29 [ted]

… we can delve into specific issues to get feedback and garner interest for this work

19:52:41 [ted]

… thinking the first week of March and setup a doodle

19:56:14 [ted]

Topic: Sensors read only?

19:56:15 [ted]

https://github.com/w3c/automotive/issues/443

19:57:18 [ted]

Ulf encourages people to read issue, his slides and comments for next week

19:58:00 [ted]

Topic: WG F2F at COVESA Spring AMM

20:01:35 [ted]

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 [ted]

https://www.covesa.global/events

20:01:55 [ted]

April 26-28 in Leipzig, Germany

20:02:30 [ted]

[group inclined modulo pandemic changes and company policies]

20:02:31 [RRSAgent]

I have made the request to generate https://www.w3.org/2022/01/25-auto-minutes.html ted