Meeting minutes
MongoDB and VSS for Automotive use
Felix: hope people are already somewhat familiar with MongoDB
… we have evolved as a company, have 30k customers with 2M MongoDB clusters on AWS, Azure, GCP etc
… far more downloads and instances elsewhere
… we are the most popular non-relational database, at least according to search engine metrics
slides
… we use binary JSON
… we started combining as a pure non-relational db, JSON based and flexible meaning you could add fields on the fly
… in non-relational world still a need for joins
… we are focused on realtime workloads
… we use code versioning to align code to database structure at different points in time
… we can attain backwards compatibility of code
… 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...
… MongoDB started as a document model database, set of name/value pairs, support graphs, joins - ability to show relationships
… support time series, indexed data, queries
… JSON structure objects which are widely used
… we can build data lakes for historic data as opposed to live, current view
… we use tls for transport, encryption at rest
… as mentioned we run on the major clouds platforms with failover capabilities between them
… Realm started as a DB, started in 2010 and acquired by Mongo in 2019
… they were very popular, open source
… over the last two years we've been merging with Mongo
… Realm can fit on an ECU, it uses websockets to transmit data
… there are a number of optimizations to reduce data transmission, only send delta differences for instance
… multiple sdk are available. we create a vehicle "shadow" in the cloud, REST APIs and GraphQL support and various ERP connectors
… vehicle architecture is more complex, multiple ECUs will want to synchronize data among themselves and with the TCU
… different Realm db can sync across vehicle and to the cloud
Gunnar: is what is shared restricted in any manner?
Felix: you can limit what object you share
Adnan: based on request you could dynamically supply what is needed, a use case we had initially
Gunnar: I was thinking about locking down access to ECU to data needed
Felix: you can create dynamic queries, define what data you want to replicate
… there might be scenarios where that changes, you may want to configure for lower connectivity data off-boarding
… this audience should be familiar with VSS. we created a JSON schema from it
… we support db per vehicle and db across multiple vehicles, different collections
… it is possible to modify the generated JSON
… we create a data model for the Realm db
… there are change notification capabilities
… for GraphQL API we go from JSON to generate schema
Gunnar: the query language specific to Mongo? it seems similar to GraphQL
Felix: yes
Gunnar: you may want to track how old data is, can you speak to time based use?
Felix: we can add timestamp to the generated JSON. it is a common way to transmit or store timestamps
<Zakim> ted, you wanted to ask if Mongo JSON differs from one in VSS repo, how and why?
Felix: what we generate is pretty close to what you have
<ted> s/you wanted to ask if we can use existing JSON or Graph schema instead of Mongo generated/
Ted: possible to use our existing JSON?
Felix: it would need some tweaks and also depends if you want to keep database as one document or multiple
Gunnar: we expect to need translations between systems
… I think Ted cares about value structure
… here you are thinking more message based
Felix: JSON structure itself just controls how the data is written into the db and ours allows for querying and other capabilities
VSSo publication and workshop planning
Daniel: we have some open design discussions, where we use restrictions, what gets instantiated...
… we want to have a 2-3 workshop around VSSo including things like presentation from MS on their DTDL
… we can delve into specific issues to get feedback and garner interest for this work
… thinking the first week of March and setup a doodle
Sensors read only?
https://
Ulf encourages people to read issue, his slides and comments for next week
WG F2F at COVESA Spring AMM
Ulf: Ted and I discussed whether we should try to have a group face to face meeting at the Spring COVESA AMM
https://
April 26-28 in Leipzig, Germany
[group inclined modulo pandemic changes and company policies]