I'm working towards resolving
issue #466, and wanted to update you all on my progress.
The team is committed to producing an Interface Control Document (ICD) and a Logical Data Model (LDM) for the PSM, and is committed to producing an architecture diagram depicting how the PSM is technically structured.
An LDM would represent the specific entities, attributes, and
relationships involved in a business function’s view of information, per
the guidance at
https://www.cms.gov/Research-Statistics-Data-and-Systems/CMS-Information-Technology/DataAdmin/LogicalDataDesign.html . As I understand it, the LDM is meant to illustrate the
flow of data through the PSM, from user input through the application to
the database, from APIs like our LEIE interface, and to users via the
front end or via APIs/export. Thus, I believe another way to talk about an LDM is to call it an architecture diagram, and am working on the assumption that it will be a
boxes-and-arrows diagram plus necessary prose annotations.
A first step to this LDM is automatically generating a map from our database schema. I've used the "pgmodeler" tool to do so. I'll avoid attaching the images directly to this mail and instead suggest you view a few sample visualizations in
this GitHub comment (click on them to magnify). I'd welcome feedback on that output.
I welcome feedback on this progress and on my working assumptions, either here or in the GitHub issue.
Thanks,
Sumana Harihareswara
Open Tech Strategies