Earlier quoted context omitted.
Both Epic and Cerner are making at least some strides toward opening up their platforms (Epic with App Orchard, and Cerner with Ignite, SMART on FHIR etc.) Athena has MDP ("More Disruption Please.") I get the feeling these organizations have at least come to the realization that they need to open up--granted their denial up to this point leaves them with a lot of catching up to do. But access to the data that exists…
But access to the data that exists in those systems is a pretty big carrot for integration partners to help push adoption. The scary reality is, they don't even have access to the data in those systems. I had a friend contracted at cerner working on a FHIR api end point. Something as simple as answering the question "what medications have been administered to a patient" was extremely difficult to pull out of their sy…
I think the point about FK constraints is perhaps a little too generalized. In a 5000+ table schema (which is entirely accurate!), I'm sure there are some tables which don't have FK constraints enabled. But I know for a fact that there are FK constraints on some of the tables (because I created them!)