There are limitations by notion on what can be viewed to thousands of records, but you can use a query to pull a filtered view of data in Notion. It's not just a 1:1 mapping but changes in Notion will persist through data in the database that is joined
It's really a way for teams such as customer service who may have their CS ops in Notion to view & change customer data in your data store without adding to an engineer's backlog
Some questions aloud from my brain while I try to research the answers:
Is the data syncing done with PUB/SUB or some kind of "cron-like" job (so the data can be out of sync for like, up to 5 minutes between database -> notion?)
Is the data pulled fresh from the database anytime the Notion page is loaded? I don't think so.